Strasmore Research
Market recaps Matt ConnorNi Matt Connor · Na-update noong 2026-07-25

market recap july 9 2026 numbers

Chip equipment gapped up at opening, then faded. Mega-caps gapped down, recovered. Market closed decisively green. NVDA ended red despite earlier gains.

Huwebes, Hulyo 9, 2026 — ang karahasan ng araw na iyon ay sumiksik sa isang minuto — at ang minutong iyon ay dumating bago ang opening bell. Ang mga pangalan ng chip-equipment ay nasa malayo na sa itaas ng pagsasara ng Miyerkules sa premarket trade, habang ang META ay nasa -3.16% na mas mababa rito; kinumpirma ng 9:30 print ang pareho. Pagkatapos ay bahagyang binawi ng araw ang sarili nitong pagbubukas: ang mga chip gaps ay kumupas, umakyat pabalik ang META, at ang tape ay nagsara ng 71.5% na berde — ang pinakamalawak na sesyon ng linggo. Ang NVDA, berde sa buong pagtakbo ng Martes, ay nagsara ng pula. Bawat numero sa ibaba ay binabasa mula sa isang stored query.

Ano ang nag-set up ng opening

Ang mga gap ay hindi nangyari noong 9:30. Sa pagitan ng 4:00 am at 9:29 am ET, ang premarket tape ay nag-reprice na sa mga pangalang ito, at ang opening print ay bumagsak sa antas na iyon.

QueryPremarket path, 4:00-9:29 am ET: last premarket print vs Wednesday's close, and the open that followed
Ang eksaktong SQL sa likod ng bawat numero
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

Ang huling premarket print ng KLAC ay +8.49% kumpara sa close noong Miyerkules at ito ay nag-open ng +8.14%; ang LRCX ay tumakbo ng +9.64% papunta sa +9.67% na opening; ang META ay nag-print ng -3.16% at nag-open ng -3.16%. Basahin ang open_vs_premkt_pct: lahat ng anim ay nag-open sa loob ng isang porsyento ng kanilang huling premarket price. Si NVDA ang kakaiba — 0.16% overnight sa 3741.7k na shares, ang pinakamabigat na premarket volume sa anim at ang pinakamaliit na galaw (premarket at after-hours trading).

Mayroon bang katalista? Walang pinangalanan ang aming datos

Dapat sabihin ng isang recap kung ano ang nagpagalaw sa isang stock. Dito, walang pinangalanan ang aming mga talahanayan: walang laman ang news feed at ang SEC filing index para sa apat na pangalang may pinakamalaking gap.

QueryNamed catalysts on file: news articles and SEC filings per name, Wednesday's close through Thursday's
Ang eksaktong SQL sa likod ng bawat numero
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

0 artikulo magdamag, 0 intraday, 0 SEC filing para sa KLAC — parehong walang laman ang row para sa LRCX, TER at WDC. Ang NVDA, na hindi nag-gap, ang may pinakamabigat na coverage sa siyam (7 magdamag, 9 intraday) at nagsara nang pula. Ito ay atensyon ng isang feed lamang, hindi ng buong mundo, at ang isang nawawalang row ay hindi patunay ng kawalan ng isang pangyayari — ngunit walang pinangalanang dahilan ang aming datos, at ang "hindi alam ang dahilan" ay isang kumpletong sagot.

Ang scoreboard

Bawat pagbabago ay paghahambing ng huling regular-session minute bar noong Hulyo 9 sa Miyerkules; alphabetical ang pagkakasunod-sunod ng mga row, kaya nananatili sa nakapirming pwesto ang bawat ETF.

QuerySPY / QQQ / DIA / IWM — July 9 vs the July 8 close, regular hours
Ang eksaktong SQL sa likod ng bawat numero
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

Lahat ng apat ay nagsara na berde. QQQ ang nanguna sa +1.67% — isang +0.99% gap na sinundan ng +0.68% na pag-akyat; ang small-cap na IWM ay kumuha ng +1.29%, SPY +0.85% hanggang $751.64, DIA ang nahuli sa +0.29%. Nanguna ang growth, nahuli ang Dow.

