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

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.
The January Effect: Does It Still Work?
SPY share volume around the turn of the year, averaged since 2011ranking · 2026-08-11 · 19×3Preview: 16 ranked values, largest first. Distinct symbols printing at least one session, by yearranking · 2026-08-11 · 20×2Preview: 16 ranked values, smallest first. The tape by average dollar volume, June 2026ranking · 2026-08-11 · 5×3Preview: 5 ranked values, largest first. Every January on the daily tape, in trading sessionsranking · 2026-08-11 · 23×2Preview: 16 ranked values, smallest first.
Reverse and forward stock splits per month, trailing year

Reverse and forward stock splits per month, trailing year

most recentas of series 12×4read in context →
Reverse and forward stock splits per month, trailing year — 12 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelreverse_splitsforward_splits
2025-10-01Oct 20258832
2025-11-01Nov 20256930
2025-12-01Dec 202512948
2026-01-01Jan 20266921
2026-02-01Feb 20268924
2026-03-01Mar 202613556
2026-04-01Apr 20269732
2026-05-01May 202610240
2026-06-01Jun 202610558
2026-07-01Jul 202611945
2026-08-01Aug 202610420
2026-09-01Sep 202610758
the exact SQL behind every number 
SELECT
    month,
    formatDateTime(month, '%b %Y')     AS month_label,
    countIf(from_shares > to_shares)   AS reverse_splits,
    countIf(to_shares > from_shares)   AS forward_splits
FROM
(
    SELECT
        ticker,
        toStartOfMonth(execution_date) AS month,
        any(split_from)                AS from_shares,
        any(split_to)                  AS to_shares
    FROM global_markets.stocks_splits
    WHERE execution_date >= toStartOfMonth(today() - 365)
      AND execution_date <  toStartOfMonth(today())
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date, month
)
GROUP BY month, month_label
ORDER BY month ASC
More from this analysisRecent Reverse Stock Splits: Last 90 Days
Reverse stock splits effective in the last 90 days ranking 15×4 → Closing prices in the 30 sessions before each recent reverse split ranking 12×3 → Reverse split ratios by size, trailing three years ranking 5×2 → Recent forward splits among widely held stocks series 10×4 → See all 3,256 queries →
$