opening_volume_curve

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 minutes AS
(
    SELECT
        toTimeZone(window_start, 'America/New_York') AS et,
        toFloat64(volume)                            AS shares
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= '2026-09-01 00:00:00'
      AND window_start <  '2026-10-01 00:00:00'
),
buckets AS
(
    SELECT
        formatDateTime(toStartOfTenMinutes(et), '%H:%i') AS et_time,
        sum(shares)                                      AS bucket_shares
    FROM minutes
    WHERE (toHour(et) * 60 + toMinute(et)) >= 570
      AND (toHour(et) * 60 + toMinute(et)) <  960
    GROUP BY et_time
)
SELECT
    et_time,
    round(100 * bucket_shares / sum(bucket_shares) OVER (), 2) AS share_of_day_pct
FROM buckets
ORDER BY et_time