Strasmore Research
Ringkasan pasaran Matt ConnorOleh Matt Connor · Dikemas kini 2026-07-26

ringkasan pasaran 9 julai 2026

Peralatan cip melonjak tinggi pada pembukaan kemudian pudar, mega-cap jatuh lalu melantun semula, pita bertukar hijau, dan NVDA ditutup merah.

Khamis, 9 Julai 2026 memadatkan keganasannya dalam satu minit — dan minit itu tiba sebelum loceng pembukaan. Nama-nama peralatan cip sudah jauh di atas harga tutup Rabu dalam dagangan prapasaran, manakala META berada -3.16% di bawahnya; cetakan 9:30 mengesahkan kedua-duanya. Hari itu kemudiannya sebahagiannya mengundur pembukaannya sendiri: jurang cip semakin pudar, META naik semula sepenuhnya, dan pita ditutup 71.5% hijau — sesi paling luas minggu ini. NVDA, hijau sepanjang runtuhan hari Selasa, ditutup merah. Setiap angka di bawah dibaca daripada pertanyaan tersimpan.

Apa yang menentukan pembukaan

Jurang harga tidak berlaku pada pukul 9:30. Antara pukul 4:00 pagi dan 9:29 pagi ET, dagangan prapasaran telah pun menetapkan semula harga saham-saham ini, dan cetakan pembukaan mendarat pada tahap tersebut.

PertanyaanLaluan prapasaran, 4:00-9:29 pagi ET: cetakan prapasaran terakhir berbanding penutupan Rabu, dan pembukaan yang menyusul
SQL tepat di sebalik setiap nombor
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    formatDateTime(first_pm_bar, '%H:%i') AS first_premkt_bar_et,
    round(premkt_last, 2) AS premkt_last,
    round((premkt_last / prior_close - 1) * 100, 2) AS premkt_pct,
    round(premkt_shares / 1e3, 1) AS premkt_shares_k,
    round((day_open / prior_close - 1) * 100, 2) AS gap_pct,
    round((day_open / premkt_last - 1) * 100, 2) AS open_vs_premkt_pct
FROM (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 20:00:00')) AS prior_close,
        minIf(toTimeZone(window_start, 'America/New_York'), window_start >= '2026-07-09 08:00:00' AND window_start < '2026-07-09 13:30:00') AS first_pm_bar,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-09 08:00:00' AND window_start < '2026-07-09 13:30:00')) AS premkt_last,
        sumIf(toFloat64(volume), window_start >= '2026-07-09 08:00:00' AND window_start < '2026-07-09 13:30:00') AS premkt_shares,
        toFloat64(argMinIf(open, window_start, window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00')) AS day_open
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'QQQ', 'KLAC', 'LRCX', 'META', 'NVDA')
      AND ((window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 20:00:00')
        OR (window_start >= '2026-07-09 08:00:00' AND window_start < '2026-07-09 20:00:00'))
    GROUP BY ticker
)
ORDER BY ticker
Run this yourself →

Cetakan prapasaran terakhir KLAC berada +8.49% berbanding harga tutup Rabu dan ia dibuka +8.14%; LRCX naik +9.64% ke pembukaan +9.67%; META mencetak -3.16% dan dibuka -3.16%. Baca open_vs_premkt_pct: kesemua enam saham dibuka dalam lingkungan satu peratus daripada harga prapasaran terakhir mereka. NVDA adalah yang luar biasa — 0.16% semalaman pada 3741.7k saham, volum prapasaran paling tinggi antara enam saham ini dan pergerakan paling kecil (dagangan prapasaran dan selepas waktu pasaran).

Adakah terdapat pemangkin? Data kami tidak menamakan sebarang punca

Rumusan harus menyatakan apa yang menggerakkan saham. Di sini jadual kami tidak menamakan apa-apa: suapan berita dan indeks pemfailan SEC kedua-duanya kosong bagi empat nama yang mengalami jurang paling teruk.

PertanyaanPemangkin bernama pada fail: artikel berita dan pemfailan SEC mengikut nama, penutupan Rabu hingga Khamis
SQL tepat di sebalik setiap nombor
SELECT
    ticker,
    toUInt32(sum(overnight_articles)) AS overnight_articles,
    toUInt32(sum(session_articles)) AS session_articles,
    toUInt32(sum(sec_filings)) AS sec_filings,
    toUInt32(sum(filings_8k)) AS filings_8k
FROM (
    SELECT
        arrayJoin(['AMD', 'KLAC', 'LRCX', 'META', 'MSFT', 'MU', 'NVDA', 'TER', 'WDC']) AS ticker,
        toUInt64(0) AS overnight_articles, toUInt64(0) AS session_articles,
        toUInt64(0) AS sec_filings, toUInt64(0) AS filings_8k
    UNION ALL
    SELECT
        arrayJoin(tickers) AS ticker,
        countIf(published_utc < '2026-07-09 13:30:00') AS overnight_articles,
        countIf(published_utc >= '2026-07-09 13:30:00') AS session_articles,
        toUInt64(0) AS sec_filings, toUInt64(0) AS filings_8k
    FROM global_markets.stocks_news
    WHERE published_utc >= '2026-07-08 20:00:00' AND published_utc < '2026-07-09 20:00:00'
    GROUP BY ticker
    UNION ALL
    SELECT
        ticker, toUInt64(0), toUInt64(0),
        count() AS sec_filings,
        countIf(form_type = '8-K') AS filings_8k
    FROM global_markets.stocks_sec_edgar_index
    WHERE filing_date >= '2026-07-08' AND filing_date <= '2026-07-09'
    GROUP BY ticker
)
WHERE ticker IN ('AMD', 'KLAC', 'LRCX', 'META', 'MSFT', 'MU', 'NVDA', 'TER', 'WDC')
GROUP BY ticker
ORDER BY ticker
Run this yourself →

0 artikel semalaman, 0 intrahari, 0 pemfailan SEC untuk KLAC — baris kosong yang sama untuk LRCX, TER dan WDC. NVDA, yang tidak pernah mengalami jurang, membawa liputan paling berat daripada sembilan saham tersebut (7 semalaman, 9 intrahari) dan ditutup merah. Ini adalah perhatian satu suapan, bukan media dunia, dan baris yang tiada bukanlah bukti ketiadaan peristiwa — tetapi tiada apa-apa dalam data kami menamakan punca, dan "punca tidak diketahui" adalah jawapan yang lengkap.

Papan skor

Setiap perubahan membandingkan bar minit terakhir sesi biasa 9 Julai dengan hari Rabu; baris disusun mengikut abjad, jadi setiap ETF kekal pada kedudukan tetap.

PertanyaanSPY / QQQ / DIA / IWM — 9 Julai berbanding penutupan 8 Julai, waktu biasa
SQL tepat di sebalik setiap nombor
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-07-08 13:30:00' AND window_start < '2026-07-08 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-07-09 13:30:00' AND window_start < '2026-07-09 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_open) / toFloat64(p.prior_close) - 1) * 100, 2) AS gap_pct,
    round((toFloat64(s.day_close) / toFloat64(s.day_open) - 1) * 100, 2) AS intraday_pct,
    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
