2026年7月6日当周市场回顾
半导体板块剧烈波动,NVDA表现亮眼,MU成交额竟超过SPY,解析指数平稳背后的个股分化。
2026年7月6日当周,半导体板块在看似平稳的指数表现下经历了剧烈波动。五个交易日内,市场经历了芯片股暴跌、反弹、夏季最剧烈的开盘,以及 NVDA 在周五的收复失地——最终 SPY 净涨 1.4%。两个事实说明了情况:本周 MU 的成交额超过了 SPY 本身,且在增长指数上涨 1.8% 的一周里,下跌的流动性股票多于上涨的股票。以下所有数据均提取自历史查询。
本周行情回顾
周涨跌幅统计周期为 7 月 2 日(周四)常规收盘至 7 月 10 日(周五)收盘(7 月 3 日为独立日休市)。各行按字母顺序排列。
每个数字背后的完整 SQL
SELECT ticker,
round(argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-07-02') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS prior_week_close,
round(argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-07-06') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS week_close,
round((argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-07-06') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
/ argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-07-02') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) - 1) * 100, 1) AS week_change_pct,
round((argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-07-02') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
/ argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-26') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) - 1) * 100, 1) AS prior_week_change_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('SPY', 'QQQ', 'DIA', 'IWM')
AND window_start >= '2026-06-22 13:30:00' AND window_start < '2026-07-10 20:00:00'
GROUP BY ticker
ORDER BY ticker市场分化明显:QQQ +1.8% 与 SPY +1.4% 表现强劲,而 DIA -0.4% 与 IWM -0.5% 则表现疲软。增长主要集中在大型科技股;道琼斯指数和小盘股指数本周收跌。本周市场涨幅并未覆盖全行业。
本周表现逊于过去一年
每个数字背后的完整 SQL
SELECT round(anyIf(ret, wk = toDate('2026-07-06')), 2) AS week_open_to_close_pct,
arrayCount(x -> x > anyIf(ret, wk = toDate('2026-07-06')), groupArrayIf(ret, wk != toDate('2026-07-06'))) + 1 AS rank_best,
count() AS weeks_compared,
toString(min(wk)) AS first_week,
anyIf(sessions, wk = toDate('2026-07-06')) AS sessions_this_week
FROM (
SELECT toStartOfWeek(toDate(toTimeZone(window_start, 'America/New_York')), 1) AS wk,
uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) AS sessions,
(argMax(toFloat64(close), window_start) / argMin(toFloat64(open), window_start) - 1) * 100 AS ret
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= toDateTime('2025-07-06 00:00:00')
AND window_start < toDateTime('2026-07-11 00:00:00')
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY wk
HAVING sessions >= 3
)若按开盘至收盘的涨跌幅计算,SPY 本周在过去 53 周中排名第 20 ——处于中游水平。本周经历了夏季以来波动最剧烈的单日开盘(周四)以及最剧烈的板块暴跌(周二),但最终表现平平:剧烈波动相互抵消,整体表现回归常态。
五个交易日,一个趋势
每个数字背后的完整 SQL
SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
round(argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS spy_close,
round((argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / any(prev) - 1) * 100, 1) AS change_pct,
round(toFloat64(sum(volume)) / 1e6, 1) AS spy_shares_m
FROM global_markets.delayed_stocks_minute_aggs
INNER JOIN (
SELECT d, lagInFrame(c) OVER (ORDER BY d ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev
FROM (
SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d,
argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) AS c
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-07-02 00:00:00') AND window_start < toDateTime('2026-07-11 00:00:00')
GROUP BY d
)
) AS p ON toDate(toTimeZone(window_start, 'America/New_York')) = p.d
WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-07-06 00:00:00') AND window_start < toDateTime('2026-07-11 00:00:00')
GROUP BY et_date
ORDER BY et_date趋势走势:周一假期后开盘跳空上涨(+0.9%,回顾);周二半导体板块走弱,但指数仅回撤 -0.5%(回顾);周三芯片股大幅反弹,指数持平(-0.3%,回顾);周四市场全面转绿,迎来夏季波动最剧烈的开盘(+0.8%,回顾);周五 NVDA 领涨并平稳收尾(+0.4%,回顾),最终收于 $754.9。
周二暴跌的两只核心个股表现如下:
每个数字背后的完整 SQL
SELECT ticker, round((c7 / c6 - 1) * 100, 1) AS day_pct
FROM (
SELECT ticker,
toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-06 20:00:00')) AS c6,
toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-07 13:30:00' AND window_start < '2026-07-07 20:00:00')) AS c7
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('INTC', 'TER')
AND window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-07 20:00:00'
GROUP BY ticker
)
ORDER BY ticker周二两股走势:INTC -9.6%,TER -9.6%,同期 SPY 表现为 -0.5%。
市场观点
本文仅作客观陈述;本周叙述均附有姓名。本周 981 篇文章中,市场关注点集中在波动核心的四个标的上:
每个数字背后的完整 SQL
SELECT toDate(toTimeZone(published_utc, 'America/New_York')) AS d,
countIf(has(tickers, 'NVDA')) AS nvda_articles,
countIf(has(tickers, 'MU')) AS mu_articles,
countIf(has(tickers, 'INTC')) AS intc_articles,
countIf(has(tickers, 'TER')) AS ter_articles
FROM global_markets.stocks_news
WHERE published_utc >= '2026-07-06 00:00:00' AND published_utc < '2026-07-11 04:00:00'
AND toDate(toTimeZone(published_utc, 'America/New_York')) >= '2026-07-06'
AND toDate(toTimeZone(published_utc, 'America/New_York')) <= '2026-07-10'
GROUP BY d
ORDER BY d此处不对标题进行转述,直接引用自原始数据流:
每个数字背后的完整 SQL
SELECT toString(toDate(toTimeZone(published_utc, 'America/New_York'))) AS session,
JSONExtractString(publisher, 'name') AS outlet,
title AS headline
FROM global_markets.stocks_news
WHERE toDate(toTimeZone(published_utc, 'America/New_York')) IN ('2026-07-07', '2026-07-08')
AND JSONExtractString(publisher, 'name') = 'The Motley Fool'
AND (positionCaseInsensitive(title, 'Burry') > 0 OR positionCaseInsensitive(title, 'Sandisk Stock Pop') > 0)
ORDER BY session, title在暴跌日,该数据流报道了 The Motley Fool 的“Michael Burry Just Revealed His Next Big Short, and It's a Bet Against Nvidia, Micron, and AMD”;在反弹日,同一媒体提出了“Why Did Sandisk Stock Pop Today?”。NVDA 在周五的上涨并未伴随任何催化剂新闻,仅见估值相关的报道;从该数据中无法确定具体原因。
两项发现:MU (17 篇文章) 仅有一次覆盖量超过 NVDA (13) —— 即周三反弹日(NVDA 在其余四天中处于领先地位);此外,暴跌最剧烈的两个标的之一 TER,在破位当天被提及 0 次,其余日期均为零。这仅代表单一数据流的关注度,而非全球媒体的共识。
市场宽度:多数个股下跌,指数却上涨
每个数字背后的完整 SQL
SELECT
countIf(cw > cp AND cp > 0 AND dv >= 5000000) AS advancers,
countIf(cw < cp AND cp > 0 AND dv >= 5000000) AS decliners,
countIf(cp > 0 AND cw > 0 AND dv >= 5000000) AS measured_names,
round(100.0 * countIf(cw > cp AND cp > 0 AND dv >= 5000000) / countIf(cp > 0 AND cw > 0 AND dv >= 5000000), 1) AS advancer_pct
FROM (
SELECT ticker,
toFloat64(argMaxIf(close, window_start, window_start < '2026-07-03 00:00:00')) AS cp,
toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00')) AS cw,
sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 13:30:00') AS dv
FROM global_markets.delayed_stocks_minute_aggs
WHERE ((window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00')
OR (window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-11 00:00:00'))
GROUP BY ticker
)在本周成交额至少达 500 万美元的 6319 只个股中,3270 的个股下跌,而 3015 的个股上涨——上涨股占比仅为 47.7%;与此同时,增长指数上涨了 1.8%。指数的上涨主要由权重股推动;中位数个股的表现则为下跌。这种市场宽度过窄的现象在 周五回顾 中曾被提及,并在过去五天内持续加剧。
板块表现
哪些板块出现下跌?以下是十个 SPDR 板块 ETF 从 7 月 2 日收盘至 7 月 10 日的表现(按字母顺序排列):
每个数字背后的完整 SQL
SELECT ticker, round((cw / cp - 1) * 100, 1) AS week_pct
FROM (
SELECT ticker,
toFloat64(argMaxIf(close, window_start, window_start < '2026-07-03 00:00:00')) AS cp,
toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')) AS cw
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('XLB', 'XLE', 'XLF', 'XLI', 'XLK', 'XLP', 'XLRE', 'XLU', 'XLV', 'XLY')
AND ((window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00')
OR (window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00'))
GROUP BY ticker
)
ORDER BY ticker十个板块中有四个收涨,但仅有两个涨幅显著:能源 (XLE, +3.5%) 和科技 (XLK, +2.9%) 领涨。金融 (0.2%) 和非必需消费 (0.1%) 仅微幅收涨。其余六个板块(从材料 -2.1% 到医疗 -1.8%)均收跌。除这两个明显的赢家外,整体走势偏向下跌。
市场领头羊:MU 交易量连续一周超过指数
每个数字背后的完整 SQL
SELECT ticker,
round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 1) AS week_dollar_bn
FROM global_markets.delayed_stocks_minute_aggs
WHERE window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-10 20:00:00'
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
AND ticker NOT IN ('SPCX')
GROUP BY ticker
ORDER BY week_dollar_bn DESC
LIMIT 6MU 在五个交易日内的常规交易美元成交量为 164B,超过了 SPY 的 137.3B。单只存储股的周交易量超过 S&P 500 ETF,这与六月的情况相似 (MU 六月深度分析);本周交易量前五名还包括 AI/GPU 风向标 NVDA (107.1B) 和另一家存储股 SNDK (88B)。市场波动不仅体现在价格上,更体现在全周资金博弈的焦点上。
剧烈波动后的结果:走势分化,两极分化
本周所有新闻的核心驱动因素为 14 只芯片股。统计周期为 7 月 2 日收盘至 7 月 10 日。按字母顺序排列。
每个数字背后的完整 SQL
SELECT ticker,
round((cw / cp - 1) * 100, 1) AS week_pct
FROM (
SELECT ticker,
toFloat64(argMaxIf(close, window_start, window_start < '2026-07-03 00:00:00')) AS cp,
toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')) AS cw
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-02 13:30:00' AND window_start < '2026-07-02 20:00:00')
OR (window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00'))
GROUP BY ticker
)
ORDER BY ticker在经历暴跌、反弹、大幅跳空高开以及周五的上涨后,该板块并未同步运行,而是呈现两极分化。AVGO (+11%)、STX (+11%)、SNDK (+9.9%)、NVDA (+8.5%) 和 WDC (+8.1%) 周末涨幅巨大;INTC (-8.8%) 表现惨淡;而周四出现大幅跳空的设备股 KLAC (-1.8%) 和 LRCX (-0.3%) 则回到了原点,基本持平。结论是:交易量超过 S&P 500 ETF 的 MU,全周净涨幅为 +0.3%。 尽管成交额高达 164 亿美元,价格却几乎没有变动——这是市场在高成交量下陷入激烈争论的最典型体现。
The week's newest ticker: SK Hynix's US debut
Friday added a listed member to the memory complex that owned the week's tape — the debut, receipted:
每个数字背后的完整 SQL
WITH ipo AS (
SELECT toFloat64(final_issue_price) AS offer, toFloat64(total_offer_size) AS raise
FROM global_markets.stocks_ipos
WHERE issuer_name = 'SK Hynix Inc' AND listing_date = '2026-07-10'
LIMIT 1
),
debuts AS (
SELECT a.ticker AS t, sum(toFloat64(a.close) * toFloat64(a.volume)) AS debut_rth_dollars
FROM global_markets.delayed_stocks_minute_aggs a
INNER JOIN (
SELECT multiIf(replaceAll(ticker, ' ', '') = 'SKHY', 'SKHYV', replaceAll(ticker, ' ', '')) AS tk, listing_date
FROM global_markets.stocks_ipos
WHERE listing_date >= '2026-01-01' AND listing_date <= '2026-07-10'
) l ON a.ticker = l.tk
WHERE a.window_start >= '2026-01-01 00:00:00' AND a.window_start < '2026-07-11 00:00:00'
AND toDate(a.window_start) = l.listing_date
AND (toHour(a.window_start) * 60 + toMinute(a.window_start)) BETWEEN 810 AND 1199
GROUP BY a.ticker
)
SELECT
round((SELECT offer FROM ipo), 2) AS offer_px,
round((SELECT raise FROM ipo) / 1e9, 1) AS raised_bn,
(SELECT countIf(toFloat64(total_offer_size) > (SELECT raise FROM ipo)) FROM global_markets.stocks_ipos WHERE listing_date >= '2026-01-01' AND listing_date <= '2026-07-10') AS bigger_2026_raises,
round((SELECT max(toFloat64(total_offer_size)) FROM global_markets.stocks_ipos WHERE listing_date >= '2026-01-01' AND listing_date <= '2026-07-10') / 1e9, 1) AS biggest_2026_raise_bn,
round(toFloat64(argMinIf(open, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')), 2) AS first_rth_px,
toHour(toTimeZone(minIf(window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00'), 'America/New_York')) * 60
+ toMinute(toTimeZone(minIf(window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00'), 'America/New_York')) AS first_rth_bar_et_minute,
formatDateTime(toTimeZone(minIf(window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00'), 'America/New_York'), '%H:%i') AS first_rth_bar_et,
round(toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')), 2) AS debut_close,
round((toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')) / (SELECT offer FROM ipo) - 1) * 100, 1) AS close_vs_offer_pct,
round(toFloat64(argMinIf(open, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00'))
- toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')), 2) AS faded_from_first_print,
round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00') / 1e9, 2) AS rth_dollar_bn,
(SELECT count() FROM debuts) AS debuts_measured_2026,
(SELECT countIf(debut_rth_dollars > (SELECT debut_rth_dollars FROM debuts WHERE t = 'SKHYV')) + 1 FROM debuts) AS debut_dollar_rank_2026,
round((SELECT max(debut_rth_dollars) FROM debuts) / 1e9, 1) AS biggest_2026_debut_bn
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SKHYV' AND window_start >= '2026-07-10 04:00:00' AND window_start < '2026-07-11 00:00:00'The raise: $28.1 billion at $158.14 a share — 1 US raise in 2026 was bigger, SpaceX's $75 billion June listing. With no prior close, the opening cross took until 11:34 ET to find a price: $170. The close, $168.33, faded $1.67 from that first print yet held 6.4% above the offer. And the tape: $18.03 billion of regular-hours dollars — of 144 US debuts measured in 2026, only SpaceX's $81.2 billion first day was heavier.
本周涨跌幅最大的股票
除了芯片股,谁赢了,谁输了?由于未经调整的行情数据会因 30 拆股 而产生虚假的四位数“涨幅”,因此本榜单排除了周内拆股的情况,且要求成交额达到 500 万美元。
每个数字背后的完整 SQL
SELECT ticker, board, week_pct, week_dollar_m,
round(100 * week_dollar_m / max(week_dollar_m) OVER (), 1) AS pct_of_dollar_max
FROM (
SELECT 'gainers' AS board, ticker, round((cw / cp - 1) * 100, 1) AS week_pct, round(dv / 1e6, 1) AS week_dollar_m
FROM (
SELECT ticker,
toFloat64(argMaxIf(close, window_start, window_start < '2026-07-03 00:00:00')) AS cp,
toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')) AS cw,
sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 13:30:00') AS dv
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker NOT IN ('SPCX')
AND ticker NOT IN (SELECT ticker FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10')
AND ((window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00')
OR (window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-11 00:00:00'))
GROUP BY ticker
HAVING cp > 0 AND cw > 0 AND dv >= 5000000
)
ORDER BY week_pct DESC
LIMIT 10
UNION ALL
SELECT 'decliners' AS board, ticker, round((cw / cp - 1) * 100, 1) AS week_pct, round(dv / 1e6, 1) AS week_dollar_m
FROM (
SELECT ticker,
toFloat64(argMaxIf(close, window_start, window_start < '2026-07-03 00:00:00')) AS cp,
toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')) AS cw,
sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 13:30:00') AS dv
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker NOT IN ('SPCX')
AND ticker NOT IN (SELECT ticker FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10')
AND ((window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00')
OR (window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-11 00:00:00'))
GROUP BY ticker
HAVING cp > 0 AND cw > 0 AND dv >= 5000000
)
ORDER BY week_pct ASC
LIMIT 10
)
ORDER BY board DESC, abs(week_pct) DESC两个板块的波动都很大:涨幅最小的股票上涨了 67%,跌幅最小的股票下跌了 -44.6%。即便 INTC 本周的芯片股表现极其惨淡 (-8.8%),其波动幅度也远不及榜单中的任何一只股票。这些板块主要由小盘股组成,但有一个例外:CRNX,成交额 9660.5 百万美元,涨幅 98%,是本周成交金额最高的股票 —— 周二隔夜几乎翻倍 的涨幅一直维持到了周五。
做空数据:完整周内仅一份文件缺失
每个数字背后的完整 SQL
SELECT toString(date) AS d,
uniqExact(ticker) AS tickers_on_file,
round(sum(short_volume) / 1e9, 2) AS short_shares_bn
FROM global_markets.stocks_short_volume
WHERE date >= '2026-07-06' AND date <= '2026-07-10'
GROUP BY date
ORDER BY date五份每日做空交易量文件中有四份是完整的,每份包含约 15384 个代码。7月7日(周二)的文件仅包含 4333 个代码 ——不足其他日期的三分之一 —— 总做空股数也随之缩减(1.93B,而完整日期的数值约为 ~4.62B)。6月29日的文件也存在类似的缺失情况(该周回顾),而7月7日恰好是市场大跌的日子。在文件重新发布前,请勿采信任何关于7月7日单只代码的 做空交易量 数据,因为这些数据无法验证。
期权周:当日到期交易量随日历波动
每个数字背后的完整 SQL
SELECT toDate(sip_timestamp) AS d,
round(toFloat64(sum(size)) / 1e6, 1) AS contracts_m,
round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = formatDateTime(toDate(sip_timestamp), '%y%m%d')) / sum(size), 1) AS pct_0dte
FROM global_markets.options_trades
WHERE sip_timestamp >= '2026-07-06 00:00:00' AND sip_timestamp < '2026-07-11 00:00:00'
GROUP BY d
ORDER BY d合约成交量从 58.9M(周四,最低)上升至 65.6M(周五,最高)。0DTE(当日到期)期权反映了日历规律:周四由于没有重大到期日,占比降至 28.7%;而周五随着周度期权到期,占比跃升至 48.7%,正如 到期日历 所预期的。当日到期期权的占比大小仍由日历决定。
利率:全周持续走高
每个数字背后的完整 SQL
SELECT
round((toFloat64(anyIf(yield_2_year, date = '2026-07-10')) - toFloat64(anyIf(yield_2_year, date = '2026-07-02'))) * 100) AS chg_2y_bp,
round((toFloat64(anyIf(yield_10_year, date = '2026-07-10')) - toFloat64(anyIf(yield_10_year, date = '2026-07-02'))) * 100) AS chg_10y_bp,
round((toFloat64(anyIf(yield_30_year, date = '2026-07-10')) - toFloat64(anyIf(yield_30_year, date = '2026-07-02'))) * 100) AS chg_30y_bp,
round(toFloat64(anyIf(yield_10_year, date = '2026-07-10')), 2) AS y10_fri_pct,
round(toFloat64(anyIf(yield_30_year, date = '2026-07-10')), 2) AS y30_fri_pct,
(SELECT count() FROM global_markets.treasury_yields WHERE date IN ('2026-07-09', '2026-07-10')) AS jul9_jul10_print_rows
FROM global_markets.treasury_yields
WHERE date IN ('2026-07-02', '2026-07-10')截至本周五(7月10日)的最终数据,收益率曲线较上周收盘呈近乎平行的上行趋势:2年期 +7 bp,10年期 +7 bp 至 4.56%,30年期 +8 bp 至 5.06% —— 曲线形态未发生扭曲,仅为整体上移。7月9日和10日的数据由于滞后,发布时间较往常更晚(目前已记录 2 行数据);本节涵盖本周完整数据。
本周行情背后的日程表
每个数字背后的完整 SQL
SELECT
(SELECT count() FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-06' AND filing_date <= '2026-07-10') AS filings_week,
(SELECT count() FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-10') AS filings_friday,
toInt64((SELECT count() FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-06'))
- toInt64((SELECT max(c) FROM (SELECT count() AS c FROM global_markets.stocks_sec_edgar_index WHERE filing_date > '2026-07-06' AND filing_date <= '2026-07-10' GROUP BY filing_date))) AS monday_minus_next_busiest,
(SELECT round(countIf(form_type = '4' AND filing_date = '2026-07-06') / countIf(form_type = '4' AND filing_date = '2026-07-10'), 1) FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-06' AND filing_date <= '2026-07-10') AS monday_over_friday_form4,
(SELECT min(c) FROM (SELECT count() AS c FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-06' AND filing_date <= '2026-07-10' AND form_type = '424B2' GROUP BY filing_date)) AS min_daily_424b2,
(SELECT max(c) FROM (SELECT count() AS c FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-06' AND filing_date <= '2026-07-10' AND form_type = '424B2' GROUP BY filing_date)) AS max_daily_424b2,
(SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-06' AND ex_dividend_date <= '2026-07-10') AS ex_dividends_week,
(SELECT countIf(toFloat64(split_from) > toFloat64(split_to)) FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10') AS reverse_splits_week,
(SELECT countIf(toFloat64(split_to) > toFloat64(split_from)) FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10') AS forward_splits_week,
(SELECT count() FROM global_markets.stocks_news WHERE toDate(toTimeZone(published_utc, 'America/New_York')) >= '2026-07-06'
AND toDate(toTimeZone(published_utc, 'America/New_York')) <= '2026-07-10') AS news_week18347 SEC 文件、560 除权记录、30 逆向与 9 正向拆股、981 新闻文章。本文发布时,7 月 10 日(周五)的 EDGAR 指数尚未更新(这是我们 曾撰文说明过的 数据延迟问题)。目前数据已更新至 3135 文件,因此上述周总计已包含全部五个交易日。
按日期和 表格类型 划分的本周申报情况:
每个数字背后的完整 SQL
SELECT toString(filing_date) AS d,
count() AS filings,
countIf(form_type = '4') AS form4,
countIf(form_type = '8-K') AS form8k,
countIf(form_type = '424B2') AS f424b2
FROM global_markets.stocks_sec_edgar_index
WHERE filing_date >= '2026-07-06' AND filing_date <= '2026-07-10'
GROUP BY filing_date
ORDER BY filing_date周一的申报量最高,共计 5019 份,比次忙碌的交易日多出 1289;其中内部人士 Form 4 占比最大,占 2465。3.6 次为周五的 694,发生在独立日四天假期后的第一个交易日。波动最平稳的是 424B2 表格(银行用于结构化票据的搁置招股说明书):该表格在每个交易日中保持在 487 至 679 的窄幅区间。内部人士申报随日历波动,而票据发行则非常稳定。
周五的申报中还包含了本周新上市的股票代码。SK Hynix 在美上市的申报记录:
每个数字背后的完整 SQL
SELECT toString(filing_date) AS filing_date,
form_type
FROM global_markets.stocks_sec_edgar_index
WHERE issuer_name = 'SK hynix Inc.'
AND filing_date >= '2026-06-01' AND filing_date <= '2026-07-10'
ORDER BY filing_date ASC, form_type ASC6 月份的注册声明、本周一的修正案、周四的交易所认证,以及最后一行:424B4 最终招股说明书,于 2026-07-10 提交,即该股开盘的交易日。申报指数与行情走势在日期上保持一致。
交易时段已确认
每个数字背后的完整 SQL
SELECT
uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) AS sessions_in_week,
toString(min(toDate(toTimeZone(window_start, 'America/New_York')))) AS first_session,
toString(max(toDate(toTimeZone(window_start, 'America/New_York')))) AS last_session,
(SELECT count() FROM global_markets.stocks_market_holidays WHERE date >= '2026-07-06' AND date <= '2026-07-10') AS holiday_rows_in_week,
(SELECT toString(min(date)) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-10' AND status = 'closed') AS next_closure_date,
(SELECT argMin(name, date) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-10' AND status = 'closed') AS next_closure_name
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-10 20:00:00'
AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 11995 个完整交易日,涵盖 2026-07-06 至 2026-07-10,该窗口期内无节假日。这是自 6 月中旬以来第一个连续五个交易日的周。下一个预定休市日为:2026-09-07 的 Labor Day。
预告
下周,来自我们自有数据的更新:
每个数字背后的完整 SQL
SELECT
(SELECT count() FROM global_markets.stocks_market_holidays WHERE date >= '2026-07-11' AND date <= '2026-07-17' AND status != 'open') AS closures_next_week,
(SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-13' AND ex_dividend_date <= '2026-07-17') AS ex_dividends_next_week,
(SELECT countIf(ticker IN ('AAPL', 'MSFT', 'JPM', 'KO', 'JNJ', 'XOM', 'CVX', 'PG', 'WMT', 'HD')) FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-13' AND ex_dividend_date <= '2026-07-17') AS household_ex_div_next_week,
(SELECT round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260717') / sum(size), 1) FROM global_markets.options_trades WHERE sip_timestamp >= '2026-07-06 00:00:00' AND sip_timestamp < '2026-07-11 00:00:00') AS jul17_expiry_pct_of_week_volume节假日数据表显示,下周将有 0 次休市——共计五个完整交易日。640 除权 记录包含在内,但样本中的十家知名公司均无此类记录。下周五是七月的第三个周五——每月期权到期日——当日到期的合约已占本周期权成交量的 14。目前仍有一项数据待更新:7月9日和7月10日的国债发行记录(文件包含 2 行),该数据是本页重新生成的触发条件,需等待财政部文件发布。周五的 EDGAR 指数(本页的另一触发条件)已发布,内容已在上方完整列出。
常见问题
2026年7月6日当周股市表现如何?
走势分化:SPY上涨 1.4%,QQQ上涨 1.8%,DIA 和 IWM 收跌。3270 的 6319 股流动性股票下跌。
2026年7月6日当周哪个板块表现最好?
能源板块:XLE 上涨 3.5%,领先于科技板块的 +2.9% —— 两者是十个板块中明确的赢家。金融板块和非必需消费品板块也小幅收涨(+0.2%,+0.1%),其余六个板块收跌。
SK Hynix 在美股上市表现如何?
其募资额为 28.1 美元,是 2026 年美股第二大募资规模,仅次于 SpaceX。首个交易日收盘价高于 158.14 美元发行价 6.4%,常规交易时段成交额为 18.03 美元。
下一次月度期权到期日是什么时候?
7 月的第三个星期五 —— 即本周之后的周五。当天到期的合约已占本周期权成交量的 14%。
数据说明
所有时间戳均为 UTC;每场交易的常规交易时间为 13:30-20:00 UTC;周统计周期从 7 月 2 日收盘开始,至 7 月 10 日结束。周滚动排名采用开盘至收盘收益率,因此与收盘至收盘计分板不同——两者均已标注。周宽度对比的是 7 月 2 日与 7 月 10 日的收盘价,并应用了单周成交额 500 万美元的筛选条件。其中一个触发阈值被限制为零:即 7 月 9 日和 7 月 10 日的国债发行数据。本页面首次运行时,周五的 EDGAR 日度指数尚未更新,目前已完全计入周申报总量中,该总量不再是底线值。此处不显示 VIX 类型的指标:指数隐含波动率序列未获得本仓库的授权——波动率直接从盘面读取(包括价格区间、0DTE 股票及报价行为)。IPO 表格中保留了带有空格的上市代码;上市面板则通过清洗后的代码进行关联。
方法论
- 市场数据来源:综合行情数据 —— 价格与成交量采用
delayed_stocks_minute_aggs;期权周数据采用options_trades。 - 时区处理:存储的时间戳为 UTC;SELECT 列表中的 ET 标签通过
toTimeZone(...)实现;WHERE 子句使用原始 UTC 字面量。 - 确定性聚合:使用元组键进行平局处理;文案中的陈述均以边界值进行编码。
- SEC 备案来源:
stocks_sec_edgar_index(每日 EDGAR 备案索引),按filing_date进行计数。 - 数据仓库截止日期:2026 年 7 月 13 日;已完整摄取股票行情、期权交易及当周的五份 EDGAR 每日索引。7 月 9 日和 7 月 10 日的国债数据仍在传输中。