Hindi ba pangkaraniwan ang araw?

Sa antas ng index, hindi: ang +1.67% na close-over-close ng QQQ ay nasa 10 sa 21 na nakaraang sesyon ayon sa laki, at ang open-to-close ng SPY ay 8 sa 22. Ang drama ay nasa pagitan ng mga grupo ng araw.

QuerySPY / QQQ day move in trailing context (~22 sessions)
Ang eksaktong SQL sa likod ng bawat numero
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
    )
)

Lawak: ang pinakamalawak na sesyon ng linggo

QueryLiquid-tape breadth: July 9 advancer share vs July 8, $1M-traded filter
Ang eksaktong SQL sa likod ng bawat numero
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
)

4263 na sumulong laban sa 1631 na bumaba — isang bahagi ng sumulong na 71.5% pagkatapos ng 29.6% noong Miyerkules, parehong kalkulasyon, parehong $1M-traded filter (5385 ng 11351 na pangalan ay nasa ilalim nito). Laban sa natitirang bahagi ng linggo:

QueryThe week so far: index moves and advancer share for each completed session
Ang eksaktong SQL sa likod ng bawat numero
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

Ang Lunes ay nagsimula sa 62.4% na sumulong, ang Martes at Miyerkules ay bumagsak sa 33.9% at 29.6%, at ang Huwebes na 71.4% ang pinakamataas sa apat na natapos na sesyon ng linggo (ang Biyernes Hulyo 10 ay pagkatapos ng recap na ito). Sinundan din ito ng QQQ: -1.82% noong Martes, 0.25% noong Miyerkules, +1.67% noong Huwebes.

Lampas sa chips: kung paano nag-trade ang iba pang bahagi ng merkado

Sinasabi ng breadth na karamihan ng stocks ay tumaas; hindi nito sinasabi na pantay ang rally. Sa ibaba: isang equal-weighted basket ng tatlong likidong pangalan bawat sektor, ang parehong deklaradong basket araw-araw.

QueryEight declared sector baskets, three names each: July 9 close-over-close, equal-weighted
Ang eksaktong SQL sa likod ng bawat numero
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

Semiconductors ang nanguna sa +4.24%, habang Energy ang nahuli sa -2.01% — isang -6.25-point spread (gap_to_best_sector_pct). Ang Financials ang pinakamalakas na non-chip basket sa +1.88%; ang Staples (-0.91%), Utilities (-0.96%) at Energy ay nagsara sa pula. Ang big tech (AAPL, MSFT at GOOGL) ay nag-average ng mahinang +0.17%. Ang pinakamalaking open-to-close reversal ng araw, ang +8.1% swing ng META, ay nasa labas ng lahat ng walong basket; sa loob ng isang ito, ang -2.25% open ng MSFT na naging +0.33% close ang pinakamatarik na round trip.

Ang pagbubukas ng semiconductor, at ang pagbaba na sumunod

gap_pct ang pagbubukas kumpara sa pagsasara ng Miyerkules; intraday_pct ang natitirang bahagi ng araw. Ang mga hilera ay naka-alpabeto.

QueryFourteen chip names: gap at the open vs the rest of the day, July 9
Ang eksaktong SQL sa likod ng bawat numero
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

KLAC ay nagbukas ng +8.14% higit sa pagsasara ng Miyerkules, pagkatapos ay bumalik ng -3.98%; LRCX ay nagbukas ng +9.67% at bumaba ng -3.26%; TER (+7.87%) at WDC (+7.89%) ay sumunod sa parehong hugis. MU ay nag-gap ng +7.07%, bumaba ng -2.56%, ngunit nagsara pa rin ng +4.33% sa 33.56B — ang pinakamabigat na pangalan sa tape para sa ikalawang sesyon (ang buod ng Miyerkules ang may una). AMD at SNDK ang mga eksepsiyon: Nagdagdag ang AMD ng 1.75% pagkatapos ng +3.87% na pagbubukas upang matapos ng +5.68%, at ang SNDK, na +6.14% na sa pagbubukas, ay nagdagdag ng isa pang 1.23% upang magsara ng +7.45%. At NVDA: isang +0.16% na pagbubukas — walang gap — patungo sa -0.68% na pagsasara.

