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

SPCX: SpaceX soko la umma mwezi wa kwanza

SpaceX ilianza kuuzwa hadharani Juni 2026 kama SPCX. Bei ya toleo, ufunguzi, kilele, chini, na kufunga kwa mwezi. Ilikuwa nne kwa kiasi cha dola Marekani.

SpaceX ilianza kuuzwa hadharani tarehe 12 Juni 2026 chini ya ticker SPCX, herufi nne ambazo mwezi Aprili bado zilikuwa zikifanya biashara kama kampuni tofauti. Bei iliwekwa $135, hisa ilifunguliwa kwa $150 (11.1% juu ya bei ya toleo), ilifikia kilele cha kufunga kwa $201.99 tarehe 2026-06-16, ilichapisha kiwango cha chini kabla ya soko la $146.88, na kumalizia kwa $170.72, 26.5% juu ya bei ya toleo, 15.5% chini ya kilele, huku ikishika nafasi ya nne kwenye soko lote la Marekani kwa kiasi cha dola katika saa za kawaida, mbele ya NVDA. Kila namba hapa ni matokeo ya swala lililohifadhiwa; panua paneli yoyote ili kuona SQL kamili.

UlizaMwezi kwa safu moja: toleo hadi kufungwa, pamoja na viwango vya juu na chini na risiti zake
SQL halisi nyuma ya kila namba
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')

Ticker moja, makampuni mawili

SPCX ni alama iliyotumiwa tena, kwa hiyo hati za uthibitisho huja kwanza. Hadi Aprili 2026 ticker hiyo ilifanya biashara kama hazina ndogo, baa za 13 dakika katika mwezi wake wa mwisho wa shughuli, kati ya $21.92 na $23.64. Mwezi Mei 2026 haikuchapisha chochote (baa 0). Mnamo Juni 12 ilikabidhiwa tena kwa Space Exploration Technologies Corp.:

UlizaRekodi ya IPO: chombo nyuma ya SPCX tangu Juni 12, 2026
SQL halisi nyuma ya kila namba
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
UlizaRisiti ya matumizi tena ya alama: miezi kumi na tatu ya baa za dakika za SPCX, Mei 2026 haipo kabisa
SQL halisi nyuma ya kila namba
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

Swala la "historia ya SPCX" lisilozuiliwa linaunganisha makampuni mawili yasiyohusiana pamoja, kwa hiyo kila dirisha hapa linaanza Juni 12, 2026. Mlipuko wa habari unaonyesha mteremko uleule (makala 0 zenye lebo ya SPCX katika miezi kumi na miwili iliyopita), kama vile riba fupi: takriban mara 11461x katika kipindi hicho.

Ufuatiliaji wa karatasi ulikuja kwanza

UlizaMkondo wa SpaceX 2026 SEC kwa aina ya fomu, kwa mpangilio wa uwasilishaji (CIK 0001181412, zimeondolewa nakala kwa ufikiaji)
SQL halisi nyuma ya kila namba
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

Ukisoma kutoka juu hadi chini, IPO inajikusanya yenyewe: rasimu ya siri ya marekebisho (DRS/A) tarehe 2026-05-07, S-1 ya umma tarehe 2026-05-20, marekebisho 2 yake, kisha 7 FWP hati za matarajio za uandishi huru, karatasi za roadshow, kati ya 2026-06-04 na 2026-06-11. Usajili wa ubadilishanaji na uidhinishaji ulifika 2026-06-10; notisi ya ufanisi na ya kwanza kati ya 10 fomu za ndani za 3 tarehe 2026-06-11; hati ya mwisho ya matarajio ya 424B4 na S-8 siku ya kuorodheshwa yenyewe. Kisha mwendo ulibadilika hadi 8-K:

