Strasmore Research
Muhtasari wa soko Matt ConnorNa Matt Connor · Imeboreshwa 2026-07-25

muhtasari wa soko juni 30 2026 namba muhimu

Kikao cha mwisho cha robo mwaka: teknolojia inaongoza faida, QQQ na SPY zinaongezeka, lakini sekta nyingi ni nyekundu. Tazama nambari za mwisho za siku.

Jumanne, Juni 30, 2026 — kikao cha mwisho cha robo mwaka — kilikuwa siku ya kupanda iliyoongozwa na teknolojia katika soko lililokuwa jekundu kwa kiasi kikubwa: QQQ ilipata 1.63% na SPY 0.73%, lakini ni 4 pekee kati ya 10 za S&P sector funds zilizofunga juu (3,349 majina yenye ukwasi yalipanda, 3,033 yalishuka). Kikao kilichotangulia: muhtasari wa Juni 29. Kila nambari hapa chini inasomwa kutoka kwa hoja iliyohifadhiwa — panua paneli yoyote ili kuona SQL.

Ubao wa alama

Kila mabadiliko yanalinganisha wati ya mwisho ya kikao cha kawaida cha Juni 30 na ile ya Jumatatu Juni 29.

UlizaSPY / QQQ / DIA / IWM — Juni 30 dhidi ya kufunga Juni 29, saa za kawaida
SQL halisi nyuma ya kila namba
WITH prior AS (
    SELECT ticker, argMax(close, window_start) AS prior_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'QQQ', 'DIA', 'IWM')
      AND window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00'
    GROUP BY ticker
),
sess AS (
    SELECT ticker,
           argMin(open, window_start) AS day_open,
           argMax(close, window_start) AS day_close,
           max(high) AS day_high,
           min(low) AS day_low,
           round(toFloat64(sum(volume)) / 1e6, 1) AS shares_traded_m
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'QQQ', 'DIA', 'IWM')
      AND window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'
    GROUP BY ticker
)
SELECT
    s.ticker AS ticker,
    round(toFloat64(p.prior_close), 2) AS prior_close,
    round(toFloat64(s.day_open), 2) AS day_open,
    round(toFloat64(s.day_close), 2) AS day_close,
    round((toFloat64(s.day_close) / toFloat64(p.prior_close) - 1) * 100, 2) AS pct_change,
    round(toFloat64(s.day_high), 2) AS day_high,
    round(toFloat64(s.day_low), 2) AS day_low,
    s.shares_traded_m AS shares_traded_m
FROM sess s
JOIN prior p ON s.ticker = p.ticker
ORDER BY s.ticker

SPY ilifungua kwa $741.29 na kumalizika kwa $746.32, karibu na kiwango chake cha juu cha $748.02. 1.63% ya QQQ ikilinganishwa na 0.12% ya DIA ndio sura ya siku: ukuaji ulikimbia, hisa za bluu hazikusogea sana, IWM 0.49%.

Robo hii imefungwa

Juni 30 ilifunga mwisho wa 62 vikao katika robo ya pili, na mwelekeo wa siku hiyo ulikuwa kioo cha robo nzima.

UlizaRobo ya pili 2026 mwisho hadi mwisho: kila ETF ya fahirisi kutoka ufunguzi wa Aprili 1 hadi kufunga Juni 30, saa za kawaida
SQL halisi nyuma ya kila namba
WITH q2 AS (
    SELECT ticker,
           toDate(toTimeZone(window_start, 'America/New_York')) AS d,
           argMin(toFloat64(open), window_start) AS d_open,
           argMax(toFloat64(close), window_start) AS d_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'QQQ', 'DIA', 'IWM')
      AND window_start >= toDateTime('2026-04-01 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, d
)
SELECT
    ticker,
    toString(min(d)) AS quarter_first_session,
    count() AS quarter_sessions,
    round(argMin(d_open, d), 2) AS quarter_open,
    round(argMax(d_close, d), 2) AS quarter_close,
    round((argMax(d_close, d) / argMin(d_open, d) - 1) * 100, 2) AS quarter_pct,
    countIf(d_close > d_open) AS up_sessions
FROM q2
GROUP BY ticker
ORDER BY quarter_pct DESC, ticker ASC

Kuanzia Aprili 1 hadi kufunga Juni 30: QQQ +26.53%, IWM 20.21%, SPY 14.13%, DIA 12.08%. QQQ iliongoza robo na Juni 30 yenyewe, ingawa nafasi za kati zilibadilishana: SPY ilimshinda IWM kwa siku hiyo, huku IWM ikimshinda SPY katika robo nzima. QQQ ilifunga juu zaidi katika 38 kati ya 62 vikao (muhtasari wa Q2 unaielezea panel kwa panel).

Je, siku hiyo ilikuwa ya kawaida?

