STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

What Is an Ex-Dividend Date? How It Works
Payout schedules of recurring US dividend payers (trailing 12 months)ranking · 2026-08-22 · 6×3Preview: 6 ranked values, largest first. How long after the ex-date the cash arrives (trailing 12 months)ranking · 2026-08-22 · 4×3Preview: 4 ranked values, largest first. 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×3Preview: 6 ranked values, smallest first. AAPL's last eight dividends: all four dates plus cash per shareseries · 2026-08-22 · 8×5Preview: a 8-point series, ending lower. AAPL's last eight ex-dividend mornings: adjusted reference vs. the actual openseries · 2026-08-22 · 8×6Preview: a 8-point series, ending higher.
Payout schedules of recurring US dividend payers (trailing 12 months)

Payout schedules of recurring US dividend payers (trailing 12 months)

most recentas of ranking 6×3read in context →
Payout schedules of recurring US dividend payers (trailing 12 months) — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
payout_schedulepayerspct_of_payers
Quarterly440249.4
Monthly191521.5
Annual132314.9
Semi-annual105711.9
Weekly1902.1
Other150.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
$