SPCX: Bei ya hisa ya SpaceX kutoka kilele chake
Jua tofauti ya bei ya hisa ya SpaceX (SPCX) kutoka kilele chake cha Juni kumi na sita, mwaka wa elfu mbili ishirini na sita, ikijumuisha mtiririko wa chaguzi na taarifa za SEC.
SpaceX (SPCX)
Hisa za SpaceX (SPCX) zilifungwa kwa bei ya $158.98 mnamo Oct 2, 2026, ambayo ndiyo kikao cha hivi karibuni zaidi cha biashara kilichorekodiwa. Bei hiyo iko chini kwa 29.5% kutoka kilele cha $225.64 kilichofikiwa mnamo Jun 16, 2026. Hii ni pungufu ya $66.66 kwa kila hisa kutoka kwa bei ya juu zaidi, na inaiacha hisa hiyo ikiwa na tofauti ya 6% ikilinganishwa na bei yake ya kwanza ya $150 katika saa za kawaida za soko, na 17.8% ikilinganishwa na bei ya $135 ya toleo la awali wakati mkataba huo ulipouzwa. Katika kipindi hicho hicho, S&P 500 ETF (SPY) ilisonga kwa 3.91%. Kila takwimu hapa ni matokeo ya hoja iliyohifadhiwa (stored query) iliyopimwa hadi kikao cha hivi karibuni zaidi kilichorekodiwa na kusasishwa kwa kundi la kila wiki; panua paneli yoyote ili kuona SQL kamili.
Jinsi SPCX ilivyoshuka kutoka kilele chake
Ubao wa matokeo unaonyesha mzunguko mzima: bei ya kuanzia ya $135, biashara ya kwanza ya saa za kawaida $150 (ufunguzi wa saa tano na dakika arobaini na sita asubuhi mnamo Juni 12, 2026, uchambuzi wa kina wa mwezi wa kwanza unaelezea utaratibu wa siku ya kwanza ya kuorodheshwa), kilele cha $225.64 mnamo Jun 16, 2026, na bei ya mwisho ya kufunga ya $158.98. Kilele hicho kilirekodiwa katikati ya asubuhi ndani ya saa za kawaida za soko na kinaonekana kupitia pau za bei jirani (maelezo ya data). Kushuka huko kunapimwa kutoka kwa bei hiyo ya kilele hadi bei ya hivi karibuni ya kufunga ya saa za kawaida, kwa hivyo hubadilika kila kikao ambacho ghala huongeza.
| Bei ya toleo | Ufunguzi IPO | Bei ya kilele | Lebo ya kilele | Mwezi wa kilele | Siku ya kilele | Lebo ya hivi karibuni | Kufunga kwa hivi karibuni | Kushuka kutoka kilele (USD) | Kushuka kutoka kilele (%) | Kilele juu ya IPO (%) | Dhidi ya chapa ya kwanza (%) | Dhidi ya toleo (%) | SPY kipindi (%) | SPY minus SPCX (basis points) | SPCX tangu kilele (%) | SPY tangu kilele (%) | Pengo la kilele (basis points) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135 | 150 | 225.64 | Jun 16, 2026 | 6 | 16 | Oct 2, 2026 | 158.98 | 66.66 | 29.5 | 50.4 | 6 | 17.8 | 3.91 | -2.1 | -21.3 | 2.6 | 23.9 |
SQL halisi nyuma ya kila namba
WITH
spcx_sessions AS (
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS d,
argMax(toFloat64(close), window_start) AS c,
max(toFloat64(high)) AS hi
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
AND window_start >= '2026-06-12 00:00:00' AND window_start < now()
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY d
HAVING count() >= 150
),
latest_row AS (
SELECT max(d) AS latest_d, argMax(c, d) AS latest_c
FROM spcx_sessions
),
peak_row AS (
SELECT max(hi) AS peak_hi, argMax(d, (hi, -toInt32(d))) AS peak_d
FROM spcx_sessions
),
first_print 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(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
),
issue_row AS (
SELECT toFloat64(final_issue_price) AS issue_px
FROM global_markets.stocks_ipos
WHERE ticker = 'SPCX'
ORDER BY listing_date DESC LIMIT 1
),
spy_ret AS (
SELECT round((argMax(toFloat64(close), window_start) / argMin(toFloat64(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 < now()
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
),
spy_sessions AS (
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS d,
argMax(toFloat64(close), window_start) AS c
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= '2026-06-12 00:00:00' AND window_start < now()
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY d
HAVING count() >= 150
),
peak_window AS (
SELECT
anyIf(x.c, x.d = pk.peak_d) AS spcx_peak_close,
anyIf(y.c, y.d = pk.peak_d) AS spy_peak_close,
anyIf(y.c, y.d = lt.latest_d) AS spy_latest_close
FROM spcx_sessions x, spy_sessions y, peak_row pk, latest_row lt
WHERE x.d = y.d
)
SELECT
toString(round(ip.issue_px, 2)) AS issue_price,
fp.ipo_open_px AS ipo_open,
round(pk.peak_hi, 2) AS peak_price,
formatDateTime(pk.peak_d, '%b %e, %Y') AS peak_label,
toMonth(pk.peak_d) AS peak_month,
toDayOfMonth(pk.peak_d) AS peak_day,
formatDateTime(lt.latest_d, '%b %e, %Y') AS latest_label,
round(lt.latest_c, 2) AS latest_close,
round(pk.peak_hi - lt.latest_c, 2) AS drop_from_peak_usd,
round((pk.peak_hi - lt.latest_c) / pk.peak_hi * 100, 1) AS decline_from_peak_pct,
round((pk.peak_hi - fp.ipo_open_px) / fp.ipo_open_px * 100, 1) AS peak_above_ipo_pct,
round((lt.latest_c / fp.ipo_open_px - 1) * 100, 1) AS vs_first_print_pct,
round((lt.latest_c / ip.issue_px - 1) * 100, 1) AS vs_issue_pct,
sr.spy_pct AS spy_period_pct,
round(sr.spy_pct - (lt.latest_c / fp.ipo_open_px - 1) * 100, 1) AS spy_minus_spcx_pp,
round((lt.latest_c / pw.spcx_peak_close - 1) * 100, 1) AS spcx_since_peak_session_pct,
round((pw.spy_latest_close / pw.spy_peak_close - 1) * 100, 1) AS spy_since_peak_session_pct,
round((pw.spy_latest_close / pw.spy_peak_close - 1) * 100 - (lt.latest_c / pw.spcx_peak_close - 1) * 100, 1) AS peak_window_gap_pp
FROM peak_row pk, first_print fp, issue_row ip, latest_row lt, spy_ret sr, peak_window pwKikao kwa kikao: kushuka kwa thamani
SPCX imefanya vikao 78 kamili vya saa za kawaida tangu kuorodheshwa. Ilifungua kikao chake cha kwanza kwa $150, ikarekodi kilele cha $225.64 vikao viwili baadaye mnamo Jun 16, na kufunga kwa $158.98 mnamo Oct 2, ikiwa imepanda kutoka kiwango cha chini cha $149.34. Kiasi cha biashara kina mstari wake: milioni 495.6 ya hisa katika siku ya kwanza, milioni 274.5 katika kikao cha kilele, na milioni 110.9 katika kikao cha hivi karibuni. Kufungwa kwa kwanza kwa saa za kawaida chini ya bei ya kwanza ya umma kulikuja mnamo Jul 7, 2026, kikao cha 16 cha maisha ya hisa hiyo, na biashara ya kuongeza Nasdaq-100 kwenye fahirisi hupima rekodi ya kufunga kwa bei ya mwisho iliyotangulia tukio hilo.
| Tarehe ya kikao | Lebo ya kikao | Ufunguzi RTH | Kufunga RTH | Chini RTH | Juu RTH | Jazo (m) |
|---|---|---|---|---|---|---|
| 2026-06-12 | Jun 12 | 150 | 161.29 | 149.34 | 176.52 | 495.6 |
| 2026-06-15 | Jun 15 | 171.74 | 192.42 | 168.35 | 193 | 219.6 |
| 2026-06-16 | Jun 16 | 200.51 | 201.99 | 195.13 | 225.64 | 274.5 |
| 2026-06-17 | Jun 17 | 209.84 | 192.2 | 187.01 | 213.8 | 179.3 |
| 2026-06-18 | Jun 18 | 188.39 | 184.97 | 172.11 | 190 | 189.3 |
| 2026-06-22 | Jun 22 | 176.04 | 154.59 | 154 | 176.75 | 150.7 |
| 2026-06-23 | Jun 23 | 151.06 | 156.06 | 147.11 | 165.5 | 132.1 |
| 2026-06-24 | Jun 24 | 154.2 | 154.46 | 150.72 | 159.86 | 65 |
| 2026-06-25 | Jun 25 | 156.62 | 153.01 | 150 | 160.65 | 52.4 |
| 2026-06-26 | Jun 26 | 150.62 | 152.74 | 148.51 | 158.4 | 66.6 |
| 2026-06-29 | Jun 29 | 157.35 | 164 | 151.74 | 166.17 | 67.9 |
| 2026-06-30 | Jun 30 | 163.38 | 170.72 | 161.64 | 172.4 | 71.4 |
| 2026-07-01 | Jul 1 | 171.56 | 157.69 | 155 | 171.74 | 89.8 |
| 2026-07-02 | Jul 2 | 159.72 | 161.86 | 155.88 | 162.16 | 50.7 |
| 2026-07-06 | Jul 6 | 165.95 | 160.4 | 155.04 | 167.9 | 75.8 |
| 2026-07-07 | Jul 7 | 158.92 | 149.58 | 148.86 | 159.3 | 66.2 |
| 2026-07-08 | Jul 8 | 152.55 | 148.33 | 145.2 | 152.93 | 52.3 |
| 2026-07-09 | Jul 9 | 150.44 | 152.12 | 147.59 | 153.5 | 39.8 |
| 2026-07-10 | Jul 10 | 150.12 | 145.4 | 145.07 | 150.57 | 38.8 |
| 2026-07-13 | Jul 13 | 144.7 | 139.19 | 136.78 | 144.92 | 65.2 |
SQL halisi nyuma ya kila namba
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
formatDateTime(toDate(toTimeZone(window_start, 'America/New_York')), '%b %e') AS session_label,
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 < now()
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY session_date, session_label
HAVING count() >= 150
ORDER BY session_dateNdani ya kikao cha hivi karibuni
Jedwali hapa chini linafuatilia kikao kamili cha hivi karibuni kwa vipindi, kuanzia kengele ya ufunguzi hadi kufungwa kwa soko. Nusu saa ya kwanza ilirekodi miamala ya hisa milioni 22.46 na kuiacha hisa hiyo katika bei ya $156.14. Nusu saa ya mwisho ilirekodi miamala ya milioni 8.74 na kumalizia kwa $158.98, ikilinganishwa na bei ya chini kabisa ya kikao hicho ya $149.34.
| Muda ET | Bei ya kufunga | kikomo cha chini | Jazo (m) |
|---|---|---|---|
| 09:30 | 156.14 | 149.34 | 22.46 |
| 10:00 | 157.93 | 155.52 | 14.94 |
| 10:30 | 156.99 | 156.84 | 9.66 |
| 11:00 | 156.72 | 155.83 | 9.11 |
| 11:30 | 157.34 | 156.56 | 7.07 |
| 12:00 | 156.97 | 156.59 | 5.91 |
| 12:30 | 157.72 | 156.74 | 4.73 |
| 13:00 | 157.41 | 157.16 | 5.76 |
| 13:30 | 158.6 | 157.33 | 5.44 |
| 14:00 | 158.7 | 158.13 | 5.26 |
| 14:30 | 158.77 | 158.6 | 6.39 |
| 15:00 | 159.52 | 158.67 | 5.46 |
| 15:30 | 158.98 | 158.82 | 8.74 |
SQL halisi nyuma ya kila namba
WITH latest_session AS (
SELECT max(d) AS latest_d
FROM (
SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
AND window_start >= '2026-06-12 00:00:00' AND window_start < now()
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY d
HAVING count() >= 150
)
)
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, 2) 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 < now()
AND toDate(toTimeZone(window_start, 'America/New_York')) = (SELECT latest_d FROM latest_session)
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY et_time
ORDER BY et_timeBid-ask spread, wiki ya orodha na sasa
Gharama za miamala na ukwasi
Bid-ask spread, ambayo ni gharama inayolipwa na kila oda ya soko, ilikuwa wastani wa 10.74 basis points kutoka katikati ya bei katika siku ya kwanza ya usajili, 7.14 basis points katika kikao cha kilele, na 1.55 basis points mnamo Oct 2. Ukwasi katika bei bora ya soko (depth at the touch) ulikuwa wastani wa 9506 hisa katika siku ya kwanza dhidi ya 345 hisa katika kikao cha hivi karibuni kwenye jopo hili. Data ya bei huchunguzwa katika vipindi viwili, wiki nne tangu kusajiliwa na wiki tatu zilizopita, ili kulinganisha huko kubaki na gharama nafuu na kuweza kufanyika kila wiki.
| Tarehe ya kikao | Lebo ya kikao | wastani wa spread (bps) | wastani wa kina | zilizofutwa (batili) |
|---|---|---|---|---|
| 2026-06-12 | Jun 12 | 10.74 | 9506 | 24988 |
| 2026-06-15 | Jun 15 | 5.19 | 2367 | 8411 |
| 2026-06-16 | Jun 16 | 7.14 | 1478 | 7679 |
| 2026-06-17 | Jun 17 | 8 | 1079 | 4348 |
| 2026-06-18 | Jun 18 | 3.97 | 861 | 10114 |
| 2026-06-22 | Jun 22 | 2.53 | 5530 | 3898 |
| 2026-06-23 | Jun 23 | 3.44 | 4657 | 4050 |
| 2026-06-24 | Jun 24 | 6.55 | 241 | 1970 |
| 2026-06-25 | Jun 25 | 5.63 | 240 | 1335 |
| 2026-06-26 | Jun 26 | 4.34 | 825 | 2960 |
| 2026-06-29 | Jun 29 | 4.54 | 331 | 2280 |
| 2026-06-30 | Jun 30 | 4.41 | 320 | 1227 |
| 2026-07-01 | Jul 1 | 3.42 | 312 | 3839 |
| 2026-07-02 | Jul 2 | 4.5 | 319 | 1411 |
| 2026-07-06 | Jul 6 | 3.82 | 384 | 2449 |
| 2026-07-07 | Jul 7 | 4.18 | 3265 | 3394 |
| 2026-07-08 | Jul 8 | 4.81 | 456 | 2013 |
| 2026-07-09 | Jul 9 | 4.72 | 328 | 1485 |
| 2026-07-10 | Jul 10 | 3.6 | 685 | 3692 |
| 2026-09-14 | Sep 14 | 2.48 | 296 | 3946 |
SQL halisi nyuma ya kila namba
SELECT
toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session_date,
formatDateTime(toDate(toTimeZone(sip_timestamp, 'America/New_York')), '%b %e') AS session_label,
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 < now()
AND ((sip_timestamp >= '2026-06-12 00:00:00' AND sip_timestamp < '2026-07-11 00:00:00')
OR sip_timestamp >= now() - INTERVAL 21 DAY)
AND (toHour(toTimeZone(sip_timestamp, 'America/New_York')) * 60 + toMinute(toTimeZone(sip_timestamp, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY session_date, session_label
HAVING countIf(bid_price > 0 AND ask_price > bid_price) > 0
ORDER BY session_dateOptions: nini kinafanyika sokoni
Mnamo Oct 2, 2026, kikao cha hivi karibuni chenye prints za chaguzi za SPCX kwenye kumbukumbu, mkataba uliokuwa na shughuli nyingi zaidi ulikuwa 155-strike put unaoisha muda wake Oct 2, 2026, kwa mikataba 146368, ikifuatiwa na 160-strike call kwa 138493. SPCX huorodhesha muda wa kuisha wa kila wiki na kila mwezi badala ya kila siku, kwa hivyo vikao vingi havina mkataba wa 0DTE wa siku hiyo hiyo hata kidogo. Katika kipindi cha wiki tatu zilizopita, uwiano wa ujazo wa put/call ulipimwa kuwa 0.55 mnamo Sep 14 na 0.81 mnamo Oct 2. Ujazo wa biashara wa siku moja pekee hauwezi kubainisha strike price ambapo wenye chaguzi watapata faida ndogo zaidi wakati wa kuisha kwa mkataba, jambo ambalo ndilo max pain hupima, na hesabu hiyo husoma open interest katika mnyororo mzima badala ya prints za kikao kimoja.
| lebo | lebo ya kuisha | Lebo ya kikao | kiasi | thamani (m) |
|---|---|---|---|---|
| 155-strike put | Oct 2, 2026 | Oct 2, 2026 | 146368 | 0.04 |
| 160-strike call | Oct 2, 2026 | Oct 2, 2026 | 138493 | 0.03 |
| 157.5-strike put | Oct 2, 2026 | Oct 2, 2026 | 132629 | 0.09 |
| 157.5-strike call | Oct 2, 2026 | Oct 2, 2026 | 94869 | 0.09 |
| 155-strike call | Oct 2, 2026 | Oct 2, 2026 | 50278 | 0.12 |
| 160-strike call | Oct 9, 2026 | Oct 2, 2026 | 42413 | 0.12 |
| 162.5-strike call | Oct 2, 2026 | Oct 2, 2026 | 32984 | 0 |
| 160-strike put | Oct 2, 2026 | Oct 2, 2026 | 31581 | 0.05 |
| 160-strike call | Oct 16, 2026 | Oct 2, 2026 | 31176 | 0.13 |
| 150-strike put | Oct 2, 2026 | Oct 2, 2026 | 30814 | 0 |
SQL halisi nyuma ya kila namba
WITH latest_opt_session AS (
SELECT max(toDate(toTimeZone(sip_timestamp, 'America/New_York'))) AS d
FROM global_markets.options_trades
WHERE ticker LIKE 'O:SPCX%'
AND length(ticker) = 21
AND sip_timestamp >= now() - INTERVAL 8 DAY AND sip_timestamp < now()
)
SELECT
concat(toString(toUInt32OrZero(substring(ticker, 14, 8)) / 1000), '-strike ', if(substring(ticker, 13, 1) = 'C', 'call', 'put')) AS label,
formatDateTime(toDate(concat('20', substring(ticker, 7, 2), '-', substring(ticker, 9, 2), '-', substring(ticker, 11, 2))), '%b %e, %Y') AS expiry_label,
formatDateTime(max(toDate(toTimeZone(sip_timestamp, 'America/New_York'))), '%b %e, %Y') AS session_label,
sum(size) AS volume,
round(sum(toFloat64(size) * toFloat64(price)) / 1e6, 2) AS notional_m
FROM global_markets.options_trades
WHERE ticker LIKE 'O:SPCX%'
AND length(ticker) = 21
AND sip_timestamp >= now() - INTERVAL 8 DAY AND sip_timestamp < now()
AND toDate(toTimeZone(sip_timestamp, 'America/New_York')) = (SELECT d FROM latest_opt_session)
GROUP BY label, expiry_label
ORDER BY volume DESC
LIMIT 10| Tarehe ya kikao | Lebo ya kikao | uwiano wa P/C | kiasi cha call | kiasi cha put |
|---|---|---|---|---|
| 2026-09-14 | Sep 14 | 0.55 | 436852 | 241781 |
| 2026-09-15 | Sep 15 | 0.71 | 532335 | 378266 |
| 2026-09-16 | Sep 16 | 0.68 | 711485 | 484512 |
| 2026-09-17 | Sep 17 | 1.12 | 672551 | 750533 |
| 2026-09-18 | Sep 18 | 0.57 | 1027174 | 581079 |
| 2026-09-21 | Sep 21 | 0.65 | 493806 | 322763 |
| 2026-09-22 | Sep 22 | 0.92 | 323961 | 298206 |
| 2026-09-23 | Sep 23 | 0.85 | 349025 | 296794 |
| 2026-09-24 | Sep 24 | 0.78 | 410115 | 320922 |
| 2026-09-25 | Sep 25 | 0.66 | 472003 | 312292 |
| 2026-09-28 | Sep 28 | 0.64 | 367289 | 235809 |
| 2026-09-29 | Sep 29 | 0.52 | 475801 | 247958 |
| 2026-09-30 | Sep 30 | 0.62 | 438347 | 270427 |
| 2026-10-01 | Oct 1 | 0.66 | 455750 | 300312 |
| 2026-10-02 | Oct 2 | 0.81 | 938299 | 762034 |
SQL halisi nyuma ya kila namba
SELECT
toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session_date,
formatDateTime(toDate(toTimeZone(sip_timestamp, 'America/New_York')), '%b %e') AS session_label,
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 >= now() - INTERVAL 21 DAY AND sip_timestamp < now()
GROUP BY session_date, session_label
HAVING sumIf(size, substring(ticker, 13, 1) = 'C') > 0
ORDER BY session_dateNukuu za chaguzi (options) zinasalia kuwa na spread pana
Bei ya hisa na mnyororo wa chaguzi zake (option chain) hazina nukuu katika kiwango kimoja. Wastani wa spread iliyonukuliwa katika mikataba ya SPCX ilikuwa 1085.63 basis points mnamo Sep 28 na 1191.78 basis points mnamo Oct 2, ikilinganishwa na 1.55 basis points ya hisa hiyo katika kikao chake cha hivi karibuni. Wastani wa ukubwa wa nukuu bora ulikuwa mikataba 176 na mikataba 237 katika vikao hivyo viwili. Paneli hii imeachwa bila kukamilishwa kwa makusudi ili isilingane na paneli za hisa: cache_options_quotes ina ucheleweshaji mkubwa zaidi wa kupokea data (ingest lag) katika ghala letu, hivyo kikao chake cha hivi karibuni kiko nyuma kwa siku moja au mbili ikilinganishwa na mkondo wa soko (tape).
| Tarehe ya kikao | Lebo ya kikao | spread ya opt (bps) | wastani wa ukubwa | zilizofutwa (batili) | nukuu |
|---|---|---|---|---|---|
| 2026-09-28 | Sep 28 | 1085.63 | 176 | 5674 | 87096587 |
| 2026-09-29 | Sep 29 | 1092.22 | 189 | 5051 | 89869721 |
| 2026-09-30 | Sep 30 | 1073.98 | 166 | 3614 | 88081039 |
| 2026-10-01 | Oct 1 | 1143.86 | 171 | 4435 | 84085472 |
| 2026-10-02 | Oct 2 | 1191.78 | 237 | 9404 | 114550454 |
SQL halisi nyuma ya kila namba
SELECT
toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session_date,
formatDateTime(toDate(toTimeZone(sip_timestamp, 'America/New_York')), '%b %e') AS session_label,
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 >= now() - INTERVAL 8 DAY AND sip_timestamp < now()
AND (toHour(toTimeZone(sip_timestamp, 'America/New_York')) * 60 + toMinute(toTimeZone(sip_timestamp, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY session_date, session_label
HAVING countIf(bid_price > 0 AND ask_price > bid_price) > 0
ORDER BY session_dateSPCX dhidi ya soko
Kushuka huku kunapimwa kuanzia kileleni, kwa hivyo ulinganisho wa soko unaanzia hapo pia. Kuanzia kufungwa kwa kikao cha kilele cha Jun 16, 2026 hadi kufungwa kwa hivi karibuni, SPCX ilisonga kwa -21.3% wakati SPY ilisonga kwa 2.6%, pengo la asilimia 23.9. Iikipimwa tangu kuorodheshwa, SPY ilisonga kwa 3.91% na SPCX kwa 6% tangu kuchapishwa kwa mara ya kwanza hadharani, kipindi ambacho kinajumuisha kupanda hadi kileleni na kushuka kulikofuata. Paneli iliyo hapa chini inaonyesha kipimo hicho hicho kikao kwa kikao: mnamo Oct 2 SPY ilichapisha -0.12% kuanzia ufunguzi hadi kufungwa na SPCX 6.29%.
| Tarehe ya kikao | Lebo ya kikao | SPY (%) | spcx (%) |
|---|---|---|---|
| 2026-09-14 | Sep 14 | 0.23 | 0.55 |
| 2026-09-15 | Sep 15 | -0.36 | -3.31 |
| 2026-09-16 | Sep 16 | -0.71 | 4.16 |
| 2026-09-17 | Sep 17 | -0.07 | 0.64 |
| 2026-09-18 | Sep 18 | 0.04 | -1.18 |
| 2026-09-21 | Sep 21 | 0.95 | -1.87 |
| 2026-09-22 | Sep 22 | -0.09 | 2.01 |
| 2026-09-23 | Sep 23 | -0.65 | -3.21 |
| 2026-09-24 | Sep 24 | 0.42 | -0.09 |
| 2026-09-25 | Sep 25 | 0.33 | 0.24 |
| 2026-09-28 | Sep 28 | -0.36 | -2.02 |
| 2026-09-29 | Sep 29 | -0.34 | 1.77 |
| 2026-09-30 | Sep 30 | -0.52 | 1.52 |
| 2026-10-01 | Oct 1 | -0.04 | -1.63 |
| 2026-10-02 | Oct 2 | -0.12 | 6.29 |
SQL halisi nyuma ya kila namba
SELECT
a.session_date AS session_date,
a.session_label AS session_label,
round(a.spy_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,
formatDateTime(toDate(toTimeZone(window_start, 'America/New_York')), '%b %e') AS session_label,
(argMax(toFloat64(close), window_start) / argMin(toFloat64(open), window_start) - 1) * 100 AS spy_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= now() - INTERVAL 21 DAY AND window_start < now()
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY session_date, session_label
HAVING count() >= 150
) a
INNER JOIN (
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
(argMax(toFloat64(close), window_start) / argMin(toFloat64(open), window_start) - 1) * 100 AS spcx_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
AND window_start >= '2026-06-12 00:00:00'
AND window_start >= now() - INTERVAL 21 DAY AND window_start < now()
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY session_date
HAVING count() >= 150
) b ON a.session_date = b.session_date
ORDER BY a.session_dateKinachoelezwa na mtiririko wa habari
Vichwa vya habari vinaweza kuhesabika. Mtiririko wa habari kutoka kwa mtoa huduma umebeba makala 754 zenye tag ya SPCX kuanzia siku ya kuanza kuorodheshwa hadi usomaji wa hivi karibuni, kutoka kwa wachapishaji 5, na The Motley Fool pekee ameandika 82.9% ya makala hizo. Siku yenye shughuli nyingi zaidi ya uandishi ilikuwa siku ya kuorodheshwa yenyewe, ikiwa na makala 42 mnamo Juni kumi na mbili, ikilinganishwa na 31 katika kikao cha kilele cha Juni kumi na sita, na hakuna siku yoyote iliyofuata iliyokaribia idadi ya makala za siku ya IPO kwa tofauti ya makala 13. Wiki ya kuorodheshwa ilikuwa na wastani wa makala 25.7 kwa siku. Wiki iliyopita ina wastani wa 3.3. Makala 145 zina tag ya pamoja ya Tesla; 33 zina neno "Nasdaq" kwenye kichwa cha habari. Hakuna siku kuu ya vichwa vya habari inayoonekana popote katika kipindi hiki cha kupungua.
| jumla ya makala | wachapishaji | mchapishaji mkuu | sehemu ya mchapishaji mkuu (%) | mwezi wenye shughuli nyingi | siku ya mwezi yenye shughuli nyingi | makala za siku ya IPO | makala za kilele cha kikao | kiwango cha juu cha kila siku baada ya kilele | siku ya IPO kutoa kiwango cha juu baada ya kilele | wastani wa wiki ya kwanza | wastani wa siku 7 zilizopita | TSLA co iliyotiwa alama | NASDAQ iliyopewa kichwa |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 754 | 5 | The Motley Fool | 82.9 | 6 | 12 | 42 | 31 | 29 | 13 | 25.7 | 3.3 | 145 | 33 |
SQL halisi nyuma ya kila namba
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 < now()
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 < now()
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,
(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(sum(n) / 7, 1) FROM daily_counts WHERE d <= toDate('2026-06-18')) AS first_week_avg,
(SELECT round(sum(n) / 7, 1) FROM daily_counts WHERE d > today() - 7) AS last7_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 < now()Uwasilishaji wa taarifa za ndani na rekodi ya EDGAR
Form 4 ni hati ambayo mtu wa ndani wa kampuni huiwasilisha ndani ya siku mbili za kazi baada ya kununua au kuuza hisa za kampuni. Kuanzia orodha ya tarehe 12 Juni hadi usomaji wa hivi karibuni, faharasa ya uwasilishaji ya EDGAR inaonyesha uwasilishaji wa 23 SPCX: 8 ripoti za sasa za 8-K, 1 taarifa ya awali ya umiliki ya Form 3, 3 Form 4, na 11 hati nyinginezo. Form 4 ya kwanza ina tarehe ya Jun 17, 2026, siku moja ya kalenda baada ya kilele. Faharasa hurekodi aina ya fomu na tarehe, bila kutoa maelezo yoyote kuhusu mwelekeo au ukubwa wa muamala. Tangu kilele hicho, rekodi ina uwasilishaji wa 19 wa aina yoyote, ule wa hivi karibuni ukiwa na tarehe ya Sep 30, 2026, siku 5 kabla ya usomaji huu.
| jumla ya faili | faili za Form 4 | faili za Form 3 | faili za 8-K | faili nyingine | lebo ya kwanza ya Form 4 | mwezi wa kwanza wa Form 4 | siku ya kwanza ya mwezi ya Form 4 | lebo ya faili ya mwisho | Siku tangu faili la mwisho | Faili tangu kilele |
|---|---|---|---|---|---|---|---|---|---|---|
| 23 | 3 | 1 | 8 | 11 | Jun 17, 2026 | 6 | 17 | Sep 30, 2026 | 5 | 19 |
SQL halisi nyuma ya kila namba
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,
formatDateTime(minIf(filing_date, form_type = '4'), '%b %e, %Y') AS first_form4_label,
toMonth(minIf(filing_date, form_type = '4')) AS first_form4_month,
toDayOfMonth(minIf(filing_date, form_type = '4')) AS first_form4_dom,
formatDateTime(max(filing_date), '%b %e, %Y') AS last_filing_label,
toInt32(today() - max(filing_date)) AS days_since_last_filing,
countIf(filing_date > toDate('2026-06-16')) AS filings_since_peak
FROM global_markets.stocks_sec_edgar_index
WHERE ticker = 'SPCX'
AND filing_date >= toDate('2026-06-12') AND filing_date <= today()Je, mzunguko wa IPO hukamilika kwa kasi kiasi gani?
SPCX ilichukua vipindi 16 kufunga chini ya bei yake ya kwanza ya hadharani. Jopo hapa chini linafanya kipimo hicho hicho kwa IPO nne za hivi karibuni za Marekani zenye hadhi ya juu, CoreWeave, Klarna, Medline, na Cerebras: chukua bei ya kwanza ya hisa katika saa za kawaida za soko, kisha uhesabu vipindi hadi kufungwa kwa saa za kawaida kutokee chini ya bei hiyo, ndani ya siku ishirini na sita za kwanza za kalenda kwa kila hisa. Klarna ilifunguka 30% juu ya bei yake ya toleo na kufunga chini ya bei yake ya kwanza katika kipindi chake cha kwanza; Cerebras ilifunguka 89.2% juu ya bei ya toleo na kufanya vivyo hivyo; CoreWeave ilifunguka 2.5% chini ya bei ya toleo na kuvunja bei hiyo katika kipindi cha 2. Medline haikuvunja kamwe ndani ya dirisha lake la vipindi 16. Muda wa SPCX kushikilia ulikuwa mrefu zaidi kati ya zile nne zilizovunja, na mchepuko wa 50.4% katikati uliifanya hii kuwa ya kipekee. Mapitio ya soko la IPO ya H1 2026 yana takwimu za soko zima la baada ya IPO.
| ticker | imeorodheshwa | Bei ya toleo | ufunguzi wa kwanza wa RTH | ufunguzi dhidi ya issue (%) | ufunguzi dhidi ya issue (abs %) | vikao katika kipindi | funga chini ya bei ya kwanza | break ya kwanza | lebo ya break | kikao cha break n |
|---|---|---|---|---|---|---|---|---|---|---|
| CRWV | 2025-03-28 | 40 | 39 | -2.5 | 2.5 | 17 | 3 | 2 | Mar 31, 2025 | 2 |
| KLAR | 2025-09-10 | 40 | 52 | 30 | 30 | 18 | 18 | 1 | Sep 10, 2025 | 1 |
| MDLN | 2025-12-17 | 29 | 35 | 20.7 | 20.7 | 16 | 0 | never in window | never in window | 0 |
| CBRS | 2026-05-14 | 185 | 350 | 89.2 | 89.2 | 17 | 17 | 1 | May 14, 2026 | 1 |
| SPCX | 2026-06-12 | 135 | 150 | 11.1 | 11.1 | 16 | 1 | 16 | Jul 7, 2026 | 16 |
SQL halisi nyuma ya kila namba
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,
minIf(session_date, rth_close < d1_open) AS break_d
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,
if(a.closes_below > 0, formatDateTime(a.break_d, '%b %e, %Y'), 'never in window') AS break_label,
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_sessionMaswali Yanayoulizwa Mara Kwa Mara
Hisa za SpaceX zimeshuka kwa kiasi gani kutoka kilele chake?
SPCX ilifikia kilele cha $225.64 mnamo Jun 16, 2026 na kufunga kwa $158.98 mnamo Oct 2, 2026, ikiwa ni kushuka kwa 29.5% kutoka bei ya juu kabisa hadi kufungwa huko, au $66.66 kwa kila hisa. Ukurasa huu hupima upya pengo hilo hadi kikao cha mwisho cha biashara kila wiki.
Je, SPCX inafanya biashara chini ya bei yake ya IPO?
Ikipimwa hadi kufungwa kwa soko la hivi karibuni, SPCX iko 6% dhidi ya bei ya kwanza ya $150 katika saa za kawaida za biashara na 17.8% dhidi ya bei ya toleo ya $135 ambayo mkataba uliuzwa. Kufungwa kwa kwanza kwa saa za kawaida chini ya bei ya kwanza kulifanyika mnamo Jul 7, 2026. Bei za intraday chini ya mstari huo zilitokea mapema zaidi, katika kikao cha kwanza kabisa (chini ya Juni 12 $149.34) na tena mnamo Jun 23 (chini ya kikao $147.11).
Je, kushuka kwa SPCX kulikuwa ni hatua ya soko zima?
Hapana. Kuanzia kufungwa kwa kikao cha kilele cha Jun 16, 2026 hadi kufungwa kwa hivi karibuni, SPCX ilisonga kwa -21.3% wakati SPY ilisonga kwa 2.6%, ikiwa ni pengo la 23.9 percentage points. Kikao kwa kikao, mnamo Oct 2 SPY ilichapisha -0.12% kutoka ufunguzi hadi kufungwa na SPCX 6.29%.
Je, watu wa ndani wa SpaceX waliuza hisa wakati wa kushuka kwa bei?
Faharisi ya faili za SEC inaonyesha 3 faili za Form 4 za SPCX, fomu ya miamala ya watu wa ndani, tangu kuorodheshwa kwa Juni 12, ambapo ya kwanza ilikuwa na tarehe Jun 17, 2026. Faharisi haionyeshi mwelekeo wa muamala, kwa hivyo hakuna chochote hapa kinachosema faili hiyo ilikuwa ya nini. Tangu kilele hicho, rekodi inaonyesha 19 faili za SPCX za aina yoyote.
Hisa za IPO hukaa kwa muda gani juu ya bei yao ya kwanza ya biashara?
Mara nyingi si kwa muda mrefu. Ikipimwa kwa njia sawa katika orodha nne mashuhuri za 2025–26, Klarna na Cerebras zilifunga chini ya bei yao ya kwanza ya saa za kawaida katika kikao chao cha kwanza na CoreWeave katika kikao cha 2, wakati SPCX ilishikilia hadi kikao cha 16 na Medline haikuwa imevunja ndani ya vikao vyake vya kwanza 16.
Vidokezo vya data
- Uhakiki wa taasisi (alama iliyotumika tena): Alama ya SPCX hapo awali ilitambulisha kampuni isiyohusika ambayo mkanda wake wa biashara uliendelea hadi Aprili 2026; hakuna chochote kabla ya tarehe ya kuanza kuorodheshwa ya Juni 12, 2026 kinachohusishwa na SpaceX, na kila paneli kwenye ukurasa huu imewekewa kikomo cha chini kuanzia tarehe hiyo. Risiti ya bei ya toleo kwenye ubao wa matokeo inasoma rekodi ya
stocks_ipos(Space Exploration Technologies Corp., iliyoorodheshwa 2026-06-12); uchambuzi wa kina wa mwezi wa kwanza una risiti kamili za uhakiki. - "Kikao kamili cha hivi karibuni" inamaanisha kikao cha hivi karibuni cha New York chenye angalau dakika 150 za biashara ya kawaida. Hii inakubali kikao cha nusu siku kilichopangwa na kuondoa siku iliyoingizwa kwa sehemu kwenye takwimu za hali ya sasa. Ghala la data hufanya kazi takribani kikao kimoja nyuma ya mkanda wa moja kwa moja, kwa hivyo usomaji wa hivi karibuni kwa kawaida ni wa kikao kilichotangulia.
- Kilele kilipita ukaguzi wa printa moja: bei ya juu kabisa ilichapishwa katika dakika mbili mfululizo (10:02–10:03 asubuhi ET katika kikao cha kilele) huku baa za jirani zikiwa ndani ya takriban dola mbili, ikiwa ni kiwango cha juu kilichofuatiliwa badala ya printa ya bahati mbaya. Bei mpya ya juu ingevunja kikomo cha tarehe ya kilele cha ukurasa huu na kuishikilia kwa ajili ya mapitio.
- Paneli za bei hazijumuishi rekodi za upande mmoja, zilizovuka, au zilizofungwa na huhesabu kile zinachokiacha kwenye safu ya
dropped_invalidya paneli hiyo hiyo. Paneli ya bei ya hisa huchukua sampuli za madirisha mawili (wiki nne tangu kuorodheshwa, na tatu za mwisho), kwa hivyo gharama yake ya skanning inabaki thabiti kadiri ukurasa unavyozeeka. - Kiasi ni jumla ya dakika za biashara wakati wa saa za kawaida pekee; printa za saa za ziada, ikiwa ni pamoja na bei ya chini ya kabla ya soko ya Juni 23 iliyotajwa katika chapisho la mwezi wa kwanza, ziko nje ya kila paneli hapa.
- Idadi ya habari ni kutoka kwa mlisho wa muuzaji mmoja, iliyopangwa kwa siku ya kalenda ya New York; The Motley Fool aliandika 82.9% ya makala zilizotambulishwa, kwa hivyo idadi hiyo hupima umakini wa mlisho, si umuhimu.
- Faharisi ya EDGAR hubeba aina ya fomu, tarehe, na URL pekee. Hakuna chochote hapa kinachodai mwelekeo wa Form 4 yoyote.
- Ulinganisho wa safari ya kwenda na kurudi huchanganua siku ishirini na sita za kwanza za kalenda ya kila hisa na imefungwa kwenye tarehe maalum, kwa hivyo inajizalisha yenyewe katika tarehe yoyote ya baadaye; "haipo kamwe kwenye dirisha" inamaanisha hivyo hasa.
Mbinu
- Hii ni chapisho linalosasishwa mara kwa mara (ROLLING). Kila paneli ya hali ya sasa hufungwa wakati wa utekelezaji na kupimwa upya katika kundi la kila wiki, na ukurasa huu hubeba muhuri wa "Data kufikia". Paneli ya kulinganisha ya kihistoria hutumia tarehe maalum na kuzalisha takwimu zilezile wakati wowote baadaye.
- Muhuri wa muda (timestamps) huhifadhiwa katika UTC na kubadilishwa kuwa saa za New York ndani ya hoja za SQL; kikao cha kawaida huchaguliwa kulingana na saa za ET (bodi za dakika 9:30 asubuhi hadi 3:59 usiku), hivyo dirisha hubaki sahihi hata wakati wa mabadiliko ya saa za kuokoa mchana. "Close" inamaanisha bodi ya dakika ya mwisho ya kikao cha kawaida; bei hutoka kwenye mtazamo uliounganishwa wa kuchelewa (delayed consolidated view).
- Safu wima za desimali hubadilishwa kuwa 64-bit floats kabla ya kufanya hesabu za uwiano. Muda wa kuisha kwa option, aina, na strike price huchambuliwa kutoka kwa ticker ya OCC (nafasi 7/13/14 kwa mzizi huu wa herufi nne;
length(ticker) = 21hufunga mzizi kikamilifu, hivyo mizizi inayofanana haiwezi kuingia).
Chapisho hili ni la tatu katika mfululizo wa SPCX, likifuata uchambuzi wa kina wa mwezi wa kwanza na biashara ya kuongeza hisa kwenye Nasdaq-100. Kila takwimu ni matokeo ya hoja ya SQL iliyohifadhiwa, endesha SQL mwenyewe kwenye terminal ya Strasmore.