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

Name: Median waits along the dividend calendar (trailing 12 months, recurring US dividends)
Creator: Strasmore
Published: 2026-08-22
License: https://www.strasmore.com/terms/

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-08-22, from Ex-Dividend Date vs. Record Date: Same Day?.

as of 2026-08-22 scalar 1×3read in context →

dividends

44,908

median declared to ex days

median record to pay days

Rows × columns: 1 × 3
Computed: 2026-08-22
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.
Column	Type	Range
`dividends`	number	every row is 44,908
`median_declared_to_ex_days`	number	every row is 32
`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 2026-08-22, and the query below is what returned them.

the exact SQL behind every number

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

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

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,170 queries →