QueryReceipts: July 9 green/red counts across the fourteen names, and NVDA's two-day turn
Ang eksaktong SQL sa likod ng bawat numero
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
)

12 sa labing-apat ay nagsara ng berde; ang 2 na pulang pagsasara ay ang kabaligtaran na balot — istruktural sa isang araw ng pagtaas — at ang NVDA sa -0.68%, isang araw pagkatapos magsara ng +3.66%. Ang pinakamalaking pangalan ng chip sa tape ay hindi sumali sa sarili nitong selebrasyon ng sektor habang dinadala ang pinakamabigat na saklaw ng balita nito.

Ang kabilang panig: bumaba ang mega-caps sa pagbubukas at umakyat pabalik

QueryEight mega-caps and defensives: gap at the open vs the rest of the day, July 9
Ang eksaktong SQL sa likod ng bawat numero
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

Pito sa walo ang bumaba kumpara sa pagsasara ng Miyerkules; ang sumunod ang naghiwalay sa kanila. META ay bumukas ng -3.16% pababa at umakyat ng +8.1% tungo sa pagsasara ng 4.69% — ang pinakamarahas na pagbaliktad mula pagbubukas hanggang pagsasara sa pahina. MSFT ay bumukas ng -2.25% pababa at bumangon sa +0.33%; sinundan din ito ng AMZN (+1.4%) at AAPL (+0.93%); TSLA ay hindi nag-gap at umakyat sa +3.21%. Ang mga pangalang nanatiling bumababa ay hindi growth: GOOGL (-0.76%), CVX (-1.06%), JNJ (-1.62%). Bakit nag-gap ang stocks magdamag ang nagpapaliwanag ng mekanismo.

Kung saan nag-trade ang pera

QueryTop 6 by dollars traded, top 4 by shares traded — July 9 regular hours
Ang eksaktong SQL sa likod ng bawat numero
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

MU ang nanguna sa dollar board muli sa 33.56B, higit sa SPY (24.37B), NVDA (21.28B) at SNDK (20.59B) — memorya sa dalawa sa apat na pinakamataas na puwesto. Iba namang merkado ang shares board: SOXS ang nanguna sa 558.1M shares, na may implied price na $3.91 (relative volume).

QueryShares per 30-minute ET bucket, regular hours, with % of the day's biggest bucket
Ang eksaktong SQL sa likod ng bawat numero
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

Isang textbook U: ang open bucket ay umabot ng 1.79B shares (91.4% ng pinakamalaki), ang midday trough ay 0.64B, at ang closing auction na kalahating oras ang pinakamalaki sa araw sa 1.96B. Kahit sa araw na ginawa sa open nito, ang volume ay natapos sa close.

Ang tape ng mga opsyon

QueryOptions tape: prints, contracts, call %, 0DTE share vs Wednesday, top contracts
Ang eksaktong SQL sa likod ng bawat numero
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'

Ang tape ay nagdala ng 9.99M na prints at 58.85M na kontrata — mas mababa sa 63.26M noong Miyerkules — ang mga call ay nasa 58% ng volume, ang bahagi ng 0DTE ay bumaba sa 28.7% mula sa 38.7%. Ang tatlong pinaka-abalang kontrata ay pawang same-day SPY calls — ang 751C (846.6K kontrata, average na $0.526), ang 752C at ang 750C — isang hagdan sa paligid ng pagsasara ng SPY sa $751.64 (saklaw ng mga opsyon na 0DTE ang produkto).

Hedge o taya? Ang isang hedge ay bumibili ng strikes malayo sa pera; ang isang taya ay bumibili ng panig na gusto nito.

QuerySPY same-day (0DTE) options: contracts by strike distance from the closing price
Ang eksaktong SQL sa likod ng bawat numero
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)

