STRASMORE/EXPLORE 2,433 QUERIES

Median waits along the dividend calendar (trailing 12 months, recurring US dividends)

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-20, from Ex-Dividend Date vs. Record Date: Same Day?.

as of scalar 1×3read in context →
dividends
45,527
median declared to ex days
33
median record to pay days
5
Rows × columns
1 × 3
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Median waits along the dividend calendar (trailing 12 months, recurring US dividends), derived from the stored result.
ColumnTypeRangeNotes
dividends number every row is 45,527
median_declared_to_ex_days number every row is 33
median_record_to_pay_days number every row is 5

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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 count() AS dividends,
       round(quantileDeterministic(0.5)(dateDiff('day', declaration_date, ex_dividend_date), cityHash64(id)), 0) AS median_declared_to_ex_days,
       round(quantileDeterministic(0.5)(dateDiff('day', record_date, pay_date), cityHash64(id)), 0) AS median_record_to_pay_days
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()
  AND declaration_date IS NOT NULL
  AND pay_date IS NOT NULL
  AND record_date IS NOT NULL
  AND pay_date >= record_date
⌘/Ctrl + Enter
More from this analysisEx-Dividend Date vs. Record Date: Same Day?
One real dividend: AAPL's most recent completed payout, all four dates scalar 1×9 → The T+1 cutover, week by week: share of dividends with ex-date = record date, April–July 2024 ranking 18×3 → Ex-date vs. record date by year: share identical, and the median gap in calendar days ranking 12×4 → Calendar days from ex-dividend date to record date (trailing 12 months) ranking 4×3 → Dividends that went ex AFTER the record date: special vs. recurring, trailing 12 months table 2×6 → Share of 2024 US dividends whose record date fell on the ex-dividend date series 12×3 → See all 2,433 queries →