Share of SPY's regular-session volume by five-minute ET bucket

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
    formatDateTime(toDateTime(bucket_minute * 60, 'UTC'), '%H:%i')        AS et_time,
    round(100 * bucket_volume / sum(bucket_volume) OVER (), 3)           AS pct_of_session_volume
FROM
(
    SELECT
        intDiv(et_minute_of_day, 5) * 5 AS bucket_minute,
        sum(volume)                     AS bucket_volume
    FROM
    (
        SELECT
            toHour(toTimeZone(window_start, 'America/New_York')) * 60
                + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minute_of_day,
            volume
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND window_start >= today() - 75
          AND window_start <  today() - 2
    )
    WHERE et_minute_of_day >= 570 AND et_minute_of_day <= 960
    GROUP BY bucket_minute
)
ORDER BY et_time