STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

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

Can You Trade US Stocks 24 Hours a Day?
Shares printed by New York clock hour: AAPL, MSFT, NVDA, SPY and TSLA, week of July 13, 2026series · 2026-08-01 · 16×3Preview: a 16-point series, roughly flat. AAPL quoted spread by New York clock hour, July 14, 2026: median and 90th percentile minuteranking · 2026-08-01 · 7×4Preview: 7 ranked values, smallest first. Share of weekly volume by session window: seven household names, week of July 13, 2026ranking · 2026-08-01 · 7×4Preview: 7 ranked values, largest first. NVDA on July 14, 2026: price and volume in 30 minute buckets, 4:00 a.m. to 8:00 p.m. ETseries · 2026-08-01 · 32×3Preview: a 16-point series, roughly flat.
Shares printed by New York clock hour: AAPL, MSFT, NVDA, SPY and TSLA, week of July 13, 2026

Shares printed by New York clock hour: AAPL, MSFT, NVDA, SPY and TSLA, week of July 13, 2026

most recentas of series 16×3read in context →
Shares printed by New York clock hour: AAPL, MSFT, NVDA, SPY and TSLA, week of July 13, 2026 — 16 rows by 3 columns, computed from US exchange, SIP and OPRA data.
et_hourvolume_millionspct_of_week
04:007.40.59
05:001.60.13
06:002.10.17
07:007.50.6
08:0090.72
09:0020416.34
10:00206.416.53
11:00142.211.39
12:00144.811.6
13:00117.89.44
14:00121.89.75
15:00233.418.7
16:0043.83.51
17:002.60.21
18:001.90.15
19:002.20.18
the exact SQL behind every number 
WITH (
    SELECT sum(volume)
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'TSLA')
      AND window_start >= toDateTime('2026-07-13 08:00:00', 'UTC')
      AND window_start <  toDateTime('2026-07-18 00:00:00', 'UTC')
) AS week_shares
SELECT formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:00') AS et_hour,
       round(toFloat64(sum(volume)) / 1000000, 1) AS volume_millions,
       round(100 * toFloat64(sum(volume)) / toFloat64(week_shares), 2) AS pct_of_week
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'TSLA')
  AND window_start >= toDateTime('2026-07-13 08:00:00', 'UTC')
  AND window_start <  toDateTime('2026-07-18 00:00:00', 'UTC')
GROUP BY et_hour
ORDER BY et_hour
More from this analysisCan You Trade US Stocks 24 Hours a Day?
NVDA on July 14, 2026: price and volume in 30 minute buckets, 4:00 a.m. to 8:00 p.m. ET series 32×3 → AAPL quoted spread by New York clock hour, July 14, 2026: median and 90th percentile minute ranking 7×4 → Share of weekly volume by session window: seven household names, week of July 13, 2026 ranking 7×4 → Quoted spread through the session: large cap fund vs micro cap fund series 79×3 → See all 2,173 queries →
$