FROM sess s LEFT JOIN prior p ON s.ticker = p.ticker
ORDER BY ticker
Run this yourself →

Keempat-empat ditutup hijau. QQQ mendahului pada +1.67% — jurang +0.99% ditambah kenaikan +0.68%; IWM bermodal kecil mencatat +1.29%, SPY +0.85% kepada $751.64, DIA ketinggalan pada +0.29%. Pertumbuhan di hadapan, Dow di belakang.

Adakah hari itu luar biasa?

Pada peringkat indeks, tidak: penutupan QQQ +1.67% berbanding penutupan sebelumnya berada di kedudukan 10 daripada 21 sesi terakhir mengikut saiz, manakala pergerakan SPY dari buka ke tutup berada di kedudukan 8 daripada 22. Drama sebenarnya terletak di antara kumpulan-kumpulan pada hari tersebut.

PertanyaanPergerakan hari SPY / QQQ dalam konteks menjejak (~22 sesi)
SQL tepat di sebalik setiap nombor
SELECT
    round(anyIf(cc_pct, ticker = 'QQQ' AND d = toDate('2026-07-09')), 2) AS qqq_close_over_close_pct,
    arrayCount(x -> x > abs(anyIf(cc_pct, ticker = 'QQQ' AND d = toDate('2026-07-09'))), groupArrayIf(abs(cc_pct), ticker = 'QQQ' AND d != toDate('2026-07-09'))) + 1 AS qqq_abs_move_rank,
    countIf(ticker = 'QQQ' AND isFinite(cc_pct)) AS qqq_sessions_compared,
    round(anyIf(oc_pct, ticker = 'SPY' AND d = toDate('2026-07-09')), 2) AS spy_open_to_close_pct,
    arrayCount(x -> x > abs(anyIf(oc_pct, ticker = 'SPY' AND d = toDate('2026-07-09'))), groupArrayIf(abs(oc_pct), ticker = 'SPY' AND d != toDate('2026-07-09'))) + 1 AS spy_abs_move_rank,
    countIf(ticker = 'SPY') AS spy_sessions_compared,
    toString(min(d)) AS first_session
FROM (
    SELECT ticker, d,
           if(isFinite(close_px / lagInFrame(close_px) OVER (PARTITION BY ticker ORDER BY d) - 1),
              (close_px / lagInFrame(close_px) OVER (PARTITION BY ticker ORDER BY d) - 1) * 100, NULL) AS cc_pct,
           oc_pct
    FROM (
        SELECT ticker, toDate(toTimeZone(window_start, 'America/New_York')) AS d,
               argMax(toFloat64(close), window_start) AS close_px,
               (argMax(toFloat64(close), window_start) / argMin(toFloat64(open), window_start) - 1) * 100 AS oc_pct
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('SPY', 'QQQ')
          AND window_start >= toDateTime('2026-06-08 13:30:00')
          AND window_start < toDateTime('2026-07-10 00:00:00')
          AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
        GROUP BY ticker, d
    )
)
Run this yourself →

Keluasan: sesi paling meluas minggu ini

PertanyaanKelompok pita cair: saham pendahulu 9 Julai berbanding 8 Julai, penapis $1M dagangan
SQL tepat di sebalik setiap nombor
SELECT
    countIf(close_9 > close_8 AND close_8 > 0 AND dv_9 >= 1000000) AS advancers,
    countIf(close_9 < close_8 AND close_8 > 0 AND dv_9 >= 1000000) AS decliners,
    countIf(close_9 = close_8 AND close_8 > 0 AND dv_9 >= 1000000) AS unchanged,
    countIf(close_8 > 0 AND close_9 > 0 AND dv_9 >= 1000000) AS liquid_tickers,
    countIf(close_8 > 0 AND close_9 > 0) AS traded_both_sessions,
    countIf(close_8 > 0 AND close_9 > 0) - countIf(close_8 > 0 AND close_9 > 0 AND dv_9 >= 1000000) AS dropped_by_liquidity_filter,
    round(100.0 * countIf(close_9 > close_8 AND close_8 > 0 AND dv_9 >= 1000000) / countIf(close_8 > 0 AND close_9 > 0 AND dv_9 >= 1000000), 1) AS advancer_pct,
    round(100.0 * countIf(close_8 > close_7 AND close_7 > 0 AND dv_8 >= 1000000) / countIf(close_8 > 0 AND close_7 > 0 AND dv_8 >= 1000000), 1) AS jul8_advancer_pct
