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

How Stock Splits Affect Your Options
US stock splits by year: forward and reverse counts, 2017 through July 2026ranking · 2026-08-04 · 10×3Preview: 10 ranked values, smallest first. One off cash distributions by size: payments, tickers and median amount since 2021table · 2026-08-04 · 5×5 Most common forward split ratios since 2020, and how each one adjusts a contractranking · 2026-08-04 · 10×4Preview: 10 ranked values, largest first. What one 100 share contract covers after a non whole split ratio, 2020 to July 2026ranking · 2026-08-04 · 10×4Preview: 10 ranked values, smallest first.
US stock splits by year: forward and reverse counts, 2017 through July 2026

US stock splits by year: forward and reverse counts, 2017 through July 2026

most recentas of ranking 10×3read in context →
US stock splits by year: forward and reverse counts, 2017 through July 2026 — 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
2026278716
the exact SQL behind every number
SELECT toYear(execution_date) AS year,
       countIf(toFloat64(split_to) > toFloat64(split_from)) AS forward_splits,
       countIf(toFloat64(split_to) < toFloat64(split_from)) AS reverse_splits
FROM global_markets.stocks_splits
WHERE execution_date >= toDate('2017-01-01')
  AND execution_date < toDate('2026-08-01')
  AND toFloat64(split_from) > 0
  AND toFloat64(split_to) > 0
GROUP BY year
ORDER BY year
$