STRASMORE/EXPLORE 2,948 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-10-02, from when-historical-market-data-is-revised.

as of series 24×4read in context →
split_cadence — 24 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelsplits_executedreverse_splits
2024-10-01Oct 202413385
2024-11-01Nov 2024144115
2024-12-01Dec 20249558
2025-01-01Jan 20259675
2025-02-01Feb 2025129103
2025-03-01Mar 202511775
2025-04-01Apr 202511082
2025-05-01May 202512381
2025-06-01Jun 202513696
2025-07-01Jul 20259168
2025-08-01Aug 202511776
2025-09-01Sep 202515095
2025-10-01Oct 202512088
2025-11-01Nov 202510069
2025-12-01Dec 2025178130
2026-01-01Jan 20269069
2026-02-01Feb 202611489
2026-03-01Mar 2026191135
2026-04-01Apr 202612997
2026-05-01May 2026142102
2026-06-01Jun 2026164105
2026-07-01Jul 2026164119
2026-08-01Aug 2026126104
2026-09-01Sep 2026165107
Rows × columns
24 × 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 2024-10-01 to 2026-09-01
month_label text 24 distinct values (Apr 2025, Apr 2026, Aug 2025…)
splits_executed number 90 to 191
reverse_splits number 58 to 135

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
    toString(toStartOfMonth(execution_date))                              AS month,
    formatDateTime(toStartOfMonth(execution_date), '%b %Y')               AS month_label,
    countDistinct(id)                                                     AS splits_executed,
    countDistinctIf(id, toFloat64(split_to) / toFloat64(split_from) < 1)  AS reverse_splits
FROM global_markets.stocks_splits
WHERE execution_date >= '2024-10-01'
  AND execution_date <  '2026-10-01'
GROUP BY month, month_label
ORDER BY month
⌘/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 analysiswhen-historical-market-data-is-revised
after_hours_by_month series 24×4 → dst_offset series 10×5 → session_clock ranking 16×3 → symbol_reuse ranking 9×3 → 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 → See all 2,948 queries →