FROM (
    SELECT ticker,
           toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-07 13:30:00' AND window_start < '2026-07-07 20:00:00')) AS close_7,
           toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 20:00:00')) AS close_8,
           toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00')) AS close_9,
           sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00') AS dv_9,
           sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 20:00:00') AS dv_8
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-07-07 13:30:00' AND window_start < '2026-07-09 20:00:00'
    GROUP BY ticker
)
Run this yourself →

4263 saham menaik berbanding 1631 saham menurun — bahagian saham menaik sebanyak 71.5% selepas 29.6% pada Rabu, pengiraan sama, penapis dagangan $1 juta yang sama (5385 daripada 11351 nama berada di bawahnya). Berbanding dengan minggu yang lain:

PertanyaanMinggu setakat ini: pergerakan indeks dan saham pendahulu bagi setiap sesi lengkap
SQL tepat di sebalik setiap nombor
WITH per_day AS (
    SELECT ticker,
           toDate(toTimeZone(window_start, 'America/New_York')) AS d,
           argMax(toFloat64(close), window_start) AS c,
           sum(toFloat64(close) * toFloat64(volume)) AS dv
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-09 20:00:00'
      AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
    GROUP BY ticker, d
),
lagged AS (
    SELECT ticker, d, c, dv,
           lagInFrame(c) OVER (PARTITION BY ticker ORDER BY d) AS prev_c
    FROM per_day
)
SELECT
    toString(d) AS date,
    round(anyIf((c / prev_c - 1) * 100, ticker = 'SPY'), 2) AS spy_pct,
    round(anyIf((c / prev_c - 1) * 100, ticker = 'QQQ'), 2) AS qqq_pct,
    round(100.0 * countIf(c > prev_c AND prev_c > 0 AND dv >= 1000000) / countIf(c > 0 AND prev_c > 0 AND dv >= 1000000), 1) AS advancer_pct,
    countIf(c > 0 AND prev_c > 0 AND dv >= 1000000) AS liquid_names
FROM lagged
WHERE d >= toDate('2026-07-06')
GROUP BY d
ORDER BY d
Run this yourself →

Isnin bermula dengan 62.4% saham menaik, Selasa dan Rabu merosot kepada 33.9% dan 29.6%, dan 71.4% Khamis adalah yang tertinggi daripada empat sesi minggu ini yang telah selesai (Jumaat 10 Julai selepas ringkasan ini). QQQ turut mengikutinya: -1.82% Selasa, 0.25% Rabu, +1.67% Khamis.

Di luar cip: bagaimana pasaran lain berdagang

Lebaran menunjukkan kebanyakan saham meningkat; ia tidak mengatakan kenaikan itu sekata. Di bawah: bakul berwajaran sama bagi tiga nama cair setiap sektor, bakul yang sama diisytiharkan setiap hari.

PertanyaanLapan bakul sektor diisytiharkan, tiga nama setiap satu: 9 Julai tutup-ke-tutup, wajaran sama
SQL tepat di sebalik setiap nombor
SELECT
    sector,
    count() AS names,
    round(avg(pct_chg), 2) AS avg_pct_chg,
    round(min(pct_chg), 2) AS worst_name_pct,
    round(max(pct_chg), 2) AS best_name_pct,
    round(avg(pct_chg) - max(avg(pct_chg)) OVER (), 2) AS gap_to_best_sector_pct
FROM (
    SELECT
        ticker,
        multiIf(ticker IN ('AMD', 'AVGO', 'KLAC'), 'Semiconductors',
                ticker IN ('AAPL', 'MSFT', 'GOOGL'), 'Big tech',
                ticker IN ('JPM', 'BAC', 'GS'), 'Financials',
                ticker IN ('CAT', 'HON', 'GE'), 'Industrials',
                ticker IN ('XOM', 'CVX', 'COP'), 'Energy',
                ticker IN ('JNJ', 'UNH', 'PFE'), 'Healthcare',
                ticker IN ('KO', 'PG', 'WMT'), 'Staples',
                'Utilities') AS sector,
        (toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00'))
         / toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 20:00:00')) - 1) * 100 AS pct_chg
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AMD', 'AVGO', 'KLAC', 'AAPL', 'MSFT', 'GOOGL', 'JPM', 'BAC', 'GS', 'CAT', 'HON', 'GE',
                     'XOM', 'CVX', 'COP', 'JNJ', 'UNH', 'PFE', 'KO', 'PG', 'WMT', 'NEE', 'DUK', 'SO')
      AND window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-09 20:00:00'
    GROUP BY ticker
)
GROUP BY sector
ORDER BY avg_pct_chg DESC
Run this yourself →

Semiconductors mendahului pada +4.24%, Energy ketinggalan pada -2.01% — spread -6.25 mata (gap_to_best_sector_pct). Kewangan adalah bakul bukan cip terkuat pada +1.88%; Staples (-0.91%), Utiliti (-0.96%) dan Tenaga ditutup merah. Teknologi besar (AAPL, MSFT dan GOOGL) purata +0.17% yang perlahan. Pembalikan terbesar hari itu dari buka ke tutup, ayunan META +8.1%, berada di luar lapan bakul; dalam bakul ini, bukaan MSFT -2.25% ke tutup +0.33% adalah perjalanan pusingan paling tajam.

Pembukaan semikonduktor, dan susulan pudar yang berlaku

gap_pct ialah harga pembukaan berbanding penutup Rabu; intraday_pct ialah baki hari tersebut. Baris disusun mengikut abjad.

