resolution

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
    toString(bars.session)                AS session_date,
    formatDateTime(bars.session, '%b %e') AS session_label,
    round((toFloat64(bars.high) - toFloat64(bars.low)) / toFloat64(bars.close) * 10000, 1) AS daily_range_bps,
    round(mins.widest_minute_bps, 1)      AS widest_minute_bps
FROM
(
    SELECT date AS session, high, low, close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'AAPL'
      AND date >= '2026-06-01'
      AND date <  '2026-07-01'
) AS bars
INNER JOIN
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS session,
        max((toFloat64(high) - toFloat64(low)) / toFloat64(close) * 10000) AS widest_minute_bps
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= '2026-06-01 04:00:00'
      AND window_start <  '2026-07-01 04: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 session
) AS mins ON mins.session = bars.session
ORDER BY bars.session