STRASMORE/EXPLORE 2,170 QUERIES

The morning after: July 7, 2026 through 12:59 p.m. ET (window pinned by design; see data notes)

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-09, from SpaceX Joins the Nasdaq-100: The Index-Add Trade.

as of scalar 1×10read in context →
morning bars
210
last bar et
12:59
open 0930
158.92
open below monday close pct
0.9
morning low
150.12
morning high
159.3
px 1259 et
152.01
px 1259 below monday close pct
5.2
morning shares m
42.9
monday official close
160.42
Rows × columns
1 × 10
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 morning after: July 7, 2026 through 12:59 p.m. ET (window pinned by design; see data notes), derived from the stored result.
ColumnTypeRangeNotes
morning_bars number every row is 210
last_bar_et text 1 distinct value (12:59)
open_0930 number every row is 158.92 US dollars
open_below_monday_close_pct number every row is 0.9 percent
morning_low number every row is 150.12 US dollars
morning_high number every row is 159.3 US dollars
px_1259_et number every row is 152.01
px_1259_below_monday_close_pct number every row is 5.2 percent
morning_shares_m number every row is 42.9 count
monday_official_close number every row is 160.42 US dollars

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 
WITH
    (
        SELECT round(toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8))), 2)
        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'
    ) AS monday_close
SELECT
    count() AS morning_bars,
    formatDateTime(toTimeZone(max(window_start), 'America/New_York'), '%H:%i') AS last_bar_et,
    round(toFloat64(argMin(open, window_start)), 2) AS open_0930,
    round((1 - toFloat64(argMin(open, window_start)) / monday_close) * 100, 1) AS open_below_monday_close_pct,
    round(min(toFloat64(low)), 2) AS morning_low,
    round(max(toFloat64(high)), 2) AS morning_high,
    round(toFloat64(argMax(close, window_start)), 2) AS px_1259_et,
    round((1 - toFloat64(argMax(close, window_start)) / monday_close) * 100, 1) AS px_1259_below_monday_close_pct,
    round(toFloat64(sum(volume)) / 1e6, 1) AS morning_shares_m,
    monday_close AS monday_official_close
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
  AND window_start >= '2026-07-07 13:30:00' AND window_start < '2026-07-07 17:00:00'

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 analysisSpaceX Joins the Nasdaq-100: The Index-Add Trade
The add-eve receipts row: checkpoints, the last continuous trade, and the auction print itself scalar 1×23 → 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 → July 6's matched volume by where it printed: the cross, continuous on-exchange, off-exchange (TRF) ranking 3×4 → 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 →