A one cent tick before and after real forward splits

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 forward_splits AS (
    SELECT
        ticker,
        execution_date,
        toUInt32(any(split_to))   AS to_shares,
        toUInt32(any(split_from)) AS from_shares
    FROM global_markets.stocks_splits
    WHERE execution_date BETWEEN '2024-01-01' AND '2026-09-30'
      AND split_to > split_from
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
),
qualifying_sessions AS (
    SELECT
        ticker,
        date,
        toFloat64(close) AS close_px
    FROM global_markets.stocks_daily_aggs
    WHERE date BETWEEN '2024-01-01' AND '2026-10-06'
      AND volume >= 500000
      AND ticker IN (SELECT ticker FROM forward_splits)
),
first_close AS (
    SELECT
        s.ticker                      AS ticker,
        s.execution_date              AS effective_date,
        s.to_shares                   AS to_shares,
        s.from_shares                 AS from_shares,
        argMin(f.close_px, f.date)    AS close_after
    FROM forward_splits AS s
    INNER JOIN qualifying_sessions AS f ON f.ticker = s.ticker
    WHERE f.date >= s.execution_date
      AND f.date <= s.execution_date + 6
    GROUP BY s.ticker, s.execution_date, s.to_shares, s.from_shares
)
SELECT
    ticker,
    formatDateTime(effective_date, '%b %e, %Y')                       AS effective_on,
    concat(toString(to_shares), '-for-', toString(from_shares))       AS split_label,
    round(100.0 / (close_after * to_shares / from_shares), 3)         AS tick_before_bps,
    round(100.0 / close_after, 3)                                     AS tick_after_bps
FROM first_close
WHERE close_after >= 10
  AND to_shares / from_shares >= 2
ORDER BY to_shares / from_shares DESC, ticker
LIMIT 12