STRASMORE/EXPLORE 2,767 QUERIES

split_cadence

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-29, from recent-reverse-stock-splits.

as of series 12×4read in context →
split_cadence — 12 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelreverse_splitsforward_splits
2025-09-01Sep 20259555
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
Rows × columns
12 × 4
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for split_cadence, derived from the stored result.
ColumnTypeRangeNotes
month date 2025-09-01 to 2026-08-01
month_label text 12 distinct values (Apr 2026, Aug 2026, Dec 2025…)
reverse_splits number 69 to 135
forward_splits number 20 to 58

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

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
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysisrecent-reverse-stock-splits
recent_reverse ranking 15×4 → pre_split_prices ranking 12×3 → ratio_buckets ranking 5×2 → The 2s10s spread by month, full history series 604×5 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → The 5s30s spread month by month, with both legs series 241×4 → See all 2,767 queries →