PertanyaanEmpat belas nama cip: jurang pada pembukaan berbanding baki hari, 9 Julai
SQL tepat di sebalik setiap nombor
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-07-09 00:00:00')) AS prior_close,
        toFloat64(argMinIf(open, window_start, window_start >= '2026-07-09 00:00:00')) AS day_open,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-09 00:00:00')) AS day_close,
        maxIf(toFloat64(high), window_start >= '2026-07-09 00:00:00') AS day_high,
        minIf(toFloat64(low), window_start >= '2026-07-09 00:00:00') AS day_low,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-09 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AMD', 'AVGO', 'INTC', 'KLAC', 'LRCX', 'MRVL', 'MU', 'NVDA', 'SNDK', 'SOXL', 'SOXS', 'STX', 'TER', 'WDC')
      AND ((window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 20:00:00')
        OR (window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00'))
    GROUP BY ticker
)
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    round(day_open, 2) AS day_open,
    round(day_close, 2) AS day_close,
    round((day_open / prior_close - 1) * 100, 2) AS gap_pct,
    round((day_close / day_open - 1) * 100, 2) AS intraday_pct,
    round((day_close / prior_close - 1) * 100, 2) AS pct_chg,
    day_dollar_bn
FROM per_name
ORDER BY ticker
Run this yourself →

KLAC dibuka +8.14% di atas penutup Rabu, kemudian susut sebanyak -3.98%; LRCX dibuka +9.67% dan pudar sebanyak -3.26%; TER (+7.87%) dan WDC (+7.89%) menjejaki bentuk yang sama. MU melonjak +7.07%, merosot -2.56%, namun masih ditutup +4.33% pada 33.56B — nama paling berat dalam pita untuk sesi kedua (ringkasan semula Rabu mempunyai yang pertama). AMD dan SNDK merupakan pengecualian: AMD menambah 1.75% selepas pembukaan +3.87% untuk ditutup +5.68%, dan SNDK, yang sudah +6.14% pada pembukaan, menambah 1.23% lagi untuk ditutup +7.45%. Dan NVDA: pembukaan +0.16% — tanpa jurang — ke arah penutup -0.68%.

PertanyaanResit: kiraan hijau/merah 9 Julai merentas empat belas nama, dan pusingan dua hari NVDA
SQL tepat di sebalik setiap nombor
SELECT
    countIf(close_9 > close_8) AS jul9_green,
    countIf(close_9 < close_8) AS jul9_red,
    countIf(close_8 > close_7) AS jul8_green,
    round(anyIf((close_9 / close_8 - 1) * 100, ticker = 'NVDA'), 2) AS nvda_jul9_pct,
    round(anyIf((close_8 / close_7 - 1) * 100, ticker = 'NVDA'), 2) AS nvda_jul8_pct,
    count() AS names_counted
FROM (
    SELECT ticker,
           toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-07 13:30:00' AND window_start < '2026-07-07 20:00:00')) AS close_7,
           toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 20:00:00')) AS close_8,
           toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00')) AS close_9
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AMD', 'AVGO', 'INTC', 'KLAC', 'LRCX', 'MRVL', 'MU', 'NVDA', 'SNDK', 'SOXL', 'SOXS', 'STX', 'TER', 'WDC')
      AND window_start >= '2026-07-07 13:30:00' AND window_start < '2026-07-09 20:00:00'
    GROUP BY ticker
)
Run this yourself →

12 daripada empat belas ditutup hijau; 2 penutup merah merupakan pembalut songsang — berstruktur pada hari menaik — dan NVDA pada -0.68%, sehari selepas ditutup +3.66%. Nama cip terbesar dalam pita itu tidak menyertai sambutan sektor sendiri sambil membawa liputan berita paling berat.

Sebaliknya: saham mega-cap dibuka rendah dan kemudian meningkat semula

PertanyaanLapan mega-cap dan defensif: jurang pada pembukaan berbanding baki hari, 9 Julai
SQL tepat di sebalik setiap nombor
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-07-09 00:00:00')) AS prior_close,
        toFloat64(argMinIf(open, window_start, window_start >= '2026-07-09 00:00:00')) AS day_open,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-09 00:00:00')) AS day_close,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-09 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL', 'AMZN', 'CVX', 'GOOGL', 'JNJ', 'META', 'MSFT', 'TSLA')
      AND ((window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 20:00:00')
        OR (window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00'))
    GROUP BY ticker
)
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    round(day_open, 2) AS day_open,
    round(day_close, 2) AS day_close,
    round((day_open / prior_close - 1) * 100, 2) AS gap_pct,
    round((day_close / day_open - 1) * 100, 2) AS intraday_pct,
    round((day_close / prior_close - 1) * 100, 2) AS pct_chg,
    day_dollar_bn
FROM per_name
ORDER BY ticker
Run this yourself →

Tujuh daripada lapan saham dibuka di bawah harga penutup Rabu; apa yang berlaku seterusnya membezakan mereka. META dibuka turun -3.16% dan kemudian melonjak +8.1% ke paras penutup 4.69% — pembalikan daripada bukaan ke penutup yang paling dramatik di halaman ini. MSFT dibuka turun -2.25% dan pulih kepada +0.33%; AMZN (+1.4%) dan AAPL (+0.93%) mengikut corak yang sama; TSLA tidak pernah mengalami jurang harga dan meningkat kepada +3.21%. Nama yang kekal rendah bukanlah saham pertumbuhan: GOOGL (-0.76%), CVX (-1.06%), JNJ (-1.62%). Kenapa saham melonjak semalaman menerangkan mekanismenya.

Tempat wang didagangkan

Pertanyaan6 teratas mengikut dolar dagangan, 4 teratas mengikut saham dagangan — waktu biasa 9 Julai
SQL tepat di sebalik setiap nombor
SELECT leaderboard, ticker, dollar_volume_bn, shares_m,
    round(1000 * dollar_volume_bn / shares_m, 2) AS implied_avg_price,
    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(volume)) / 1e6, 1) AS shares_m
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 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(volume)) / 1e6, 1) AS shares_m
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00'
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
    ORDER BY shares_m DESC
    LIMIT 4
)
ORDER BY leaderboard, pct_of_board_leader DESC
Run this yourself →