UlizaKila 8-K ya SpaceX iliyowasilishwa Juni 2026, pamoja na mistari ya mwanzo ya kila moja
SQL halisi nyuma ya kila namba
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 kati yao ndani ya chini ya wiki mbili: mauzo ya hisa zisizosajiliwa wakati wa kufungwa kwa IPO (Kipengele 3.02); makubaliano muhimu na X67 Inc., kampuni tanzu inayomilikiwa kikamilifu (1.01); mabadiliko ya bodi na maafisa (5.02); notisi ya Kanuni FD (7.01); na notisi za Kipengele 8.01 kuhusu toleo la noti za juu zisizohakikishwa ambalo lilianza Juni 22, kwa mujibu wa 8-K iliyowasilishwa 2026-06-23. Kichwa cha habari cha Juni 23 kilikadiria: "SpaceX's Fundraising Is Not Over With a $20 Billion New Bond Offering". Dirisha la toleo na viwango vya chini vya mwezi vya hisa viko kwenye siku sawa za kalenda; data hii haisemi chochote zaidi ya hilo.

Siku ya kuorodheshwa: ufunguzi usio na saa 9:30

IPO haifunguki pamoja na soko. Nasdaq ilianza kuchapisha nukuu za SPCX saa 09:50:01 ET, zilizofungwa, jozi za bei ya kununua na kuuza zilizolingana zikitembeza kitabu kuelekea bei ya kusafisha, na kwa karibu saa mbili hakukuwa na biashara yoyote. Chapisho la kwanza la SpaceX lilikuwa msalaba wa ufunguzi wenyewe: 58.21 milioni hisa kwa $150, lililotambulishwa saa 11:46:45 ET chini ya misimbo ya hali 17, 9 na 41 (chapisho la ufunguzi wa kituo cha soko, msalaba, ubaguzi wa biashara). Hisa ilikimbia hadi 176.52, ikashikilia kiwango cha chini cha 149.34, na ikafunga kwa msalaba wa kufunga wa 7.85 milioni hisa kwa $160.95, 19.2% juu ya toleo. Jumla: 513.5 milioni hisa, $84.1 bilioni, 8.57 milioni chapisho, katika kikao cha kawaida cha muda kidogo zaidi ya saa nne.

UlizaSiku ya kuorodheshwa kwa safu moja: nukuu ya kwanza, msalaba wa ufunguzi, msalaba wa kufunga, jumla za siku
SQL halisi nyuma ya kila namba
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)

Mkondo wa nukuu unaonyesha nusu ya ugunduzi wa bei. Kabla ya msalaba, sasisho pekee za NBBO ni zile za kufungwa (18 katika nusu saa ya 09:30, uenezi sifuri kwa muundo). Kisha nukuu zilimwagika: 445211 sasisho katika kikundi cha 11:30 pekee, kwa wastani wa uenezi wa bei ya kununua na kuuza wa 30 senti (18.6 bps). Kufikia kikundi cha 13:00 wastani ulikuwa 6 senti (3.5 bps), uenezi hauzaliwa mwembamba; huu uliwaa ndani ya saa mbili.

UlizaSiku ya kwanza kwa nusu saa: sasisho za nukuu na wastani wa uenezi unaopata kiwango chake
SQL halisi nyuma ya kila namba
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

Kikao kwa kikao

UlizaVikao: kufunga kwa saa za kawaida, mabadiliko ya kufunga-kwa-kufunga, kiasi cha siku nzima
SQL halisi nyuma ya kila namba
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

Mwelekeo: 19.3% katika kikao cha pili, kufungwa kwa kilele cha $201.99 mnamo 2026-06-16, kisha kushuka mara tatu mfululizo, kikali zaidi kikiwa ni mwendo wa -16.4% mnamo 2026-06-22, kikao cha kwanza baada ya sikukuu ya Juni 19 na siku ambayo utoaji wa hati fungani ulianza. Kushuka kulifika chini kwa $152.74 mnamo 2026-06-26; vikao viwili vya mwisho vilifungwa 7.4% na 4.1% juu zaidi (2026-06-29 ina muhtasari wa kila siku na uchambuzi wa kina wa ngazi ya tick). Kiasi cha hisa kilipungua kwa kasi kuliko bei ilivyopona: 513.5 milioni hisa siku ya kwanza, 75.8 milioni hisa mnamo 2026-06-30.

