STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

How After-Market Orders Work: AMO vs Live
AAPL volume by ET half hour, September 2026series · 2026-10-06 · 32×3Preview: a 16-point series, roughly flat. Share of monthly volume by session phase, September 2026ranking · 2026-10-06 · 5×4Preview: 5 ranked values, largest first. Median overnight gap against median intraday range, twelve months to September 2026ranking · 2026-10-06 · 5×3Preview: 5 ranked values, largest first. Upcoming US market holidays and early closesseries · 2026-10-06 · 12×7Preview: a 12-point series, ending higher.
Premarket and After-Hours Trading Hours (ET)
Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only)table · 2026-10-04 · 3×5 The session envelope, read from SPY minute bars (last two weeks, ET)scalar · 2026-10-04 · 1×7240 Stock headlines by ET hour of publication (last 30 days, all days)ranking · 2026-10-04 · 24×3Preview: 16 ranked values, smallest first. AAPL median quoted spread: regular session vs extended hours (past week, full sessions)series · 2026-10-04 · 2×3Preview: a 2-point series, ending lower. AAPL median shares per traded minute, and the share of minutes that traded at all (ET)series · 2026-10-04 · 32×3Preview: a 16-point series, ending lower.
US Premarket and After-Hours in UK Time
SPY volume by New York hour, with the London clock beside itseries · 2026-10-01 · 16×4Preview: a 16-point series, roughly flat. AAPL median quoted spread by hour across one full extended dayseries · 2026-10-01 · 16×4Preview: a 16-point series, roughly flat. The London clock time of the 9:30am ET open, late October 2025series · 2026-10-01 · 16×4Preview: a 16-point series, roughly flat.
AAPL volume by ET half hour, September 2026

AAPL volume by ET half hour, September 2026

most recentas of series 32×3read in context →
AAPL volume by ET half hour, September 2026 — 32 rows by 3 columns, computed from US exchange, SIP and OPRA data.
et_timevolume_share_pctvolume_millions
04:000.2371.65
04:300.0560.39
05:000.0480.33
05:300.050.34
06:000.0490.34
06:300.0820.57
07:000.161.11
07:300.1621.13
08:000.241.67
08:300.281.94
09:000.5243.63
09:3016.532114.69
10:009.33264.74
10:307.67553.24
11:006.5845.65
11:306.13742.58
12:005.2336.28
12:304.27329.64
13:004.55931.63
13:304.50731.27
14:004.77133.1
14:305.41937.6
15:005.7639.96
15:3012.84889.13
16:003.61225.06
16:300.3312.3
17:000.1731.2
17:300.1591.11
18:000.0590.41
18:300.0520.36
19:000.0380.26
19:300.0640.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,256 queries →
$