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

3,256 answered market questions

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

What Happens After a Reverse Stock Split?
Reverse splits executed Mar 2025 to Feb 2026, by consolidation ratioranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. Reverse vs forward splits by execution month, trailing two yearsseries · 2026-10-04 · 24×5Preview: a 16-point series, ending higher. Median move after the split, same cohort, at 20, 60 and 120 sessionsranking · 2026-10-04 · 3×4Preview: 3 ranked values, largest first.
Upcoming Reverse Stock Splits: Live Calendar
Reverse versus forward splits by yearranking · 2026-10-04 · 8×4Preview: 8 ranked values, smallest first. Upcoming reverse stock splits: ratio, effective date and last closetable · 2026-10-04 · 18×6 Pre-split price of reverse splits: the calendar ahead versus the trailing twelve monthstable · 2026-10-04 · 3×5 Reverse versus forward splits by month, last twelve complete monthsseries · 2026-10-04 · 12×5Preview: a 12-point series, ending lower.
Recent Reverse Stock Splits: Last 90 Days
Reverse and forward stock splits per month, trailing yearseries · 2026-10-04 · 12×4Preview: a 12-point series, ending higher. Reverse stock splits effective in the last 90 daysranking · 2026-10-04 · 15×4Preview: 15 ranked values, largest first. Reverse split ratios by size, trailing three yearsranking · 2026-10-04 · 5×2Preview: 5 ranked values, smallest first. Closing prices in the 30 sessions before each recent reverse splitranking · 2026-10-04 · 12×3Preview: 12 ranked values, smallest first.
How Often Do Stocks Split?
The most common reverse-split ratios, 2016 to todayranking · 2026-10-04 · 8×2Preview: 8 ranked values, largest first. Forward and reverse stock splits per year, 2016 to todayranking · 2026-10-04 · 11×3Preview: 11 ranked values, smallest first. The most common forward-split ratios, 2016 to todayranking · 2026-10-04 · 8×2Preview: 8 ranked values, largest first. Every share-count adjustment since 2016, by typeranking · 2026-10-04 · 3×2Preview: 3 ranked values, largest first. Recent forward splits among widely held stocksseries · 2026-10-04 · 10×4Preview: a 10-point series, roughly flat.
How Long Can a Stock Trade Under $1? The Rules
Listed stocks closing under $1, session by session, trailing five monthsseries · 2026-10-04 · 103×3Preview: a 16-point series, ending higher. How long the sub-$1 names have already been there: consecutive sessions closing under $1ranking · 2026-10-04 · 4×3Preview: 4 ranked values, largest first. Reverse splits executed per month, trailing twelve full monthsseries · 2026-10-04 · 12×3Preview: a 12-point series, ending lower. Listed stocks closing under $1 on the latest session, by price bandranking · 2026-10-04 · 5×4Preview: 5 ranked values, smallest first.
Reverse splits executed Mar 2025 to Feb 2026, by consolidation ratio

Reverse splits executed Mar 2025 to Feb 2026, by consolidation ratio

most recentas of ranking 5×3read in context →
Reverse splits executed Mar 2025 to Feb 2026, by consolidation ratio — 5 rows by 3 columns, computed from US exchange, SIP and OPRA data.
ratio_bucketreverse_split_countshare_pct
1-for-2 up to 1-for-523322.9
1-for-6 up to 1-for-1029128.6
1-for-11 up to 1-for-2523122.7
1-for-26 up to 1-for-5011010.8
steeper than 1-for-5015315
the exact SQL behind every number 
SELECT
    tupleElement(band, 1)                                                          AS ratio_bucket,
    countIf(ratio >= tupleElement(band, 2) AND ratio < tupleElement(band, 3))      AS reverse_split_count,
    round(100 * countIf(ratio >= tupleElement(band, 2) AND ratio < tupleElement(band, 3)) / count(), 1) AS share_pct
FROM
(
    SELECT
        ticker,
        toDate(execution_date)                              AS execution_date,
        max(toFloat64(split_from) / toFloat64(split_to))    AS ratio
    FROM global_markets.stocks_splits
    WHERE split_to < split_from
      AND toDate(execution_date) >= '2025-03-01'
      AND toDate(execution_date) <  '2026-03-01'
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
)
ARRAY JOIN
[
    ('1-for-2 up to 1-for-5',    1.0,   5.5),
    ('1-for-6 up to 1-for-10',   5.5,  10.5),
    ('1-for-11 up to 1-for-25', 10.5,  25.5),
    ('1-for-26 up to 1-for-50', 25.5,  50.5),
    ('steeper than 1-for-50',   50.5, 1.0e9)
] AS band
GROUP BY ratio_bucket
ORDER BY min(tupleElement(band, 2))
More from this analysisWhat Happens After a Reverse Stock Split?
Median move after the split, same cohort, at 20, 60 and 120 sessions ranking 3×4 → Reverse vs forward splits by execution month, trailing two years series 24×5 → Listed stocks closing under $1 on the latest session, by price band ranking 5×4 → How long the sub-$1 names have already been there: consecutive sessions closing under $1 ranking 4×3 → See all 3,256 queries →
$