o_monthly_trace

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    month                                              AS month,
    formatDateTime(month, '%m.%Y')                     AS month_label,
    round(toFloat64(sum(amount)), 4)                   AS gross_per_share_usd,
    round(toFloat64(sum(amount)) * 0.70, 4)            AS net_per_share_usd
FROM
(
    SELECT
        toStartOfMonth(ex_dividend_date) AS month,
        ex_dividend_date,
        max(cash_amount)                 AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'O'
      AND currency = 'USD'
      AND cash_amount > 0
      AND ex_dividend_date >= addMonths(toStartOfMonth(today()), -24)
      AND ex_dividend_date <  toStartOfMonth(today())
    GROUP BY month, ex_dividend_date
)
GROUP BY month
ORDER BY month