STRASMORE/EXPLORE 2,170 QUERIES

Listing day on one row: first quote, opening cross, closing cross, day totals

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 scalar 1×14read in context →
first quote et
09:50:01
day quote updates m
2.24
opening cross et
11:46:45
opening cross shares m
58.21
opening cross price
150
closing cross et
16:00:00
closing cross shares m
7.85
closing cross price
160.95
close vs issue pct
19.2
day prints m
8.57
day shares m
513.5
day dollar bn
84.1
day high
176.52
day low
149.34
Rows × columns
1 × 14
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 Listing day on one row: first quote, opening cross, closing cross, day totals, derived from the stored result.
ColumnTypeRangeNotes
first_quote_et text 1 distinct value (09:50:01)
day_quote_updates_m number every row is 2.24
opening_cross_et text 1 distinct value (11:46:45)
opening_cross_shares_m number every row is 58.21 count
opening_cross_price number every row is 150 US dollars
closing_cross_et text 1 distinct value (16:00:00)
closing_cross_shares_m number every row is 7.85 count
closing_cross_price number every row is 160.95 US dollars
close_vs_issue_pct number every row is 19.2 percent
day_prints_m number every row is 8.57
day_shares_m number every row is 513.5 count
day_dollar_bn number every row is 84.1
day_high number every row is 176.52 US dollars
day_low number every row is 149.34 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 toFloat64(final_issue_price)
        FROM global_markets.stocks_ipos
        WHERE ticker = 'SPCX'
        ORDER BY listing_date DESC LIMIT 1
    ) AS issue_px,
    (
        SELECT (formatDateTime(toTimeZone(min(sip_timestamp), 'America/New_York'), '%H:%i:%S'), round(count() / 1e6, 2))
        FROM global_markets.cache_stocks_quotes
        WHERE ticker = 'SPCX'
          AND sip_timestamp >= toDateTime64('2026-06-12 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-06-13 00:00:00', 9)
    ) AS q,
    (
        SELECT (round(toFloat64(sum(volume)) / 1e6, 1), round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 1),
                round(max(toFloat64(high)), 2), round(min(toFloat64(low)), 2))
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPCX'
          AND window_start >= toDateTime('2026-06-12 00:00:00') AND window_start < toDateTime('2026-06-13 00:00:00')
    ) AS bars
SELECT
    q.1 AS first_quote_et,
    q.2 AS day_quote_updates_m,
    formatDateTime(toTimeZone(minIf(sip_timestamp, has(conditions, 17)), 'America/New_York'), '%H:%i:%S') AS opening_cross_et,
    round(toFloat64(maxIf(size, has(conditions, 17))) / 1e6, 2) AS opening_cross_shares_m,
    round(toFloat64(argMaxIf(price, size, has(conditions, 17))), 2) AS opening_cross_price,
    formatDateTime(toTimeZone(minIf(sip_timestamp, has(conditions, 8)), 'America/New_York'), '%H:%i:%S') AS closing_cross_et,
    round(toFloat64(maxIf(size, has(conditions, 8))) / 1e6, 2) AS closing_cross_shares_m,
    round(toFloat64(argMaxIf(price, size, has(conditions, 8))), 2) AS closing_cross_price,
    round((toFloat64(argMaxIf(price, size, has(conditions, 8))) / issue_px - 1) * 100, 1) AS close_vs_issue_pct,
    round(count() / 1e6, 2) AS day_prints_m,
    bars.1 AS day_shares_m,
    bars.2 AS day_dollar_bn,
    bars.3 AS day_high,
    bars.4 AS day_low
FROM global_markets.stocks_trades
WHERE ticker = 'SPCX'
  AND sip_timestamp >= toDateTime64('2026-06-12 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-06-13 00:00:00', 9)

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
The whole SPCX tape in one row: prints, print sizes, and the quote census scalar 1×12 → The first short-interest print, with the old-entity cliff as its own receipt scalar 1×9 → SpaceX's options market in one row: totals, expiry structure, flagship contracts scalar 1×22 → The information flow in one row: tagging switches on, feed composition, co-tags scalar 1×17 → The month on one row: issue to close, with the extremes and their receipts scalar 1×22 → The IPO record: the entity behind SPCX since June 12, 2026 scalar 1×8 → See all 2,170 queries →