STRASMORE/EXPLORE 2,214 QUERIES

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.

as of series 5×2read in context →
regular_open — 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
Rows × columns
5 × 2
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for regular_open, derived from the stored result.
ColumnTypeRangeNotes
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 →