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.
What Are Call Options?
One SPY $740 call vs SPY, indexed to 100 on May 1 (expired Jun 18 2026)series · 2026-07-16 · 31×3Preview: a 16-point series, ending higher. The $740 call split into intrinsic and time value, five key sessionsseries · 2026-07-16 · 5×4Preview: a 5-point series, ending lower. SPY vs its $740 call, May 1 to June 2 (the SPY peak)ranking · 2026-07-16 · 2×4Preview: 2 ranked values, largest 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
$