Notable US stock splits since 2020: ratio, how the action was recorded, and the next 21 sessions vs SPY

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.

SELECT ticker, executed_on, ratio, recorded_as, stock_21_sessions_pct, spy_21_sessions_pct
FROM (
    WITH events AS (
        SELECT ticker, execution_date,
               concat(toString(toInt32(split_to)), '-for-', toString(toInt32(split_from))) AS ratio,
               if(adjustment_type = 'stock_dividend', 'stock dividend', 'forward split') AS recorded_as
        FROM global_markets.stocks_splits
        WHERE ticker IN ('AAPL', 'TSLA', 'GOOGL', 'AMZN', 'NVDA', 'WMT', 'CMG', 'AVGO', 'SMCI', 'LRCX', 'DECK', 'ORLY', 'NFLX')
          AND execution_date >= '2020-01-01' AND execution_date <= '2026-06-30'
          AND split_to > split_from
    ),
    daily AS (
        SELECT ticker,
               toDate(toTimeZone(window_start, 'America/New_York')) AS d,
               argMaxIf(toFloat64(close), window_start,
                        (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS close_rth
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN (SELECT ticker FROM events UNION ALL SELECT 'SPY')
          AND window_start >= '2020-08-01 00:00:00' AND window_start < '2026-01-15 00:00:00'
        GROUP BY ticker, d
        HAVING close_rth > 0
    ),
    series AS (
        SELECT ticker, arraySort(x -> x.1, groupArray((d, close_rth))) AS dc
        FROM daily
        GROUP BY ticker
    ),
    spy AS (
        SELECT dc AS spy_dc FROM series WHERE ticker = 'SPY'
    )
    SELECT e.ticker AS ticker,
           toString(e.execution_date) AS executed_on,
           e.ratio AS ratio,
           e.recorded_as AS recorded_as,
           arrayFirstIndex(x -> x.1 >= e.execution_date, s.dc) AS idx,
           arrayFirstIndex(x -> x.1 >= e.execution_date, spy_dc) AS sidx,
           round((s.dc[idx + 21].2 / s.dc[idx].2 - 1) * 100, 1) AS stock_21_sessions_pct,
           round((spy_dc[sidx + 21].2 / spy_dc[sidx].2 - 1) * 100, 1) AS spy_21_sessions_pct,
           e.execution_date AS ed
    FROM events e
    JOIN series s ON s.ticker = e.ticker
    CROSS JOIN spy
    ORDER BY ed DESC, ticker ASC
)