Days from ex-dividend date to payment date, all cash dividends in the trailing year

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
    gap_bucket,
    payouts,
    round(100 * payouts / sum(payouts) OVER (), 1)                                        AS share_pct,
    round(100 * sum(payouts) OVER (ORDER BY bucket_order) / sum(payouts) OVER (), 1)      AS cumulative_pct
FROM
(
    SELECT
        multiIf(gap_days <= 7,  '0-7 days',
                gap_days <= 14, '8-14 days',
                gap_days <= 21, '15-21 days',
                gap_days <= 30, '22-30 days',
                gap_days <= 45, '31-45 days',
                                '46+ days')                  AS gap_bucket,
        multiIf(gap_days <= 7, 1, gap_days <= 14, 2, gap_days <= 21, 3,
                gap_days <= 30, 4, gap_days <= 45, 5, 6)     AS bucket_order,
        count()                                              AS payouts
    FROM
    (
        SELECT dateDiff('day', ex_dividend_date, pay_date) AS gap_days
        FROM global_markets.stocks_dividends
        WHERE ex_dividend_date >= today() - 365
          AND ex_dividend_date <  today()
          AND pay_date > ex_dividend_date
          AND cash_amount > 0
        GROUP BY ticker, ex_dividend_date, pay_date
    )
    GROUP BY gap_bucket, bucket_order
)
ORDER BY bucket_order