UlizaMwenendo wa SPY kutoka ufunguzi hadi kufunga ukilinganishwa na mwezi uliopita wa vikao (cheo 1 = mwenendo mkubwa kabisa kwa thamani kamili)
SQL halisi nyuma ya kila namba
SELECT round(anyIf(oc_pct, d = toDate('2026-06-30')), 2) AS day_move_pct,
       arrayCount(x -> x > abs(anyIf(oc_pct, d = toDate('2026-06-30'))), groupArrayIf(abs(oc_pct), d != toDate('2026-06-30'))) + 1 AS abs_move_rank,
       count() AS sessions_compared,
       toString(min(d)) AS first_session
FROM (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d,
           (argMax(toFloat64(close), window_start) / argMin(toFloat64(open), window_start) - 1) * 100 AS oc_pct
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-06-01 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 d
)

Kutoka kwa ufunguzi hadi kufunga ndani ya kikao — lenzi tofauti kutoka kwa ubao wa alama za kufunga-kwa-kufunga — SPY ilisogea 0.68%, ikishika nafasi 7 kati ya 21 vikao vilivyopita kwa ukubwa kamili. Fahirisi ilikuwa shwari; mkanda ulio chini yake haukuwa hivyo.

Upeo: ukingo mwembamba wa mwelekeo chanya

UlizaWapanda dhidi ya washuka miongoni mwa ticker zenye angalau $1M zilizouzwa Juni 30
SQL halisi nyuma ya kila namba
WITH per_ticker AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') AS day_dollar_volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE (window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
       OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00')
    GROUP BY ticker
)
SELECT
    countIf(day_close > prior_close AND day_dollar_volume >= 1000000) AS advancers,
    countIf(day_close < prior_close AND day_dollar_volume >= 1000000) AS decliners,
    countIf(day_close = prior_close AND day_dollar_volume >= 1000000) AS unchanged,
    countIf(day_dollar_volume >= 1000000) AS liquid_tickers,
    count() AS tickers_traded_both_sessions,
    count() - countIf(day_dollar_volume >= 1000000) AS dropped_by_liquidity_filter,
    round(100.0 * countIf(day_close > prior_close AND day_dollar_volume >= 1000000)
        / countIf(day_dollar_volume >= 1000000), 1) AS advancer_pct,
    countIf(ticker IN ('XLB', 'XLE', 'XLF', 'XLI', 'XLK', 'XLP', 'XLRE', 'XLU', 'XLV', 'XLY')) AS sector_funds_counted,
    countIf(ticker IN ('XLB', 'XLE', 'XLF', 'XLI', 'XLK', 'XLP', 'XLRE', 'XLU', 'XLV', 'XLY')
        AND day_close > prior_close) AS sector_funds_up
FROM per_ticker
WHERE prior_close > 0 AND day_close > 0

3,349 waongezaji, 3,033 wapunguzaji, 88 wasiobadilika: 51.8% ya mkanda wa ukwasi ulipanda — ni kama sarafu inayopinduliwa chini ya 1.63% uchapishaji wa faharasa ya ukuaji. Kichujio cha ukwasi kinaondoa 5,055 kati ya 11,525 vitambulisho vya vipindi viwili (vilivyofanya biashara chini ya dola milioni 1), vilivyohesabiwa hapa, kamwe havijafichwa.

Sekta kwa sekta: pesa zilikwenda wapi

Kuhesabu majina kwa kura moja kila moja kunaficha mahali pesa zilipokaa. Mfuko kumi hapa chini kila mmoja unashikilia sehemu moja ya S&P 500, na tofauti kati ya bora na mbaya zaidi inapima jinsi kikao kilivyokuwa kisicho sawa.

UlizaMifuko kumi ya sekta ya S&P Juni 30: mabadiliko dhidi ya kufunga Jumatatu, na umbali wa kila moja nyuma ya kiongozi
SQL halisi nyuma ya kila namba
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('XLB', 'XLE', 'XLF', 'XLI', 'XLK', 'XLP', 'XLRE', 'XLU', 'XLV', 'XLY')
      AND ((window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
        OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'))
    GROUP BY ticker
)
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    round(day_close, 2) AS day_close,
    round((day_close / prior_close - 1) * 100, 2) AS pct_chg,
    if(day_close > prior_close, 1, 0) AS is_up,
    round(max((day_close / prior_close - 1) * 100) OVER () - (day_close / prior_close - 1) * 100, 2) AS pts_behind_leader,
    day_dollar_bn
FROM per_name
ORDER BY pct_chg DESC, ticker ASC

Teknolojia (XLK) ilipata 2.69% na ikasimama pekee: viwanda 1.34%, nyenzo 0.36% na bidhaa za hiari 0.15% ndizo pekee zilizokuwa kijani, na ubao unaendelea kuwa nyekundu kutoka kwa fedha (-0.17%) hadi kwa huduma (-1.48%), bidhaa za msingi (-1.53%) na mali isiyohamishika mwisho kwa -2%. Bora ukiondoa mbaya zaidi: 4.69 asilimia, 4 kati ya 10 ya fedha zikiwa kijani. Fahirisi iliyopanda chini ya asilimia moja, tofauti ya pointi nne chini yake: sekta moja ilibeba siku hiyo.

Wachuuzi wakubwa wa siku, kwenye soko zima

Upana huhesabu ni majina mangapi yalipanda; hii inaonyesha yale yaliyobadilika zaidi — tano bora na tano dhaifu kwa mabadiliko ya asilimia miongoni mwa majina yanayofanya biashara ya $256.76% milioni au zaidi.

UlizaWapanda 5 bora na washuka 5 bora miongoni mwa majina yenye $10M+ yaliyouzwa Juni 30 (orodha moja ya alama iliyotumiwa tena imetengwa)
SQL halisi nyuma ya kila namba
WITH per_ticker AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') AS day_dollar_volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE (window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
       OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00')
    GROUP BY ticker
    HAVING prior_close > 1 AND day_close > 0 AND day_dollar_volume >= 10000000 AND ticker NOT IN ('SPCX')
)
SELECT
    board,
    ticker,
    prior_close,
    day_close,
    pct_chg,
    round(abs(pct_chg), 2) AS abs_pct_chg,
    dollar_volume_m,
    if(ticker IN (SELECT ticker FROM global_markets.stocks_splits
                  WHERE execution_date >= '2026-06-29' AND execution_date <= '2026-06-30'), 1, 0) AS split_record_on_file