MU mendahului papan dolar sekali lagi pada 33.56B, mengatasi SPY (24.37B), NVDA (21.28B) dan SNDK (20.59B) — memori dalam dua daripada empat slot teratas. Papan saham adalah pasaran yang berbeza: SOXS mendahului pada 558.1M saham, harga tersirat $3.91 (volume relatif).

PertanyaanSaham setiap baldi 30 minit ET, waktu biasa, dengan % baldi terbesar hari itu
SQL tepat di sebalik setiap nombor
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-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00'
GROUP BY et_time
ORDER BY et_time
Run this yourself →

U berbentuk buku teks: baldi pembukaan menjalankan 1.79B saham (91.4% daripada yang terbesar), palung tengah hari 0.64B, dan lelongan penutup setengah jam adalah yang terbesar pada hari itu pada 1.96B. Walaupun pada hari yang dibuat pada pembukaannya, volume berakhir pada penutup.

Pita opsyen

PertanyaanPita opsyen: cetakan, kontrak, % panggilan, bahagian 0DTE berbanding Rabu, kontrak teratas
SQL tepat di sebalik setiap nombor
WITH
    (
        SELECT (groupArray(und), groupArray(strike), groupArray(typ), groupArray(vol), groupArray(avg_px), groupArray(is_0dte))
        FROM (
            SELECT any(underlying_symbol) AS und, any(toFloat64(strike_price)) AS strike, any(option_type) AS typ,
                   sum(size) AS vol, round(avg(toFloat64(price)), 3) AS avg_px,
                   if(substring(ticker, length(ticker) - 14, 6) = '260709', 1, 0) AS is_0dte
            FROM global_markets.options_trades
            WHERE sip_timestamp >= '2026-07-09 00:00:00' AND sip_timestamp < '2026-07-10 00:00:00'
            GROUP BY ticker
            ORDER BY vol DESC
            LIMIT 3
        )
    ) AS top3,
    (
        SELECT round(toFloat64(argMax(close, window_start)), 2)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY' AND window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00'
    ) AS spy_regular_close,
    (
        SELECT round(toFloat64(sum(size)) / 1e6, 2)
        FROM global_markets.options_trades
        WHERE sip_timestamp >= '2026-07-08 00:00:00' AND sip_timestamp < '2026-07-09 00:00:00'
    ) AS jul8_contracts_m,
    (
        SELECT round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260708') / sum(size), 1)
        FROM global_markets.options_trades
        WHERE sip_timestamp >= '2026-07-08 00:00:00' AND sip_timestamp < '2026-07-09 00:00:00'
    ) AS jul8_pct_0dte
SELECT
    round(count() / 1e6, 2) AS option_prints_m,
    round(toFloat64(sum(size)) / 1e6, 2) AS contracts_m,
    jul8_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) = '260709') / sum(size), 1) AS pct_0dte,
    jul8_pct_0dte,
    spy_regular_close,
    top3.1[1] AS top1_und, top3.2[1] AS top1_strike, top3.3[1] AS top1_type,
    round(toFloat64(top3.4[1]) / 1e3, 1) AS top1_contracts_k, top3.5[1] AS top1_avg_px, top3.6[1] AS top1_is_0dte,
    top3.1[2] AS top2_und, top3.2[2] AS top2_strike, top3.3[2] AS top2_type, top3.6[2] AS top2_is_0dte,
    top3.1[3] AS top3_und, top3.2[3] AS top3_strike, top3.3[3] AS top3_type, top3.6[3] AS top3_is_0dte,
    round(toFloat64(top3.2[1]) - spy_regular_close, 2) AS top1_moneyness
FROM global_markets.options_trades
WHERE sip_timestamp >= '2026-07-09 00:00:00' AND sip_timestamp < '2026-07-10 00:00:00'
Run this yourself →

Pita tersebut membawa 9.99M cetakan dan 58.85M kontrak — di bawah 63.26M hari Rabu — panggilan pada 58% daripada volum, bahagian 0DTE turun kepada 28.7% daripada 38.7%. Tiga kontrak paling sibuk semuanya adalah panggilan SPY hari sama — 751C (846.6K kontrak, purata $0.526), 752C dan 750C — satu tangga di sekitar penutupan SPY $751.64 (opsyen 0DTE merangkumi produk tersebut).

Lindung nilai atau pertaruhan? Lindung nilai membeli strike jauh daripada wang; pertaruhan membeli pihak yang dikehendaki.

PertanyaanOpsyen SPY hari sama (0DTE): kontrak mengikut jarak mogok dari harga penutupan
SQL tepat di sebalik setiap nombor
WITH (
    SELECT toFloat64(argMax(close, window_start))
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY' AND window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00'
) AS spy_close
SELECT
    multiIf(dist < -2, 'Strike >2% below close',
            dist < -0.5, 'Strike 0.5-2% below',
            dist <= 0.5, 'Strike within 0.5%',
            dist <= 2, 'Strike 0.5-2% above',
            'Strike >2% above close') AS strike_bucket,
    round(toFloat64(sumIf(size, option_type = 'C')) / 1e3, 1) AS call_contracts_k,
    round(toFloat64(sumIf(size, option_type = 'P')) / 1e3, 1) AS put_contracts_k,
    round(100.0 * sumIf(size, option_type = 'C') / sum(size), 1) AS call_share_pct
