STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Cost Basis After a Stock Split, Step by Step
Forward and reverse splits per calendar yearranking · 2026-08-22 · 11×3Preview: 11 ranked values, smallest first. The most common split terms of the past five yearsranking · 2026-08-22 · 12×3Preview: 12 ranked values, largest first. One hypothetical 100-share lot through every AAPL splitseries · 2026-08-22 · 3×5Preview: a 3-point series, ending lower. Every KO dividend of the past four years, one new lot each if reinvestedseries · 2026-08-22 · 16×3Preview: a 16-point series, ending higher.
Forward and reverse splits per calendar year

Forward and reverse splits per calendar year

most recentas of ranking 11×3read in context →
Forward and reverse splits per calendar year — 11 rows by 3 columns, computed from US exchange, SIP and OPRA data.
yearforward_splitsreverse_splits
2016149266
2017379701
2018516524
2019388606
2020352679
2021404488
2022362622
2023358834
2024451867
20254241036
2026289778
the exact SQL behind every number 
SELECT
    toString(toYear(execution_date))     AS year,
    toUInt32(countIf(to_val > from_val)) AS forward_splits,
    toUInt32(countIf(from_val > to_val)) AS reverse_splits
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(), 10)
      AND execution_date <= today()
      AND split_from > 0
      AND split_to > 0
    GROUP BY ticker, execution_date
)
GROUP BY year
ORDER BY year
More from this analysisCost Basis After a Stock Split, Step by Step
The most common split terms of the past five years ranking 12×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 → See all 2,170 queries →
$