STRASMORE/EXPLORE 2,170 QUERIES

The month on one row: issue to close, with the extremes and their receipts

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×22read in context →
issue price usd
135
opening cross price
150
open pop vs issue pct
11.1
peak close date
2026-06-16
peak close
201.99
final close
170.72
final vs issue pct
26.5
final below peak pct
15.5
month high
225.64
month high first bar et
2026-06-16 10:02
bars within cent of high
2
high minute trades
47,699
month low extended
146.88
month low bar et
2026-06-23 04:11
bars within cent of low
2
low minute trades
14,844
month low regular hours
147.11
rth minus extended low
0.23
month shares bn
2.17
sessions
12
may 2026 bars
0
spy bars june19
0
Rows × columns
1 × 22
Period covered
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 month on one row: issue to close, with the extremes and their receipts, derived from the stored result.
ColumnTypeRangeNotes
issue_price_usd number every row is 135 US dollars
opening_cross_price number every row is 150 US dollars
open_pop_vs_issue_pct number every row is 11.1 percent
peak_close_date date 2026-06-16
peak_close number every row is 201.99 US dollars
final_close number every row is 170.72 US dollars
final_vs_issue_pct number every row is 26.5 percent
final_below_peak_pct number every row is 15.5 percent
month_high number every row is 225.64 US dollars
month_high_first_bar_et date 2026-06-16
bars_within_cent_of_high number every row is 2 US dollars
high_minute_trades number every row is 47,699 US dollars
month_low_extended number every row is 146.88 US dollars
month_low_bar_et date 2026-06-23
bars_within_cent_of_low number every row is 2 US dollars
low_minute_trades number every row is 14,844 US dollars
month_low_regular_hours number every row is 147.11 US dollars
rth_minus_extended_low number every row is 0.23 US dollars
month_shares_bn number every row is 2.17 count
sessions number every row is 12
may_2026_bars number every row is 0
spy_bars_june19 number every row is 0

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 count() FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPCX'
          AND window_start >= toDateTime('2026-05-01 00:00:00') AND window_start < toDateTime('2026-06-01 00:00:00')
    ) AS may_bars,
    (
        SELECT count() FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND window_start >= toDateTime('2026-06-19 00:00:00') AND window_start < toDateTime('2026-06-20 00:00:00')
    ) AS spy_jun19,
    (
        SELECT (toString(argMax(et_date, c)), max(c), argMax(c, et_date))
        FROM (
            SELECT
                toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
                argMax(toFloat64(close), window_start) AS c
            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-07-01 00:00:00')
              AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
            GROUP BY et_date
        )
    ) AS closes,
    (
        SELECT max(toFloat64(high)) 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-07-01 00:00:00')
    ) AS hi,
    (
        SELECT min(toFloat64(low)) 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-07-01 00:00:00')
    ) AS lo
SELECT
    round(issue_px, 2) AS issue_price_usd,
    round(toFloat64(argMin(open, window_start)), 2) AS opening_cross_price,
    round((toFloat64(argMin(open, window_start)) / issue_px - 1) * 100, 1) AS open_pop_vs_issue_pct,
    closes.1 AS peak_close_date,
    round(closes.2, 2) AS peak_close,
    round(closes.3, 2) AS final_close,
    round((closes.3 / issue_px - 1) * 100, 1) AS final_vs_issue_pct,
    round((1 - closes.3 / closes.2) * 100, 1) AS final_below_peak_pct,
    round(hi, 2) AS month_high,
    formatDateTime(toTimeZone(minIf(window_start, toFloat64(high) >= hi - 0.011), 'America/New_York'), '%Y-%m-%d %H:%i') AS month_high_first_bar_et,
    countIf(toFloat64(high) >= hi - 0.011) AS bars_within_cent_of_high,
    argMinIf(transactions, window_start, toFloat64(high) >= hi - 0.011) AS high_minute_trades,
    round(lo, 2) AS month_low_extended,
    formatDateTime(toTimeZone(argMin(window_start, toFloat64(low)), 'America/New_York'), '%Y-%m-%d %H:%i') AS month_low_bar_et,
    countIf(toFloat64(low) <= lo + 0.011) AS bars_within_cent_of_low,
    argMin(transactions, toFloat64(low)) AS low_minute_trades,
    round(minIf(toFloat64(low), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS month_low_regular_hours,
    round(minIf(toFloat64(low), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) - lo, 2) AS rth_minus_extended_low,
    round(toFloat64(sum(volume)) / 1e9, 2) AS month_shares_bn,
    uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) AS sessions,
    may_bars AS may_2026_bars,
    spy_jun19 AS spy_bars_june19
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-07-01 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 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 → Listing day on one row: first quote, opening cross, closing cross, day totals scalar 1×14 → The IPO record: the entity behind SPCX since June 12, 2026 scalar 1×8 → See all 2,170 queries →