STRASMORE/EXPLORE 2,170 QUERIES

Large special dividends from well-known payers since 2012

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-07-15, from What Is a Special Dividend? (With Examples).

as of ranking 12×3read in context →
Large special dividends from well-known payers since 2012 — 12 rows by 3 columns, computed from US exchange, SIP and OPRA data.
payer_yearyearspecial_dividend_usd
COST 2023202315
COST 2020202010
COST 201220127
COST 201720177
CME 202620266.15
FIZZ 202020206
CME 202420245.8
CME 202320235.25
LYB 202220225.2
COST 201520155
CME 202220224.5
CME 201720173.5
Rows × columns
12 × 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 Large special dividends from well-known payers since 2012, derived from the stored result.
ColumnTypeRangeNotes
payer_year text 12 distinct values (CME 2017, CME 2022, CME 2023…)
year number 2,012 to 2,026
special_dividend_usd number 3.5 to 15 US dollars

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.

the exact SQL behind every number 
SELECT
    concat(ticker, ' ', toString(toYear(ex_dividend_date))) AS payer_year,
    toYear(ex_dividend_date) AS year,
    round(cash_amount, 2) AS special_dividend_usd
FROM global_markets.stocks_dividends
WHERE frequency = 0
  AND cash_amount >= 1
  AND ticker IN ('COST', 'FIZZ', 'CME', 'LYB', 'LVS', 'EBAY', 'MPC', 'WSM', 'BBY', 'HRB')
  AND ex_dividend_date >= '2012-01-01'
ORDER BY special_dividend_usd DESC, payer_year ASC
LIMIT 12

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 analysisWhat Is a Special Dividend? (With Examples)
How US dividends were scheduled in 2026, by payment cadence (Jan 1 - Jul 13) ranking 5×2 → National Beverage (FIZZ): every special dividend since 2016, and no regular one series 7×2 → 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 → Trailing 12 month distribution rate, by fund family ranking 12×3 → Distributions per year: monthly funds beside quarterly benchmarks ranking 12×3 → See all 2,170 queries →