FROM (
    SELECT option_type, size, (toFloat64(strike_price) / spy_close - 1) * 100 AS dist
    FROM global_markets.options_trades
    WHERE sip_timestamp >= '2026-07-09 00:00:00' AND sip_timestamp < '2026-07-10 00:00:00'
      AND underlying_symbol = 'SPY'
      AND substring(ticker, length(ticker) - 14, 6) = '260709'
)
GROUP BY strike_bucket
ORDER BY min(dist)
Run this yourself →

Pita hari sama berada pada wang: 3768.9k panggilan dan 2563.3k letak dalam lingkungan setengah peratus daripada penutupan (59.5% panggilan). Sayap terbahagi mengikut arah — di bawah penutupan, 1356.5k letak berbanding 255.4k panggilan (1.2% bahagian panggilan lebih dalam ke bawah); di atasnya, panggilan mengambil 91.6% daripada baldi 29.1k yang jauh lebih nipis. Volum sayap terletak pada strike sisi bawah, tempat perlindungan nilai dibeli: satu tangga pada wang, bukan tangga sisi atas.

Pita sebut harga

PertanyaanKiraan kemas kini NBBO saham: 9 Julai berbanding 8 Julai, dengan kemas kini ticker bernama (juta)
SQL tepat di sebalik setiap nombor
SELECT
    round(countIf(toDate(sip_timestamp) = toDate('2026-07-09')) / 1e6, 2) AS jul9_updates_m,
    round(countIf(toDate(sip_timestamp) = toDate('2026-07-08')) / 1e6, 2) AS jul8_updates_m,
    round((countIf(toDate(sip_timestamp) = toDate('2026-07-09')) / countIf(toDate(sip_timestamp) = toDate('2026-07-08')) - 1) * 100, 1) AS day_over_day_pct,
    round(countIf(toDate(sip_timestamp) = toDate('2026-07-09') AND ticker = 'SPY') / 1e6, 2) AS jul9_spy_updates_m,
    round(countIf(toDate(sip_timestamp) = toDate('2026-07-09') AND ticker = 'QQQ') / 1e6, 2) AS jul9_qqq_updates_m,
    round(countIf(toDate(sip_timestamp) = toDate('2026-07-09') AND ticker = 'NVDA') / 1e6, 2) AS jul9_nvda_updates_m,
    round(countIf(toDate(sip_timestamp) = toDate('2026-07-09') AND ticker = 'TSLA') / 1e6, 2) AS jul9_tsla_updates_m,
    round(countIf(toDate(sip_timestamp) = toDate('2026-07-09') AND ticker = 'MU') / 1e6, 2) AS jul9_mu_updates_m
FROM global_markets.cache_stocks_quotes
WHERE sip_timestamp >= '2026-07-08 00:00:00' AND sip_timestamp < '2026-07-10 00:00:00'
Run this yourself →

Fakta paling senyap hari ini: 383.44M kemas kini NBBO pada pita saham, -27.7% berbanding Rabu. Keganasan berlaku pada tahap harga, bukan pada pusing ganti di sentuhan. QQQ mendahului ticker bernama pada 4.35M, mengatasi 2.71M SPY dan 1.83M NVDA.

