STRASMORE/EXPLORE 2,170 QUERIES

The whole US tape ranked by June 12–30 regular-hours dollar volume

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-07-27, from SPCX: SpaceX's First Month on the Public Market.

as of ranking 12×4read in context →
The whole US tape ranked by June 12–30 regular-hours dollar volume — 12 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickerregular_hours_dollar_bnpct_of_leaderis_spcx
MU585.41000
SPY434.174.20
QQQ346.659.20
SPCX344.658.91
NVDA253.143.20
SNDK231.639.60
TSLA192.432.90
INTC164.328.10
MSFT161.827.60
AAPL155.626.60
AMD147.925.30
AMZN136.523.30
Rows × columns
12 × 4
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 The whole US tape ranked by June 12–30 regular-hours dollar volume, derived from the stored result.
ColumnTypeRangeNotes
ticker text 12 distinct values (AAPL, AMD, AMZN…)
regular_hours_dollar_bn number 136.5 to 585.4
pct_of_leader number 23.3 to 100 percent
is_spcx number 0 to 1

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
    ticker,
    round(sum(toFloat64(volume) * toFloat64(close)) / 1e9, 1) AS regular_hours_dollar_bn,
    round(100 * sum(toFloat64(volume) * toFloat64(close)) / max(sum(toFloat64(volume) * toFloat64(close))) OVER (), 1) AS pct_of_leader,
    toUInt8(ticker = 'SPCX') AS is_spcx
FROM global_markets.delayed_stocks_minute_aggs
WHERE window_start >= toDateTime('2026-06-12 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
  AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
GROUP BY ticker
ORDER BY regular_hours_dollar_bn DESC
LIMIT 12

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 analysisSPCX: SpaceX's First Month on the Public Market
Day one by half hour: quote updates and the median spread finding its level ranking 13×4 SpaceX's 2026 SEC trail by form type, in filing order (CIK 0001181412, deduped by accession) ranking 12×4 Where the contracts landed: call and put volume by strike bucket table 19×5 Symbol-reuse receipt: thirteen months of SPCX minute bars, May 2026 is absent entirely series 12×5 The seasoning curve: regular-hours spread by session, per-update and time-weighted series 12×8 FINRA off-exchange short volume by session: marked-short share and reported volume series 12×4 See all 2,170 queries →