SpaceX Joins the Nasdaq-100: The Index-Add Trade
July 6's matched volume by where it printed: the cross, continuous on-exchange, off-exchange (TRF)ranking ·
2026-07-09 · 3×4
The morning after: July 7, 2026 through 12:59 p.m. ET (window pinned by design; see data notes)scalar ·
2026-07-09 · 1×10210
The add-eve receipts row: checkpoints, the last continuous trade, and the auction print itselfscalar ·
2026-07-09 · 1×23165.95
July 6, 2026 in five-minute buckets: the slide, the late climb, and the volume underneathseries ·
2026-07-09 · 78×3
Levine's three sessions on our tape: day volume, the closing cross, and the cross's share of the dayseries ·
2026-07-09 · 3×7
Entity receipt: the old SPCX tape ends in April 2026, May is silent, SpaceX lists June 12series ·
2026-07-09 · 5×6
Every SPCX closing cross since the June 12 listing: size, share of the day, and the official close it setseries ·
2026-07-09 · 15×6
July 6's matched volume by where it printed: the cross, continuous on-exchange, off-exchange (TRF)
July 6's matched volume by where it printed: the cross, continuous on-exchange, off-exchange (TRF)
| bucket | shares_m | pct_of_matched | prints |
|---|---|---|---|
| Closing auction (one print) | 74.9 | 39.7 | 1 |
| Off-exchange (TRF) | 68.8 | 36.4 | 598632 |
| On-exchange, continuous | 45.1 | 23.9 | 644125 |
the exact SQL behind every number
SELECT
multiIf(has(conditions, 8), 'Closing auction (one print)', exchange = 4, 'Off-exchange (TRF)', 'On-exchange, continuous') AS bucket,
round(toFloat64(sum(size)) / 1e6, 1) AS shares_m,
round(100 * toFloat64(sum(size)) / sum(toFloat64(sum(size))) OVER (), 1) AS pct_of_matched,
count() AS prints
FROM global_markets.stocks_trades
WHERE ticker = 'SPCX'
AND sip_timestamp >= '2026-07-06 00:00:00' AND sip_timestamp < '2026-07-07 00:00:00'
AND NOT hasAny(conditions, [15, 16, 38])
GROUP BY bucket
ORDER BY bucket
More from this analysisSpaceX Joins the Nasdaq-100: The Index-Add Trade
July 6, 2026 in five-minute buckets: the slide, the late climb, and the volume underneath
series 78×3
→
Every SPCX closing cross since the June 12 listing: size, share of the day, and the official close it set
series 15×6
→
Entity receipt: the old SPCX tape ends in April 2026, May is silent, SpaceX lists June 12
series 5×6
→
Levine's three sessions on our tape: day volume, the closing cross, and the cross's share of the day
series 3×7
→
See all 2,170 queries →