Regular dividends: ex-date before the record date, or on it

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
    toString(toStartOfMonth(ex_date))                       AS month,
    formatDateTime(toStartOfMonth(ex_date), '%b %Y')        AS month_label,
    count()                                                 AS dividend_count,
    round(100 * countIf(ex_date <  record_on) / count(), 1) AS ex_before_record_pct,
    round(100 * countIf(ex_date =  record_on) / count(), 1) AS ex_on_record_pct
FROM
(
    SELECT
        id,
        any(ex_dividend_date) AS ex_date,
        any(record_date)      AS record_on
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date >= toDate('2023-01-01')
      AND ex_dividend_date <  toStartOfMonth(today())
      AND record_date      >= toDate('2000-01-01')
      AND frequency > 0
    GROUP BY id
)
GROUP BY month, month_label
ORDER BY month