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.
How Ex-Dividend Dates Affect Options
Day before SPY's ex-date: time value left in deep-in-the-money calls, by days to expiryranking · 2026-07-17 · 3×4Preview: 3 ranked values, smallest first. SPY's quarterly dividends, 2025 through the June 2026 ex-dateseries · 2026-07-17 · 6×2Preview: a 6-point series, ending higher. Where the exercise-optimal calls concentrated on June 29, 2026ranking · 2026-07-17 · 10×4Preview: 10 ranked values, largest first. The early-exercise census: every ITM call on every June 30 ex-dividend payer, tested on June 29scalar · 2026-07-17 · 1×485 A near-the-money SPY call and put: delta across the June 18 ex-dividend dateseries · 2026-07-17 · 9×3Preview: a 9-point series, ending lower.
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
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 →
$