The eight widest prior-close to regular-open distances in AAPL, Sep 2023 to Sep 2026

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 daily AS
(
    SELECT
        date,
        toFloat64(any(open))  AS open_px,
        toFloat64(any(close)) AS close_px
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'AAPL'
      AND date >= '2023-09-01'
      AND date <  '2026-09-01'
    GROUP BY date
),
gapped AS
(
    SELECT
        date,
        open_px,
        any(close_px) OVER (ORDER BY date ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prior_close_px
    FROM daily
)
SELECT
    formatDateTime(date, '%b %e, %Y')                    AS session_label,
    round(prior_close_px, 2)                             AS prior_close,
    round(open_px, 2)                                    AS session_open,
    round(abs(open_px / prior_close_px - 1) * 100, 2)    AS gap_pct,
    if(open_px >= prior_close_px, 'above', 'below')      AS open_side
FROM gapped
WHERE prior_close_px > 0
ORDER BY gap_pct DESC
LIMIT 8