nasdaq listing — 3 answered market questions

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

most recentas of 2026-09-20 ranking 5×3read in context →

Reverse splits executed Mar 2025 to Feb 2026, by consolidation ratio — 5 rows by 3 columns, computed 2026-09-20 from US exchange, SIP and OPRA data.
ratio_bucket	reverse_split_count	share_pct
1-for-2 up to 1-for-5	233	22.9
1-for-6 up to 1-for-10	291	28.6
1-for-11 up to 1-for-25	231	22.7
1-for-26 up to 1-for-50	110	10.8
steeper than 1-for-50	153	15

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 2,433 queries →