Stock splits taking effect each quarter, forward and reverse

Name: Stock splits taking effect each quarter, forward and reverse
Creator: Strasmore
Published: 2026-08-22
License: https://www.strasmore.com/terms/

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-08-22, from h5i-db: Point-in-Time Data for Backtests.

as of 2026-08-22 series 16×3read in context →

Stock splits taking effect each quarter, forward and reverse — 16 rows by 3 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
quarter_start_date	forward_splits	reverse_splits
2022-07-01	102	154
2022-10-01	77	216
2023-01-01	76	176
2023-04-01	94	227
2023-07-01	124	215
2023-10-01	68	219
2024-01-01	101	192
2024-04-01	126	216
2024-07-01	113	205
2024-10-01	114	258
2025-01-01	89	253
2025-04-01	110	259
2025-07-01	119	239
2025-10-01	111	287
2026-01-01	102	293
2026-04-01	131	303

Rows × columns: 16 × 3
Period covered: 2022-07-01 to 2026-04-01
Computed: 2026-08-22
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 Stock splits taking effect each quarter, forward and reverse, derived from the stored result.
Column	Type	Range
`quarter_start_date`	date	2022-07-01 to 2026-04-01
`forward_splits`	number	68 to 131
`reverse_splits`	number	154 to 303

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 2026-08-22, and the query below is what returned them.

the exact SQL behind every number

SELECT
    toString(toStartOfQuarter(execution_date))    AS quarter_start_date,
    countDistinctIf(id, split_to > split_from)    AS forward_splits,
    countDistinctIf(id, split_to < split_from)    AS reverse_splits
FROM global_markets.stocks_splits
WHERE execution_date >= toStartOfQuarter(today() - 1460)
  AND execution_date <  toStartOfQuarter(today())
  AND split_from > 0
  AND split_to   > 0
GROUP BY quarter_start_date
ORDER BY quarter_start_date

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysish5i-db: Point-in-Time Data for Backtests

Days between a dividend declaration and its ex-date, by month series 24×3 → How long 13F holdings filings take to reach the public series 16×3 → When market headlines publish, by New York clock hour ranking 24×2 → KO quarterly dividend in cents and as a percent of the share price, 2016 to 2026 series 42×4 → Average distance from one session's close to the next session's open, monthly series 24×4 → How far the price travels inside one minute: KO, by New York clock time, 17 June 2026 series 18×2 → See all 2,170 queries →