Recent household-name splits: shares from one share

Name: Recent household-name splits: shares from one share
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 Due Bills and Stock Splits: Ex-Date Timing.

as of 2026-08-22 ranking 15×4read in context →

Recent household-name splits: shares from one share — 15 rows by 4 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
ticker	shares_from_one	ratio_label	adjusted_trading_began
CMG	50	50-for-1	Jun 26, 2024
AMZN	20	20-for-1	Jun 6, 2022
GOOGL	20	20-for-1	Jul 18, 2022
AVGO	10	10-for-1	Jul 15, 2024
LRCX	10	10-for-1	Oct 3, 2024
NVDA	10	10-for-1	Jun 10, 2024
SHOP	10	10-for-1	Jun 29, 2022
SMCI	10	10-for-1	Oct 1, 2024
FTNT	5	5-for-1	Jun 23, 2022
AAPL	4	4-for-1	Aug 31, 2020
DXCM	4	4-for-1	Jun 13, 2022
NEE	4	4-for-1	Oct 27, 2020
TSLA	3	3-for-1	Aug 25, 2022
WMT	3	3-for-1	Feb 26, 2024
PANW	2	2-for-1	Dec 16, 2024

Rows × columns: 15 × 4
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 Recent household-name splits: shares from one share, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	15 distinct values (AAPL, AMZN, AVGO…)
`shares_from_one`	number	2 to 50	count
`ratio_label`	text	7 distinct values (10-for-1, 2-for-1, 20-for-1…)
`adjusted_trading_began`	text	15 distinct values (Aug 25, 2022, Aug 31, 2020, Dec 16, 2024…)

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
    ticker,
    round(argMax(toFloat64(split_to) / greatest(toFloat64(split_from), 1.0), execution_date), 2) AS shares_from_one,
    argMax(concat(toString(toUInt32(split_to)), '-for-', toString(toUInt32(split_from))), execution_date) AS ratio_label,
    argMax(formatDateTime(execution_date, '%b %e, %Y'), execution_date) AS adjusted_trading_began
FROM global_markets.stocks_splits
WHERE execution_date >= '2020-01-01'
  AND execution_date <= today()
  AND toFloat64(split_to) / greatest(toFloat64(split_from), 1.0) >= 2
  AND ticker IN ('AAPL', 'AMZN', 'AVGO', 'CMG', 'DXCM', 'FTNT', 'GOOGL', 'LRCX', 'NEE', 'NVDA', 'PANW', 'SHOP', 'SMCI', 'TSLA', 'WMT')
GROUP BY ticker
ORDER BY shares_from_one DESC, ticker

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 analysisDue Bills and Stock Splits: Ex-Date Timing

Days between pay date and ex-date, cash distributions that went ex late ranking 12×3 → US stock splits by year, sorted by size of the distribution ranking 10×4 → NVDA across its June 2024 split: stored close and one pre-split share series 10×5 → The T+1 cutover, week by week: share of dividends with ex-date = record date, April–July 2024 ranking 18×3 → Time value left in deep in-the-money SPY calls, against the dividend at stake ranking 16×4 → Ex-date vs. record date by year: share identical, and the median gap in calendar days ranking 12×4 → See all 2,170 queries →