Strasmore Research
Deep Dives · Matt ConnorBy Matt Connor · · Updated 2026-07-25

SPCX: spacex unang buwan sa publiko spcx

Pag-debut ng SpaceX bilang SPCX noong Hunyo 2026: antala sa opening cross, top-of-tape dollar volume, pag-aayos ng spread, options sa ikatlong araw, at shorts.

Pumunta sa publiko ang SpaceX noong Hunyo 12, 2026 sa ilalim ng ticker na SPCX — apat na letra na noong Abril ay kinakalakal pa bilang ibang kumpanya. Inpresyo sa $135, nagbukas ang stock sa $150 (11.1% higit sa issue), umakyat sa pinakamataas na $201.99 na pagsasara noong 2026-06-16, nagtala ng $146.88 pre-market na pinakamababa, at nagtapos sa $170.72 — 26.5% higit sa issue, 15.5% mas mababa sa peak — habang pumang-apat sa buong US tape ayon sa regular-hours dollar volume, nangunguna sa NVDA. Bawat numero rito ay resulta ng nakaimbak na query; palawakin ang anumang panel para sa eksaktong SQL.

QueryAng buwan sa isang row: mula issue hanggang close, kasama ang mga sukdulan at ang kanilang mga resibo
Ang eksaktong SQL sa likod ng bawat numero
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')

Isang ticker, dalawang kumpanya

Ang SPCX ay isang simbolong ginamit muli, kaya nauuna ang mga resibo ng beripikasyon. Hanggang Abril 2026, ang ticker ay naging isang manipis na pondo — 13 minutong bar sa huling aktibong buwan nito, sa pagitan ng $21.92 at $23.64. Noong Mayo 2026 ay wala itong naitalang anuman (0 bar). Noong Hunyo 12 ay na-reassign ito sa Space Exploration Technologies Corp.:

QueryAng talaan ng IPO: ang entidad sa likod ng SPCX mula noong Hunyo 12, 2026
Ang eksaktong SQL sa likod ng bawat numero
WITH
    (
        SELECT (toString(listing_date), toFloat64(final_issue_price), round(toFloat64(total_offer_size) / 1e9, 1),
                primary_exchange, issuer_name, security_description, toFloat64(max_shares_offered))
        FROM global_markets.stocks_ipos
        WHERE ticker = 'SPCX'
        ORDER BY listing_date DESC LIMIT 1
    ) AS ipo,
    (SELECT count() FROM global_markets.stocks_balance_sheets WHERE cik = '0001181412' OR has(tickers, 'SPCX')) AS bs_rows,
    (SELECT count() FROM global_markets.stocks_cash_flow_statements WHERE cik = '0001181412' OR has(tickers, 'SPCX')) AS cf_rows,
    (SELECT count() FROM global_markets.stocks_income_statements WHERE cik = '0001181412' OR has(tickers, 'SPCX')) AS is_rows
SELECT
    ipo.1 AS listing_date,
    ipo.5 AS issuer,
    round(ipo.2, 2) AS final_issue_price_usd,
    ipo.3 AS offer_size_busd,
    round(ipo.7 / 1e6, 1) AS max_shares_offered_m,
    ipo.4 AS listing_exchange,
    ipo.6 AS security,
    bs_rows + cf_rows + is_rows AS fundamentals_rows
QueryResibo ng muling paggamit ng simbolo: labintatlong buwan ng SPCX minute bars — ganap na wala ang Mayo 2026
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    toStartOfMonth(window_start) AS month,
    count() AS minute_bars,
    round(min(toFloat64(low)), 2) AS low_usd,
    round(max(toFloat64(high)), 2) AS high_usd,
    round(toFloat64(sum(volume)) / 1e6, 2) AS shares_m
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
  AND window_start >= toDateTime('2025-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
GROUP BY month
ORDER BY month

Ang isang "SPCX history" query na walang window ay pinagsasama ang dalawang walang-kaugnayang kumpanya — kaya bawat window dito ay nagsisimula sa Hunyo 12, 2026. Ipinapakita ng news feed ang parehong talampas (0 SPCX-tagged na artikulo sa nakaraang labindalawang buwan), gayundin ang short interest: isang halos 11461x na pagtalon sa pagitan ng agwat.

Nauna ang papel na trail

QueryAng 2026 SEC trail ng SpaceX ayon sa uri ng form, sa pagkakasunud-sunod ng filing (CIK 0001181412, deduped ayon sa accession)
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    form_type,
    uniqExact(accession_number) AS filings,
    toString(min(filing_date)) AS first_filed,
    toString(max(filing_date)) AS last_filed
FROM global_markets.stocks_sec_edgar_index
WHERE cik = '0001181412'
  AND filing_date >= toDate('2026-01-01') AND filing_date <= toDate('2026-06-30')
GROUP BY form_type
ORDER BY min(filing_date), form_type

Kapag binasa mula taas pababa, ang IPO ay bumubuo sa sarili: isang confidential draft amendment (DRS/A) noong 2026-05-07, ang pampublikong S-1 noong 2026-05-20, 2 na mga susog dito, pagkatapos ay 7 FWP na free-writing prospectuses — roadshow paper — sa pagitan ng 2026-06-04 at 2026-06-11. Ang exchange registration at certification ay dumating noong 2026-06-10; ang effectiveness notice at ang una sa 10 na insider Form 3 noong 2026-06-11; ang huling 424B4 prospectus at isang S-8 sa mismong araw ng listing. Pagkatapos ay lumipat ang ritmo sa 8-Ks:

QueryBawat SpaceX 8-K na inihain noong Hunyo 2026, kasama ang mga pambungad na linya ng bawat isa
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    toString(filing_date) AS filed,
    form_type,
    replaceAll(substring(items_text, 1, 170), '\n', ' · ') AS opening_lines
FROM global_markets.stocks_8k_text
WHERE cik = '0001181412'
  AND filing_date >= toDate('2026-06-01') AND filing_date <= toDate('2026-06-30')
ORDER BY filing_date

6 sa mga ito sa loob ng wala pang dalawang linggo: unregistered share sales sa IPO closing (Item 3.02); isang material agreement sa X67 Inc., isang wholly owned subsidiary (1.01); board at officer changes (5.02); isang Regulation FD notice (7.01); at Item 8.01 notices sa isang senior unsecured notes offering na nagsimula noong June 22, ayon sa 8-K na inihain noong 2026-06-23. Isang June 23 headline ang nagbigay ng laki: "SpaceX's Fundraising Is Not Over With a $20 Billion New Bond Offering". Ang offering window at ang month lows ng stock ay nasa parehong mga araw ng kalendaryo; ang datos na ito ay walang sinasabi na higit pa riyan.

Araw ng paglilista: isang bukas na walang 9:30

Ang isang IPO ay hindi bumubukas kasabay ng merkado. Sinimulan ng Nasdaq ang pag-publish ng mga quote ng SPCX noong 09:50:01 ET — naka-lock, indicative bid-equals-ask pairs na naglalakad sa libro patungo sa clearing price — at sa loob ng halos dalawang oras ay walang anumang trade. Ang unang public print ng SpaceX ay ang mismong opening cross: 58.21 milyong shares sa $150, na na-stamp noong 11:46:45 ET sa ilalim ng condition codes 17, 9 at 41 (market-center opening print, cross, trade-through exempt). Ang stock ay tumakbo hanggang 176.52, naghawak ng 149.34 na mababa, at lumabas sa isang 7.85 milyong-share na closing cross sa $160.95 — 19.2% higit sa issue. Kabuuan: 513.5 milyong shares, $84.1 bilyon, 8.57 milyong prints, sa isang regular na session na mahigit apat na oras ang haba.

QueryAraw ng listing sa isang row: unang quote, opening cross, closing cross, day totals
Ang eksaktong SQL sa likod ng bawat numero
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)