FROM (
    SELECT 'top gainers' AS board, ticker, round(prior_close, 2) AS prior_close, round(day_close, 2) AS day_close,
           round((day_close / prior_close - 1) * 100, 2) AS pct_chg, round(day_dollar_volume / 1e6, 0) AS dollar_volume_m
    FROM per_ticker
    ORDER BY (day_close / prior_close) DESC, ticker ASC
    LIMIT 5
    UNION ALL
    SELECT 'top decliners' AS board, ticker, round(prior_close, 2) AS prior_close, round(day_close, 2) AS day_close,
           round((day_close / prior_close - 1) * 100, 2) AS pct_chg, round(day_dollar_volume / 1e6, 0) AS dollar_volume_m
    FROM per_ticker
    ORDER BY (day_close / prior_close) ASC, ticker ASC
    LIMIT 5
)
ORDER BY if(board = 'top gainers', 0, 1) ASC, pct_chg DESC, ticker ASC

Hakuna ubao unaofanana na fahirisi. JEM iliongoza kwa +256.76% kwa biashara ya $141 milioni; SOC ilipoteza 55.89% kwa $306 milioni. ABVX ilipanda 38.56% kwa $942 milioni, mauzo makubwa zaidi kwenye ubao wowote; NVCT ilishuka 35.62% na UNCY 39.09%. Safu ya rekodi zilizogawanyika inaweka ubao wazi — mgawanyiko wa kinyume wa 1-kwa-10 huchapisha kama "faida" ya +900% kwenye mkanda usiorekebishwa — na kila jina hapa lina 0: chapa halisi.

Safu tatu ni biashara moja mara mbili: CRCA (-35.16%) na CRCG (-35.19%) zilishuka huku CRCD ikipanda 35.47% — kila moja karibu mara mbili ya mabadiliko ya -17.53% ya jina lililo karibu na sarafu-fiche hapa chini: vifungashio vya hisa moja vilivyotumia faida.

Kile kilichoangaziwa siku hii: semiconductors kuelekea mwisho wa robo mwaka

Majina sita, mada moja, matokeo tofauti kabisa — mwendo-shirikishi na ukubwa tu; data haisemi kwa nini.

