Longest gaps between consecutive AAPL dividend payments, in years

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 payouts AS
(
    SELECT
        id,
        any(ex_dividend_date) AS ex_date
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND ex_dividend_date <= today()
    GROUP BY id
),
sequenced AS
(
    SELECT
        ex_date,
        any(ex_date) OVER (ORDER BY ex_date ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prior_date
    FROM payouts
)
SELECT
    concat(formatDateTime(prior_date, '%b %Y'), ' to ', formatDateTime(ex_date, '%b %Y')) AS gap_between,
    round(dateDiff('day', prior_date, ex_date) / 365.25, 2) AS gap_span,
    formatDateTime(prior_date, '%b %Y')                     AS earlier_payment,
    formatDateTime(ex_date, '%b %Y')                        AS later_payment
FROM sequenced
WHERE prior_date > toDate('1980-01-01')
ORDER BY gap_span DESC
LIMIT 6