Ang same-day tape ay nasa mismong pera: 3768.9k na mga call at 2563.3k na mga put sa loob ng kalahating porsyento ng pagsasara (59.5% na mga call). Ang mga pakpak ay nahati ayon sa direksyon — sa ibaba ng pagsasara, 1356.5k na mga put laban sa 255.4k na mga call (1.2% na bahagi ng call ay mas malalim pababa); sa itaas nito, ang mga call ay kumuha ng 91.6% ng isang mas manipis na 29.1k na bucket. Ang volume ng pakpak ay nasa downside strikes, kung saan binibili ang proteksyon: isang hagdan sa mismong pera, hindi isang pataas na hagdan.

Ang quote tape

QueryStocks NBBO update count: July 9 vs July 8, with named-ticker updates (millions)
Ang eksaktong SQL sa likod ng bawat numero
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'

Ang pinakatahimik na katotohanan ng araw: 383.44M NBBO updates sa stock tape, -27.7% kumpara noong Miyerkules. Ang karahasan ay nasa antas ng presyo, hindi sa pag-ikot sa touch. Nanguna ang QQQ sa mga named tickers sa 4.35M, higit sa 2.71M ng SPY at 1.83M ng NVDA.

QuerySPY / QQQ / NVDA / TSLA / MU / SNDK / AVGO: RTH median quoted spread in basis points
Ang eksaktong SQL sa likod ng bawat numero
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

Ang median quoted spread ng SPY ay nag-print ng 0.27 bps, QQQ 0.42, NVDA 0.99 — mga ordinaryong numero. Ang mas malawak na buntot: MU sa 4.23 bps, SNDK sa 8.79 bps (ang bid-ask spread ang gastos na sinusukat nito).

QuerySPY's RTH average quoted spread in trailing-month context
Ang eksaktong SQL sa likod ng bawat numero
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
)

Ang average quoted spread ng SPY na 2.071 cents ay nag-rank ng 10 sa 22 na nakaraang sesyon, nasa loob ng 1.809–2.865 cent range: walang stress sa quote, kahit sa pagbukas na iyon.

QueryOptions NBBO tape: total updates vs the stock tape, plus the SPY root slice
Ang eksaktong SQL sa likod ng bawat numero
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

Ang options-quote tape ay nagdala ng 6.9 billion NBBO updates — 18× ng stock tape, ang SPY root lamang ay nasa 242M.

Rates: ang July 9 print

QueryTreasury print status: July 9 rows on record, and the July 8 curve (latest at authoring)
Ang eksaktong SQL sa likod ng bawat numero
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'

Ang July 9 treasury print ay dumating pagkatapos ng authoring, sa karaniwang lag ng daily yield file — 1 row na ngayon ang nasa record. Ang curve ng araw na iyon (2026-07-09): 2-year 4.16%, 10-year 4.54%, 30-year 5.05%, 2s10s 0.38 points — ang 2-year ay bumaba mula sa marka ng July 8 habang ang long end ay nanatili.

Ang kalendaryo sa likod ng araw

QueryEx-divs, splits, SEC filings, news attention
Ang eksaktong SQL sa likod ng bawat numero
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

Isang ordinaryong kalendaryo sa ilalim ng hindi ordinaryong pagbubukas: 127 ex-dibidendo na rekord, 5 na reverse split, 1 na forward split, 2979 na pagsusumite sa SEC (623 na Form 4, 605 na 424B2, 149 na 8-K). Ang feed ay naglabas ng 184 na artikulo mula sa 3 na publisher; ang pinakasaklaw na ticker ay NVDA, 20 na artikulo, 8 na agwat mula sa susunod na pangalan.

Naka-iskedyul

Mula sa aming sariling talaan — mga katotohanan tungkol sa susunod na sesyon, hindi mga hula.

QueryOn deck: the next session, its ex-dividend slate, the SPY expiry ladder, and the short-interest clock
Ang eksaktong SQL sa likod ng bawat numero
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) AS latest_short_settlement,
    (SELECT count() FROM global_markets.stocks_short_interest WHERE settlement_date = '2026-07-15') 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'
)

