STRASMORE/EXPLORE 2,549 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,549 answered market questions

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

Upcoming Reverse Stock Splits: Live Calendar
Reverse versus forward splits by yearranking · 2026-09-20 · 8×4Preview: 8 ranked values, smallest first. Upcoming reverse stock splits: ratio, effective date and last closetable · 2026-09-20 · 19×6 Pre-split price of reverse splits: the calendar ahead versus the trailing twelve monthstable · 2026-09-20 · 3×5 Reverse versus forward splits by month, last twelve complete monthsseries · 2026-09-20 · 12×5Preview: a 12-point series, ending higher.
Reverse versus forward splits by year

Reverse versus forward splits by year

most recentas 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
the exact SQL behind every number
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
$