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

2,170 answered market questions

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

MOC and MOO Order Cutoff Times: NYSE & Nasdaq
SPY minute volume into the close, June 30 2026 (quarter end)series · 2026-08-22 · 31×2Preview: a 16-point series, ending higher. Share of SPY's regular-session volume by five-minute ET bucketseries · 2026-08-22 · 79×2Preview: a 16-point series, ending lower. Opening and closing windows as a share of regular-session volumeranking · 2026-08-22 · 8×3Preview: 8 ranked values, largest first. SPY: opening and closing window share of session volume, by monthseries · 2026-08-22 · 25×3Preview: a 16-point series, ending lower.
NYSE Imbalance Messages: How to Read Them
Gap between the 3:50 p.m. price and the official close, July 2026 sessionsranking · 2026-08-19 · 6×3Preview: 6 ranked values, largest first. How often the close finished above the 3:50 p.m. price, July 2026 sessionsranking · 2026-08-19 · 6×3Preview: 6 ranked values, largest first. Coca-Cola average volume per five-minute bucket, 3:00 p.m. ET to the close, July 2026series · 2026-08-19 · 13×2Preview: a 13-point series, roughly flat. Share of regular-session volume printed in the opening and closing auction minutes, July 2026ranking · 2026-08-19 · 6×3Preview: 6 ranked values, largest first.
What Is the Opening Auction? How Stocks Open
The opening cross vs. the rest of the day: SPY, AAPL, NVDA on July 2, 2026series · 2026-07-26 · 3×12Preview: a 3-point series, ending higher. AAPL volume by quarter-hour, July 2, 2026: pre-market to after-hours (ET)series · 2026-07-26 · 64×2Preview: a 16-point series, roughly flat. The 9:30 bar vs. the 12:30 bar: SPY, AAPL, NVDA on July 2, 2026table · 2026-07-26 · 3×8 The tape's own labels for the open, straight from the code dictionaryranking · 2026-07-26 · 5×3Preview: 5 ranked values, smallest first. The receipt: AAPL's opening cross vs. everything that traded before it, July 1-2, 2026scalar · 2026-07-26 · 1×14390
SPY minute volume into the close, June 30 2026 (quarter end)

SPY minute volume into the close, June 30 2026 (quarter end)

most recentas of series 31×2read in context →
SPY minute volume into the close, June 30 2026 (quarter end) — 31 rows by 2 columns, computed from US exchange, SIP and OPRA data.
et_timevolume_mm
15:300.13
15:310.16
15:320.18
15:330.11
15:340.1
15:350.11
15:360.16
15:370.11
15:380.12
15:390.22
15:400.22
15:410.11
15:420.14
15:430.17
15:440.1
15:450.24
15:460.17
15:470.15
15:480.14
15:490.2
15:500.43
15:510.33
15:520.25
15:530.21
15:540.39
15:550.77
15:560.95
15:571.13
15:582.09
15:593.35
16:001.07
the exact SQL behind every number 
SELECT
    formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:%i') AS et_time,
    round(volume / 1e6, 2)                                               AS volume_mm
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
  AND window_start >= toDateTime('2026-06-30 19:30:00', 'UTC')
  AND window_start <= toDateTime('2026-06-30 20:00:00', 'UTC')
ORDER BY window_start
More from this analysisMOC and MOO Order Cutoff Times: NYSE & Nasdaq
Share of SPY's regular-session volume by five-minute ET bucket series 79×2 → SPY: opening and closing window share of session volume, by month series 25×3 → Opening and closing windows as a share of regular-session volume ranking 8×3 → Average quoted spread by half hour, AAPL and KO, June 17 2026 series 15×3 → See all 2,170 queries →
$