2,358 answered market questions

SELECT
    multiIf(minute_of_day < 570,  '04:00-09:29 premarket',
            minute_of_day < 630,  '09:30-10:29 opening hour',
            minute_of_day < 900,  '10:30-14:59 midday',
            minute_of_day <= 960, '15:00-16:00 closing hour',
                                  '16:01-20:00 after hours')                  AS segment,
    round(toFloat64(sum(volume)) / 1e6, 1)                                     AS shares_millions,
    round(100 * toFloat64(sum(volume)) / toFloat64(sum(sum(volume)) OVER ()), 2) AS share_of_volume_pct
FROM
(
    SELECT
        volume,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
          + toMinute(toTimeZone(window_start, 'America/New_York')) AS minute_of_day
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= toDateTime('2026-08-17 08:00:00', 'UTC')
      AND window_start <  toDateTime('2026-09-12 00:00:00', 'UTC')
)
GROUP BY segment
ORDER BY segment