Mipaka yote miwili ya mwezi inaishi katika ukaguzi wa mwisho wa nakala moja, na iko katika awamu tofauti za soko. Kilele cha $225.64 kilichapishwa saa 2026-06-16 10:02 ET: 2 baa ndani ya senti moja, 47699 biashara katika dakika ya kwanza ya kilele. Chini ya $146.88 ilichapishwa saa 2026-06-23 04:11 ET ikiwa na 2 baa ndani ya senti moja na 14844 biashara dakika hiyo. Chini ya saa za kawaida ni $147.11, $0.23 juu yake; takwimu yoyote ya "chini ya Juni" inapaswa kueleza ni ipi inamaanisha.

Tiketi ya nne kwa ukubwa kwenye tepu

Orodhesha kila alama iliyoorodheshwa Marekani kwa kiasi cha dola katika saa za kawaida kuanzia Juni 12 hadi 30, mkusanyiko kamili wa soko zima, si orodha ya wagombea, na orodha mpya kabisa iko nne: $344.6 bilioni, nyuma ya MU ($585.4 bilioni), SPY na QQQ, mbele ya NVDA ($253.1 bilioni), TSLA na AAPL. Kila safu ilikuwa na vipindi sawa vya 12 vya kufanyia kazi.

UlizaKanda nzima ya US iliyoorodheshwa kwa kiasi cha dola cha saa za kawaida Juni 12–30
SQL halisi nyuma ya kila namba
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

Nyenzo ya mkanda uliotengenezwa

UlizaKanda nzima ya SPCX kwa safu moja: chapa, ukubwa wa chapa, na sensa ya nukuu
SQL halisi nyuma ya kila namba
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)

Muundo wake ni wa maandishi madogo na wingi wa nukuu: 41.01 milioni za chapa kwa wastani wa 10 hisa (wastani 64.2, misalaba mikubwa huvuta wastani), 81.9% kura zisizo za kawaida (chini ya hisa 100), 8.73% sehemu ndogo, sawia na programu za rejareja zinazogawanya maagizo, huku watengenezaji wa soko wakiwa upande mwingine. Sehemu ya nukuu: 11.78 milioni za sasisho za NBBO, 99.32% safi zenye pande mbili; 46377 zilivuka kwa muda (bei ya kununua ikiwa juu ya bei ya kuuza, sehemu za biashara zikiwa hazijasawazishwa), zikipungua kutoka 17730 siku ya kwanza hadi 437 Juni 30; 34118 zimefungwa; 116 za upande mmoja au tupu. Takwimu za uenezi hapa chini hazijumuishi nukuu zilizovuka na za upande mmoja, na hesabu za kushuka zimeonyeshwa kwenye jedwali.

Misimu ya Kuenea kwa Bei

Mfululizo wa kipekee wa orodha mpya ni kuenea kwa bei kupata kiwango chake, kinachopimwa kwa kila kikao kwa kutumia wastani wa sasisho na wastani wa uzani wa muda. Siku ya kwanza huanza saa 11:46 baada ya kukamilika kwa mauzo; kujumuisha viashiria vilivyofungwa kabla ya ufunguzi kungeliongeza sifa zake.

UlizaMviringo wa ukomavu: uenezi wa saa za kawaida kwa kikao, kwa kila sasisho na uzani wa wakati
SQL halisi nyuma ya kila namba
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

Kwa uzani wa muda, kuenea kwa bei kulikwenda kutoka senti 23.5 (7.64 bps) siku ya kwanza hadi senti 7.9 (4.7 bps) tarehe 2026-06-30, karibu asilimia thelathini na tatu nyembamba kwa dola, lakini kidogo sana kwa uwiano; mfululizo wa dola na uwiano hutofautiana katika kipindi ambacho bei ilisafiri katika safu ya $146.88–$225.64. Kikao kilicho na kuenea nyembamba zaidi kilikuwa 2026-06-22 kwa 2 bps, na upanuzi tena tarehe 2026-06-17 (8.96 bps, kikao baada ya kilele cha bei) na 2026-06-24 (7.38 bps), ambapo mwisho huo uliwiana na kiasi kinachoshuka hadi hisa milioni 71.7 kutoka hisa milioni 152.3. Kwa kulinganisha, nanga tatu za Juni 30:

