Average days between ex-dividend dates, 2021 to date

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.

WITH deduped AS
(
    SELECT
        id,
        any(ticker)           AS sym,
        any(ex_dividend_date) AS ex_date
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'JPM', 'ABBV', 'CSCO')
      AND ex_dividend_date >= '2021-01-01'
      AND ex_dividend_date <  '2026-10-01'
    GROUP BY id
)
SELECT
    sym                                                                   AS ticker,
    count()                                                               AS payments,
    formatDateTime(max(ex_date), '%b %e, %Y')                             AS latest_ex_date,
    round(dateDiff('day', min(ex_date), max(ex_date)) / (count() - 1), 1) AS avg_days_between_ex_dates
FROM deduped
GROUP BY sym
HAVING count() >= 8
ORDER BY avg_days_between_ex_dates