UlizaMajina ya semiconductor na uhifadhi: mabadiliko dhidi ya kufunga Jumatatu, mwanya, na kiasi cha dola
SQL halisi nyuma ya kila namba
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        maxIf(toFloat64(high), window_start >= '2026-06-30 00:00:00') AS day_high,
        minIf(toFloat64(low), window_start >= '2026-06-30 00:00:00') AS day_low,
        argMinIf(window_start, toFloat64(low), window_start >= '2026-06-30 00:00:00') AS low_bar,
        argMaxIf(window_start, toFloat64(high), window_start >= '2026-06-30 00:00:00') AS high_bar,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AMD', 'INTC', 'MU', 'SNDK', 'TSM', 'WDC')
      AND ((window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
        OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'))
    GROUP BY ticker
)
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    round(day_close, 2) AS day_close,
    round((day_close / prior_close - 1) * 100, 2) AS pct_chg,
    round(day_high, 2) AS day_high,
    formatDateTime(toTimeZone(high_bar, 'America/New_York'), '%H:%i') AS day_high_et,
    round(day_low, 2) AS day_low,
    formatDateTime(toTimeZone(low_bar, 'America/New_York'), '%H:%i') AS day_low_et,
    round((day_high / day_low - 1) * 100, 2) AS range_pct,
    day_dollar_bn
FROM per_name
ORDER BY ticker

SanDisk iliruka 10.79%, AMD 7.7%, Intel 5.93%, TSMC 4.86% — huku MU, tiketi kubwa zaidi kwenye mkanda kwa $37.41 bilioni ya mauzo, ikifunga juu kwa 0.52% tu na Western Digital (-2.01%) haikushiriki. Hii ndiyo ngumu nyuma ya tasnia ya teknolojia kwa 2.69% ya sekta (MU ya Juni, tiketi kwa tiketi).

Mkondo wa kupinga ulipitia fedha za karibu na sarafu-fiche, dhidi ya mkanda wa kijani:

UlizaFedha zinazohusiana na crypto: mabadiliko dhidi ya kufunga Jumatatu, mwanya, na kiasi cha dola
SQL halisi nyuma ya kila namba
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        maxIf(toFloat64(high), window_start >= '2026-06-30 00:00:00') AS day_high,
        minIf(toFloat64(low), window_start >= '2026-06-30 00:00:00') AS day_low,
        argMinIf(window_start, toFloat64(low), window_start >= '2026-06-30 00:00:00') AS low_bar,
        argMaxIf(window_start, toFloat64(high), window_start >= '2026-06-30 00:00:00') AS high_bar,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('COIN', 'CRCL', 'HOOD', 'MSTR')
      AND ((window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
        OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'))
    GROUP BY ticker
)
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    round(day_close, 2) AS day_close,
    round((day_close / prior_close - 1) * 100, 2) AS pct_chg,
    round(day_high, 2) AS day_high,
    formatDateTime(toTimeZone(high_bar, 'America/New_York'), '%H:%i') AS day_high_et,
    round(day_low, 2) AS day_low,
    formatDateTime(toTimeZone(low_bar, 'America/New_York'), '%H:%i') AS day_low_et,
    round((day_high / day_low - 1) * 100, 2) AS range_pct,
    day_dollar_bn
FROM per_name
ORDER BY ticker

CRCL ilichapisha -17.53%, kiwango chake cha chini cha $62.52 kikifika saa 15:59 ET — dakika ya mwisho ya kikao — huku MSTR -6.2%, COIN -3.61% na HOOD -1.53% zikiwa pamoja. Mwendo-shirikishi ulionekana; sababu haijathibitishwa.

Kile kituo cha habari kilichobeba

Muhtasari unaokataa kusema sababu unamdaiwa msomaji kile kilichochapishwa siku hiyo.

UlizaMlango wa habari Juni 30: idadi ya makala na kichwa cha mwisho cha siku kwa kila jina katika muhtasari huu
SQL halisi nyuma ya kila namba
SELECT
    names.n AS ticker,
    countIf(has(tickers, names.n)) AS articles_today,
    if(countIf(has(tickers, names.n)) = 0, 'none',
       formatDateTime(toTimeZone(argMaxIf(published_utc, (published_utc, id), has(tickers, names.n)), 'America/New_York'), '%H:%i')) AS latest_et,
    if(countIf(has(tickers, names.n)) = 0, 'no article in our feed this session',
       JSONExtractString(argMaxIf(publisher, (published_utc, id), has(tickers, names.n)), 'name')) AS publisher_name,
    if(countIf(has(tickers, names.n)) = 0, 'no article in our feed this session',
       argMaxIf(title, (published_utc, id), has(tickers, names.n))) AS latest_headline
FROM global_markets.stocks_news
CROSS JOIN (SELECT arrayJoin(['NVDA', 'MU', 'SNDK', 'CRCL', 'SOC', 'ABVX', 'JEM']) AS n) AS names
WHERE published_utc >= '2026-06-30 04:00:00' AND published_utc < '2026-07-01 04:00:00'
GROUP BY names.n
ORDER BY articles_today DESC, ticker ASC

Jina lililotajwa zaidi lilikuwa NVDA kwa makala 21 — si miongoni mwa wale waliosonga siku hiyo hata kidogo — kipande chake cha mwisho cha kikao (16:28 ET, Investing.com) kilichoitwa "These Stocks Could Benefit as the Robotaxi Race Heats Up". MU ilivuta 7; makala pekee ya SanDisk (The Motley Fool) ndiyo kichwa pekee siku nzima kinachotaja mwendo halisi: "Why Sandisk Stock Is Skyrocketing Today".

Pengo ndilo ugunduzi: mshuka mkubwa zaidi wa siku, mpanda mkubwa zaidi na jina linalohusiana na sarafu-fumbo lililoanguka kwa nguvu zaidi lilivuta makala 0, 0 na 0 — sufuri kila moja, ndani ya kituo cha vipande 211. Ufunikaji si kigezo cha hatua ya bei.

Mahali ambapo pesa zilifanya biashara

UlizaViongozi wa kiasi kwa njia mbili: 6 bora kwa dola zilizouzwa, 4 bora kwa hisa zilizouzwa (orodha moja ya alama iliyotumiwa tena imetengwa ikisubiri uthibitishaji wa chombo)
SQL halisi nyuma ya kila namba
SELECT ticker, leaderboard, dollar_volume_bn, if(dollar_volume_bn < 1, dollar_volume_m, NULL) AS dollar_value_m, shares_m,
    round(100 * if(leaderboard = 'by dollars traded', dollar_volume_bn, shares_m)
        / max(if(leaderboard = 'by dollars traded', dollar_volume_bn, shares_m)) OVER (PARTITION BY leaderboard), 1) AS pct_of_board_leader
FROM (
    SELECT
        'by dollars traded' AS leaderboard,
        ticker,
        round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 2) AS dollar_volume_bn,
        round(sum(toFloat64(close) * toFloat64(volume)) / 1e6, 0) AS dollar_volume_m,
        round(sum(toFloat64(volume)) / 1e6, 1) AS shares_m
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
    ORDER BY dollar_volume_bn DESC
    LIMIT 6
    UNION ALL
    SELECT
        'by shares traded' AS leaderboard,
        ticker,
        round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 2) AS dollar_volume_bn,
        round(sum(toFloat64(close) * toFloat64(volume)) / 1e6, 0) AS dollar_volume_m,
        round(sum(toFloat64(volume)) / 1e6, 1) AS shares_m
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
    ORDER BY shares_m DESC
    LIMIT 4
)
ORDER BY leaderboard ASC, if(leaderboard = 'by dollars traded', dollar_volume_bn, shares_m) DESC

