Wiki ya mwisho ya Juni ilikuwa wiki ya vikao vinne: soko lilifanya biashara Jumatatu Juni 29 hadi Alhamisi Julai 2, kisha likafungwa Ijumaa Julai 3 kwa Siku ya Uhuru — Julai 4 ilianguka Jumamosi, kwa hivyo sikukuu ilizingatiwa Ijumaa iliyotangulia. Mapokezi ya kufungwa huko, na kwa kila kitu kingine hapa, yamo kwenye paneli. Kipimo cha ukweli kinachojulikana zaidi cha wiki hii kiko kwenye jedwali la kiasi: mtengenezaji mmoja wa chip za kumbukumbu aliweka $190.2 bilioni kwenye mkanda kwa siku nne — mara moja na nusu zaidi ya SPY yenyewe. Kila nambari kwenye ukurasa huu ni matokeo ya swala lililohifadhiwa; panua paneli yoyote kwa SQL kamili.
Wiki kwenye ubao
Je, tepu ilipona kushuka kwa wiki iliyopita, au iliongeza hasara? Ubao wa matokeo unasema imepona: paneli hii inakokotoa mabadiliko ya kila ETF ya index kwa wiki hadi wiki na, kwa kulinganisha, wiki iliyotangulia — pande zote mbili zikiwa safi kutoka kwa swala moja.
SQL halisi nyuma ya kila namba
SELECT ticker,
round(argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-26') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS prior_friday_close,
round(argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-06-29') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS week_close,
round((argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-06-29') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
/ argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-26') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) - 1) * 100, 1) AS week_change_pct,
round((argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-26') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
/ argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-18') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) - 1) * 100, 1) AS prior_week_change_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('SPY', 'QQQ', 'DIA', 'IWM')
AND window_start >= toDateTime('2026-06-15 00:00:00') AND window_start < toDateTime('2026-07-03 00:00:00')
GROUP BY ticker
ORDER BY tickerSPY ilimaliza wiki kwa $744.8, ikiwa juu kwa 2.2% kutoka Ijumaa iliyopita — ikifuata wiki ya -2.3% iliyotangulia. QQQ ilipanda kwa 1% baada ya wiki ya -4.6% iliyotangulia, DIA ilipata faida ya 2%, na IWM ilifunga kwa 297.53 — 0% kwa wiki, ikibaki tuli wakati index za kampuni kubwa zilipanda.
Wiki dhidi ya mwaka uliopita
SQL halisi nyuma ya kila namba
SELECT round(anyIf(ret, wk = toDate('2026-06-29')), 2) AS week_2026_pct,
arrayCount(x -> x > anyIf(ret, wk = toDate('2026-06-29')), groupArrayIf(ret, wk != toDate('2026-06-29'))) + 1 AS rank_best,
count() AS weeks_compared,
toString(min(wk)) AS first_week,
anyIf(sessions, wk = toDate('2026-06-29')) AS sessions_this_week
FROM (
SELECT toStartOfWeek(toDate(toTimeZone(window_start, 'America/New_York')), 1) AS wk,
uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) AS sessions,
(argMax(toFloat64(close), window_start) / argMin(toFloat64(open), window_start) - 1) * 100 AS ret
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= toDateTime('2025-06-29 00:00:00')
AND window_start < toDateTime('2026-07-03 00:00:00')
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY wk
HAVING sessions >= 3
)Ikizingatiwa kuanzia ufunguzi hadi kufunga ndani ya wiki — kipindi cha kwanza cha saa za kawaida za Jumatatu hadi cha mwisho cha Alhamisi, lenye mtazamo tofauti kidogo kutoka kwa ubao wa kufunga wa Ijumaa ulio hapo juu, na hati inasema hivyo — wiki ya SPY inashika nafasi 14 kati ya wiki 53 zilizopita (nafasi 1 = bora zaidi): katikati ya kundi, katika mwaka uliopita uliojumuisha mauzo makubwa na pia ufufuaji. Wiki zilizo na vikao chini ya vitatu hazijumuishwi na kizuizi cha vikao; hii ilikuwa na 4. Muktadha wa kihistoria hupima kwa kipindi cha dirisha — muhtasari wa mwezi, robo, na nusu mwaka hulinganisha vipindi vyao dhidi ya kila mwaka wa rekodi ya dakika.
Vikao vinne, kisha likizo
Wiki ya biashara ya siku tano ni dhana, siyo ukweli — wiki hii ilikuwa na vikao vinne. Paneli ya upokeaji inakagua kufungwa kutoka kwenye mkanda wenyewe: hakuna baa za SPY zilizochapishwa Julai 3 dhidi ya baa 1560 za kikao cha kawaida katika siku nne za biashara.
SQL halisi nyuma ya kila namba
SELECT
(SELECT uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-06-29 00:00:00') AND window_start < toDateTime('2026-07-03 00:00:00')) AS sessions_in_week,
(SELECT countIf((toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-06-29 00:00:00') AND window_start < toDateTime('2026-07-03 00:00:00')) AS regular_bars_week,
(SELECT count() FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-07-03 00:00:00') AND window_start < toDateTime('2026-07-04 00:00:00')) AS jul3_spy_barsSQL halisi nyuma ya kila namba
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 spy_close,
round((argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / any(prev) - 1) * 100, 1) AS change_pct,
round(toFloat64(sum(volume)) / 1e6, 1) AS shares_m
FROM global_markets.delayed_stocks_minute_aggs
INNER JOIN (
SELECT d, lagInFrame(c) OVER (ORDER BY d ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev
FROM (
SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d, argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) AS c
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-06-26 00:00:00') AND window_start < toDateTime('2026-07-03 00:00:00')
GROUP BY d
)
) AS p ON toDate(toTimeZone(window_start, 'America/New_York')) = p.d
WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-06-29 00:00:00') AND window_start < toDateTime('2026-07-03 00:00:00')
GROUP BY et_date
ORDER BY et_dateVikao vyote vinne vilifuata ratiba kamili ya kawaida — baa 1560 za kawaida zinajumuisha vikao vinne vya dakika 390 haswa. Wiki ilifungwa kwa kiasi kikubwa bila mabadiliko (-0.1%) kwenye 2026-07-02, ikielekea likizo — faida za wiki zilipatikana katika vikao vyake vitatu vya kwanza.
Upana: ni kiasi gani cha soko kilipanda
Fahirisi moja kupanda kunaweza kuficha soko kushuka. Paneli hii inahesabu kila ticker iliyo na bei ya kufunga pande zote mbili za wiki, huku seti iliyotengwa ikionyeshwa wazi badala ya kuachwa kimya.
SQL halisi nyuma ya kila namba
SELECT
countIf(chg > 0 AND NOT dropped) AS advancers,
countIf(chg < 0 AND NOT dropped) AS decliners,
countIf(chg = 0 AND NOT dropped) AS unchanged,
countIf(dropped) AS dropped_by_liquidity_filter,
count() AS tickers_with_both_closes
FROM (
SELECT ticker,
argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-06-29') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
- argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-26') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) AS chg,
sumIf(toFloat64(close) * toFloat64(volume), toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-06-29')) < 1e6 AS dropped
FROM global_markets.delayed_stocks_minute_aggs
WHERE window_start >= toDateTime('2026-06-26 00:00:00') AND window_start < toDateTime('2026-07-03 00:00:00')
GROUP BY ticker
HAVING countIf(toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-26') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) > 0
AND countIf(toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-06-29') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) > 0
)5047 ticker zilipanda wiki hii dhidi ya 3525 zilizoshuka (39 hazikubadilika) — mwendo wa kupanda ulikuwa mpana, si tu kwa kiwango cha fahirisi. Kichujio cha ukwasi kilitenga 3163 ticker zilizofanya biashara chini ya $1M wiki nzima; zinahesabiwa hapa, hazijafichwa.
Viongozi wa tape: hisa moja juu ya ETFs
SQL halisi nyuma ya kila namba
SELECT ticker,
round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 1) AS dollar_bn,
round(100 * sum(toFloat64(close) * toFloat64(volume)) / max(sum(toFloat64(close) * toFloat64(volume))) OVER (), 1) AS pct_of_leader
FROM global_markets.delayed_stocks_minute_aggs
WHERE window_start >= toDateTime('2026-06-29 00:00:00') AND window_start < toDateTime('2026-07-03 00:00:00')
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
AND ticker NOT IN ('SPCX')
GROUP BY ticker
ORDER BY dollar_bn DESC
LIMIT 8MU iliongoza tape nzima kwa $190.2 bilioni katika kiasi cha dola za saa za kawaida — SPY, ETF kubwa zaidi, ilifanya 66.4% ya hiyo. Kampuni moja ikifanya biashara zaidi ya index fund ya msingi ya soko kwa wiki nzima ni ukweli uliopimwa unaojitokeza wiki hii; ukurasa huu unaripoti ukubwa wa mtiririko, si sababu yake. Msingi: Juni 29–Julai 2 saa za kawaida; orodha moja ya Juni iliyotumika tena imetengwa hadi uthibitishaji wa chombo ukamilike — risiti zake ziko katika uchambuzi wake wa kina.
Likizo lilihamisha mwisho wa wiki
Je, mwisho wa wiki ya Ijumaa unaenda wapi Ijumaa ikiwa imefungwa? Kanda ya chaguzi inajibu moja kwa moja: paneli hii inachambua tarehe ya mwisho kutoka kwa kila mkataba uliouzwa wakati wa wiki na kuyapanga kwa viwango.
SQL halisi nyuma ya kila namba
SELECT concat('20', substring(expiry_raw, 1, 2), '-', substring(expiry_raw, 3, 2), '-', substring(expiry_raw, 5, 2)) AS expiry,
round(sum(size) / 1e6, 1) AS contracts_m,
round(100 * sum(size) / max(sum(size)) OVER (), 1) AS pct_of_biggest
FROM (
SELECT substring(ticker, length(ticker) - 14, 6) AS expiry_raw, size
FROM global_markets.options_trades
WHERE sip_timestamp >= toDateTime64('2026-06-29 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-03 00:00:00', 9)
)
GROUP BY expiry
ORDER BY contracts_m DESC
LIMIT 6Mwisho wa wiki ulio na shughuli nyingi zaidi ulikuwa 2026-07-02 — Alhamisi — kwa mikataba 74.1 milioni, 42.2% mbele ya tarehe iliyofuata. Kwa kuwa Julai 3 ilikuwa imefungwa, "Ijumaa" ya wiki hii ilimalizika Alhamisi badala yake; mwisho wa wiki wa kila siku wa Jumatatu hadi Jumatano na mwisho wa mwezi wa Julai 17 unajaza jedwali. Tarehe za mwisho zinachambuliwa tena kutoka kwa ishara ya OCC ya kila mkataba (safu ya mwisho ya kanda yenyewe haina uhakika); mbinu za wiki za mwisho kama hii ziko katika maelezo ya likizo.
Viwango: miaka 10 ilipanda
SQL halisi nyuma ya kila namba
SELECT toString(date) AS d,
round(yield_10_year, 2) AS y10,
round(yield_2_year, 2) AS y2,
round((yield_10_year - yield_2_year) * 100, 0) AS spread_2s10s_bp
FROM global_markets.treasury_yields
WHERE date >= toDate('2026-06-26') AND date <= toDate('2026-07-02')
ORDER BY dateMiaka 10 iliongezeka kutoka 4.38% Ijumaa iliyopita hadi 4.48% kufikia 2026-07-01, huku upanuzi wa 2s10s ukibaki karibu na pointi za msingi 31. Ufafanuzi mmoja: chapisho la mavuno la Julai 2 halikuwa limeingizwa bado wakati ukurasa huu ulipozalishwa (safu 4 hadi Julai 1) — paneli itabeba habari hiyo kwenye uundaji upya unaofuata.
Kalenda: robo ya mwaka inaisha, siku ya kuwasilisha faili inakosekana
SQL halisi nyuma ya kila namba
SELECT
(SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= toDate('2026-06-29') AND ex_dividend_date <= toDate('2026-07-02')) AS ex_div_events,
(SELECT count() FROM global_markets.stocks_splits WHERE execution_date >= toDate('2026-06-29') AND execution_date <= toDate('2026-07-02')) AS splits,
(SELECT count() FROM global_markets.stocks_ipos WHERE listing_date >= toDate('2026-06-29') AND listing_date <= toDate('2026-07-02')) AS ipos,
(SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-06-29')) AS filings_jun29,
(SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-06-30')) AS filings_jun30,
(SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-07-01')) AS filings_jul1,
(SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-07-02')) AS filings_jul2,
(SELECT count() FROM global_markets.stocks_news WHERE published_utc >= toDateTime('2026-06-29 00:00:00') AND published_utc < toDateTime('2026-07-03 00:00:00')) AS news_articlesWiki hii ilibeba matukio 2217 ya kukosa mgao wa faida, migawanyiko 48, na orodha mpya 7 kwenye mzunguko wa mwisho wa robo. Safu wima za uwasilishaji zina ugunduzi wa ubora wa data wa wiki hii: faharasa ya uwasilishaji wa SEC inaonyesha faili 4439 mnamo Juni 29 na faili 4282 mnamo Julai 1, lakini ni 31 tu mnamo Juni 30 — siku ya mwisho ya robo. Siku za mwisho za robo za miaka iliyopita hubeba maelfu. Pengo liko kwenye mlisho wa data, si kwenye faili zilizowasilishwa na makampuni; hesabu yoyote ya faili za Juni au Q2 inayojumuisha Juni 30 imepunguzwa hadi faharasa ijaze nyuma. Ni sehemu ya muundo wa mwisho wa mwezi wa 2026 — noti ya uchunguzi ina risiti — iliyofichuliwa hapa na katika muhtasari wa Juni na Q2.
Fupi: faili moja lililokatwa, tatu kamili
SQL halisi nyuma ya kila namba
SELECT toString(date) AS d,
uniqExact(ticker) AS tickers_on_file,
max(ticker) AS alphabetical_end,
round(100 * sum(toFloat64(short_volume)) / sum(toFloat64(total_volume)), 1) AS marked_short_pct
FROM (
SELECT date, ticker, any(short_volume) AS short_volume, any(total_volume) AS total_volume
FROM global_markets.stocks_short_volume
WHERE date >= toDate('2026-06-29') AND date <= toDate('2026-07-02')
GROUP BY date, ticker
)
GROUP BY date
ORDER BY dateKiasi cha biashara nje ya soko kilikuwa kimewekwa alama kuwa fupi takriban 48.8% katikati ya wiki — ni utaratibu wa kawaida wa watengenezaji soko, si ishara ya msongamano. Safu wima za utoaji taarifa zina onyo: faili ya Juni 29 imekatwa kote sokoni (5489 tickers zinazoishia "SSUS" dhidi ya takriban 15,000 zinazoishia "ZYME" siku kamili), kwa hivyo 45.8% ya Juni 29 imekokotolewa kutoka faili isiyokamilika. Uchunguzi wa kina wa Juni 29 una uchunguzi kamili wa soko zima.
Maelezo ya Data
Maelezo Kamili ya Data
- Julai 3 ilikuwa kufungwa kamili, si kufungwa mapema. Julai 4, 2026 ilianguka siku ya Jumamosi; NYSE na Nasdaq ziliadhimisha sikukuu hiyo Ijumaa Julai 3 — 0 baa za SPY zilichapishwa siku hiyo. Ujumbe wa seti ya data uliopatikana wakati ukurasa huu ulipozalishwa upya: jedwali la kalenda ya ubadilishanaji ni mfumo unaoendelea wa sikukuu zijazo, na safu ya Julai 3 iliondoka mara tu sikukuu ilipopita (ilikuwepo katika toleo la kwanza la ukurasa huu), kwa hivyo risiti ya kufungwa ni siku ya baa sifuri ya tepu; mbinu ziko katika maelezo ya sikukuu.
- Maslahi mafupi yanaisha kwenye suluhu ya Juni 15. Suluhu ya mwisho wa Juni ya kila mwezi mara mbili haikuwa imechapishwa wakati ukurasa huu ulipozalishwa; hakuna chochote hapa kinachotumia, na muhtasari wa Juni unabeba ufichuzi kamili. Chapisho hili litazalishwa upya linapotua.
- Pengo la faharasa ya uwasilishaji ya Juni 30 limefichuliwa moja kwa moja hapo juu; chapisho la hazina la Julai 2 linangoja kuingizwa.
- Faili ya kiasi kifupi cha FINRA ya Juni 29 imekatwa kote sokoni; uwiano wake unaonyeshwa pamoja na ufunikaji wake moja kwa moja.
- Kutengwa kwa kiongozi wa kiasi: orodha moja ya Juni inafanya biashara chini ya alama iliyotumiwa tena na imetengwa kwenye ubao wa viongozi hadi uthibitishaji wa chombo utakapokamilika (chapisho lake lenyewe linabeba risiti).
Mbinu
- Kipindi ni Juni 29 hadi Julai 2, 2026 — vikao vinne vya biashara vya wiki; Julai 3 lilikuwa likizo ya soko. Mipaka ya vikao inathibitishwa kutoka kwa baa zilizozingatiwa, kamwe haidhaniwi (seti ya data ya kalenda ya ubadilishaji hubeba likizo zijazo tu — angalia dokezo la data).
- Nyakati zimehifadhiwa kwa UTC na kuchujwa kwa mipaka ghafi ya UTC; saa za kawaida katika wiki hii (EDT) ni 13:30–20:00 UTC. Kufunga ni dakika ya mwisho ya saa za kawaida; kiasi cha dola ni kufunga kwa dakika mara kiasi cha dakika, kilichojumlishwa kwa saa za kawaida.
- Takwimu za wiki hadi wiki zinalinganishwa na kufunga kwa Ijumaa iliyopita, zilizokokotwa upya katika swala moja kama za wiki hii — kamwe hazisomwi kutoka kwa thamani iliyohifadhiwa. Cheo cha mwaka unaofuata kinakokotoa upya kila wiki kwa namna ileile (saa za kawaida za ukuta wa Mashariki, ulinzi wa kikao cha chini, kikomo cha juu kimefungwa mwishoni mwa wiki hii).
- Uzalishaji unaendesha kupitia njia ya kusoma tu iliyozuiliwa; ukurasa wa umma kamwe haulizi moja kwa moja. Hali ya ghala kama ya Julai 5, 2026.
Hii ni toleo la kwanza la muhtasari wa kila wiki wa kudumu — toleo la wiki ijayo litashughulikia Julai 6–10 na kuunganisha kurudi hapa. Muhtasari wa kila siku wa Juni 29 unashughulikia Jumatatu kwa undani wa kiwango cha siku.