dem_nvda

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
        toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
            + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minutes,
        volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'NVDA'
      AND window_start >= toDateTime('2026-07-01 00:00:00')
      AND window_start <  toDateTime('2026-10-01 00:00:00')
),
nightly AS
(
    SELECT
        et_date,
        sumIf(volume, et_minutes < 570)  / 1e6 AS premarket_millions,
        sumIf(volume, et_minutes >= 960) / 1e6 AS after_hours_millions
    FROM bars
    GROUP BY et_date
),
peak AS
(
    SELECT
        formatDateTime(argMax(et_date, after_hours_millions), '%d/%m/%Y') AS peak_label,
        round(max(after_hours_millions), 2)                               AS peak_millions
    FROM nightly
)
SELECT
    toString(et_date)                       AS date,
    round(premarket_millions, 2)            AS premarket_volume_millions,
    round(after_hours_millions, 2)          AS after_hours_volume_millions,
    (SELECT peak_millions FROM peak)        AS peak_after_hours_millions,
    (SELECT peak_label FROM peak)           AS peak_night_date_label
FROM nightly
ORDER BY et_date