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

How split-adjusted price history works
Split multiples for large US stock splits since 2020ranking · 2026-08-22 · 10×3Preview: 10 ranked values, smallest first. Dollar volume and daily range across a large forward split (NVDA, 2024)series · 2026-08-22 · 19×4Preview: a 16-point series, roughly flat. Dividend adjustment factors on every KO ex-date since 2019series · 2026-08-22 · 30×4Preview: a 16-point series, ending higher. Is the price file already adjusted? The pre and post close quotientranking · 2026-08-22 · 10×3Preview: 10 ranked values, largest first.
Split multiples for large US stock splits since 2020

Split multiples for large US stock splits since 2020

most recentas of ranking 10×3read in context →
Split multiples for large US stock splits since 2020 — 10 rows by 3 columns, computed from US exchange, SIP and OPRA data.
split_eventsplit_ratiosplit_n
TSLA Aug 20223-for-13
WMT Feb 20243-for-13
AAPL Aug 20204-for-14
NVDA Jul 20214-for-14
TSLA Aug 20205-for-15
NVDA Jun 202410-for-110
SHOP Jun 202210-for-110
AMZN Jun 202220-for-120
GOOGL Jul 202220-for-120
CMG Jun 202450-for-150
the exact SQL behind every number
SELECT
    concat(ticker, ' ', formatDateTime(execution_date, '%b %Y'))                             AS split_event,
    concat(toString(toUInt32(any(split_to))), '-for-', toString(toUInt32(any(split_from)))) AS split_ratio,
    round(toFloat64(any(split_to)) / toFloat64(any(split_from)), 2)                          AS split_n
FROM global_markets.stocks_splits
WHERE execution_date >= '2020-01-01'
  AND execution_date < today()
  AND split_to >= split_from * 3
  AND ticker IN ('AAPL', 'AMZN', 'CMG', 'GOOGL', 'NVDA', 'SHOP', 'TSLA', 'WMT')
  AND ticker NOT IN ('SPCX')
GROUP BY ticker, execution_date
ORDER BY split_n, split_event
$