What Is an Ex-Dividend Date? How It Works
Payout schedules of recurring US dividend payers (trailing 12 months)ranking ·
2026-08-22 · 6×3
How long after the ex-date the cash arrives (trailing 12 months)ranking ·
2026-08-22 · 4×3
Median waits between dividend dates (trailing 12 months, all recurring US dividends)scalar ·
2026-08-22 · 1×444,904
Share of US dividends where ex-date = record date, by yearranking ·
2026-08-22 · 6×3
AAPL's last eight dividends: all four dates plus cash per shareseries ·
2026-08-22 · 8×5
AAPL's last eight ex-dividend mornings: adjusted reference vs. the actual openseries ·
2026-08-22 · 8×6
Payout schedules of recurring US dividend payers (trailing 12 months)
Payout schedules of recurring US dividend payers (trailing 12 months)
| payout_schedule | payers | pct_of_payers |
|---|---|---|
| Quarterly | 4402 | 49.4 |
| Monthly | 1915 | 21.5 |
| Annual | 1323 | 14.9 |
| Semi-annual | 1057 | 11.9 |
| Weekly | 190 | 2.1 |
| Other | 15 | 0.2 |
the exact SQL behind every number
SELECT multiIf(frequency = 4, 'Quarterly',
frequency = 12, 'Monthly',
frequency = 1, 'Annual',
frequency = 2, 'Semi-annual',
frequency = 52, 'Weekly',
'Other') AS payout_schedule,
uniqExact(ticker) AS payers,
round(100.0 * uniqExact(ticker) / sum(uniqExact(ticker)) OVER (), 1) AS pct_of_payers
FROM global_markets.stocks_dividends
WHERE currency = 'USD'
AND distribution_type = 'recurring'
AND ex_dividend_date >= today() - INTERVAL 12 MONTH
AND ex_dividend_date <= today()
GROUP BY payout_schedule
ORDER BY payers DESC
More from this analysisWhat Is an Ex-Dividend Date? How It Works
Share of US dividends where ex-date = record date, by year
ranking 6×3
→
How long after the ex-date the cash arrives (trailing 12 months)
ranking 4×3
→
AAPL's last eight dividends: all four dates plus cash per share
series 8×5
→
AAPL's last eight ex-dividend mornings: adjusted reference vs. the actual open
series 8×6
→
See all 2,173 queries →