STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

When Does a Stock Split Take Effect?
Completed forward splits of 3-for-1 or larger: selected large-cap names, 2022 to 2026ranking · 2026-08-05 · 12×4Preview: 12 ranked values, largest first. US-listed splits by ratio band, 2021 to mid-2026: the 25% line in the dataranking · 2026-08-05 · 5×3Preview: 5 ranked values, largest first. NVDA around its 10-for-1 split: regular-session close and volume, June 3 to June 14, 2024series · 2026-08-05 · 10×4Preview: a 10-point series, ending higher. Effective dates by weekday: US-listed splits, 2021 to mid-2026series · 2026-08-05 · 5×3Preview: a 5-point series, ending lower.
Completed forward splits of 3-for-1 or larger: selected large-cap names, 2022 to 2026

Completed forward splits of 3-for-1 or larger: selected large-cap names, 2022 to 2026

most recentas of ranking 12×4read in context →
Completed forward splits of 3-for-1 or larger: selected large-cap names, 2022 to 2026 — 12 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickereffective_labelratio_labelnew_shares_per_old_share
BKNGApr 6, 202625-for-125
NFLXNov 17, 202510-for-110
ORLYJun 10, 202515-for-115
LRCXOct 3, 202410-for-110
SMCIOct 1, 202410-for-110
DECKSep 17, 20246-for-16
AVGOJul 15, 202410-for-110
CMGJun 26, 202450-for-150
NVDAJun 10, 202410-for-110
WMTFeb 26, 20243-for-13
TSLAAug 25, 20223-for-13
GOOGLJul 18, 202220-for-120
the exact SQL behind every number 
SELECT ticker,
       formatDateTime(execution_date, '%b %e, %Y') AS effective_label,
       concat(toString(toUInt32(max(split_to))), '-for-', toString(toUInt32(max(split_from)))) AS ratio_label,
       round(toFloat64(max(split_to)) / toFloat64(max(split_from)), 1) AS new_shares_per_old_share
FROM global_markets.stocks_splits
WHERE execution_date >= toDate('2022-01-01')
  AND execution_date <= toDate('2026-07-31')
  AND split_to > 0
  AND split_from > 0
  AND toFloat64(split_to) / toFloat64(split_from) >= 3
  AND ticker IN ('AMZN', 'GOOGL', 'TSLA', 'WMT', 'NVDA', 'CMG', 'AVGO', 'SMCI', 'LRCX', 'DECK', 'ORLY', 'NFLX', 'MSFT', 'AAPL', 'COST', 'ISRG', 'BKNG', 'FICO')
GROUP BY ticker, execution_date
ORDER BY max(execution_date) DESC
LIMIT 12
More from this analysisWhen Does a Stock Split Take Effect?
US-listed splits by ratio band, 2021 to mid-2026: the 25% line in the data ranking 5×3 → NVDA around its 10-for-1 split: regular-session close and volume, June 3 to June 14, 2024 series 10×4 → Effective dates by weekday: US-listed splits, 2021 to mid-2026 series 5×3 → Forward and reverse splits by year across US listings ranking 10×3 → See all 2,170 queries →
$