Kwa dola, MU ilitawala kila kitu, ikijumuisha fedha za fahirisi: $37.41 bilioni dhidi ya $31.84 bilioni za SPY — kikao cha pili mfululizo ambacho ilifanya biashara zaidi ya fedha ya fahirisi ya bendera (muhtasari wa Jumatatu una rekodi ya kwanza). Ubao wa hisa unasema kitu kingine: SOXS, ETF ya semiconductor yenye nyongeza mara 3 (515.5 milioni hisa), na majina mawili yenye thamani chini ya dola moja ambayo ni makosa ya kukadiria ikilinganishwa na siku ya MU — kiasi kinasomeka kwa njia mbili.

Jina moja limezuiliwa kwenye mbao zote mbili kwa makusudi: orodha ya Juni ambayo ticker yake hapo awali ilikuwa ya kampuni tofauti, isiyohusiana, kwa hivyo milisho ya wauzaji inaweka lebo kwa vyombo viwili kwa herufi tatu sawa (risiti hapa).

UlizaHisa zilizouzwa kwa ndoo ya dakika 30, saa za kawaida (mabilioni)
SQL halisi nyuma ya kila namba
SELECT
    formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
    round(sum(toFloat64(volume)) / 1e9, 2) AS shares_bn,
    round(100 * sum(toFloat64(volume)) / max(sum(toFloat64(volume))) OVER (), 1) AS pct_of_biggest_bucket
FROM global_markets.delayed_stocks_minute_aggs
WHERE window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'
GROUP BY et_time
ORDER BY et_time

2.05 bilioni hisa katika nusu saa ya kwanza, mteremko wa 0.78 bilioni saa 13:30, na ndoo kubwa zaidi ya siku — 2.69 bilioni — kuelekea kufunga kwa mwisho wa robo, ambapo mnada wa kufunga na mtiririko wake wa kusawazisha unachapishwa (uchambuzi wa kina wa Juni 29 unaenda chini ya baa).

Kanda ya chaguzi

UlizaSafu moja kwa siku nzima ya chaguzi: kiasi, muda wake unaoisha siku hiyo hiyo, mwelekeo wa put/call wa SPY kwa pesa, wiki iliyohamishwa kwa likizo
SQL halisi nyuma ya kila namba
WITH
    (
        SELECT (any(underlying_symbol), any(toFloat64(strike_price)), any(option_type),
                any(toDateOrNull(concat('20', substring(ticker, length(ticker) - 14, 6)))),
                sum(size), count(), round(avg(toFloat64(price)), 3))
        FROM global_markets.options_trades
        WHERE sip_timestamp >= '2026-06-30 00:00:00' AND sip_timestamp < '2026-07-01 00:00:00'
        GROUP BY ticker
        ORDER BY sum(size) DESC
        LIMIT 1
    ) AS top_contract,
    (
        SELECT round(toFloat64(argMax(close, window_start)), 2)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY' AND window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'
    ) AS spy_close
SELECT
    round(count() / 1e6, 2) AS option_prints_m,
    round(toFloat64(sum(size)) / 1e6, 2) AS contracts_m,
    round(100.0 * sumIf(size, option_type = 'C') / sum(size), 1) AS call_pct_of_volume,
    round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260630') / sum(size), 1) AS same_day_expiry_pct,
    round(toFloat64(sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260702')) / 1e6, 2) AS thu_jul2_expiry_contracts_m,
    countIf(substring(ticker, length(ticker) - 14, 6) = '260703') AS fri_jul3_expiry_prints,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY')) / 1e6, 2) AS spy_contracts_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'QQQ')) / 1e6, 2) AS qqq_contracts_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'P'))
        / toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'C')), 2) AS spy_put_call_ratio,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'C'
        AND substring(ticker, length(ticker) - 14, 6) = '260630' AND toFloat64(strike_price) > spy_close)) / 1e6, 2) AS spy_0dte_otm_calls_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'C'
        AND substring(ticker, length(ticker) - 14, 6) = '260630' AND toFloat64(strike_price) <= spy_close)) / 1e6, 2) AS spy_0dte_itm_calls_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'P'
        AND substring(ticker, length(ticker) - 14, 6) = '260630' AND toFloat64(strike_price) < spy_close)) / 1e6, 2) AS spy_0dte_otm_puts_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'P'
        AND substring(ticker, length(ticker) - 14, 6) = '260630' AND toFloat64(strike_price) >= spy_close)) / 1e6, 2) AS spy_0dte_itm_puts_m,
    top_contract.1 AS top_contract_underlying,
    top_contract.2 AS top_contract_strike,
    top_contract.3 AS top_contract_type,
    top_contract.4 AS top_contract_expiry,
    top_contract.5 AS top_contract_volume,
    round(top_contract.7, 3) AS top_contract_avg_price,
    round(top_contract.2 - spy_close, 2) AS top_strike_minus_spy_close