PertanyaanSPY / QQQ / NVDA / TSLA / MU / SNDK / AVGO: median sebaran sebut harga RTH dalam mata asas
SQL tepat di sebalik setiap nombor
SELECT
    ticker,
    round(quantileExact(0.5)((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000), 2) AS median_spread_bps
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('SPY', 'QQQ', 'NVDA', 'TSLA', 'MU', 'SNDK', 'AVGO')
  AND sip_timestamp >= '2026-07-09 13:30:00' AND sip_timestamp < '2026-07-09 20:00:00'
  AND bid_price > 0 AND ask_price > 0 AND ask_price > bid_price
GROUP BY ticker
ORDER BY median_spread_bps ASC
Run this yourself →

Spread sebut harga median SPY tercatat 0.27 bps, QQQ 0.42, NVDA 0.99 — angka biasa. Ekor yang lebih lebar: MU pada 4.23 bps, SNDK pada 8.79 bps (spread bida-tawaran ialah kos yang diukur ini).

PertanyaanPurata sebaran sebut harga RTH SPY dalam konteks bulan menjejak
SQL tepat di sebalik setiap nombor
SELECT
    round(anyIf(avg_spread_cents, d = toDate('2026-07-09')), 3) AS jul9_avg_spread_cents,
    arrayCount(x -> x < anyIf(avg_spread_cents, d = toDate('2026-07-09')), groupArrayIf(avg_spread_cents, d != toDate('2026-07-09'))) + 1 AS tightness_rank,
    count() AS sessions_compared,
    round(min(avg_spread_cents), 3) AS tightest_session_cents,
    round(max(avg_spread_cents), 3) AS widest_session_cents,
    toString(min(d)) AS first_session
FROM (
    SELECT toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS d,
           avgIf(toFloat64(ask_price - bid_price), bid_price > 0 AND ask_price >= bid_price) * 100 AS avg_spread_cents
    FROM global_markets.cache_stocks_quotes
    WHERE ticker = 'SPY'
      AND sip_timestamp >= toDateTime('2026-06-08 00:00:00')
      AND sip_timestamp < toDateTime('2026-07-10 00:00:00')
      AND (toHour(sip_timestamp) * 60 + toMinute(sip_timestamp)) BETWEEN 810 AND 1199
    GROUP BY d
)
Run this yourself →

Purata spread sebut harga SPY sebanyak 2.071 sen berada di kedudukan 10 daripada 22 sesi sebelumnya, dalam julat 1.809–2.865 sen: tiada tekanan pada sebut harga, walaupun pada pembukaan itu.

PertanyaanPita NBBO opsyen: jumlah kemas kini berbanding pita saham, ditambah hirisan akar SPY
SQL tepat di sebalik setiap nombor
WITH
    (SELECT count() FROM global_markets.cache_options_quotes WHERE sip_timestamp >= '2026-07-09 00:00:00' AND sip_timestamp < '2026-07-10 00:00:00') AS jul9_options_rows,
    (SELECT count() FROM global_markets.cache_stocks_quotes WHERE sip_timestamp >= '2026-07-09 00:00:00' AND sip_timestamp < '2026-07-10 00:00:00') AS jul9_stock_quote_rows
SELECT
    round(jul9_options_rows / 1e9, 2) AS jul9_options_bn,
    round(jul9_options_rows / jul9_stock_quote_rows, 1) AS options_to_stock_ratio,
    round((SELECT count() FROM global_markets.cache_options_quotes WHERE ticker >= 'O:SPY26' AND ticker < 'O:SPY27' AND sip_timestamp >= '2026-07-09 13:30:00' AND sip_timestamp < '2026-07-09 20:00:00') / 1e6, 0) AS jul9_spy_options_m
Run this yourself →

Pita sebut harga opsyen membawa 6.9 bilion kemas kini NBBO — 18× ganda pita saham, akar SPY sahaja pada 242M.

Kadar: cetakan 9 Julai

PertanyaanStatus cetakan Treasury: baris 9 Julai pada rekod, dan keluk 8 Julai (terkini semasa pengarangan)
SQL tepat di sebalik setiap nombor
SELECT
    (SELECT count() FROM global_markets.treasury_yields WHERE date = '2026-07-09') AS jul9_print_rows,
    toString(any(date)) AS latest_print_date,
    round(toFloat64(any(yield_2_year)), 2) AS latest_2y_pct,
    round(toFloat64(any(yield_10_year)), 2) AS latest_10y_pct,
    round(toFloat64(any(yield_30_year)), 2) AS latest_30y_pct,
    round(toFloat64(any(yield_10_year)) - toFloat64(any(yield_2_year)), 2) AS latest_2s10s_pct
FROM global_markets.treasury_yields
WHERE date = '2026-07-09'
Run this yourself →

Cetakan perbendaharaan 9 Julai tiba selepas penulisan, pada ketinggalan biasa fail hasil harian — baris 1 kini direkodkan. Keluk hari tersebut (2026-07-09): 2-tahun 4.16%, 10-tahun 4.54%, 30-tahun 5.05%, 2s10s 0.38 mata — kadar 2-tahun mengendur daripada paras 8 Julai manakala hujung panjang kekal.

Kalendar di sebalik hari ini

PertanyaanEx-div, pecahan, pemfailan SEC, perhatian berita
SQL tepat di sebalik setiap nombor
WITH
    (
        SELECT (count(), uniqExact(publisher))
        FROM global_markets.stocks_news
        WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-07-09'
    ) AS news,
    (
        SELECT (argMax(t, (n, t)), max(n), max(n) - arraySort(x -> -x, groupArray(n))[2])
        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-07-09'
            )
            WHERE t != 'SPCX'
            GROUP BY t
        )
    ) AS top_news
SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-07-09') AS ex_dividend_records,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date = '2026-07-09') AS splits_executed,
    (SELECT countIf(toFloat64(split_from) > toFloat64(split_to)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-09') AS reverse_splits,
    (SELECT countIf(toFloat64(split_to) > toFloat64(split_from)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-09') AS forward_splits,
    (SELECT countIf(form_type = '424B2') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-09') AS fil_424b2,
    (SELECT countIf(form_type = '4') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-09') AS fil_form4,
    (SELECT countIf(form_type = '8-K') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-09') AS fil_8k,
    (SELECT count() FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-09') AS fil_total,
    news.1 AS news_articles, news.2 AS news_publishers,
    top_news.1 AS top_news_ticker, top_news.2 AS top_news_n, top_news.3 AS top_news_lead_over_next,
    if(top_news.1 = 'NVDA', 1, 0) AS top_news_is_nvda
Run this yourself →

Kalendar biasa di bawah pembukaan yang luar biasa: 127 rekod ex-dividen, 5 belahan saham songsang, 1 belahan saham ke hadapan, 2981 pemfailan SEC (623 Borang 4, 606 424B2, 149 8-K). Suapan tersebut menjalankan 184 artikel merentasi 3 penerbit; ticker paling banyak diliputi NVDA, 20 artikel, 8 mendahului nama seterusnya.

Atur cara

Daripada jadual kami sendiri — fakta tentang sesi akan datang, bukan ramalan.

PertanyaanAkan datang: sesi seterusnya, senarai ex-dividennya, tangga luput SPY, dan jam faedah pendek
SQL tepat di sebalik setiap nombor
SELECT
    toString(min(d)) AS next_session_date,
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date = '2026-07-10') AS next_session_holiday_rows,
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-07-10') AS ex_div_records_next,
    (SELECT countIf(ticker IN ('AAPL', 'MSFT', 'JNJ', 'KO', 'PG', 'XOM', 'CVX', 'JPM', 'WMT', 'PEP', 'HON', 'CAT'))
     FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-07-10') AS household_ex_div_next,
    (SELECT round(toFloat64(sum(size)) / 1e6, 2) FROM global_markets.options_trades
     WHERE sip_timestamp >= '2026-07-09 00:00:00' AND sip_timestamp < '2026-07-10 00:00:00'
       AND underlying_symbol = 'SPY' AND substring(ticker, length(ticker) - 14, 6) = '260710') AS spy_next_expiry_contracts_m,
    (SELECT round(toFloat64(sum(size)) / 1e6, 2) FROM global_markets.options_trades
     WHERE sip_timestamp >= '2026-07-09 00:00:00' AND sip_timestamp < '2026-07-10 00:00:00'
       AND underlying_symbol = 'SPY' AND substring(ticker, length(ticker) - 14, 6) = '260717') AS spy_monthly_expiry_contracts_m,
    (SELECT toString(max(settlement_date)) FROM global_markets.stocks_short_interest
     WHERE _ingest_time < '2026-07-11 00:00:00') AS latest_short_settlement,
    (SELECT count() FROM global_markets.stocks_short_interest
     WHERE settlement_date = '2026-07-15' AND _ingest_time < '2026-07-11 00:00:00') AS jul15_short_rows
FROM (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY' AND window_start >= '2026-07-10 00:00:00' AND window_start < '2026-07-14 00:00:00'
)
Run this yourself →

Sesi akan datang ialah 2026-07-10, 0 baris cuti bertentangan dengannya: Jumaat biasa. 153 syarikat menjadi ex-dividen pada pagi itu, 0 daripada senarai semak nama terkenal kami. Tamat tempoh SPY pada hari Jumaat adalah yang paling berat ke hadapan yang telah didagangkan — 1.66M kontrak pada 9 Julai berbanding 0.57M menentang bulanan Julai. Jam faedah pendek: penyelesaian terkini dalam fail 2026-06-15, 0 baris belum difailkan untuk pertengahan Julai — FINRA menerbitkan kira-kira lapan hari perniagaan selepas penyelesaian (kenapa faedah pendek berusia dua minggu).

Sesi, disahkan

PertanyaanPengesahan sesi: bar SPY pertama/terakhir ET, kiraan bar biasa, resit cuti, penutupan seterusnya
SQL tepat di sebalik setiap nombor
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-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00') AS regular_session_bars,
    uniqExactIf(toDate(toTimeZone(window_start, 'America/New_York')), window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00') AS day_sessions,
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date = '2026-07-09') AS jul9_holiday_rows,
    (SELECT toString(min(date)) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-09' AND status = 'closed') AS next_closure_date,
    (SELECT concat(monthName(min(date)), ' ', toString(toDayOfMonth(min(date))), ', ', toString(toYear(min(date))))
     FROM global_markets.stocks_market_holidays WHERE date > '2026-07-09' AND status = 'closed') AS next_closure_label,
    (SELECT argMin(name, date) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-09' AND status = 'closed') AS next_closure_name
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= '2026-07-09 00:00:00' AND window_start < '2026-07-10 00:00:00'
Run this yourself →

Sesi biasa penuh: bar SPY pertama 04:00 ET, terakhir 19:59 ET, 390 bar minit biasa, tiada baris cuti. Penutupan seterusnya: Labor Day, September 7, 2026.

Soalan Lazim

Apa yang berlaku di pasaran saham pada 9 Julai 2026?

Setiap ETF indeks ditutup lebih tinggi — QQQ +1.67%, IWM +1.29%, SPY +0.85%, DIA +0.29%, 71.5% saham cair naik. Saham peralatan cip melonjak pada pembukaan lalu menurun; saham mega-cap jatuh pada pembukaan lalu pulih.

Mengapa saham peralatan cip seperti KLAC dan LRCX melonjak pada 9 Julai 2026?

Data kami tidak menyatakan sebab: tiada artikel dan tiada pemfailan SEC untuk KLAC, LRCX, TER atau WDC dari penutupan Rabu hingga Khamis. Pergerakan itu sudah pun ditetapkan harga sebelum pasaran dibuka, sebelum 9:30 pagi ET.

Mengapa NVDA jatuh sedangkan sektor cip melonjak?

NVDA ditutup -0.68% manakala 12 daripada empat belas saham cip ditutup hijau. Ia tidak pernah melonjak pada pembukaan (0.16% pada pembukaan) dan merupakan ticker paling banyak diliputi dengan 20 artikel — kejadian bersama adalah rekod, puncanya tiada dalam data ini.

Adakah 9 Julai 2026 hari yang luar biasa bagi pasaran?

Tidak pada tahap indeks: pergerakan QQQ berada pada kedudukan 10 daripada 21 sesi sebelumnya mengikut saiz, spread purata SPY 10 daripada 22. Serakan di bawahnya adalah: -6.25 mata antara bakul sektor terbaik dan terburuk.

Nota data

Waktu dagang biasa ialah 13:30–20:00 UTC (9:30 pagi–4:00 petang ET); panel prapasaran menggunakan 08:00–13:30 UTC. Lapan bakul sektor ini dikurasi dan diberat sama — tiga saham cair setiap satu, setiap ticker disenaraikan dalam SQL panel tersebut. Itu adalah kaedah yang diisytiharkan, bukan klasifikasi vendor: tiga nama itu mewakili diri mereka sendiri, bukan keseluruhan sektor. Panel pemangkin hanya mengira suapan berita kami dan indeks EDGAR.

Nota data penuh

Panel setiap ticker adalah mengikut abjad, jadi setiap rujukan prosa merujuk kepada baris tetap; papan pendahulu diisih mengikut nilai, setiap tuntutan kedudukan adalah terbatas. Cetakan perbendaharaan dan penyelesaian jualan pendek pertengahan Julai adalah terbatas kepada sifar baris — ketibaan mereka menahan siaran ini untuk penulisan semula.

Metodologi

  • Sumber: SQL setiap panel menamakan jadualnya sendiri — agregat minit, cache NBBO saham dan opsyen, dagangan opsyen, suapan berita kami, indeks EDGAR, dividen, faedah pendek, cuti umum, hasil perbendaharaan.
  • Konvensyen: literal UTC mentah dalam WHERE, label ET hanya dalam SELECT; jurang = bukaan palang biasa pertama ÷ tutup biasa sebelumnya − 1; angka sesi sebelumnya dan minggu sebelumnya dikira dalam pertanyaan, tidak pernah dibawa dari siaran terdahulu. Gudang data setakat 13 Julai 2026.
#recap#daily#spy#qqq#semiconductors#market structure