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

What Is a Stock Split? Ratios and Mechanics
Forward vs reverse splits per year, all US-listed securities, 2016 through June 2026ranking · 2026-07-26 · 11×3Preview: 11 ranked values, smallest first. After the split: median forward returns for 2025's whole-number forward splits vs SPY over the same sessionsscalar · 2026-07-26 · 1×544 NVDA around its 10-for-1 split: regular-session open and close, last pre-split day vs first post-split dayseries · 2026-07-26 · 2×3Preview: a 2-point series, ending lower. NVDA trading volume, 20 sessions before vs 20 sessions from its 10-for-1 split (June 10, 2024)ranking · 2026-07-26 · 2×4Preview: 2 ranked values, largest first. Notable US stock splits since 2020: ratio, how the action was recorded, and the next 21 sessions vs SPYtable · 2026-07-26 · 15×6 Most common forward split ratios, July 2025 through June 2026: whole-number ratios, all US-listed securitiesranking · 2026-07-26 · 6×2Preview: 6 ranked values, largest first. A decade of splits, 2016-2025: forward vs reverse totals and the annual scorescalar · 2026-07-26 · 1×44,122
How Monthly Stock Returns Are Measured
SPY June 2026: price return vs total return (June ex-dividend included)scalar · 2026-07-26 · 1×6756.4 SPY monthly close-to-close returns: twelve months ending June 2026, simple and logseries · 2026-07-26 · 12×4Preview: a 12-point series, ending lower. SPY over five years, June 2021 to June 2026: price return vs return with dividendsscalar · 2026-07-26 · 1×7428.07 NVDA June 2024: a raw close-to-close calc vs the split-adjusted returnscalar · 2026-07-26 · 1×61,097.46 June 2026 measured two ways: close-to-close vs open-to-close, NVDA and SPYtable · 2026-07-26 · 2×7 SPY on June 30, 2026: official-close vs the final extended-hours printscalar · 2026-07-26 · 1×3746.32 Sum vs compound: twelve SPY monthly returns linked three waysscalar · 2026-07-26 · 1×712
Forward vs reverse splits per year, all US-listed securities, 2016 through June 2026

Forward vs reverse splits per year, all US-listed securities, 2016 through June 2026

most recentas of ranking 11×3read in context →
Forward vs reverse splits per year, all US-listed securities, 2016 through June 2026 — 11 rows by 3 columns, computed from US exchange, SIP and OPRA data.
yearforward_splitsreverse_splits
2016421726
2017391707
2018529526
2019392606
2020362685
2021416491
2022366622
2023362837
2024454871
20254291038
2026233597
the exact SQL behind every number
SELECT toYear(execution_date) AS year,
       countIf(split_to > split_from) AS forward_splits,
       countIf(split_from > split_to) AS reverse_splits
FROM global_markets.stocks_splits
WHERE execution_date >= '2016-01-01' AND execution_date <= '2026-06-30'
GROUP BY year
ORDER BY year
$