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

2,595 answered market questions

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

How an IPO's Opening Price Is Set
A seasoned ticker's opening auction: QQQ minute volume around 9:30 ET, September 4, 2026series · 2026-09-12 · 5×2Preview: a 5-point series, ending higher. New symbols since June 2026: minutes between the 9:30 bell and the first print, ten heaviest first minutesseries · 2026-09-12 · 10×4Preview: a 10-point series, roughly flat.
A seasoned ticker's opening auction: QQQ minute volume around 9:30 ET, September 4, 2026

A seasoned ticker's opening auction: QQQ minute volume around 9:30 ET, September 4, 2026

most recentas of series 5×2read in context →
A seasoned ticker's opening auction: QQQ minute volume around 9:30 ET, September 4, 2026 — 5 rows by 2 columns, computed from US exchange, SIP and OPRA data.
et_timeshares
09:2810650.149956
09:2911113.507785
09:30431672.159791
09:31187247.262979
09:32138608.895475
the exact SQL behind every number
SELECT
    formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:%i') AS et_time,
    sum(volume) AS shares
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'QQQ'
  AND window_start >= toDateTime('2026-09-04 09:28:00', 'America/New_York')
  AND window_start <  toDateTime('2026-09-04 09:33:00', 'America/New_York')
GROUP BY et_time
ORDER BY et_time
$