Ang susunod na sesyon ay 2026-07-10, 0 holiday row laban dito: isang normal na Biyernes. 153 kumpanya ang mag-e-ex-dividend sa umagang iyon, 0 mula sa aming checklist ng mga kilalang pangalan. Ang SPY expiry ng Biyernes ang pinakamabigat na forward na na-trade na — 1.66M kontrata noong Hulyo 9 kumpara sa 0.57M laban sa July monthly. Short-interest clock: pinakabagong settlement na nasa file 2026-06-30, 0 row pa ang hindi naisumite para sa mid-July — naglalathala ang FINRA mga walong araw ng negosyo pagkatapos ng settlement (bakit dalawang linggo ang edad ng short interest).

Ang sesyon, beripikado

QuerySession verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closure
Ang eksaktong SQL sa likod ng bawat numero
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'

Isang buong ordinaryong sesyon: unang SPY bar 04:00 ET, huling 19:59 ET, 390 regular na minutong bar, walang holiday row. Susunod na pagsasara: Labor Day, September 7, 2026.

FAQ

Ano ang nangyari sa stock market noong Hulyo 9, 2026?

Lahat ng index ETF ay nagsara nang mas mataas — QQQ +1.67%, IWM +1.29%, SPY +0.85%, DIA +0.29%, 71.5% ng mga likidong stock ay umakyat. Ang mga chip-equipment name ay nag-gap up at kumupas; ang mga mega-cap naman ay nag-gap down at nakabawi.

Bakit tumalon ang mga chip-equipment stock tulad ng KLAC at LRCX noong Hulyo 9, 2026?

Ang aming datos ay walang pinangalanang dahilan: walang artikulo at walang SEC filing para sa KLAC, LRCX, TER o WDC mula sa pagsara ng Miyerkules hanggang sa pagsara ng Huwebes. Ang galaw ay nasa presyo na bago ang 9:30 am ET.

Bakit bumagsak ang NVDA habang umangat ang sektor ng chip?

Nagsara ang NVDA sa -0.68% habang 12 ng labing-apat na chip name ay nagsara na berde. Hindi ito nag-gap (0.16% sa pagbubukas) at ito ang pinaka-cover na ticker sa 20 na artikulo — co-occurrence ang record, ang dahilan ay wala sa datos na ito.

Hindi ba pangkaraniwang araw ang Hulyo 9, 2026 para sa merkado?

Hindi sa antas ng index: ang galaw ng QQQ ay niraranggo ang 10 ng 21 na nakaraang session ayon sa laki, ang average spread ng SPY ay 10 ng 22. Ang dispersion sa ilalim ay: -6.25 puntos sa pagitan ng pinakamahusay at pinakamasamang sector basket.

Mga tala sa datos

Ang regular na oras ay 13:30–20:00 UTC (9:30 am–4:00 pm ET); ang premarket panel ay gumagamit ng 08:00–13:30 UTC. Ang walong sector basket ay na-curate at equal-weighted — tig-tatlong likidong pangalan bawat isa, nakalista lahat ng ticker sa SQL ng panel na iyon. Iyan ay isang idineklarang pamamaraan, hindi isang vendor classification: tatlong pangalan ang nagsasalita para sa kanilang sarili, hindi para sa buong sector. Ang catalyst panel ay binibilang lamang ang aming news feed at ang EDGAR index.

Buong tala sa datos

Ang per-ticker panels ay alphabetical, kaya ang bawat prose reference ay nakaturo sa isang nakapirming row; ang leaderboards ay value-ordered, bawat positional claim ay bounded. Ang treasury print at ang mid-July short-interest settlement ay bounded sa zero rows — ang kanilang pagdating ay nagpahinto sa post na ito para sa isang rewrite.

Pamamaraan

  • Mga Pinagmulan: ang SQL ng bawat panel ay nagpapangalan ng sarili nitong mga talahanayan — minute aggregates, ang stock at options NBBO caches, options trades, ang ating news feed, ang EDGAR index, dividends, short interest, holidays, treasury yields.
  • Mga Kombensyon: raw UTC literals sa WHERE, ET labels lamang sa SELECT; gap = open ng unang regular bar ÷ prior regular close − 1; prior-session at prior-week figures ay kinukwenta sa-query, hindi kailanman dinadala mula sa naunang post. Warehouse as-of July 13, 2026.
#recap#daily#spy#qqq#semiconductors#market structure