split_math
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-24, from stock-splits-in-japan-trading-units.
| ticker | split_label | effective_on | shares_after_100 | ticket_cut_pct |
|---|---|---|---|---|
| CMG | 50-for-1 | Jun 26, 2024 | 5000 | 98 |
| BKNG | 25-for-1 | Apr 6, 2026 | 2500 | 96 |
| GOOGL | 20-for-1 | Jul 18, 2022 | 2000 | 95 |
| GOOG | 20-for-1 | Jul 18, 2022 | 2000 | 95 |
| KLAC | 10-for-1 | Jun 12, 2026 | 1000 | 90 |
| NFLX | 10-for-1 | Nov 17, 2025 | 1000 | 90 |
| LRCX | 10-for-1 | Oct 3, 2024 | 1000 | 90 |
| SMCI | 10-for-1 | Oct 1, 2024 | 1000 | 90 |
| AVGO | 10-for-1 | Jul 15, 2024 | 1000 | 90 |
| CVNA | 5-for-1 | May 8, 2026 | 500 | 80 |
| NOW | 5-for-1 | Dec 18, 2025 | 500 | 80 |
| FTNT | 5-for-1 | Jun 23, 2022 | 500 | 80 |
- Rows × columns
- 12 × 5
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
ticker |
text | 12 distinct values (AVGO, BKNG, CMG…) | |
split_label |
text | 5 distinct values (10-for-1, 20-for-1, 25-for-1…) | |
effective_on |
text | 11 distinct values (Apr 6, 2026, Dec 18, 2025, Jul 15, 2024…) | |
shares_after_100 |
number | 500 to 5,000 | count |
ticket_cut_pct |
number | 80 to 98 | percent |
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.
WITH
large_caps AS
(
SELECT ticker
FROM global_markets.stocks_ratios
WHERE date >= today() - 60
AND market_cap > 20000000000
GROUP BY ticker
),
forward_splits AS
(
SELECT
ticker,
execution_date,
any(split_to) AS split_to,
any(split_from) AS split_from
FROM global_markets.stocks_splits
WHERE execution_date >= '2022-01-01'
AND execution_date < today()
AND ticker NOT IN ('SPCX')
GROUP BY ticker, execution_date
HAVING split_to > split_from
)
SELECT
f.ticker AS ticker,
concat(toString(toUInt32(f.split_to)), '-for-',
toString(toUInt32(f.split_from))) AS split_label,
formatDateTime(f.execution_date, '%b %e, %Y') AS effective_on,
toUInt32(round(100 * toFloat64(f.split_to) / toFloat64(f.split_from))) AS shares_after_100,
round(100 * (1 - toFloat64(f.split_from) / toFloat64(f.split_to)), 1) AS ticket_cut_pct
FROM forward_splits AS f
INNER JOIN large_caps AS l ON l.ticker = f.ticker
ORDER BY shares_after_100 DESC, f.execution_date DESC
LIMIT 12
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.