Dividends that went ex AFTER the record date: special vs. recurring, trailing 12 months

Name: Dividends that went ex AFTER the record date: special vs. recurring, trailing 12 months
Creator: Strasmore
Published: 2026-09-20
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-09-20, from Ex-Dividend Date vs. Record Date: Same Day?.

as of 2026-09-20 table 2×6read in context →

Dividends that went ex AFTER the record date: special vs. recurring, trailing 12 months — 2 rows by 6 columns, computed 2026-09-20 from US exchange, SIP and OPRA data.
dividend_type	dividends	ex_after_record	pct_ex_after_record	median_days_record_to_ex	pct_of_those_ex_after_pay
special	455	22	4.84	16	95
recurring	45590	13	0.03	8	38

Rows × columns: 2 × 6
Computed: 2026-09-20
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 Dividends that went ex AFTER the record date: special vs. recurring, trailing 12 months, derived from the stored result.
Column	Type	Range	Notes
`dividend_type`	text	2 distinct values (recurring, special)
`dividends`	number	455 to 45,590
`ex_after_record`	number	13 to 22
`pct_ex_after_record`	number	0.03 to 4.84	percent
`median_days_record_to_ex`	number	8 to 16
`pct_of_those_ex_after_pay`	number	38 to 95	percent

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-09-20, 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 distribution_type AS dividend_type,
       count() AS dividends,
       countIf(ex_dividend_date > record_date) AS ex_after_record,
       round(100.0 * countIf(ex_dividend_date > record_date) / count(), 2) AS pct_ex_after_record,
       round(quantileDeterministicIf(0.5)(dateDiff('day', record_date, ex_dividend_date), cityHash64(id), ex_dividend_date > record_date), 0) AS median_days_record_to_ex,
       round(100.0 * countIf(ex_dividend_date > record_date AND ex_dividend_date > pay_date) / greatest(countIf(ex_dividend_date > record_date), 1), 0) AS pct_of_those_ex_after_pay
FROM global_markets.stocks_dividends
WHERE currency = 'USD'
  AND distribution_type IN ('special', 'recurring')
  AND ex_dividend_date >= today() - INTERVAL 12 MONTH
  AND ex_dividend_date <= today()
  AND record_date IS NOT NULL
  AND pay_date IS NOT NULL
GROUP BY distribution_type
HAVING countIf(ex_dividend_date > record_date) > 0
ORDER BY indexOf(['special', 'recurring'], distribution_type)

SQL to run

⌘/Ctrl + Enter

More from this analysisEx-Dividend Date vs. Record Date: Same Day?

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 → One real dividend: AAPL's most recent completed payout, all four dates scalar 1×9 → Median waits along the dividend calendar (trailing 12 months, recurring US dividends) scalar 1×3 → From ex-dividend date to record date to the cash, in calendar days table 8×6 → See all 2,433 queries →