By Matt Connor · · Updated 2026-07-25SPCX: SpaceX stock price drop from peak wey high wella
SpaceX stock (SPCX) drop 33.7% from im $225.64 peak for June 16, 2026 go $149.58 close for July 7, na di first time e close below di $150 IPO opening print.
SpaceX price dia IPO for $135 per share and e start to dey trade for June 12, 2026 for $150 — and by di time market close for July 7, di whole circle don complete. SPCX reach im highest point of $225.64 for June 16, 2026, wey be 50.4% up from di IPO opening trade, den e return everi kobo: July 7 close for $149.58, wey be $0.42 below di first regular-hours print, afta e touch low of $148.86 late for di day. From dat peak to di close na 33.7% drop. For di same period, di S&P 500 ETF (SPY) rise 0.94% — dis na one stock repricing, no be market move. Everi number wey dey below na stored query result from di consolidated tape and quote feed; expand any panel make you see di exact SQL.
Di curve: from IPO open go round trip
Di scoreboard row tell am for one line: issue price na $135, first regular-hours trade na $150 (11:46 a.m. opening cross — di deep dive for first month carry di listing-day mechanics), peak na $225.64 for June 16, and e close $149.58 for July 7. Di peak show mid-morning inside regular hours and di bars wey dey near am trace am (data notes); di July 7 session low, $148.86, show for 15:55 ET — inside di last half hour.
The exact SQL behind every number
WITH
peak_stats AS (
SELECT
round(toFloat64(max(high)), 2) AS peak_hi,
toDate(toTimeZone(argMax(window_start, (toFloat64(high), -toInt64(toUnixTimestamp(window_start)))), 'America/New_York')) AS peak_d
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
AND window_start >= '2026-06-12 00:00:00' AND window_start < '2026-07-08 00:00:00'
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
),
ipo_open AS (
SELECT round(toFloat64(argMin(open, window_start)), 2) AS ipo_open_px
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
AND window_start >= '2026-06-12 00:00:00' AND window_start < '2026-06-13 00:00:00'
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
),
issue_price AS (
SELECT toFloat64(final_issue_price) AS issue_px
FROM global_markets.stocks_ipos
WHERE ticker = 'SPCX'
ORDER BY listing_date DESC LIMIT 1
),
jul7 AS (
SELECT
round(toFloat64(argMax(close, window_start)), 2) AS jul7_c,
round(toFloat64(min(low)), 2) AS jul7_lo,
argMin(window_start, (toFloat64(low), toInt64(toUnixTimestamp(window_start)))) AS low_bar
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
AND window_start >= '2026-07-07 00:00:00' AND window_start < '2026-07-08 00:00:00'
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
),
spy_ret AS (
SELECT round((toFloat64(argMax(close, window_start)) / toFloat64(argMin(open, window_start)) - 1) * 100, 2) AS spy_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= '2026-06-12 00:00:00' AND window_start < '2026-07-08 00:00:00'
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
)
SELECT
toString(round(ip.issue_px, 2)) AS issue_price,
io.ipo_open_px AS ipo_open,
ps.peak_hi AS peak_price,
toString(ps.peak_d) AS peak_date,
toMonth(ps.peak_d) AS peak_month,
toDayOfMonth(ps.peak_d) AS peak_day,
j.jul7_c AS jul7_close,
j.jul7_lo AS jul7_low,
formatDateTime(toTimeZone(j.low_bar, 'America/New_York'), '%H:%i') AS jul7_low_et,
toHour(toTimeZone(j.low_bar, 'America/New_York')) * 60 + toMinute(toTimeZone(j.low_bar, 'America/New_York')) AS jul7_low_et_minute,
round(io.ipo_open_px - j.jul7_c, 2) AS close_below_ipo_usd,
round(io.ipo_open_px - j.jul7_lo, 2) AS low_below_ipo_usd,
round((ps.peak_hi - io.ipo_open_px) / io.ipo_open_px * 100, 1) AS peak_above_ipo_pct,
round((ps.peak_hi - j.jul7_c) / ps.peak_hi * 100, 1) AS decline_from_peak_pct,
sr.spy_pct AS spy_period_pct
FROM peak_stats ps, ipo_open io, issue_price ip, jul7 j, spy_ret srSession by session: how e fall
SPCX trade for 16 sessions from di day dem list am reach July 7 — di June 19 Juneteenth holiday and July 3 Independence Day holiday na im cause di gaps for calendar. E open im first session for $150, hit di $225.64 peak two sessions later, and reach July 7 with $149.58 close on top $148.86 low. Di volume come down as di gist dey old: 495.6 million shares for day one, 274.5 million for di peak session, 66.2 million for July 7.
The exact SQL behind every number
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
round(toFloat64(argMin(open, window_start)), 2) AS rth_open,
round(toFloat64(argMax(close, window_start)), 2) AS rth_close,
round(toFloat64(min(low)), 2) AS rth_low,
round(toFloat64(max(high)), 2) AS rth_high,
round(toFloat64(sum(volume)) / 1e6, 1) AS vol_m
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
AND window_start >= '2026-06-12 00:00:00' AND window_start < '2026-07-08 00:00:00'
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
GROUP BY session_date
ORDER BY session_dateJuly 7: di day wey di line break
July 7 still be SPCX first session inside Nasdaq-100 — di index-add trade dey measure di record closing cross wey happen before am on July 6, auction by auction. For di day itself, di selling show for front and back. SPCX open for $158.92 and di first half hour alone turn over 13.4 million shares, carry di stock reach $153.08 by 10:00 a.m. Midday hold above di IPO print — from mid-morning reach 3 p.m. di half-hour closes sit between roughly $150.42 and $152.59 — and den di final half hour break am: 10.9 million shares, di session low of $148.86 print for 15:55 ET, and a $149.58 finish. Dat close na $0.42 below di IPO opening trade — di first closing print wey fall below dat line for di stock short life.
The exact SQL behind every number
SELECT
formatDateTime(toTimeZone(toStartOfInterval(window_start, INTERVAL 30 MINUTE), 'America/New_York'), '%H:%i') AS et_time,
round(toFloat64(argMax(close, window_start)), 2) AS close_px,
round(toFloat64(min(low)), 2) AS bucket_low,
round(toFloat64(sum(volume)) / 1e6, 1) AS vol_m
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
AND window_start >= '2026-07-07 13:30:00' AND window_start < '2026-07-07 20:00:00'
GROUP BY et_time
ORDER BY et_timeDi spread narrow as di price fall
One tin wey no spoil during di drop na di cost to trade. Di bid-ask spread — di toll wey every marketable order dey pay — average na 10.74 bps of di midpoint for IPO day, 7.14 bps for di peak session, and 4.18 bps for July 7. Depth for di touch thin as di crowd move on: average of 9506 shares for day one against 3265 for July 7. Di quote feed settle even as di price fall.
The exact SQL behind every number
SELECT
toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session_date,
round(avgIf((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, bid_price > 0 AND ask_price > bid_price), 2) AS avg_spread_bps,
round(avgIf((toFloat64(ask_size) + toFloat64(bid_size)) / 2, bid_price > 0 AND ask_price > bid_price), 0) AS avg_depth,
countIf(NOT (bid_price > 0 AND ask_price > bid_price)) AS dropped_invalid
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'SPCX'
AND sip_timestamp >= '2026-06-12 00:00:00' AND sip_timestamp < '2026-07-08 00:00:00'
AND (toHour(sip_timestamp) * 60 + toMinute(sip_timestamp)) BETWEEN 810 AND 1199
GROUP BY session_date
ORDER BY session_dateOptions: puts for di IPO price, no 0DTE to trade
For July 7, di busiest SPCX contract na di 330-strike call (28906 contracts), and di 150-strike put — 21261 contracts — e siddon exactly for di $150 IPO opening price. All five of di busiest contracts go expire on 2026-07-10, wey be di Friday weekly: SPCX dey list weekly and monthly expiries, so Tuesday session no get any same-day 0DTE contract to trade. Di put/call volume ratio move from 0.61 for July 1 go 0.83 for July 7.
The exact SQL behind every number
SELECT
concat('20', substring(ticker, 7, 2), '-', substring(ticker, 9, 2), '-', substring(ticker, 11, 2)) AS expiry_date,
if(substring(ticker, 13, 1) = 'C', 'call', 'put') AS call_or_put,
toUInt32OrZero(substring(ticker, 14, 8)) / 1000 AS strike,
concat(toString(toUInt32OrZero(substring(ticker, 14, 8)) / 1000), '-strike ', if(substring(ticker, 13, 1) = 'C', 'call', 'put')) AS label,
sum(size) AS volume,
round(sum(toFloat64(size) * toFloat64(price)) / 1e6, 2) AS notional_m,
if(substring(ticker, 7, 6) = '260710', 1, 0) AS expires_jul10
FROM global_markets.options_trades
WHERE ticker LIKE 'O:SPCX%'
AND length(ticker) = 21
AND sip_timestamp >= '2026-07-07 00:00:00' AND sip_timestamp < '2026-07-08 00:00:00'
GROUP BY expiry_date, call_or_put, strike, label, expires_jul10
ORDER BY volume DESC
LIMIT 10The exact SQL behind every number
SELECT
toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session_date,
round(sumIf(size, substring(ticker, 13, 1) = 'P') / sumIf(size, substring(ticker, 13, 1) = 'C'), 2) AS pc_ratio,
sumIf(size, substring(ticker, 13, 1) = 'C') AS call_vol,
sumIf(size, substring(ticker, 13, 1) = 'P') AS put_vol
FROM global_markets.options_trades
WHERE ticker LIKE 'O:SPCX%'
AND length(ticker) = 21
AND sip_timestamp >= '2026-07-01 00:00:00' AND sip_timestamp < '2026-07-08 00:00:00'
GROUP BY session_date
ORDER BY session_dateDi options quote feed bin dey wide
Even as di stock own spread narrow reach single-digit basis points, di option chain quote still dey wide all through: di average quoted spread across SPCX contracts measure 1086.65 bps for July 1, 1059.11 for July 2, and 1183.25 bps for July 6 — e be like hundreds times di stock own touch for di same days (both panels get di receipts). Average size for di best quote run 231 contracts for July 1 and 200 for July 6. July 7 option quotes never enter yet as at di time dem dey write — dat table get di longest lag for di warehouse — so dis panel stop for July 6 and e tok am.
The exact SQL behind every number
SELECT
toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session_date,
round(avgIf((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, bid_price > 0 AND ask_price > bid_price), 2) AS opt_spread_bps,
round(avgIf((toFloat64(ask_size) + toFloat64(bid_size)) / 2, bid_price > 0 AND ask_price > bid_price), 0) AS avg_size,
countIf(NOT (bid_price > 0 AND ask_price > bid_price)) AS dropped_invalid,
count() AS quotes
FROM global_markets.cache_options_quotes
WHERE ticker LIKE 'O:SPCX%'
AND sip_timestamp >= '2026-07-01 00:00:00' AND sip_timestamp < '2026-07-07 00:00:00'
AND (toHour(sip_timestamp) * 60 + toMinute(sip_timestamp)) BETWEEN 810 AND 1199
GROUP BY session_date
ORDER BY session_dateSPY no really move
From June 12 go reach July 7, SPY climb 0.94% (na from di first regular-hours open to di last regular-hours close). As we dey look am session by session for July, di difference dey clear: for July 7, SPY print -0.34% open-to-close, but SPCX print -5.87%.
The exact SQL behind every number
SELECT
a.session_date AS session_date,
round(a.spx_pct, 2) AS spy_pct,
round(b.spcx_pct, 2) AS spcx_pct
FROM (
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
(toFloat64(argMax(close, window_start)) / toFloat64(argMin(open, window_start)) - 1) * 100 AS spx_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= '2026-07-01 00:00:00' AND window_start < '2026-07-08 00:00:00'
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
GROUP BY session_date
) a
INNER JOIN (
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
(toFloat64(argMax(close, window_start)) / toFloat64(argMin(open, window_start)) - 1) * 100 AS spcx_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
AND window_start >= '2026-07-01 00:00:00' AND window_start < '2026-07-08 00:00:00'
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
GROUP BY session_date
) b ON a.session_date = b.session_date
ORDER BY a.session_dateWetin di news feed show about di slide
Di headlines wey dem fit count no plenty. Di vendor feed get 398 SPCX-tagged articles from listing day reach July 7, from just 4 publishers — The Motley Fool alone write 71.1% of dem. Di day wey coverage heavy pass na di listing day itself — 42 articles on June 12, 31 on di June 16 peak session — and no later day come close to di IPO-day count by 13 articles. Coverage fade as di price dey fade: 25.7 articles a day for di first week, 9.3 for di last one. 84 articles dey co-tag Tesla; 20 carry “Nasdaq” for di title. No day wey headline dominate show for di slide — attention just decay; e no spike.
The exact SQL behind every number
WITH daily_counts AS (
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-12 04:00:00') AND published_utc < toDateTime('2026-07-08 04:00:00')
GROUP BY d
),
top_pub AS (
SELECT JSONExtractString(publisher, 'name') AS p, count() AS n
FROM global_markets.stocks_news
WHERE has(tickers, 'SPCX')
AND published_utc >= toDateTime('2026-06-12 04:00:00') AND published_utc < toDateTime('2026-07-08 04:00:00')
GROUP BY p ORDER BY n DESC, p ASC LIMIT 1
)
SELECT
count() AS total_articles,
uniqExact(JSONExtractString(publisher, 'name')) AS publishers,
(SELECT p FROM top_pub) AS top_publisher,
round(100.0 * (SELECT n FROM top_pub) / count(), 1) AS top_publisher_share_pct,
(SELECT toMonth(argMax(d, (n, -toInt32(toDayOfYear(d))))) FROM daily_counts) AS busiest_month,
(SELECT toDayOfMonth(argMax(d, (n, -toInt32(toDayOfYear(d))))) FROM daily_counts) AS busiest_dom,
countIf(toDate(toTimeZone(published_utc, 'America/New_York')) = toDate('2026-06-12')) AS ipo_day_articles,
countIf(toDate(toTimeZone(published_utc, 'America/New_York')) = toDate('2026-06-16')) AS peak_session_articles,
countIf(toDate(toTimeZone(published_utc, 'America/New_York')) = toDate('2026-07-07')) AS jul7_articles,
(SELECT max(n) FROM daily_counts WHERE d > toDate('2026-06-16')) AS max_daily_after_peak,
countIf(toDate(toTimeZone(published_utc, 'America/New_York')) = toDate('2026-06-12')) - (SELECT max(n) FROM daily_counts WHERE d > toDate('2026-06-16')) AS ipo_day_minus_max_after,
(SELECT round(avg(n), 1) FROM daily_counts WHERE d <= toDate('2026-06-18')) AS first_week_avg,
(SELECT round(avg(n), 1) FROM daily_counts WHERE d >= toDate('2026-07-01')) AS final_week_avg,
countIf(has(tickers, 'TSLA')) AS tsla_co_tagged,
countIf(positionCaseInsensitive(title, 'nasdaq') > 0) AS nasdaq_titled
FROM global_markets.stocks_news
WHERE has(tickers, 'SPCX')
AND published_utc >= toDateTime('2026-06-12 04:00:00') AND published_utc < toDateTime('2026-07-08 04:00:00')One Form 4, then filing vacuum
Form 4 na di document wey corporate insider dey file within two business days after dem buy or sell company stock. Between di June 12 listing and July 7, di EDGAR filing index show 10 SPCX filings: 6 8-K current reports, one Form 3 (wey be initial ownership statement), 2 offering documents from listing week, and exactly 1 Form 4 — wey dem date June 17, di calendar day after di peak. Di index just dey record form type and date — na fact, no be verdict. Di louder fact na di silence after am: di last SPCX filing for di window get date June 26, and di final week and a half — di stretch wey actually break di IPO print — show 0 filings — na disclosure vacuum, no be wave of disclosed insider sales.
The exact SQL behind every number
SELECT
count() AS total_filings,
countIf(form_type = '4') AS form4_filings,
countIf(form_type = '3') AS form3_filings,
countIf(form_type = '8-K') AS eightk_filings,
countIf(form_type NOT IN ('4', '3', '8-K')) AS other_filings,
toMonth(maxIf(filing_date, form_type = '4')) AS form4_month,
toDayOfMonth(maxIf(filing_date, form_type = '4')) AS form4_dom,
toString(max(filing_date)) AS last_filing,
toMonth(max(filing_date)) AS last_filing_month,
toDayOfMonth(max(filing_date)) AS last_filing_dom,
countIf(filing_date > toDate('2026-06-26')) AS filings_after_jun26
FROM global_markets.stocks_sec_edgar_index
WHERE ticker = 'SPCX'
AND filing_date >= toDate('2026-06-12') AND filing_date <= toDate('2026-07-07')How fast IPO round trips dey normally happen?
SPCX take 16 sessions before e close below im first public print. Di panel wey dey below run di same measurement for four high-profile US IPOs wey just happen — CoreWeave, Klarna, Medline, and Cerebras: take each stock first regular-hours print, den count sessions until one regular-hours close land below am, over each stock first 26 calendar days (na SPCX own span through July 7). Klarna open 30% above im issue price and close below im first print for im debut session; Cerebras open 89.2% above issue and do di same; CoreWeave open 2.5% below issue and break for session 2. Medline no break at all inside im 16-session window. SPCX own hold na di longest among di four wey break — di round trip itself dey ordinary; na di 50.4% detour for middle make dis one stand out. Di H1 2026 IPO market review get di market-wide aftermarket numbers.
The exact SQL behind every number
WITH daily AS (
SELECT ticker,
toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
argMin(toFloat64(open), window_start) AS rth_open,
argMax(toFloat64(close), window_start) AS rth_close
FROM global_markets.delayed_stocks_minute_aggs
WHERE ((ticker = 'CRWV' AND window_start >= '2025-03-28 00:00:00' AND window_start < '2025-04-23 00:00:00')
OR (ticker = 'KLAR' AND window_start >= '2025-09-10 00:00:00' AND window_start < '2025-10-06 00:00:00')
OR (ticker = 'MDLN' AND window_start >= '2025-12-17 00:00:00' AND window_start < '2026-01-12 00:00:00')
OR (ticker = 'CBRS' AND window_start >= '2026-05-14 00:00:00' AND window_start < '2026-06-09 00:00:00')
OR (ticker = 'SPCX' AND window_start >= '2026-06-12 00:00:00' AND window_start < '2026-07-08 00:00:00'))
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
GROUP BY ticker, session_date
),
w AS (
SELECT ticker, session_date, rth_close,
row_number() OVER (PARTITION BY ticker ORDER BY session_date) AS rn,
first_value(rth_open) OVER (PARTITION BY ticker ORDER BY session_date) AS d1_open
FROM daily
),
agg AS (
SELECT ticker,
min(session_date) AS first_session,
any(d1_open) AS day1_open,
count() AS sessions_in_window,
countIf(rth_close < d1_open) AS closes_below,
minIf(toInt32(rn), rth_close < d1_open) AS break_rn
FROM w GROUP BY ticker
)
SELECT a.ticker AS ticker,
toString(a.first_session) AS listed,
round(l.issue_px, 2) AS issue_price,
round(a.day1_open, 2) AS first_rth_open,
round((a.day1_open / l.issue_px - 1) * 100, 1) AS open_vs_issue_pct,
round(abs((a.day1_open / l.issue_px - 1) * 100), 1) AS open_vs_issue_pct_abs,
a.sessions_in_window AS sessions_in_window,
a.closes_below AS closes_below_first_print,
if(a.closes_below > 0, toString(a.break_rn), 'never in window') AS first_break,
a.break_rn AS break_session_n
FROM agg a
INNER JOIN (
SELECT ticker, min(listing_date) AS ld, argMin(toFloat64(final_issue_price), listing_date) AS issue_px
FROM global_markets.stocks_ipos
WHERE ticker IN ('SPCX', 'CBRS', 'MDLN', 'CRWV', 'KLAR') AND listing_date >= '2025-01-01' AND ipo_status = 'history'
GROUP BY ticker
) l ON a.ticker = l.ticker
ORDER BY a.first_sessionFAQ
How far SpaceX stock fall from im peak?
SPCX reach im highest price of $225.64 for June 16, 2026 and e close for $149.58 for July 7, 2026 — na 33.7% drop from dat peak to di close.
SpaceX stock go below im IPO price?
Yes — e don happen two times. Regular-hours trades wey dey below di $150 IPO opening trade show face as early as di first day of trading (June 12 low na $149.34) and again for June 23 (session low na $147.11), and for July 7 di stock close below am, for $149.58. Di $135 issue price na different matter: SPCX never trade near am.
Na di whole market cause di SPCX drop?
No. For di same period, SPY rise 0.94%, and for July 7 itself, SPY show -0.34% from open to close while SPCX show -5.87%.
SpaceX insiders sell during di stock drop?
Di SEC filing index show exactly 1 SPCX Form 4 — wey be di insider-transaction form — between di listing and July 7, e get date of June 17, 2026, and 0 SPCX filings of any kind after June 26. Di index no dey show di direction of a transaction: di record show one insider filing near di peak and none during di worst part of di drop.
How long IPO stocks dey stay above dia first trading price?
E no dey long many times. Wen dem measure am di same way across four big 2025–26 listings, Klarna and Cerebras close below dia first regular-hours print for dia debut session and CoreWeave for session 2, while SPCX hold on until session 16 and Medline never break within im first 16 sessions.
Data notes
- Entity verification (reused symbol): di SPCX symbol before don dey for anoda company wey no relate, and im tape run till April 2026; nothing wey happen before di June 12, 2026 listing dey linked to SpaceX. Di scoreboard issue-price receipt na di
stocks_iposrecord (Space Exploration Technologies Corp., listed 2026-06-12); di first-month deep dive get all di verification receipts. - Di peak pass di lone-print cross-check: di $225.64 high print for two minutes straight (10:02–10:03 a.m. ET for di peak session) and di bars wey dey near am dey within like two dollars — na traced extreme, no be stray print.
- Quote panels no dey include one-sided, crossed, or locked records and dem dey count wetin dem drop for one
dropped_invalidcolumn inside di same panel. - July 7 OPTION quotes never land wen dem dey write —
cache_options_quotesget di longest ingest lag for di warehouse; di options-quote panel cover July 1–6 and dem label am like dat. Equity quotes and trades for July 7 complete. - Volumes na minute-bar sums for regular hours only; extended-hours prints (including di pre-market June 23 low wey dem mention for di first-month post) dey outside every panel for dis page.
- News counts na from one vendor feed, dem arrange am by New York calendar day; The Motley Fool write 71.1% of di tagged articles — di counts dey measure feed attention, no be importance.
- Di EDGAR index get form type, date, and URL only. Nothing here dey talk about di direction of di June 17 Form 4.
- Di round-trip comparison dey scan each stock first 26 calendar days — “never in window” mean exactly dat; each series start from im own listing date, so no pre-listing tape dey leak inside.
How We Do Am
- SPCX trade for 16 sessions from June 12 reach July 7, 2026 — we verify the June 19 (Juneteenth) and July 3 (Independence Day) closures from the bars we see, we no just assume. Timestamps dey for UTC and we convert am to New York time inside the queries; regular hours na 13:30–19:59 UTC (9:30 a.m.–4:00 p.m. ET for summer); “close” mean the last regular-session minute bar; prices come from the delayed consolidated view.
- We cast decimal columns to 64-bit floats before we do ratio arithmetic. We parse option expiry, type, and strike from the OCC ticker (positions 7/13/14 for this four-character root;
length(ticker) = 21pin the root exactly, so look-alike roots no fit enter). - Dis na pinned post: every query dey use explicit date literals and e dey reproduce these figures for any later date. Warehouse state as of July 9, 2026.
Dis post na the third one for the SPCX series, e follow the first-month deep dive and the Nasdaq-100 index-add trade. Every figure na stored query result — run the SQL yourself for Strasmore terminal.