FROM global_markets.options_trades
WHERE sip_timestamp >= '2026-06-30 00:00:00' AND sip_timestamp < '2026-07-01 00:00:00'

Chaguzi zilifanya biashara mikata 61.95 milioni katika chapa 10.06 milioni; simu zilichukua 57.3% ya kiasi cha soko lote, na 28% yake ilikoma Jumanne hiyo. SPY iliegemea upande mwingine: mikata 12.04 milioni kwa uwiano wa kuweka/simu wa 1.09 — kuweka zaidi kuliko simu, siku ambayo mfuko ulipanda.

Kupanga chaguzi za SPY zinazoisha siku hiyo hiyo dhidi ya kufunga kwake kwa $746.32 kunafanya mkunjo kuwa wazi: 3.33 milioni za kuweka nje ya pesa (bei za chini ya kufunga) na 2.28 milioni za simu nje ya pesa, dhidi ya 1.77 milioni za simu ndani ya pesa na 0.63 milioni za kuweka ndani ya pesa — bei za chini zilizoisha bila thamani zilikuwa kundi lenye shughuli nyingi zaidi katika siku ya 0DTE ya SPY. Hakuna chochote chenye msimbo wa kukoma Ijumaa, Julai 3 kilichochapishwa kabisa (0 chapa — soko limefungwa Ijumaa hiyo); wiki ya Alhamisi ilibeba 10.52 milioni.

UlizaMikataba sita yenye shughuli nyingi zaidi ya Juni 30, kwa mikataba iliyouzwa
SQL halisi nyuma ya kila namba
SELECT
    concat(underlying, ' $', toString(strike), ' ', if(typ = 'C', 'call', 'put')) AS contract,
    toString(expiry) AS expires,
    formatDateTimeInJodaSyntax(expiry, 'MMMM d, yyyy') AS expires_label,
    if(expiry = toDate('2026-06-30'), 1, 0) AS is_same_day,
    contracts,
    round(avg_px, 3) AS avg_premium,
    round(100 * contracts / max(contracts) OVER (), 1) AS pct_of_busiest
FROM (
    SELECT any(underlying_symbol) AS underlying,
           any(toFloat64(strike_price)) AS strike,
           any(option_type) AS typ,
           any(toDateOrNull(concat('20', substring(ticker, length(ticker) - 14, 6)))) AS expiry,
           sum(size) AS contracts,
           avg(toFloat64(price)) AS avg_px,
           any(ticker) AS occ
    FROM global_markets.options_trades
    WHERE sip_timestamp >= '2026-06-30 00:00:00' AND sip_timestamp < '2026-07-01 00:00:00'
    GROUP BY ticker
    ORDER BY contracts DESC, occ ASC
    LIMIT 6
)
ORDER BY contracts DESC, contract ASC

Mkataba wenye shughuli nyingi zaidi popote ulikuwa simu ya siku hiyo hiyo ya SPY $747 — mikata 821,361 kwa wastani wa malipo ya $0.641, ikimaliza $0.68 juu ya upau wa mwisho wa kawaida wa SPY, na bila thamani. Ubao nyuma yake ndio somo: tano kati ya mikata sita yenye shughuli nyingi zaidi kwenye kanda zilikuwa bei za siku hiyo hiyo za SPY tofauti ya dola moja karibu na kufunga (SPY $748 call ijayo), kila moja ikifanya biashara kwa senti. Isipokuwa, kwa 65.1% ya kiasi cha kiongozi, ilikuwa KWEB $29 call ikikoma December 18, 2026, si mkataba wa siku hiyo hiyo: nafasi moja ya miezi sita kati ya tiketi tano za bahati nasibu za alasiri.

Viwango: urefu wa mwisho ulipanda hadi kufungwa kwa nusu ya mwaka

UlizaMviringo wa Hazina, kufunga Juni 30 dhidi ya Juni 29 (muda uliojazwa tu)
SQL halisi nyuma ya kila namba
SELECT
    t.1 AS curve_point,
    round(t.2, 2) AS jun30_yield_pct,
    round((t.2 - t.3) * 100) AS one_day_change_bp
