STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

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

Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan
Upcoming Reverse Stock Splits: Live Calendar
Reverse versus forward splits by yearranking · 2026-11-07 · 8×4Preview: 8 ranked values, smallest first. Upcoming reverse stock splits: ratio, effective date and last closetable · 2026-11-07 · 38×6 Pre-split price of reverse splits: the calendar ahead versus the trailing twelve monthstable · 2026-11-07 · 3×5 Reverse versus forward splits by month, last twelve complete monthsseries · 2026-11-07 · 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
2026104539272.7
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
$