spinoff_resets

Name: spinoff_resets
Creator: Strasmore
Published: 2026-09-12
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-12, from mo-dividend-increase-history.

as of 2026-09-12 series 16×3read in context →

spinoff_resets — 16 rows by 3 columns, computed 2026-09-12 from US exchange, SIP and OPRA data.
ex_date	quarterly_dividend	amount_label
2006-03-13	0.8	0.8
2006-06-13	0.8	0.8
2006-09-13	0.86	0.86
2006-12-22	0.86	0.86
2007-03-13	0.86	0.86
2007-06-13	0.69	0.69
2007-09-12	0.75	0.75
2007-12-21	0.75	0.75
2008-03-17	0.75	0.75
2008-06-11	0.29	0.28
2008-09-11	0.32	0.32
2008-12-22	0.32	0.32
2009-03-12	0.32	0.32
2009-06-11	0.32	0.32
2009-09-11	0.34	0.34
2009-12-28	0.34	0.34

Rows × columns: 16 × 3
Period covered: 2006-03-13 to 2009-12-28
Computed: 2026-09-12
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 spinoff_resets, derived from the stored result.
Column	Type	Range
`ex_date`	date	2006-03-13 to 2009-12-28
`quarterly_dividend`	number	0.29 to 0.86
`amount_label`	text	7 distinct values (0.28, 0.32, 0.34…)

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-12, and the query below is what returned them.

the exact SQL behind every number

SELECT
    toString(ex_dividend_date)                        AS ex_date,
    round(toFloat64(max(cash_amount)), 3)             AS quarterly_dividend,
    if(toInt64(max(cash_amount) * 1000) % 10 = 0,
       toString(toDecimal64(toFloat64(max(cash_amount)), 2)),
       toString(toDecimal64(toFloat64(max(cash_amount)), 3))) AS amount_label
FROM global_markets.stocks_dividends
WHERE ticker = 'MO'
  AND ex_dividend_date >= toDate('2006-01-01')
  AND ex_dividend_date <  toDate('2010-01-01')
GROUP BY ex_dividend_date
ORDER BY ex_dividend_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 analysismo-dividend-increase-history

raises series 21×7 → payment_calendar series 4×6 → cadence series 2×5 → fcf_coverage table 6×5 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → 2s10s spread, monthly average: last 20 years series 240×2 → See all 2,214 queries →