FROM (
    SELECT arrayJoin([
        ('1 month',  toFloat64(d.yield_1_month),  toFloat64(p.yield_1_month)),
        ('3 month',  toFloat64(d.yield_3_month),  toFloat64(p.yield_3_month)),
        ('1 year',   toFloat64(d.yield_1_year),   toFloat64(p.yield_1_year)),
        ('2 year',   toFloat64(d.yield_2_year),   toFloat64(p.yield_2_year)),
        ('5 year',   toFloat64(d.yield_5_year),   toFloat64(p.yield_5_year)),
        ('10 year',  toFloat64(d.yield_10_year),  toFloat64(p.yield_10_year)),
        ('30 year',  toFloat64(d.yield_30_year),  toFloat64(p.yield_30_year)),
        ('2s10s spread', toFloat64(d.yield_10_year - d.yield_2_year), toFloat64(p.yield_10_year - p.yield_2_year))
    ]) AS t
    FROM (SELECT * FROM global_markets.treasury_yields WHERE date = '2026-06-30') AS d,
         (SELECT * FROM global_markets.treasury_yields WHERE date = '2026-06-29') AS p
)

Mwisho wa muda mrefu ulipanda siku ya mwisho ya nusu ya mwaka: dhamana ya miaka 10 ilipanda 6 pointi za msingi hadi 4.44%, ya miaka 2 4 pointi za msingi hadi 4.14%, na mweneo wa miaka 2 na 10 uliongezeka 2 pointi za msingi hadi 0.3 pointi. Mavuno ya muda mrefu yalipanda wakati wa kikao ambacho sekta yake dhaifu zaidi, mali isiyohamishika (-2%), na ya tatu kwa udhaifu, huduma za umma (-1.48%), zote mbili kwa kawaida huathiriwa na viwango: hili ni tukio la kuzingatia, si utaratibu ambao data hii inaweza kuthibitisha (muhtasari wa nusu ya kwanza ya mwaka unabeba mkunjo wa nusu ya mwaka).

Kalenda nyuma ya siku hiyo

UlizaKalenda ya kampuni na mtiririko wa habari Juni 30, katika safu moja (pengo la faharasa ya uwasilishaji linaonyeshwa)
SQL halisi nyuma ya kila namba
WITH
    (
        SELECT (count(), uniqExact(publisher))
        FROM global_markets.stocks_news
        WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-06-30'
    ) AS news,
    (
        SELECT (argMax(t, n), max(n))
        FROM (
            SELECT t, count() AS n
            FROM (
                SELECT arrayJoin(tickers) AS t
                FROM global_markets.stocks_news
                WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-06-30'
            )
            WHERE t != 'SPCX'
            GROUP BY t
        )
    ) AS top_news
SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-06-30') AS ex_dividend_records,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date = '2026-06-30') AS splits_executed,
    (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date = '2026-06-30') AS ipos_listed,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-06-30') AS sec_filings,
    (SELECT uniqExactIf(accession_number, form_type = '4') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-06-30') AS insider_form4_filings,
    (SELECT uniqExactIf(accession_number, form_type = '8-K') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-06-30') AS filings_8k,
    (SELECT arrayStringConcat(groupArray(concat(ticker, ' — ', issuer_name)), '; ') FROM (
        SELECT ticker, issuer_name FROM global_markets.stocks_ipos WHERE listing_date = '2026-06-30' ORDER BY ticker
    )) AS ipo_names,
    news.1 AS news_articles,
    news.2 AS news_publishers,
    top_news.1 AS most_covered_ticker,
    top_news.2 AS most_covered_articles,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-06-29')) AS filings_prior_session

Rekodi 704 za gawio zilienda bila gawio siku ya mwisho ya robo mwaka — wimbi la mwisho wa robo, kampuni nyingi za Marekani zikilipa kila robo mwaka — pamoja na migawanyiko 7 na orodha mpya 2 (AACU — Ares Acquisition Corp III; OSPRU — Osprey Acquisition Corp. III). Safu ya uwasilishaji ndiyo kichwa cha habari cha ubora wa data: faharasa ya SEC ina 31 uwasilishaji kwa Juni 30 — 0 Fomu za 4 za watu wa ndani, 0 8-Ks — dhidi ya 4439 kikao kilichotangulia. Mchoro wa mwisho wa mwezi katika mfumo, uliotambuliwa katika dokezo la pengo la mwisho wa mwezi; hesabu yoyote inayojumuisha siku hii inapunguzwa hadi ijazwe nyuma.

Kikao, kimehakikiwa

UlizaUkaguzi wa kikao: muda wa dakika moja uliozingatiwa wa SPY
SQL halisi nyuma ya kila namba
SELECT
    formatDateTime(min(toTimeZone(window_start, 'America/New_York')), '%H:%i') AS first_spy_bar_et,
    formatDateTime(max(toTimeZone(window_start, 'America/New_York')), '%H:%i') AS last_spy_bar_et,
    count() AS spy_minute_bars,
    countIf(window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00') AS regular_session_bars,
    uniqExactIf(toDate(toTimeZone(window_start, 'America/New_York')), window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00') AS day_sessions
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= '2026-06-30 00:00:00' AND window_start < '2026-07-01 00:00:00'

Mishororo ya SPY inaendesha 04:00 hadi 19:59 kwa saa za New York ikiwa na mishororo 390 ya dirisha la kawaida — kikao kamili, kilichohakikiwa kutoka kwenye mkanda (seti ya data ya kalenda ya soko hubeba tu kufungwa kwa siku zijazo).

Muhtasari wa kikao

Uchapishaji wa 0.73% SPY huku 51.8% ya majina yakiwa juu, 4 ya 10 fedha za sekta zikiwa kijani na 4.69 pointi kati ya bora na mbaya zaidi si mkusanyiko mpana — ni mkusanyiko wa sekta moja ukiwa umevaa nguo za fahirisi, nusu saa yake nzito zaidi katika mnada wa mwisho wa robo mwaka. Mabadiliko ya fahirisi ni wastani, na hili lilichukuliwa na teknolojia huku sekta nyingi zikianguka: angalia mtawanyiko kabla ya kuamini mwelekeo.

Maswali Yanayoulizwa Mara kwa Mara

Je, soko la hisa lilifanyaje tarehe 30 Juni 2026?

Lilifunga juu zaidi: SPY ilipata 0.73% na QQQ 1.63% ikilinganishwa na kufunga kwa tarehe 29 Juni. Upana ulikuwa mdogo — 51.8% ya majina yenye ukwasi yaliongezeka, 4 ya 10 ya fedha za sekta za S&P zilikuwa kijani.

Ni sekta gani iliongoza soko tarehe 30 Juni 2026?

Teknolojia: XLK ilipata 2.69%, dhidi ya 1.34% kwa viwanda vilivyofuata na -2% kwa mali isiyohamishika mwishoni — 4.69 pointi kati ya bora na mbaya zaidi.

Je, ni zipi zilikuwa hisa zilizosonga zaidi tarehe 30 Juni 2026?

Miongoni mwa majina yaliyofanya biashara ya dola milioni 10 au zaidi, JEM ilipata faida kubwa zaidi (+256.76%) na SOC ilipata hasara kubwa zaidi (55.89%). Hakuna lililokuwa na rekodi ya mgawanyiko: zote ni mabadiliko halisi ya bei, si athari za hatua za kampuni.

Je, soko la hisa lilifanyaje katika Q2 2026?

Kuanzia ufunguzi wa Aprili 1 hadi kufunga kwa Juni 30, katika vipindi 62: QQQ +26.53%, IWM 20.21%, SPY 14.13%, DIA 12.08% — robo iliyoongozwa na ukuaji, iliyomalizika kwa siku iliyoongozwa na ukuaji.

Kwa nini kiasi kikubwa cha biashara kinafanyika katika nusu saa ya mwisho?

Nusu saa ya mwisho ilibeba bilioni 2.69 za hisa dhidi ya bilioni 2.05 wakati wa ufunguzi. Mnada wa kufunga huweka bei rasmi ya kufunga ya kila hisa katika makutano moja, na fedha za fahirisi hufanya biashara huko ili kuilinganisha; kusawazisha mwisho wa robo hukusanya mtiririko huo.

Vidokezo vya data na mbinu

  • Vikapu. Bodi ya sekta ni fedha kumi za SPDR za sekta zilizotajwa kwenye paneli yake — kikapu kile kile kila kikao, hivyo nambari ya mtawanyiko inalinganishwa katika siku mbalimbali. Bodi za wasogezaji zinahitaji mauzo ya dola milioni 10 na bei ya kufunga iliyopita ya zaidi ya $1, hazijumuishi orodha ya alama iliyotumiwa tena iliyotajwa hapo juu, na zina safu wima ya rekodi iliyogawanyika.
  • Tahadhari. Kiasi cha dola ni kikadirio cha dakika kwa dakika (bei ya kufunga × kiasi kwa upau). Kielezo cha uwasilishaji cha Juni 30 kiko karibu tupu (dokezo la pengo la mwisho wa mwezi linatambua hilo). Hesabu za habari ni mlisho mmoja wa muuzaji: hakuna makala hapa inayothibitisha kuwa hakuna chochote kilichochapishwa popote.
  • Mbinu. Kikao kimoja (1, kilichothibitishwa kutoka kwa upau uliozingatiwa); nyakati zimehifadhiwa kwa UTC, zimebadilishwa kuwa wakati wa New York katika maswali; "kufunga" ni upau wa mwisho wa dakika za kawaida, si chapa ya mnada. Muda wa kuisha kwa chaguo unachambuliwa upya kutoka kwa ticker ya OCC (safu wima ya jedwali yenyewe imevunjika); uhalisia wa pesa unapimwa dhidi ya upau wa mwisho wa kawaida wa SPY. Paneli zinaendeshwa mara moja, wakati wa uandishi, kupitia njia ya kusoma tu iliyozuiwa. Ghala kufikia Julai 13, 2026.

Kila paneli ni matokeo ya swala lililohifadhiwa — chati, jedwali na SQL katika kitu kimoja. Bandika yoyote kati yao kwenye terminal ya Strasmore. Kikao kijacho: Julai 1.

#recap#daily#spy#qqq#market structure