UlizaNanga za Juni 30: mega-cap, SPCX, na small-cap nyembamba, kikao kimoja, hesabu sawa
SQL halisi nyuma ya kila namba
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

Wastani wa kuenea kwa bei kwa Apple: senti 3 (1.04 bps). SPCX: senti 6 (3.54 bps). Nathan's Famous, yenye sasisho 1036 za nukuu katika kikao chote: senti 30 (29.66 bps). Siku kumi na nane baadaye, SpaceX ilikuwa na kuenea kwa bei mara chache zaidi kuliko kampuni kubwa, lakini nyembamba mara kadhaa kuliko jina dhaifu.

Chaguzi kutoka siku ya tatu

UlizaSoko la chaguo la SpaceX kwa safu moja: jumla, muundo wa ukomavu, mikataba bendera
SQL halisi nyuma ya kila namba
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)

Chaguzi zilizoorodheshwa kwa 2026-06-16 09:30:00 ET, kikao cha tatu cha hisa. Katika vikao 10 vya chaguzi: 2.18 milioni za prints, 10.4 milioni za mikataba katika orodha 3199, $9.15 bilioni kwa malipo (bei ikizidishwa na kizidishi cha kawaida cha hisa 100), $0.31 bilioni zaidi ya malipo ya chaguzi za AAPL yaliyokusanywa katika MWEZI mzima wa Juni ($8.84 bilioni kwa mikataba 27 milioni; vikao kumi dhidi ya mwezi mzima, asymmetry ya makusudi ambayo hoja inabaki). Muda wa mwisho 22 uliofanyika biashara, kutoka kwa wiki moja inayoisha Alhamisi Juni 18 (soko lilikuwa limefungwa Ijumaa hiyo) hadi 2028-12-15 LEAPS; wiki hiyo ya kwanza pekee ilichukua 26.7% ya kiasi cha mwezi. Mkataba wenye shughuli nyingi: $175 put, expiry 2026-06-18, mikataba 203765 katika prints 41648 kwa wastani wa malipo $1.43. Sumaku ya malipo: $225 call, expiry 2026-09-18, $121.3 milioni kwa $40.12.

UlizaKikao cha chaguo kwa kikao: mikataba, mgawanyiko wa wito/kuweka, na uwiano wa kuweka/wito
SQL halisi nyuma ya kila namba
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

Calls zilizidi puts katika kila kikao: uwiano wa kila siku wa put/call ulifikia kilele cha 0.987 mnamo 2026-06-17, karibu na kilele cha bei, na kushuka chini hadi 0.46 mnamo 2026-06-29, kikao ambacho hisa ilifunga 7.4% juu zaidi, kiasi cha put kilifikia kilele na bei, si shimo. Kikao chenye shughuli nyingi kilikuwa 2026-06-18, siku ya mwisho ya wiki ya kwanza: mikataba 1844490.

UlizaMahali mikataba ilipotua: kiasi cha wito na kuweka kwa ndoo ya bei ya awali
SQL halisi nyuma ya kila namba
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))

Ramani ya strike ni barbell kuzunguka njia ya bei. Kundi la $150 lilichukua kiasi kikubwa zaidi, likigawanywa 55% puts, biashara ya pande mbili kwa bei ya sasa. Chini ya safu ya biashara puts zinamiliki kitabu (92.7% ya kundi la $125); juu yake calls (1.6% puts kwa $250), na mikataba 42228 ya call kwenye kundi la $450, takriban mara mbili ya kiwango cha juu cha mwezi.

UlizaGharama ya kuuza mkataba wenye shughuli nyingi: uenezi wa NBBO katika vipindi vyake vitatu
SQL halisi nyuma ya kila namba
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

Gharama ya biashara ilikuwa ndogo tangu saa ya kwanza: mkataba wenye shughuli nyingi ulikuwa na wastani wa kuenea kwa NBBO ya senti 10.3 kwenye kikao chake cha kwanza (6.7% ya katikati; wastani ulikuwa senti 10), wastani ukibana hadi senti 5 kwa siku ya mwisho (5.23% ya katikati, sasisho 93198 za quote, quotes 37 mbaya zilizotupwa na kuhesabiwa). Kuenea kwa nikeli hadi dime kwenye kitovu cha kioevu cha kitabu cha siku chache, mbawa za mbali zinagharimu zaidi, na paneli hii haizungumzi kwa niaba yao.

