intraday_path

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
    bars AS
    (
        SELECT
            ticker,
            toTimeZone(window_start, 'America/New_York') AS et,
            toFloat64(close)                             AS px
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('VOO', 'QQQ')
          AND window_start >= toDateTime('2026-09-15 04:00:00')
          AND window_start <  toDateTime('2026-09-16 04:00:00')
    ),
    firsts AS
    (
        SELECT
            ticker,
            argMin(px, et) AS open_px
        FROM bars
        GROUP BY ticker
    )
SELECT
    formatDateTime(toStartOfInterval(b.et, INTERVAL 30 MINUTE), '%H:%i')                                  AS et_time,
    round(100 * (argMaxIf(b.px, b.et, b.ticker = 'VOO') / anyIf(f.open_px, f.ticker = 'VOO') - 1), 2)     AS voo_change_pct,
    round(100 * (argMaxIf(b.px, b.et, b.ticker = 'QQQ') / anyIf(f.open_px, f.ticker = 'QQQ') - 1), 2)     AS qqq_change_pct
FROM bars AS b
INNER JOIN firsts AS f ON f.ticker = b.ticker
GROUP BY et_time
HAVING countIf(b.ticker = 'VOO') > 0
   AND countIf(b.ticker = 'QQQ') > 0
ORDER BY et_time