amo — 4 answered market questions

AAPL volume by ET half hour, September 2026

most recentas of 2026-10-06 series 32×3read in context →

AAPL volume by ET half hour, September 2026 — 32 rows by 3 columns, computed 2026-10-06 from US exchange, SIP and OPRA data.
et_time	volume_share_pct	volume_millions
04:00	0.237	1.65
04:30	0.056	0.39
05:00	0.048	0.33
05:30	0.05	0.34
06:00	0.049	0.34
06:30	0.082	0.57
07:00	0.16	1.11
07:30	0.162	1.13
08:00	0.24	1.67
08:30	0.28	1.94
09:00	0.524	3.63
09:30	16.532	114.69
10:00	9.332	64.74
10:30	7.675	53.24
11:00	6.58	45.65
11:30	6.137	42.58
12:00	5.23	36.28
12:30	4.273	29.64
13:00	4.559	31.63
13:30	4.507	31.27
14:00	4.771	33.1
14:30	5.419	37.6
15:00	5.76	39.96
15:30	12.848	89.13
16:00	3.612	25.06
16:30	0.331	2.3
17:00	0.173	1.2
17:30	0.159	1.11
18:00	0.059	0.41
18:30	0.052	0.36
19:00	0.038	0.26
19:30	0.064	0.44

the exact SQL behind every number

WITH bars AS
(
    SELECT
        toTimeZone(window_start, 'America/New_York') AS et,
        volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= '2026-09-01 04:00:00'
      AND window_start <  '2026-10-01 04:00:00'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 240
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 1200
)
SELECT
    formatDateTime(toStartOfInterval(et, INTERVAL 30 MINUTE), '%H:%i') AS et_time,
    round(100 * sum(volume) / (SELECT sum(volume) FROM bars), 3)       AS volume_share_pct,
    round(sum(volume) / 1e6, 2)                                        AS volume_millions
FROM bars
GROUP BY et_time
ORDER BY et_time

More from this analysisHow After-Market Orders Work: AMO vs Live

Upcoming US market holidays and early closes series 12×7 → Share of monthly volume by session phase, September 2026 ranking 5×4 → Median overnight gap against median intraday range, twelve months to September 2026 ranking 5×3 → Average quoted spread by half hour, AAPL and KO, June 17 2026 series 15×3 → See all 3,127 queries →