The most common split terms of the past five years

Name: The most common split terms of the past five years
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 Cost Basis After a Stock Split, Step by Step.

as of 2026-08-22 ranking 12×3read in context →

The most common split terms of the past five years — 12 rows by 3 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
split_label	direction	split_count
1-for-10	reverse	947
1-for-20	reverse	417
2-for-1	forward	337
1-for-5	reverse	326
1-for-4	reverse	194
3-for-1	forward	190
1-for-15	reverse	188
1-for-25	reverse	171
1-for-3	reverse	161
1-for-100	reverse	152
1-for-50	reverse	149
1-for-30	reverse	146

Rows × columns: 12 × 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 The most common split terms of the past five years, derived from the stored result.
Column	Type	Range	Notes
`split_label`	text	12 distinct values (1-for-10, 1-for-100, 1-for-15…)
`direction`	text	2 distinct values (forward, reverse)
`split_count`	number	146 to 947	count

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
    concat(toString(to_val), '-for-', toString(from_val)) AS split_label,
    if(to_val > from_val, 'forward', 'reverse')           AS direction,
    toUInt32(count())                                     AS split_count
FROM
(
    SELECT
        ticker,
        execution_date,
        any(split_from) AS from_val,
        any(split_to)   AS to_val
    FROM global_markets.stocks_splits
    WHERE execution_date >= subtractYears(today(), 5)
      AND execution_date <= today()
      AND split_from > 0
      AND split_to > 0
    GROUP BY ticker, execution_date
)
GROUP BY split_label, direction
ORDER BY split_count DESC
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 analysisCost Basis After a Stock Split, Step by Step

Forward and reverse splits per calendar year ranking 11×3 → Every KO dividend of the past four years, one new lot each if reinvested series 16×3 → One hypothetical 100-share lot through every AAPL split series 3×5 → Recent reverse stock splits (shares consolidated), last 30 days ranking 15×4 → Recent forward stock splits (shares multiplied), last 60 days, ETFs excluded ranking 15×4 → Apple's yearly price range, split-adjusted, 2012 through the current year ranking 15×4 → See all 2,170 queries →