delay_window

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 buckets AS
(
    SELECT
        ticker,
        toStartOfInterval(window_start, INTERVAL 15 MINUTE) AS bucket,
        max(toFloat64(high))  AS hi,
        min(toFloat64(low))   AS lo,
        avg(toFloat64(close)) AS mid
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'KO')
      AND window_start >= '2026-06-01 00:00:00'
      AND window_start <  '2026-07-01 00:00:00'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) <  960
    GROUP BY ticker, bucket
)
SELECT
    formatDateTime(toTimeZone(bucket, 'America/New_York'), '%H:%i') AS et_time,
    round(avgIf((hi - lo) / mid * 100, ticker = 'SPY'), 3)          AS spy_range_pct,
    round(avgIf((hi - lo) / mid * 100, ticker = 'KO'), 3)           AS ko_range_pct
FROM buckets
GROUP BY et_time
HAVING countIf(ticker = 'SPY') > 0
   AND countIf(ticker = 'KO') > 0
ORDER BY et_time