ist_hour_volume

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
    hourly AS
    (
        SELECT
            ticker,
            toHour(toTimeZone(window_start, 'America/New_York')) AS et_h,
            sum(volume)                                          AS v
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('AAPL', 'MSFT', 'NVDA')
          AND window_start >= '2026-09-01 00:00:00'
          AND window_start <  '2026-10-01 00:00:00'
          AND toHour(toTimeZone(window_start, 'America/New_York')) BETWEEN 4 AND 19
        GROUP BY ticker, et_h
    ),
    shares AS
    (
        SELECT
            ticker,
            et_h,
            100 * v / sum(v) OVER (PARTITION BY ticker) AS pct
        FROM hourly
    )
SELECT
    concat(leftPad(toString((et_h + 9) % 24), 2, '0'), ':30') AS ist_time,
    round(sumIf(pct, ticker = 'AAPL'), 2)                     AS aapl_pct,
    round(sumIf(pct, ticker = 'MSFT'), 2)                     AS msft_pct,
    round(sumIf(pct, ticker = 'NVDA'), 2)                     AS nvda_pct
FROM shares
GROUP BY et_h
ORDER BY et_h