STRASMORE/EXPLORE 2,830 QUERIES

splits_by_month

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-30, from us-stock-splits-for-russian-investors.

as of series 12×5read in context →
splits_by_month — 12 rows by 5 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelsplits_totalforward_splitsreverse_splits
2025-09-01сен 20251505595
2025-10-01окт 20251203288
2025-11-01ноя 20251003169
2025-12-01дек 202517848130
2026-01-01янв 2026902169
2026-02-01фев 20261142589
2026-03-01мар 202619156135
2026-04-01апр 20261293297
2026-05-01май 202614240102
2026-06-01июн 202616459105
2026-07-01июл 202616445119
2026-08-01авг 202612622104
Rows × columns
12 × 5
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 splits_by_month, derived from the stored result.
ColumnTypeRangeNotes
month date 2025-09-01 to 2026-08-01
month_label text 12 distinct values (авг 2026, апр 2026, дек 2025…)
splits_total number 90 to 191
forward_splits number 21 to 59
reverse_splits number 69 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(m)                                AS month,
    concat(arrayElement(['янв', 'фев', 'мар', 'апр', 'май', 'июн', 'июл', 'авг', 'сен', 'окт', 'ноя', 'дек'], toMonth(m)), ' ', toString(toYear(m))) AS month_label,
    count()                                    AS splits_total,
    countIf(ratio > 1)                         AS forward_splits,
    countIf(ratio < 1)                         AS reverse_splits
FROM
(
    SELECT DISTINCT
        ticker,
        execution_date,
        toStartOfMonth(execution_date)              AS m,
        toFloat64(split_to) / toFloat64(split_from) AS ratio
    FROM global_markets.stocks_splits
    WHERE execution_date >= toStartOfMonth(today()) - INTERVAL 12 MONTH
      AND execution_date <  toStartOfMonth(today())
      AND split_from > 0
      AND split_to > 0
      AND ticker NOT IN ('SPCX')
)
GROUP BY m
ORDER BY m
⌘/Ctrl + Enter

Work with this data in your AI assistant

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

Claude ChatGPT Gemini Muse Your own agent