Swichi ya habari na wauzaji fupi

UlizaMtiririko wa habari kwa safu moja: vitambulisho vinageuka, muundo wa malisho, vitambulisho shirikishi
SQL halisi nyuma ya kila namba
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')

Uwekaji lebo za habari ni utaratibu wake wenyewe: 0 makala zenye lebo ya SPCX katika miezi kumi na mbili kabla ya kuorodheshwa, kisha 14 kwenye 2026-06-11 (siku ya kuweka bei), kilele cha 42 makala kwenye 2026-06-12, 347 kwa mwezi huo. Soma hesabu hizo kwa mashaka: 4 wachapishaji, na The Motley Fool pekee aliandika 65%, umakini wa mlisho mmoja, si wa vyombo vya habari vya dunia. Lebo-shirikishi zinaonyesha mwelekeo: TSLA katika 83 makala, NVDA katika 59, Alphabet (madaraja ya hisa yameunganishwa) katika 57, huku Rocket Lab (21) na AST SpaceMobile (15) zikiwa nyuma sana: mlisho huu uliishughulikia kama hadithi ya kampuni kubwa, si ya sekta ya anga.

UlizaKiasi cha uuzaji mfupi cha nje ya soko la FINRA kwa kikao: hisa zilizowekwa alama ya ufupi na kiasi kilichoripotiwa
SQL halisi nyuma ya kila namba
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

Wauzaji fupi walijitokeza siku ya kwanza, wakiwa na ufafanuzi ulioambatishwa. Kiasi cha mauzo fupi nje ya soko ni sehemu ya kiasi kinachoripotiwa na FINRA (nje ya soko) kilichowekwa alama kuwa fupi; sehemu kubwa yake ni wafanya soko wanaouza fupi kujaza ununuzi wa wateja, mfumo wa kawaida, na si riba fupi. Sehemu ya mauzo fupi yenye alama ya SPCX ilianza kwa 33.7% siku ya kuorodheshwa na ikapanda hadi 71% kufikia 2026-06-30, huku kiasi cha mauzo nje ya soko kilichoripotiwa kikishuka kutoka 131.53 milioni hisa hadi 35.77 milioni. Mwendo-shirikishi ndicho kitu ambacho data hii inaweza kuonyesha; maana yake haipo katika data hii.

UlizaChapisho la kwanza la riba ya ufupi, pamoja na ukingo wa chombo cha zamani kama risiti yake
SQL halisi nyuma ya kila namba
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'

Riba fupi halisi, nafasi wazi kufikia tarehe ya malipo, ilichapishwa kwa mara ya kwanza tarehe 2026-06-30: 111.3 milioni hisa fupi dhidi ya wastani wa siku wa 151.63 milioni hisa. Mtoa huduma anaripoti siku za kufidia kama 1, kiwango cha chini; uwiano ghafi ni 0.73: wauzaji fupi wangeweza kufidia chini ya siku moja ya wastani. Malipo ya mwisho ya chombo cha awali (2026-03-31) yalionyesha 9711 hisa, tena mteremko wa kutumia tena alama. Tangu toleo la kwanza la ukurasa huu, malipo ya baadaye ya 1 (Juni 30) yamechapishwa, na chanzo kikirekebisha chapa ya Juni 15 yenyewe kwa kiasi kikubwa juu, takwimu zilizo hapo juu ndizo rekodi ya sasa, inayoendeshwa upya kila wakati wa kuzalisha upya, na ukurasa unashikiliwa kwa ukaguzi kila zinapohama nje ya mipaka yake iliyotangazwa. Hiyo ni mashine ya marekebisho ya ukurasa huu ikifanya kazi kama ilivyokusudiwa.

Vidokezo vya Data