Ang quote stream ay nagsasabi sa kalahati ng price-discovery. Bago ang cross, ang tanging NBBO updates ay ang mga naka-lock na indicative (18 sa 09:30 na kalahating oras, spread zero ayon sa disenyo). Pagkatapos ay bumuhos ang quoting: 445211 updates sa 11:30 bucket lamang, sa median na bid-ask spread na 30 sentimo (18.6 bps). Pagsapit ng 13:00 bucket, ang median ay 6 sentimo (3.5 bps) — ang isang spread ay hindi ipinanganak na masikip; ito ay humigpit sa loob ng dalawang oras.

QueryUnang araw kada kalahating oras: mga update sa quote at ang median spread na nakakahanap ng antas nito
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    formatDateTime(toStartOfInterval(toTimeZone(sip_timestamp, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_bucket,
    count() AS quote_updates,
    round(quantileDeterministicIf(0.5)(toFloat64(ask_price) - toFloat64(bid_price), toUInt64(toUnixTimestamp64Micro(sip_timestamp)), bid_price > 0 AND ask_price >= bid_price) * 100, 1) AS med_spread_cents,
    round(quantileDeterministicIf(0.5)((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, toUInt64(toUnixTimestamp64Micro(sip_timestamp)), bid_price > 0 AND ask_price >= bid_price), 2) AS med_spread_bps
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'SPCX'
  AND sip_timestamp >= toDateTime64('2026-06-12 13:30:00', 9) AND sip_timestamp < toDateTime64('2026-06-12 20:00:00', 9)
GROUP BY et_bucket
ORDER BY et_bucket

Sesyon sa sesyon

QueryAng mga sesyon: regular-hours close, close-over-close change, full-day volume
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    et_date,
    close_usd,
    round(if(prev_close = 0, NULL, (close_usd / prev_close - 1) * 100), 1) AS change_pct,
    shares_m,
    dollar_bn
FROM (
    SELECT et_date, close_usd, shares_m, dollar_bn,
           lagInFrame(close_usd) OVER (ORDER BY et_date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_close
    FROM (
        SELECT
            toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
            round(argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS close_usd,
            round(toFloat64(sum(volume)) / 1e6, 1) AS shares_m,
            round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 2) AS dollar_bn
        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')
        GROUP BY et_date
    )
)
ORDER BY et_date

Ang daloy: 19.3% sa ikalawang sesyon, isang $201.99 peak close noong 2026-06-16, sinundan ng tatlong sunod na pagbaba — ang pinakamatarik ay -16.4% na galaw noong 2026-06-22, ang unang sesyon pagkatapos ng holiday noong June 19 at ang araw na sinimulan ang notes offering. Ang slide ay umabot sa ilalim sa $152.74 noong 2026-06-26; ang huling dalawang sesyon ay nagsara ng 7.4% at 4.1% na mas mataas (ang 2026-06-29 ay may sariling pang-araw-araw na recap at tick-level deep-dive). Mas mabilis na bumaba ang volume kaysa sa pag-recover ng presyo: 513.5 milyong shares sa unang araw, 75.8 milyon noong 2026-06-30.

Parehong extremes ng buwan ay pumasa sa lone-print cross-check — at nasa magkaibang market phases. Ang $225.64 na mataas ay na-print noong 2026-06-16 10:02 ET: 2 bars sa loob ng isang sentimo, 47699 trades sa unang minuto ng peak. Ang $146.88 na mababa ay na-print noong 2026-06-23 04:11 ET na may 2 bars sa loob ng isang sentimo at 14844 trades sa minutong iyon. Ang regular-hours low ay $147.11, $0.23 sa itaas nito; anumang "June low" na figure ay dapat sabihin kung alin ang tinutukoy nito.

Ikaapat na pinakamalaking ticker sa tape

I-rank ang bawat US-listed symbol ayon sa regular-hours dollar volume mula Hunyo 12–30 — isang buong whole-market aggregation, hindi candidate list — at ang brand-new listing ay nasa ikaapat: $344.6 bilyon, nasa likod lang ng MU ($585.4 bilyon), SPY at QQQ, nauuna sa NVDA ($253.1 bilyon), TSLA at AAPL. Bawat row ay may parehong 12 sessions na gagamitin.

QueryAng buong US tape na niraranggo ayon sa regular-hours dollar volume mula Hunyo 12–30
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    ticker,
    round(sum(toFloat64(volume) * toFloat64(close)) / 1e9, 1) AS regular_hours_dollar_bn,
    round(100 * sum(toFloat64(volume) * toFloat64(close)) / max(sum(toFloat64(volume) * toFloat64(close))) OVER (), 1) AS pct_of_leader,
    toUInt8(ticker = 'SPCX') AS is_spcx
FROM global_markets.delayed_stocks_minute_aggs
WHERE 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 ticker
ORDER BY regular_hours_dollar_bn DESC
LIMIT 12

Ano ang binubuo ng tape

QueryAng buong SPCX tape sa isang row: prints, print sizes, at ang quote census
Ang eksaktong SQL sa likod ng bawat numero
WITH
    (
        SELECT (round(count() / 1e6, 2),
                round(100.0 * countIf(bid_price > 0 AND ask_price > 0 AND ask_price > bid_price) / count(), 2),
                countIf(bid_price > 0 AND ask_price > 0 AND ask_price = bid_price),
                countIf(bid_price > 0 AND ask_price > 0 AND ask_price < bid_price),
                countIf(bid_price <= 0 OR ask_price <= 0),
                countIf(bid_price > 0 AND ask_price > 0 AND ask_price < bid_price AND sip_timestamp < toDateTime64('2026-06-13 00:00:00', 9)),
                countIf(bid_price > 0 AND ask_price > 0 AND ask_price < bid_price AND sip_timestamp >= toDateTime64('2026-06-30 00:00:00', 9)))
        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-07-01 00:00:00', 9)
    ) AS quote_census
SELECT
    round(count() / 1e6, 2) AS prints_m,
    quantileDeterministic(0.5)(toFloat64(size), toUInt64(abs(sequence_number))) AS median_print_shares,
    round(avg(toFloat64(size)), 1) AS avg_print_shares,
    round(100.0 * countIf(size < 100) / count(), 1) AS odd_lot_pct_of_prints,
    round(100.0 * countIf(toFloat64(size) != round(toFloat64(size))) / count(), 2) AS fractional_pct_of_prints,
    quote_census.1 AS nbbo_updates_m,
    quote_census.2 AS clean_two_sided_pct,
    quote_census.3 AS locked_updates,
    quote_census.4 AS crossed_updates,
    quote_census.5 AS one_sided_or_empty_updates,
    quote_census.6 AS crossed_first_session,
    quote_census.7 AS crossed_final_session
FROM global_markets.stocks_trades
WHERE ticker = 'SPCX'
  AND sip_timestamp >= toDateTime64('2026-06-12 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)

Ang texture ay maliit na print at siksik sa quotes: 41.01 milyong prints na may median na 10 shares (average na 64.2 — hinihila ng malalaking crosses ang mean), 81.9% odd lots (mas mababa sa 100 shares), 8.73% fractional — consistent sa paghiwa-hiwalay ng orders ng retail apps, kasama ang mga market maker sa kabilang side. Ang quote half: 11.78 milyong NBBO updates, 99.32% malinis na two-sided; 46377 pansamantalang crossed (bid above ask — hindi naka-sync ang mga venue), bumababa mula 17730 sa unang araw hanggang 437 noong June 30; 34118 naka-lock; 116 one-sided o walang laman. Ang spread statistics sa ibaba ay hindi kasama ang crossed at one-sided quotes, na may drop counts sa loob ng panel.

Ang mga panahon ng spread

Ang tanda ng isang bagong listahan ay ang pagtira ng spread nito sa isang antas — sinusukat bawat sesyon bilang parehong median sa mga update at time-weighted average. Ang unang araw ay nagsisimula sa 11:46 cross; ang pagsama ng naka-lock na pre-open indicative ay magpapaganda lamang dito.

QueryAng seasoning curve: regular-hours spread ayon sa sesyon, per-update at time-weighted
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    session,
    quote_updates,
    invalid_dropped,
    med_spread_cents,
    tw_spread_cents,
    med_spread_bps,
    tw_spread_bps,
    round(100 * (tw_spread_bps / min(tw_spread_bps) OVER () - 1), 0) AS pct_above_tightest_session
FROM (
    SELECT
        session,
        count() AS quote_updates,
        countIf(NOT valid) AS invalid_dropped,
        round(quantileDeterministicIf(0.5)(spread, toUInt64(ts_us), valid) * 100, 1) AS med_spread_cents,
        round(sumIf(spread * dt, valid AND dt > 0) / sumIf(dt, valid AND dt > 0) * 100, 1) AS tw_spread_cents,
        round(quantileDeterministicIf(0.5)(spread / mid * 10000, toUInt64(ts_us), valid), 2) AS med_spread_bps,
        round(sumIf(spread / mid * dt, valid AND dt > 0) / sumIf(dt, valid AND dt > 0) * 10000, 2) AS tw_spread_bps
    FROM (
        SELECT session, spread, mid, valid, ts_us,
               greatest(if(next_us = 0, end_us, least(next_us, end_us)) - ts_us, 0) AS dt
        FROM (
            SELECT
                toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session,
                toFloat64(ask_price) - toFloat64(bid_price) AS spread,
                (toFloat64(ask_price) + toFloat64(bid_price)) / 2 AS mid,
                (bid_price > 0 AND ask_price > 0 AND ask_price >= bid_price) AS valid,
                toUnixTimestamp64Micro(sip_timestamp) AS ts_us,
                toUnixTimestamp64Micro(toDateTime64(concat(toString(toDate(toTimeZone(sip_timestamp, 'America/New_York'))), ' 20:00:00'), 6, 'UTC')) AS end_us,
                leadInFrame(toUnixTimestamp64Micro(sip_timestamp)) OVER (PARTITION BY toDate(toTimeZone(sip_timestamp, 'America/New_York')) ORDER BY sip_timestamp ASC, sequence_number ASC ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) AS next_us
            FROM global_markets.cache_stocks_quotes
            WHERE ticker = 'SPCX'
              AND sip_timestamp >= toDateTime64('2026-06-12 15:46:00', 9)
              AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
              AND (toHour(sip_timestamp) * 60 + toMinute(sip_timestamp)) BETWEEN 810 AND 1199
        )
    )
    GROUP BY session
)
ORDER BY session

Sa time-weighted, ang spread ay bumaba mula 23.5 sentimo (7.64 bps) sa unang araw hanggang 7.9 sentimo (4.7 bps) noong 2026-06-30 — halos dalawang-katlo ang higpit sa dolyar, ngunit mas maliit sa relatibong termino; ang serye ng dolyar at relatibo ay nagkakaiba sa isang yugto kung saan ang presyo ay gumalaw sa hanay na $146.88–$225.64. Ang pinakamasikip na sesyon ay noong 2026-06-22 sa 2 bps, na may muling paglawak noong 2026-06-17 (8.96 bps, ang sesyon pagkatapos ng peak ng presyo) at 2026-06-24 (7.38 bps), ang huli ay kasabay ng pagbaba ng volume sa 71.7 milyong bahagi mula sa 152.3 milyon. Para sa sukatan, tatlong anchor mula Hunyo 30:

QueryMga anchor noong Hunyo 30: isang mega-cap, SPCX, at isang manipis na small-cap, parehong sesyon, parehong math
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    ticker,
    count() AS quote_updates,
    countIf(NOT valid) AS invalid_dropped,
    round(quantileDeterministicIf(0.5)(spread, toUInt64(ts_us), valid) * 100, 1) AS med_spread_cents,
    round(quantileDeterministicIf(0.5)(spread / mid * 10000, toUInt64(ts_us), valid), 2) AS med_spread_bps,
    round(sumIf(spread / mid * dt, valid AND dt > 0) / sumIf(dt, valid AND dt > 0) * 10000, 2) AS tw_spread_bps
FROM (
    SELECT ticker, spread, mid, valid, ts_us,
           greatest(if(next_us = 0, end_us, least(next_us, end_us)) - ts_us, 0) AS dt
    FROM (
        SELECT
            ticker,
            toFloat64(ask_price) - toFloat64(bid_price) AS spread,
            (toFloat64(ask_price) + toFloat64(bid_price)) / 2 AS mid,
            (bid_price > 0 AND ask_price > 0 AND ask_price >= bid_price) AS valid,
            toUnixTimestamp64Micro(sip_timestamp) AS ts_us,
            toUnixTimestamp64Micro(toDateTime64('2026-06-30 20:00:00', 6, 'UTC')) AS end_us,
            leadInFrame(toUnixTimestamp64Micro(sip_timestamp)) OVER (PARTITION BY ticker ORDER BY sip_timestamp ASC, sequence_number ASC ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) AS next_us
        FROM global_markets.cache_stocks_quotes
        WHERE ticker IN ('SPCX', 'AAPL', 'NATH')
          AND sip_timestamp >= toDateTime64('2026-06-30 13:30:00', 9)
          AND sip_timestamp < toDateTime64('2026-06-30 20:00:00', 9)
    )
)
GROUP BY ticker
ORDER BY ticker

Median quoted spread ng Apple: 3 sentimo (1.04 bps). SPCX: 6 sentimo (3.54 bps). Nathan's Famous, na may 1036 quote updates sa buong sesyon: 30 sentimo (29.66 bps). Labing-walong araw sa, ang SpaceX ay naka-quote ng ilang beses na mas malawak kaysa sa isang mega-cap, at ilang beses na mas masikip kaysa sa isang manipis na pangalan.

Mga opsyon mula sa ikatlong araw

QueryAng options market ng SpaceX sa isang row: totals, expiry structure, flagship contracts
Ang eksaktong SQL sa likod ng bawat numero
WITH
    (
        SELECT (round(sum(toFloat64(price) * size) * 100 / 1e9, 2), round(sum(size) / 1e6, 1))
        FROM global_markets.options_trades
        WHERE startsWith(ticker, 'O:AAPL') AND length(ticker) = 21
          AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
    ) AS aapl,
    (
        SELECT (
            concat('$', toString(intDiv(toUInt32OrZero(substring(ticker, 14, 8)), 1000)),
                   if(substring(ticker, 13, 1) = 'P', ' put', ' call'),
                   ', expiry 20', substring(ticker, 7, 2), '-', substring(ticker, 9, 2), '-', substring(ticker, 11, 2)),
            toUInt64(sum(size)), toUInt64(count()),
            round(toFloat64(sum(toFloat64(price) * size)) / toFloat64(sum(size)), 2),
            round(sum(toFloat64(price) * size) * 100 / 1e6, 1))
        FROM global_markets.options_trades
        WHERE startsWith(ticker, 'O:SPCX') AND length(ticker) = 21
          AND sip_timestamp >= toDateTime64('2026-06-12 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
        GROUP BY ticker ORDER BY sum(size) DESC LIMIT 1
    ) AS busiest,
    (
        SELECT (
            concat('$', toString(intDiv(toUInt32OrZero(substring(ticker, 14, 8)), 1000)),
                   if(substring(ticker, 13, 1) = 'P', ' put', ' call'),
                   ', expiry 20', substring(ticker, 7, 2), '-', substring(ticker, 9, 2), '-', substring(ticker, 11, 2)),
            round(toFloat64(sum(toFloat64(price) * size)) / toFloat64(sum(size)), 2),
            round(sum(toFloat64(price) * size) * 100 / 1e6, 1))
        FROM global_markets.options_trades
        WHERE startsWith(ticker, 'O:SPCX') AND length(ticker) = 21
          AND sip_timestamp >= toDateTime64('2026-06-12 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
        GROUP BY ticker ORDER BY sum(toFloat64(price) * size) DESC LIMIT 1
    ) AS premium_magnet,
    (
        SELECT max(pc)
        FROM (
            SELECT round(toFloat64(sumIf(size, substring(ticker, 13, 1) = 'P')) / toFloat64(sumIf(size, substring(ticker, 13, 1) = 'C')), 3) AS pc
            FROM global_markets.options_trades
            WHERE startsWith(ticker, 'O:SPCX') AND length(ticker) = 21
              AND sip_timestamp >= toDateTime64('2026-06-12 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
            GROUP BY toDate(sip_timestamp)
        )
    ) AS max_daily_pc
SELECT
    formatDateTime(toTimeZone(min(sip_timestamp), 'America/New_York'), '%Y-%m-%d %H:%i:%S') AS first_print_et,
    uniqExact(toDate(sip_timestamp)) AS option_sessions,
    round(count() / 1e6, 2) AS prints_m,
    uniqExact(ticker) AS distinct_contracts,
    round(sum(size) / 1e6, 2) AS contracts_traded_m,
    round(sum(toFloat64(price) * size) * 100 / 1e9, 2) AS premium_notional_busd,
    round(toFloat64(sumIf(size, substring(ticker, 13, 1) = 'P')) / toFloat64(sumIf(size, substring(ticker, 13, 1) = 'C')), 2) AS month_put_call_ratio,
    max_daily_pc AS max_session_put_call_ratio,
    uniqExact(substring(ticker, 7, 6)) AS expiries_traded,
    concat('20', substring(max(substring(ticker, 7, 6)), 1, 2), '-', substring(max(substring(ticker, 7, 6)), 3, 2), '-', substring(max(substring(ticker, 7, 6)), 5, 2)) AS longest_expiry,
    round(100 * toFloat64(sumIf(size, substring(ticker, 7, 6) = '260618')) / toFloat64(sum(size)), 1) AS jun18_expiry_share_pct,
    busiest.1 AS busiest_contract,
    busiest.2 AS busiest_contract_volume,
    busiest.3 AS busiest_contract_prints,
    busiest.4 AS busiest_contract_avg_premium,
    busiest.5 AS busiest_contract_notional_musd,
    premium_magnet.1 AS top_premium_contract,
    premium_magnet.2 AS top_premium_avg,
    premium_magnet.3 AS top_premium_notional_musd,
    aapl.1 AS aapl_full_june_notional_busd,
    aapl.2 AS aapl_full_june_contracts_m,
    round(round(sum(toFloat64(price) * size) * 100 / 1e9, 2) - aapl.1, 2) AS spcx_minus_aapl_notional_busd
FROM global_markets.options_trades
WHERE startsWith(ticker, 'O:SPCX') AND length(ticker) = 21
  AND sip_timestamp >= toDateTime64('2026-06-12 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)

Mga opsyon na nakalista noong 2026-06-16 09:30:00 ET — ikatlong sesyon ng stock. Sa 10 sesyon ng opsyon: 2.18 milyong print, 10.4 milyong kontrata sa 3199 listahan, $9.15 bilyon sa premium (presyo na pinarami ng karaniwang 100-share multiplier) — $0.31 bilyon na mas mataas kaysa sa naipon ng mga opsyon ng AAPL sa buong buwan ng Hunyo ($8.84 bilyon sa 27 milyong kontrata; sampung sesyon laban sa isang buong buwan — isang sadyang kawalan ng simetriya na nananatili ang punto). 22 expiry ang na-trade, mula sa isang weekly na nag-expire noong Huwebes, Hunyo 18 (sarado ang merkado noong Biyernes na iyon) hanggang sa 2028-12-15 LEAPS; ang unang weekly na iyon lamang ay kumuha ng 26.7% ng volume ng buwan. Pinaka-abalang kontrata: ang $175 put, expiry 2026-06-18 — 203765 kontrata sa 41648 print sa $1.43 average premium. Premium magnet: ang $225 call, expiry 2026-09-18 — $121.3 milyon sa $40.12.

QueryOptions session ayon sa sesyon: contracts, call/put split, at put/call ratio
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    toDate(sip_timestamp) AS session,
    count() AS prints,
    toUInt64(sum(size)) AS contracts_traded,
    toUInt64(sumIf(size, substring(ticker, 13, 1) = 'C')) AS call_contracts,
    toUInt64(sumIf(size, substring(ticker, 13, 1) = 'P')) AS put_contracts,
    round(toFloat64(sumIf(size, substring(ticker, 13, 1) = 'P')) / toFloat64(sumIf(size, substring(ticker, 13, 1) = 'C')), 2) AS put_call_ratio,
    round(100 * toFloat64(sum(size)) / max(toFloat64(sum(size))) OVER (), 1) AS pct_of_busiest_session
FROM global_markets.options_trades
WHERE startsWith(ticker, 'O:SPCX') AND length(ticker) = 21
  AND sip_timestamp >= toDateTime64('2026-06-12 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
GROUP BY session
ORDER BY session

Ang mga call ay lumampas sa trade ng puts sa bawat sesyon: ang daily put/call ratio ay umabot sa peak na 0.987 noong 2026-06-17, malapit sa tuktok ng presyo, at bumaba sa 0.46 noong 2026-06-29, ang sesyon na nagsara ang stock ng 7.4% na mas mataas — ang put volume ay sumikat kasabay ng presyo, hindi sa baba. Ang pinaka-abalang sesyon ay 2026-06-18, ang expiry day ng unang weekly: 1844490 kontrata.

QueryKung saan dumating ang mga kontrata: call at put volume ayon sa strike bucket
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    concat('$', toString(toUInt32(bucket))) AS strike_bucket,
    call_contracts,
    put_contracts,
    round(100.0 * put_contracts / (call_contracts + put_contracts), 1) AS put_share_pct,
    round(100 * (call_contracts + put_contracts) / max(call_contracts + put_contracts) OVER (), 1) AS pct_of_biggest_bucket
FROM (
    SELECT
        least(floor(toFloat64(toUInt32OrZero(substring(ticker, 14, 8))) / 1000 / 25) * 25, 450) AS bucket,
        toUInt64(sumIf(size, substring(ticker, 13, 1) = 'C')) AS call_contracts,
        toUInt64(sumIf(size, substring(ticker, 13, 1) = 'P')) AS put_contracts
    FROM global_markets.options_trades
    WHERE startsWith(ticker, 'O:SPCX') AND length(ticker) = 21
      AND sip_timestamp >= toDateTime64('2026-06-12 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
    GROUP BY bucket
)
ORDER BY toUInt32OrZero(substring(strike_bucket, 2))

Ang strike map ay isang barbell sa paligid ng landas ng presyo. Ang $150 bucket ang kumuha ng pinakamaraming volume, nahati sa 55% puts — at-the-money two-way traffic. Sa ibaba ng trading range, ang puts ang may hawak ng libro (92.7% ng $125 bucket); sa itaas nito, ang calls (1.6% puts sa $250), na may 42228 call contract sa $450 bucket, halos doble ng pinakamataas ng buwan.

QueryAng halaga ng pag-trade sa pinaka-abalang kontrata: NBBO spread sa tatlong sesyon nito
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    toDate(sip_timestamp) AS session,
    count() AS nbbo_updates,
    countIf(bid_price <= 0 OR ask_price < bid_price) AS dropped_bad_quotes,
    round(avgIf(toFloat64(ask_price) - toFloat64(bid_price), bid_price > 0 AND ask_price >= bid_price) * 100, 1) AS avg_spread_cents,
    round(quantileDeterministicIf(0.5)(toFloat64(ask_price) - toFloat64(bid_price), toUInt64(sequence_number), bid_price > 0 AND ask_price >= bid_price) * 100, 1) AS med_spread_cents,
    round(100 * avgIf((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2), bid_price > 0 AND ask_price >= bid_price), 2) AS avg_spread_pct_of_mid
FROM global_markets.cache_options_quotes
WHERE ticker = 'O:SPCX260618P00175000'
  AND sip_timestamp >= toDateTime64('2026-06-16 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-06-19 00:00:00', 9)
GROUP BY session
ORDER BY session

Ang trading cost ay mahigpit mula sa unang oras: ang pinaka-abalang kontrata ay nag-average ng 10.3-sentimo na NBBO spread sa unang sesyon nito (6.7% ng mid; ang median ay 10 sentimo), ang median ay humigpit sa 5 sentimo pagsapit ng expiry day (5.23% ng mid, 93198 quote update, 37 bad quote na ibinagsak at binilang). Nickel-to-dime spreads sa likidong sentro ng isang araw-gulang na libro — ang malalayong wings ay mas mahal, at ang panel na ito ay hindi nagsasalita para sa kanila.

Ang news switch at ang mga shorts

QueryAng daloy ng impormasyon sa isang row: pag-switch ng tagging, feed composition, co-tags
Ang eksaktong SQL sa likod ng bawat numero
WITH
    (
        SELECT count()
        FROM global_markets.stocks_news
        WHERE has(tickers, 'SPCX')
          AND published_utc >= toDateTime('2025-06-01 00:00:00')
          AND published_utc < toDateTime('2026-06-01 00:00:00')
    ) AS prior_12mo,
    (
        SELECT (toString(d), n)
        FROM (
            SELECT toDate(toTimeZone(published_utc, 'America/New_York')) AS d, count() AS n
            FROM global_markets.stocks_news
            WHERE has(tickers, 'SPCX')
              AND published_utc >= toDateTime('2026-06-01 00:00:00')
              AND published_utc < toDateTime('2026-07-01 04:00:00')
            GROUP BY d ORDER BY n DESC, d ASC LIMIT 1
        )
    ) AS peak_day,
    (
        SELECT (JSONExtractString(any(publisher), 'name'), count())
        FROM global_markets.stocks_news
        WHERE has(tickers, 'SPCX')
          AND published_utc >= toDateTime('2026-06-01 00:00:00')
          AND published_utc < toDateTime('2026-07-01 04:00:00')
        GROUP BY JSONExtractString(publisher, 'name') ORDER BY count() DESC LIMIT 1
    ) AS top_pub,
    (
        SELECT n
        FROM (
            SELECT toDate(toTimeZone(published_utc, 'America/New_York')) AS d, count() AS n
            FROM global_markets.stocks_news
            WHERE has(tickers, 'SPCX')
              AND published_utc >= toDateTime('2026-06-01 00:00:00')
              AND published_utc < toDateTime('2026-07-01 04:00:00')
            GROUP BY d ORDER BY d ASC LIMIT 1
        )
    ) AS first_day_n,
    (
        SELECT substring(title, 1, 90)
        FROM global_markets.stocks_news
        WHERE has(tickers, 'SPCX')
          AND published_utc >= toDateTime('2026-06-22 04:00:00')
          AND published_utc < toDateTime('2026-06-24 04:00:00')
          AND title ILIKE '%bond%'
        ORDER BY published_utc ASC LIMIT 1
    ) AS notes_headline
SELECT
    prior_12mo AS prior_12_months_articles,
    toString(min(toDate(toTimeZone(published_utc, 'America/New_York')))) AS first_tagged_day,
    first_day_n AS first_day_articles,
    peak_day.1 AS peak_day_date,
    peak_day.2 AS peak_day_articles,
    count() AS june_articles,
    uniqExact(JSONExtractString(publisher, 'name')) AS publishers,
    top_pub.1 AS top_publisher,
    top_pub.2 AS top_publisher_articles,
    round(100.0 * top_pub.2 / count(), 0) AS top_publisher_pct,
    countIf(has(tickers, 'TSLA')) AS tsla_co_articles,
    countIf(has(tickers, 'NVDA')) AS nvda_co_articles,
    countIf(hasAny(tickers, ['GOOG', 'GOOGL', 'GOOGN', 'GOOGM'])) AS alphabet_co_articles,
    countIf(has(tickers, 'RKLB')) AS rklb_co_articles,
    countIf(has(tickers, 'ASTS')) AS asts_co_articles,
    countIf(has(tickers, 'TSLA')) - countIf(has(tickers, 'RKLB')) AS tsla_minus_rklb,
    notes_headline AS notes_offering_headline
FROM global_markets.stocks_news
WHERE has(tickers, 'SPCX')
  AND published_utc >= toDateTime('2026-06-01 00:00:00')
  AND published_utc < toDateTime('2026-07-01 04:00:00')

Ang pag-tag ng balita ay may sariling resibo: 0 artikulong may SPCX tag sa labindalawang buwan bago ang listing, pagkatapos ay 14 noong 2026-06-11 (araw ng pagpepresyo), isang peak na 42 artikulo noong 2026-06-12, at 347 para sa buwan. Basahin ang mga bilang na ito nang may pag-aalinlangan: 4 na publisher, at si The Motley Fool lang ang sumulat ng 65% — atensyon ng isang feed lamang, hindi ng buong mundo. Ipinapakita ng mga co-tag ang framing: TSLA sa 83 artikulo, NVDA sa 59, Alphabet (pinagsamang share classes) sa 57, habang ang Rocket Lab (21) at AST SpaceMobile (15) ay malayo sa likod: sinakop ng feed na ito ito bilang isang mega-cap story, hindi isang space-sector.

QueryFINRA off-exchange short volume ayon sa sesyon: marked-short share at reported volume
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    date,
    round(toFloat64(any(short_volume)) / 1e6, 2) AS short_shares_m,
    round(toFloat64(any(total_volume)) / 1e6, 2) AS offexchange_total_m,
    round(100 * toFloat64(any(short_volume)) / toFloat64(any(total_volume)), 1) AS short_pct_of_offexchange
FROM global_markets.stocks_short_volume
WHERE ticker = 'SPCX' AND date >= toDate('2026-06-01') AND date <= toDate('2026-06-30')
GROUP BY date
ORDER BY date

Nagpakita ang mga shorts sa unang araw — may kasamang depinisyon. Ang off-exchange short volume ay ang bahagi ng FINRA-reported (off-exchange) volume na minarkahang short; karamihan dito ay market makers na nagbebenta ng short para punan ang mga bili ng customer — routine plumbing, at hindi short interest. Ang marked-short share ng SPCX ay nagsimula sa 33.7% sa araw ng listing at umakyat sa 71% pagsapit ng 2026-06-30, habang ang reported off-exchange volume ay bumagsak mula 131.53 milyong shares hanggang 35.77 milyon. Ang co-movement ang maipapakita ng datos na ito; ang kahulugan nito ay wala sa datos na ito.

QueryAng unang short-interest print, kasama ang old-entity cliff bilang sarili nitong resibo
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    toString(maxIf(settlement_date, settlement_date >= toDate('2026-06-01'))) AS new_entity_settlement,
    round(toFloat64(maxIf(short_interest, settlement_date >= toDate('2026-06-01'))) / 1e6, 2) AS shares_short_m,
    round(toFloat64(maxIf(avg_daily_volume, settlement_date >= toDate('2026-06-01'))) / 1e6, 2) AS avg_daily_volume_m,
    maxIf(days_to_cover, settlement_date >= toDate('2026-06-01')) AS reported_days_to_cover,
    round(toFloat64(maxIf(short_interest, settlement_date >= toDate('2026-06-01'))) / toFloat64(maxIf(avg_daily_volume, settlement_date >= toDate('2026-06-01'))), 2) AS implied_days_to_cover,
    countIf(settlement_date > toDate('2026-06-15')) AS settlements_published_after_june15,
    toString(argMaxIf(settlement_date, settlement_date, settlement_date < toDate('2026-06-01'))) AS last_old_entity_settlement,
    argMaxIf(short_interest, settlement_date, settlement_date < toDate('2026-06-01')) AS last_old_entity_short_interest,
    round(toFloat64(maxIf(short_interest, settlement_date >= toDate('2026-06-01'))) / toFloat64(argMaxIf(short_interest, settlement_date, settlement_date < toDate('2026-06-01'))), 0) AS jump_multiple_vs_old_entity
FROM global_markets.stocks_short_interest
WHERE ticker = 'SPCX'

Ang aktwal na short interest — open positions ayon sa isang settlement date — ay nag-print sa unang pagkakataon noong 2026-06-30: 111.3 milyong shares na short laban sa 151.63 milyong-share na average na araw. Iniulat ng vendor ang days-to-cover bilang 1 — isang floor; ang raw ratio ay 0.73: maaaring mag-cover ang mga shorts sa ilalim ng isang average na araw. Ang final settlement ng naunang entity (2026-03-31) ay nagpakita ng 9711 shares — ang symbol-reuse cliff na naman. Simula noong unang edisyon ng pahinang ito, nai-publish na ang 1 na susunod na settlement (June 30), at ang source ay nag-restate ng June 15 print mismo nang malaki pataas — ang mga figure sa itaas ay ang kasalukuyang record, na nire-run sa bawat regeneration, at ang page ay naka-hold para sa review tuwing lilipat ang mga ito sa labas ng kanilang declared ranges. Iyan ang revision machinery ng pahinang ito na gumagana.

Mga tala sa datos

Buong tala sa datos
  • Saklaw ng entity (ang batayan para sa verified_tickers). Ang stocks_ipos record (Space Exploration Technologies Corp., nakalista 2026-06-12 sa $135 noong XNAS), ang May-2026 zero-bar gap, at ang paglipat ng news-tag ang nagtuturo sa June 12 reassignment. Walang pre-June-12 row na naiugnay sa SpaceX; frontmatter verified_tickers: ["SPCX"] ay isang sinadyang editorial assertion para sa June 12–30, 2026, sa mga resibong ito.
  • Ang raw trade-tape sums ay doble-bilang ng auction volume (opisyal na open/close re-reports); ang kabuuang share at dollar ay galing sa minute aggregates, ang cross sizes ay galing sa cross prints (ang June 29 deep-dive ang nagmula ng correction na iyon).
  • Ang day one ay isang partial session — quotes mula 09:50:01 ET, unang print 11:46:45 ET. Ang day-one high/low ay minute-bar extremes; ang month extremes ay may within-a-cent corroboration counts sa scoreboard.
  • Ang EDGAR counting ay nagde-dedup sa pamamagitan ng accession_number at pumipili ng CIK 0001181412; ang hindi kaugnay na "Space Exploration I" Form D filer (CIK 0002130081) ay hindi kasama sa pamamagitan ng construction.
  • Walang fundamentals na mailalathala: 0 SpaceX rows sa tatlong financial-statement tables.
  • Ang June 29 FINRA short-volume file ay truncated market-wide (ang source file ay nagtatapos sa gitna ng alpabeto); ang SPCX ay nauuna sa cutoff at kumpleto ang row nito — ang June 29 deep-dive ang may dalang short-volume probe receipt.
  • Ang June 19 ay isang market-wide closure, na naobserbahan hindi inakala: 0 SPY bars sa araw na iyon, kaya ang June spans ng SPCX ay 12 sessions.

Pamamaraan

  • Ang mga timestamp ay naka-imbak sa UTC at sinala gamit ang raw UTC bounds; ang Hunyo 2026 ay ganap na EDT, kaya ang regular na oras ay 13:30–20:00 UTC (9:30 am–4:00 pm ET). Lumilitaw lamang ang toTimeZone sa mga SELECT list.
  • Ang pagsasara ng session ay ang huling minutong bar ng regular na oras; ang mga presyo ng auction ay nagmumula sa cross prints (unang araw: $161.29 ayon sa bar, $160.95 ayon sa cross).
  • Ang dollar volume ay minute close times minute volume, na pinagsama-sama — isang close-weighted proxy para sa notional.
  • Ang options expiry, type at strike ay muling na-parse mula sa OCC ticker (hindi maaasahan ang expiration_date column ng table); ang premium notional ay ipinapalagay ang 100-share multiplier.
  • Ang per-update spread statistics ay pantay na tinitimbang ang bawat NBBO update; ang time-weighted statistics ay tinitimbang ang bawat quote ayon sa tagal nito. Ang mga median ay gumagamit ng deterministic quantiles.
  • Ang generation ay batch-only sa pamamagitan ng gated read-only path; ang pampublikong page ay hindi kailanman nag-query ng live. Ang warehouse ay nagpapanatili ng buong tick history na walang rolling expiry, kaya ang analysis na ito ay nagre-reproduce mula sa parehong mga table anumang oras. Estado ng warehouse noong Hulyo 3, 2026.

Ang listing na ito ay nasa loob ng mas malawak na 2026 story — ang unang kalahati ng IPO market, sinusukat ay naglalagay nito sa konteksto. Ang bawat panel ay isang stored object — chart, table at SQL. Dalhin ang anumang query sa Strasmore terminal.

← All SPCX periods
#spacex#spcx#ipo#deepdive#microstructure