The add-eve receipts row: checkpoints, the last continuous trade, and the auction print itself

Name: The add-eve receipts row: checkpoints, the last continuous trade, and the auction print itself
Creator: Strasmore
Published: 2026-07-09
License: https://www.strasmore.com/terms/

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 2026-07-09 scalar 1×23read in context →

open 0930

165.95

px 1300 et

162.18

px 1530 close

155.46

px 1530 bar low

155.42

px 1530 bar high

155.92

shares 1530 1559 m

19.3

last continuous px

160.5

last continuous et

16:00:00

code8 prints

auction shares m

74.94

auction price

160.42

auction time et

16:00:00

auction notional busd

12.02

close minus 1530 usd

4.96

open minus close usd

5.53

px1300 minus close usd

1.76

open minus 1300 usd

3.77

cross vs last tick cents

-8

spcx close below prior pct

0.98

spy close jul6

751.28

spy day change pct

0.87

median prior auction m

4.49

auction vs prior median x

16.7

Rows × columns: 1 × 23
Computed: 2026-07-09
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 add-eve receipts row: checkpoints, the last continuous trade, and the auction print itself, derived from the stored result.
Column	Type	Range	Notes
`open_0930`	number	every row is 165.95	US dollars
`px_1300_et`	number	every row is 162.18
`px_1530_close`	number	every row is 155.46	US dollars
`px_1530_bar_low`	number	every row is 155.42	US dollars
`px_1530_bar_high`	number	every row is 155.92	US dollars
`shares_1530_1559_m`	number	every row is 19.3	count
`last_continuous_px`	number	every row is 160.5
`last_continuous_et`	text	1 distinct value (16:00:00)
`code8_prints`	number	every row is 1
`auction_shares_m`	number	every row is 74.94	count
`auction_price`	number	every row is 160.42	US dollars
`auction_time_et`	text	1 distinct value (16:00:00)
`auction_notional_busd`	number	every row is 12.02
`close_minus_1530_usd`	number	every row is 4.96	US dollars
`open_minus_close_usd`	number	every row is 5.53	US dollars
`px1300_minus_close_usd`	number	every row is 1.76	US dollars
`open_minus_1300_usd`	number	every row is 3.77	US dollars
`cross_vs_last_tick_cents`	number	every row is -8
`spcx_close_below_prior_pct`	number	every row is 0.98	percent
`spy_close_jul6`	number	every row is 751.28	US dollars
`spy_day_change_pct`	number	every row is 0.87	percent
`median_prior_auction_m`	number	every row is 4.49
`auction_vs_prior_median_x`	number	every row is 16.7

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 2026-07-09, and the query below is what returned them.

the exact SQL behind every number

WITH
    (
        SELECT (
            round(toFloat64(argMin(open, window_start)), 2),
            round(toFloat64(argMaxIf(close, window_start, window_start < '2026-07-06 17:01:00')), 2),
            round(toFloat64(argMaxIf(close, window_start, window_start < '2026-07-06 19:31:00')), 2),
            round(toFloat64(minIf(low, window_start = '2026-07-06 19:30:00')), 2),
            round(toFloat64(maxIf(high, window_start = '2026-07-06 19:30:00')), 2),
            round(toFloat64(sumIf(volume, window_start >= '2026-07-06 19:30:00')) / 1e6, 1)
        )
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPCX'
          AND window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-06 20:00:00'
    ) AS bars,
    (
        SELECT round(quantileDeterministic(0.5)(auction_m, day_key), 2)
        FROM (
            SELECT
                toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS d,
                toUInt64(toYYYYMMDD(toDate(toTimeZone(sip_timestamp, 'America/New_York')))) AS day_key,
                toFloat64(maxIf(size, has(conditions, 8))) / 1e6 AS auction_m
            FROM global_markets.stocks_trades
            WHERE ticker = 'SPCX'
              AND sip_timestamp >= '2026-06-12 00:00:00' AND sip_timestamp < '2026-07-03 00:00:00'
            GROUP BY d, day_key
        )
    ) AS med_prior,
    (
        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-02 00:00:00' AND sip_timestamp < '2026-07-03 00:00:00'
    ) AS spcx_prev_close,
    (
        SELECT (
            round(toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8) AND sip_timestamp < '2026-07-03 00:00:00')), 2),
            round(toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8) AND sip_timestamp >= '2026-07-06 00:00:00')), 2)
        )
        FROM global_markets.stocks_trades
        WHERE ticker = 'SPY'
          AND ((sip_timestamp >= '2026-07-02 00:00:00' AND sip_timestamp < '2026-07-03 00:00:00')
            OR (sip_timestamp >= '2026-07-06 00:00:00' AND sip_timestamp < '2026-07-07 00:00:00'))
    ) AS spy,
    (
        SELECT maxIf(sip_timestamp, has(conditions, 8))
        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 auction_ts
SELECT
    bars.1 AS open_0930,
    bars.2 AS px_1300_et,
    bars.3 AS px_1530_close,
    bars.4 AS px_1530_bar_low,
    bars.5 AS px_1530_bar_high,
    bars.6 AS shares_1530_1559_m,
    round(toFloat64(argMaxIf(price, (sip_timestamp, sequence_number), sip_timestamp < auction_ts AND NOT has(conditions, 8) AND NOT hasAny(conditions, [15, 16, 38]))), 2) AS last_continuous_px,
    formatDateTime(toTimeZone(maxIf(sip_timestamp, sip_timestamp < auction_ts AND NOT has(conditions, 8) AND NOT hasAny(conditions, [15, 16, 38])), 'America/New_York'), '%H:%i:%S') AS last_continuous_et,
    countIf(has(conditions, 8)) AS code8_prints,
    round(toFloat64(maxIf(size, has(conditions, 8))) / 1e6, 2) AS auction_shares_m,
    round(toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8))), 2) AS auction_price,
    formatDateTime(toTimeZone(auction_ts, 'America/New_York'), '%H:%i:%S') AS auction_time_et,
    round(toFloat64(maxIf(size, has(conditions, 8))) * toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8))) / 1e9, 2) AS auction_notional_busd,
    round(toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8))) - bars.3, 2) AS close_minus_1530_usd,
    round(bars.1 - toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8))), 2) AS open_minus_close_usd,
    round(bars.2 - toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8))), 2) AS px1300_minus_close_usd,
    round(bars.1 - bars.2, 2) AS open_minus_1300_usd,
    round((toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8))) - toFloat64(argMaxIf(price, (sip_timestamp, sequence_number), sip_timestamp < auction_ts AND NOT has(conditions, 8) AND NOT hasAny(conditions, [15, 16, 38])))) * 100, 1) AS cross_vs_last_tick_cents,
    round((1 - toFloat64(argMaxIf(price, (size, sip_timestamp), has(conditions, 8))) / spcx_prev_close) * 100, 2) AS spcx_close_below_prior_pct,
    spy.2 AS spy_close_jul6,
    round((spy.2 / spy.1 - 1) * 100, 2) AS spy_day_change_pct,
    med_prior AS median_prior_auction_m,
    round(toFloat64(maxIf(size, has(conditions, 8))) / 1e6 / med_prior, 1) AS auction_vs_prior_median_x
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'

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 morning after: July 7, 2026 through 12:59 p.m. ET (window pinned by design; see data notes) scalar 1×10 → 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 →