Vidokezo Kamili vya Data
  • Mpaka wa chombo (msingi wa verified_tickers). Rekodi ya stocks_ipos (Space Exploration Technologies Corp., iliyoorodheshwa 2026-06-12 kwa $135 tarehe XNAS), pengo la sifuri la Mei-2026, na kubadilisha lebo ya habari kunathibitisha ugawaji upya wa Juni 12. Hakuna safu mlalo kabla ya Juni 12 inayohusishwa na SpaceX; verified_tickers za mbele: ["SPCX"] ni madai ya kimakusudi ya uhariri kwa Juni 12–30, 2026, kwenye hati hizi.
  • Jumla mbichi za mkanda wa biashara huhesabu mara mbili kiasi cha mnada (taarifa rasmi za ufunguzi/kufunga huripotiwa tena); jumla ya hisa na dola hutoka kwa mkusanyiko wa dakika, ukubwa wa cross kutoka kwa alama za cross (uchambuzi wa kina wa Juni 29 unatoa marekebisho hayo).
  • Siku ya kwanza ni kipindi cha sehemu, nukuu kutoka 09:50:01 ET, alama ya kwanza 11:46:45 ET. Kiwango cha juu/cha chini cha siku ya kwanza ni mipaka ya baa za dakika; mipaka ya mwezi hubeba hesabu za uthibitisho ndani ya senti moja kwenye ubao wa alama.
  • Uhesabuji wa EDGAR huondoa nakala kwa accession_number na kuchagua CIK 0001181412; mwasilishaji Form D asiyehusiana "Space Exploration I" (CIK 0002130081) ametengwa kwa muundo.
  • Hakuna misingi ya kuchapisha: 0 safu mlalo za SpaceX kwenye majedwali matatu ya taarifa za fedha.
  • Faili ya kiasi kifupi cha FINRA ya Juni 29 imekatwa kote sokoni (faili chanzo inaisha katikati ya alfabeti); SPCX inapanga kabla ya kukatwa na safu yake imekamilika, uchambuzi wa kina wa Juni 29 unabeba risiti ya uchunguzi wa kiasi kifupi.
  • Juni 19 ilikuwa kufungwa kote sokoni, kulionekana si kukisiwa: 0 baa za SPY siku hiyo, kwa hivyo vipindi vya Juni vya SPCX vina 12 vikao.

Mbinu

  • Nyakati za muda huhifadhiwa kwa UTC na huchujwa kwa mipaka ghafi ya UTC; Juni 2026 iko katika EDT kwa ukamilifu, hivyo saa za kawaida ni 13:30–20:00 UTC (9:30 asubuhi–4:00 jioni ET). toTimeZone inaonekana tu katika orodha za SELECT.
  • Kufunga kwa kipindi ni baa ya dakika ya mwisho ya saa za kawaida; bei za mnada hutoka kwa alama za msalaba (siku ya kwanza: $161.29 kwa baa, $160.95 kwa msalaba).
  • Kiasi cha dola ni bei ya kufunga ya dakika ikizidishwa na kiasi cha dakika, kisha kujumlishwa, kiwakilishi cha karibu cha dhamana ya kawaida.
  • Muda wa kuisha kwa chaguo, aina na bei ya utekelezaji huchambuliwa upya kutoka kwa ticker ya OCC (safu ya expiration_date ya jedwali haina uhakika); dhamana ya kawaida ya malipo inachukua kizidishi cha hisa 100.
  • Takwimu za usambaaji kwa kila sasisho hupima kila sasisho la NBBO kwa usawa; takwimu za usambaaji kwa uzito wa muda hupima kila nukuu kwa muda uliosimama. Wastani wa kati hutumia quantile za uamuzi.
  • Uzalishaji ni kwa kundi pekee kupitia njia ya kusoma tu iliyozuiliwa; ukurasa wa umma hauwahi kuuliza moja kwa moja. Ghala huhifadhi historia kamili ya tick bila kuisha kwa mzunguko, hivyo uchambuzi huu unazalishwa kutoka kwa majedwali yale yale wakati wowote. Hali ya ghala kufikia Julai 3, 2026.

Orodha hii iko katika hadithi pana ya 2026, soko la IPO la nusu ya kwanza, lililopimwa inaiweka katika muktadha. Kila paneli ni kitu kimoja kilichohifadhiwa, chati, jedwali na SQL. Chukua swali lolote zaidi kwenye terminal ya Strasmore.

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