regular_open
Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-12, from how-the-ipo-opening-price-is-set.
| et_time | shares |
|---|---|
| 09:28 | 10650.149956 |
| 09:29 | 11113.507785 |
| 09:30 | 431672.159791 |
| 09:31 | 187247.262979 |
| 09:32 | 138608.895475 |
- Rows × columns
- 5 × 2
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
et_time |
text | 5 distinct values (09:28, 09:29, 09:30…) | |
shares |
number | 10,650.15 to 431,672.1598 | count |
Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.
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
Run your own version of this
The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.
More from this analysishow-the-ipo-opening-price-is-set
new_symbols
series 10×4
→
One SPY $600 LEAPS call's price over two years (expired Jan 16 2026)
series 470×2
→
2s10s spread, monthly average: last 20 years
series 240×2
→
Growth of $100 in the 1x SOXX vs the 3x SOXL, Jan 2 to Jul 13 2026
series 131×3
→
SPY underwater curve: month end close against its running peak, 2016 to 2026
series 127×2
→
The S&P 500's underwater curve: worst drawdown from a prior high, by month
series 127×2
→
See all 2,214 queries →