STRASMORE/EXPLORE 3,127 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,127 answered market questions

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

US Stock Splits for Chinese Investors
Forward and reverse splits on the US tape, by yearranking · 2026-10-06 · 10×3Preview: 10 ranked values, largest first. Recent US splits, stamped in New York and Beijing timeseries · 2026-10-06 · 12×7Preview: a 12-point series, ending higher. A 137-share lot through real large-cap splitsranking · 2026-10-06 · 7×4Preview: 7 ranked values, smallest first. NVDA traded option strikes, before and after the splitseries · 2026-10-06 · 8×5Preview: a 8-point series, ending higher. One US split session, hour by hour, in both time zonesseries · 2026-10-06 · 16×3Preview: a 16-point series, ending higher.
Forward and reverse splits on the US tape, by year

Forward and reverse splits on the US tape, by year

most recentas of ranking 10×3read in context →
Forward and reverse splits on the US tape, by year — 10 rows by 3 columns, computed from US exchange, SIP and OPRA data.
yearforward_splitsreverse_splits
2017391707
2018529526
2019392606
2020362685
2021416491
2022366622
2023362837
2024454871
20254291038
2026363941
the exact SQL behind every number 
SELECT
    toString(toYear(execution_date))         AS year,
    uniqExactIf(id, split_to > split_from)   AS forward_splits,
    uniqExactIf(id, split_to < split_from)   AS reverse_splits
FROM global_markets.stocks_splits
WHERE execution_date >= toDate('2017-01-01')
  AND execution_date < today()
  AND ticker NOT IN ('SPCX')
GROUP BY year
ORDER BY year
More from this analysisUS Stock Splits for Chinese Investors
A 137-share lot through real large-cap splits ranking 7×4 → One US split session, hour by hour, in both time zones series 16×3 → Recent US splits, stamped in New York and Beijing time series 12×7 → NVDA traded option strikes, before and after the split series 8×5 → See all 3,127 queries →
$