STRASMORE/EXPLORE 2,549 QUERIES

Reverse versus forward splits by year

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-20, from Upcoming Reverse Stock Splits: Live Calendar.

as of ranking 8×4read in context →
Reverse versus forward splits by year — 8 rows by 4 columns, computed from US exchange, SIP and OPRA data.
yearreverse_splitsforward_splitsreverse_share_pct
201960638861
202067934665.9
202148540154.4
202262036263
202383435670
202486844765.9
2025103642371
202689031374
Rows × columns
8 × 4
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Reverse versus forward splits by year, derived from the stored result.
ColumnTypeRangeNotes
year text 8 distinct values (2019, 2020, 2021…)
reverse_splits number 485 to 1,036
forward_splits number 313 to 447
reverse_share_pct number 54.4 to 74 percent

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    toString(toYear(execution_date))                              AS year,
    countIf(from_shares > to_shares)                              AS reverse_splits,
    countIf(to_shares > from_shares)                              AS forward_splits,
    round(100.0 * countIf(from_shares > to_shares) / count(), 1)  AS reverse_share_pct
FROM
(
    SELECT
        ticker,
        execution_date,
        max(toFloat64(split_from))  AS from_shares,
        max(toFloat64(split_to))    AS to_shares
    FROM global_markets.stocks_splits
    WHERE execution_date >= toDate('2019-01-01')
      AND execution_date <= today()
      AND split_from != split_to
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
)
GROUP BY year
ORDER BY year
⌘/Ctrl + Enter

Arbeiten Sie mit diesen Daten in Ihrem KI-Assistenten

Öffnet sich abfragebereit, mit den Daten dieser Seite. Kostenlos, ohne Konto.

More from this analysisUpcoming Reverse Stock Splits: Live Calendar
Upcoming reverse stock splits: ratio, effective date and last close table 19×6 → Reverse versus forward splits by month, last twelve complete months series 12×5 → Pre-split price of reverse splits: the calendar ahead versus the trailing twelve months table 3×5 → Forward and reverse stock splits per year, 2016 to today ranking 11×3 → The most common reverse-split ratios, 2016 to today ranking 8×2 → The most common forward-split ratios, 2016 to today ranking 8×2 → See all 2,549 queries →