Strasmore Research
市场回顾 Matt Connor作者： Matt Connor · 更新于 2026-07-23

2026年7月6日美股行情回顾

独立日假期后市场跳空高开，QQQ与DIA表现分化，指数报价处于月内最窄区间。

2026年7月6日，星期一——独立日假期后的首个交易日——开盘受增长预期推动大幅跳空高开，并维持了涨幅。QQQ 收盘涨幅为 1.39%，DIA 收盘涨幅为 0.42%，这与 周四的轮动 趋势一致。市场广度呈现上涨态势：3861 个流动性良好的股票上涨，而 2242 个股票下跌。此次行情的主要驱动因素是开盘跳空，其指数报价处于过去一个月内的最窄区间。以下所有数据均提取自存储查询。

市场表现

数据对比 7 月 6 日常规交易时段最后一分钟与 7 月 2 日（上一个交易日）的情况。

查询SPY / QQQ / DIA / IWM — 7月6日对比7月2日收盘（常规交易时段）
每个数字背后的完整 SQL
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-02 13:30:00' AND window_start < '2026-07-02 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-06 13:30:00' AND window_start < '2026-07-06 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 AS shares_traded_m
FROM sess s
JOIN prior p ON s.ticker = p.ticker
ORDER BY s.ticker

QQQ 的 1.39% 在四大指数 ETF 中领涨，DIA 的 0.42% 表现垫底——这与 周四 的走势完全相反，当时 DIA 上涨而 QQQ 下跌。SPY 收涨 0.87%，IWM 收涨 0.45%。今日走势特征为“跳空”而非“震荡上行”：QQQ 开盘高出周四收盘价 1.01%，但全天仅额外上涨了 0.38%。SPY 的 0.53% 跳空涨幅贡献了其 0.87% 全天涨幅的大部分。IWM (0.07%) 和 DIA (0.17%) 几乎没有跳空，主要是在盘中震荡走高。

今日走势异常吗？

查询SPY 开盘至收盘涨跌幅在过去一个月交易中的排名（排名1 = 绝对涨跌幅最大）
每个数字背后的完整 SQL
SELECT round(anyIf(oc_pct, d = toDate('2026-07-06')), 2) AS day_move_pct,
       arrayCount(x -> x > abs(anyIf(oc_pct, d = toDate('2026-07-06'))), groupArrayIf(abs(oc_pct), d != toDate('2026-07-06'))) + 1 AS abs_move_rank,
       count() AS sessions_compared,
       toString(min(d)) AS first_session
FROM (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d,
           (argMax(toFloat64(close), window_start) / argMin(toFloat64(open), window_start) - 1) * 100 AS oc_pct
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-06-06 00:00:00')
      AND window_start < toDateTime('2026-07-07 00:00:00')
      AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
    GROUP BY d
)

指数层面来看，并不异常：SPY 从开盘到收盘的变动幅度为 0.34%，在过去 19 个交易日中，其绝对值排名为 13 —— 处于中等水平。日内走势平稳；波动主要源于开盘跳空。

市场广度：涨幅扩大，增长势头回归

查询7月6日成交额至少 $1M 的个股：上涨 vs 下跌数量
每个数字背后的完整 SQL
WITH per_ticker AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-07-06 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-06 00:00:00')) AS day_close,
        sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 00:00:00') AS day_dollar_volume
    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-06 20:00:00')
    GROUP BY ticker
)
SELECT
    countIf(day_close > prior_close AND day_dollar_volume >= 1000000) AS advancers,
    countIf(day_close < prior_close AND day_dollar_volume >= 1000000) AS decliners,
    countIf(day_close = prior_close AND day_dollar_volume >= 1000000) AS unchanged,
    countIf(day_dollar_volume >= 1000000) AS liquid_tickers,
    count() AS tickers_traded_both_sessions,
    count() - countIf(day_dollar_volume >= 1000000) AS dropped_by_liquidity_filter,
    round(100.0 * countIf(day_close > prior_close AND day_dollar_volume >= 1000000)
        / countIf(day_dollar_volume >= 1000000), 1) AS advancer_pct
FROM per_ticker
WHERE prior_close > 0 AND day_close > 0

3861 只上涨，2242 只下跌，86 持平 —— 62.4% 的活跃股票上涨。指数权重广度与等权重广度一致，均为上涨，而 周四 两者表现分化。该过滤器剔除了 5361 的 11550 个交易额低于 100 万美元的连续两日交易股票。

板块表现：分化程度如何？

仅凭四家超大市值公司无法代表整个市场。本调查通过 11 只大型板块 ETF 来评估当日表现——每只基金对应 S&P 500 的一个板块，且每日篮子构成相同。请关注表现最佳与最差板块之间的价差：即当日的离散度。

查询11 个板块 ETF：7月6日对比7月2日收盘，分为跳空与日内涨跌
每个数字背后的完整 SQL
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-07-06 00:00:00')) AS prior_close,
        toFloat64(argMinIf(open, window_start, window_start >= '2026-07-06 00:00:00')) AS day_open,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-06 00:00:00')) AS day_close,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('XLB', 'XLC', '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-06 13:30:00' AND window_start < '2026-07-06 20:00:00'))
    GROUP BY ticker
)
SELECT
    ticker,
    round((day_close / prior_close - 1) * 100, 2) AS pct_chg,
    round((day_open / prior_close - 1) * 100, 2) AS gap_pct,
    round((day_close / day_open - 1) * 100, 2) AS intraday_pct,
    day_dollar_bn,
    round(max((day_close / prior_close - 1) * 100) OVER () - (day_close / prior_close - 1) * 100, 2) AS points_behind_leader
FROM per_name
ORDER BY pct_chg DESC, ticker ASC

科技板块 (XLK) 以 1.71% 的涨幅领涨，且涨幅几乎全部集中在开盘后：开盘时为 1.19%，随后六个半小时内上涨了 0.52%。金融板块 (0.99%) 和工业板块 (0.9%) 紧随其后。随后走势发生逆转：五个上涨板块被六个下跌板块取代，防御性板块——公用事业、医疗保健、必需消费品——跌幅低至 -1.08%。从最高到最低，在 S&P 指数波动 0.87% 的日子里，表现最好与最差的板块之间相差了 2.79 个百分点——这一波动幅度是指数波动的数倍，这也说明不能仅凭指数上涨就断定市场表现良好。房地产和公用事业的走势与科技板块相反：开盘接近持平 (0.09%, -0.11%)，随后全天持续下跌 (-1.01% 和 -0.92% 从开盘到收盘)。

今日亮点：存储板块反弹，仅实现部分回升

在 周三 和 周四 遭遇大跌的存储板块于周一出现反弹，但涨幅仅为跌幅的一半。

查询存储与内存板块：对比周四收盘的涨跌、波动区间时间及成交金额
每个数字背后的完整 SQL
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-07-06 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-06 00:00:00')) AS day_close,
        maxIf(toFloat64(high), window_start >= '2026-07-06 00:00:00') AS day_high,
        minIf(toFloat64(low), window_start >= '2026-07-06 00:00:00') AS day_low,
        argMinIf(window_start, toFloat64(low), window_start >= '2026-07-06 00:00:00') AS low_bar,
        argMaxIf(window_start, toFloat64(high), window_start >= '2026-07-06 00:00:00') AS high_bar,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('MU', 'SNDK', 'STX', 'WDC')
      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-06 20:00:00'))
    GROUP BY ticker
)
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    round(day_close, 2) AS day_close,
    round((day_close / prior_close - 1) * 100, 2) AS pct_chg,
    round(day_high, 2) AS day_high,
    formatDateTime(toTimeZone(high_bar, 'America/New_York'), '%H:%i') AS day_high_et,
    round(day_low, 2) AS day_low,
    formatDateTime(toTimeZone(low_bar, 'America/New_York'), '%H:%i') AS day_low_et,
    round((day_high / day_low - 1) * 100, 2) AS range_pct,
    day_dollar_bn
FROM per_name
ORDER BY ticker

两家硬盘制造商领涨：Western Digital 涨 7.14%，Seagate 涨 6%，两者均在上午盘中触及高点（10:44 和 10:39 ET）。涨幅最重的两股表现平平：MU 下跌 0.88%，并在收盘时创下当日低点 (15:59)；SanDisk 在 7.27% 的波动范围内收跌 -0.03%。MU 的成交额达 $30.9 billion，超过了其他三家公司的总和（详情请参阅 MU 深度分析）。

板块轮动中的另一部分资金流向了大型科技股：

查询超大盘股轮动：对比周四收盘的涨跌、波动区间时间及成交金额
每个数字背后的完整 SQL
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-07-06 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-06 00:00:00')) AS day_close,
        maxIf(toFloat64(high), window_start >= '2026-07-06 00:00:00') AS day_high,
        minIf(toFloat64(low), window_start >= '2026-07-06 00:00:00') AS day_low,
        argMinIf(window_start, toFloat64(low), window_start >= '2026-07-06 00:00:00') AS low_bar,
        argMaxIf(window_start, toFloat64(high), window_start >= '2026-07-06 00:00:00') AS high_bar,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'TSLA')
      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-06 20:00:00'))
    GROUP BY ticker
)
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    round(day_close, 2) AS day_close,
    round((day_close / prior_close - 1) * 100, 2) AS pct_chg,
    round(day_high, 2) AS day_high,
    formatDateTime(toTimeZone(high_bar, 'America/New_York'), '%H:%i') AS day_high_et,
    round(day_low, 2) AS day_low,
    formatDateTime(toTimeZone(low_bar, 'America/New_York'), '%H:%i') AS day_low_et,
    round((day_high / day_low - 1) * 100, 2) AS range_pct,
    day_dollar_bn
FROM per_name
ORDER BY ticker

TSLA 单边上涨至 6.86% —— 低点出现在 09:37 ET，高点出现在收盘时 (15:59) —— 这与其 周四 的跌势正好相反。AAPL 上涨 1.49%，NVDA 上涨 0.57%；MSFT 是唯一下跌的大型科技股，跌幅为 -0.7%，其高点出现在 09:30 开盘时。

资金流向

查询成交量领涨：成交金额前6名，成交股数前4名（排除一个待验证的重复代码）
每个数字背后的完整 SQL
SELECT leaderboard, ticker, dollar_volume_bn, shares_m,
    round(100 * if(leaderboard = 'by dollars traded', dollar_volume_bn, shares_m)
        / max(if(leaderboard = 'by dollars traded', dollar_volume_bn, shares_m)) OVER (PARTITION BY leaderboard), 1) AS pct_of_board_leader
FROM (
    SELECT
        'by dollars traded' AS leaderboard,
        ticker,
        round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 2) AS dollar_volume_bn,
        round(sum(toFloat64(volume)) / 1e6, 1) AS shares_m
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-06 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-06 13:30:00' AND window_start < '2026-07-06 20:00:00'
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
    ORDER BY shares_m DESC
    LIMIT 4
)
ORDER BY leaderboard ASC, if(leaderboard = 'by dollars traded', dollar_volume_bn, shares_m) DESC

SPY 以 $31.49 十亿 的成交额领涨，MU ($30.9 十亿) 紧随其后 —— 结束了 MU 连续四个交易日的榜首地位（周一 至 周四 的数据可供参考）。在股票板块中，3 倍做空半导体 ETF SOXS 的成交量为 467.1 百万股，尽管其追踪的芯片股上涨，但该 ETF 的成交量再次位居首位。

查询每30分钟时段的成交股数，常规交易时段（单位：十亿）
每个数字背后的完整 SQL
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-06 13:30:00' AND window_start < '2026-07-06 20:00:00'
GROUP BY et_time
ORDER BY et_time

开盘半小时内成交 1.96 十亿股，14:30 时降至 0.68 十亿股的低点，15:30 收盘时回升至 2.1 十亿股 —— 呈现典型的日内“微笑”曲线，即开盘和收盘阶段交易最为活跃。

The options tape

查询全天期权数据：成交量、看涨期权股数及周一当日到期量
每个数字背后的完整 SQL
WITH
    (
        SELECT (any(underlying_symbol), any(toFloat64(strike_price)), any(option_type),
                any(toDateOrNull(concat('20', substring(ticker, length(ticker) - 14, 6)))),
                sum(size), count(), round(avg(toFloat64(price)), 3))
        FROM global_markets.options_trades
        WHERE sip_timestamp >= '2026-07-06 00:00:00' AND sip_timestamp < '2026-07-07 00:00:00'
        GROUP BY ticker
        ORDER BY sum(size) DESC
        LIMIT 1
    ) AS top_contract,
    (
        SELECT round(toFloat64(argMax(close, window_start)), 2)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY' AND window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-06 20:00:00'
    ) AS spy_regular_close
SELECT
    round(count() / 1e6, 2) AS option_prints_m,
    round(toFloat64(sum(size)) / 1e6, 2) AS contracts_m,
    round(100.0 * sumIf(size, option_type = 'C') / sum(size), 1) AS call_pct_of_volume,
    round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260706') / sum(size), 1) AS same_day_expiry_pct,
    round(toFloat64(sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260706')) / 1e6, 2) AS same_day_contracts_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY')) / 1e6, 2) AS spy_contracts_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'QQQ')) / 1e6, 2) AS qqq_contracts_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'TSLA')) / 1e6, 2) AS tsla_contracts_m,
    top_contract.1 AS top_contract_underlying,
    top_contract.2 AS top_contract_strike,
    top_contract.3 AS top_contract_type,
    if(top_contract.3 = 'C', 1, 0) AS top_contract_is_call,
    top_contract.4 AS top_contract_expiry,
    round(toFloat64(top_contract.5) / 1e6, 2) AS top_contract_volume_m,
    round(top_contract.7, 3) AS top_contract_avg_price,
    round(spy_regular_close - top_contract.2, 2) AS spy_close_minus_strike
FROM global_markets.options_trades
WHERE sip_timestamp >= '2026-07-06 00:00:00' AND sip_timestamp < '2026-07-07 00:00:00'

Options traded 60.98 million contracts across 10.53 million prints, 58.4% of it in calls. Same-day expiries took 38.7% of the tape (23.57 million contracts) — a routine Monday 0DTE share, below Thursday's double-loaded holiday-eve figure. The busiest contract was the same-day SPY $751 call, 1.08 million contracts at an average $0.564, with SPY closing $0.3 above the strike — in the money. A call atop the board, where Thursday finished on a put.

报价行情：跳空高开时的市场买卖价差是否扩大？

每个价格背后都是报价流——即全市场所有上市股票的全国最佳买卖报价（NBBO），且在持续更新。跳空开盘可能导致报价变得不利，因此我们每交易日都会对其进行衡量。

查询全股票 NBBO 流：7月6日对比7月2日交易，以及周一报价聚集点
每个数字背后的完整 SQL
SELECT
    round(countIf(toDate(sip_timestamp) = toDate('2026-07-06')) / 1e6, 2) AS jul6_updates_m,
    round(countIf(toDate(sip_timestamp) = toDate('2026-07-02')) / 1e6, 2) AS jul2_updates_m,
    round((countIf(toDate(sip_timestamp) = toDate('2026-07-06')) / countIf(toDate(sip_timestamp) = toDate('2026-07-02')) - 1) * 100, 1) AS day_over_day_pct,
    round(countIf(sip_timestamp >= '2026-07-06 13:30:00' AND sip_timestamp < '2026-07-06 14:00:00') / 1e6, 2) AS jul6_open_half_hour_m,
    round(countIf(sip_timestamp >= '2026-07-06 17:30:00' AND sip_timestamp < '2026-07-06 18:00:00') / 1e6, 2) AS jul6_midday_half_hour_m,
    round(countIf(sip_timestamp >= '2026-07-06 19:30:00' AND sip_timestamp < '2026-07-06 20:00:00') / 1e6, 2) AS jul6_close_half_hour_m
FROM global_markets.cache_stocks_quotes
WHERE (sip_timestamp >= '2026-07-02 00:00:00' AND sip_timestamp < '2026-07-03 00:00:00')
   OR (sip_timestamp >= '2026-07-06 00:00:00' AND sip_timestamp < '2026-07-07 00:00:00')

周一的 NBBO 更新量为 391.96 百万次，而周四为 597.22 百万次——即-34.4%，比节前交易日的报价量少了三分之一。报价在开盘时激增：前半小时为 58.66 百万次，下午 1:30 为 20.74 百万次，收盘前为 33.7 百万次。报价数量虽少于周四，但价差并未扩大：

查询跳空开盘时的报价：中位数买卖价差与报价频率，9:30–9:42 ET 对比正午基准（各12分钟）
每个数字背后的完整 SQL
SELECT
    ticker,
    round(quantileExactIf(0.5)((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, bid_price > 0 AND ask_price >= bid_price AND sip_timestamp >= '2026-07-06 13:30:00' AND sip_timestamp < '2026-07-06 13:42:00'), 2) AS open_spread_bps,
    round(quantileExactIf(0.5)((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, bid_price > 0 AND ask_price >= bid_price AND sip_timestamp >= '2026-07-06 17:30:00' AND sip_timestamp < '2026-07-06 17:42:00'), 2) AS midday_spread_bps,
    round(quantileExactIf(0.5)((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, bid_price > 0 AND ask_price >= bid_price AND sip_timestamp >= '2026-07-06 13:30:00' AND sip_timestamp < '2026-07-06 13:42:00')
        - quantileExactIf(0.5)((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, bid_price > 0 AND ask_price >= bid_price AND sip_timestamp >= '2026-07-06 17:30:00' AND sip_timestamp < '2026-07-06 17:42:00'), 2) AS spread_delta_bps,
    round(countIf(sip_timestamp >= '2026-07-06 13:30:00' AND sip_timestamp < '2026-07-06 13:42:00') / 1e3, 1) AS open_updates_k,
    round(countIf(sip_timestamp >= '2026-07-06 17:30:00' AND sip_timestamp < '2026-07-06 17:42:00') / 1e3, 1) AS midday_updates_k,
    round(countIf(sip_timestamp >= '2026-07-06 13:30:00' AND sip_timestamp < '2026-07-06 13:42:00') / countIf(sip_timestamp >= '2026-07-06 17:30:00' AND sip_timestamp < '2026-07-06 17:42:00'), 1) AS quote_rate_ratio,
    round(count() / 1e6, 2) AS session_updates_m,
    countIf(bid_price <= 0 OR ask_price <= 0 OR bid_price > ask_price) AS dropped_invalid_quotes
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('DIA', 'IWM', 'MSFT', 'MU', 'QQQ', 'SNDK', 'SPY', 'STX', 'TSLA', 'WDC')
  AND sip_timestamp >= '2026-07-06 13:30:00' AND sip_timestamp < '2026-07-06 20:00:00'
GROUP BY ticker
ORDER BY ticker

买卖价差是以中间价基点计的成交成本——1 bp 代表 100 美元股票中的 1 美分。在跳空开盘后的前 12 分钟内，没有任何个股的报价比中午更窄；尽管 SPY 在开盘时的报价速度快了 3 倍，但其触及价差在两个时段完全一致（0.27 bps，变化为 0 bps）。价差惩罚主要出现在个股而非指数基金上：SanDisk 的价差最大（+12.9 bps，从 8.16 升至 21.07），其次是 MU +3.63，TSLA +2.89；相比之下，QQQ 的触及价差为 0.42 bps，变化为 0.83 bps。针对“难道所有股票都不具流动性吗？”的质疑，Seagate 提供了答案：开盘时价差为 30.94 bps，是 SPY 触及价差的一百多倍。

查询SPY 更新加权平均买卖价差：7月6日在过去一个月中的排名（排名1 = 价差最窄）
每个数字背后的完整 SQL
SELECT
    round(anyIf(avg_spread_cents, d = toDate('2026-07-06')), 3) AS jul6_avg_spread_cents,
    arrayCount(x -> x < anyIf(avg_spread_cents, d = toDate('2026-07-06')), groupArrayIf(avg_spread_cents, d != toDate('2026-07-06'))) + 1 AS tightness_rank,
    count() AS sessions_compared,
    round(max(avg_spread_cents), 3) AS widest_session_cents,
    round(avgIf(avg_spread_cents, d != toDate('2026-07-06')), 3) AS other_sessions_avg_cents,
    replaceAll(formatDateTime(min(d), '%M %e, %Y'), '  ', ' ') AS first_session,
    sum(dropped_invalid) AS dropped_invalid_quotes
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,
           countIf(NOT (bid_price > 0 AND ask_price >= bid_price)) AS dropped_invalid
    FROM global_markets.cache_stocks_quotes
    WHERE ticker = 'SPY'
      AND sip_timestamp >= toDateTime('2026-06-04 00:00:00')
      AND sip_timestamp < toDateTime('2026-07-07 00:00:00')
      AND (toHour(sip_timestamp) * 60 + toMinute(sip_timestamp)) BETWEEN 810 AND 1199
    GROUP BY d
)

在整个常规交易日中，7 月 6 日是 SPY 过去一个月内价差最窄的交易日：按更新量加权的平均价差为 1.815 美分，在 June 4, 2026 以来的 21 个交易日中排名 1；而该月平均价差为 2.337 美分，最大值达到 2.865。尽管节假日导致报价数量减少，但指数买家仍获得了全场最低的成交价差。

利率：长假期间曲线走势平稳

查询国债收益率曲线：7月6日对比7月2日数据（仅包含已发布的期限）
每个数字背后的完整 SQL
SELECT
    t.1 AS curve_point,
    round(t.2, 2) AS jul6_yield_pct,
    round((t.2 - t.3) * 100) AS session_change_bp
FROM (
    SELECT arrayJoin([
        ('1 month',  toFloat64(d.yield_1_month),  toFloat64(p.yield_1_month)),
        ('3 month',  toFloat64(d.yield_3_month),  toFloat64(p.yield_3_month)),
        ('1 year',   toFloat64(d.yield_1_year),   toFloat64(p.yield_1_year)),
        ('2 year',   toFloat64(d.yield_2_year),   toFloat64(p.yield_2_year)),
        ('5 year',   toFloat64(d.yield_5_year),   toFloat64(p.yield_5_year)),
        ('10 year',  toFloat64(d.yield_10_year),  toFloat64(p.yield_10_year)),
        ('30 year',  toFloat64(d.yield_30_year),  toFloat64(p.yield_30_year)),
        ('2s10s spread', toFloat64(d.yield_10_year - d.yield_2_year), toFloat64(p.yield_10_year - p.yield_2_year))
    ]) AS t
    FROM (SELECT * FROM global_markets.treasury_yields WHERE date = '2026-07-06') AS d,
         (SELECT * FROM global_markets.treasury_yields WHERE date = '2026-07-02') AS p
)

长假期间，收益率曲线几乎没有波动。10年期利率维持在 4.48%，2s10s 利差为 0.35 个百分点，两者与7月2日的数值相比，波动均在1至2个基点以内；唯一显著变化的是3个月期利率，变动了 5 个基点。

交易日历回顾

查询7月6日公司日历与信息流（包含逆股本拆分陷阱）
每个数字背后的完整 SQL
WITH
    (
        SELECT (count(), uniqExact(publisher))
        FROM global_markets.stocks_news
        WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-07-06'
    ) AS news,
    (
        SELECT (argMax(t, n), max(n))
        FROM (
            SELECT t, count() AS n
            FROM (
                SELECT arrayJoin(tickers) AS t
                FROM global_markets.stocks_news
                WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-07-06'
            )
            WHERE t != 'SPCX'
            GROUP BY t
        )
    ) AS top_news
SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-07-06') AS ex_dividend_records,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date = '2026-07-06') AS splits_executed,
    (SELECT countIf(toFloat64(split_from) > toFloat64(split_to)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-06') AS reverse_splits,
    (SELECT countIf(toFloat64(split_to) > toFloat64(split_from)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-06') AS forward_splits,
    (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date = '2026-07-06') AS ipos_listed,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-06') AS sec_filings,
    (SELECT uniqExactIf(accession_number, form_type = '4') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-06') AS insider_form4_filings,
    (SELECT uniqExactIf(accession_number, form_type = '8-K') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-06') AS filings_8k,
    news.1 AS news_articles,
    news.2 AS news_publishers,
    top_news.1 AS most_covered_ticker,
    top_news.2 AS most_covered_articles

118 股息记录已进入 除息期，15 已执行拆股，0 有新股上市，SEC 指数记录了 3161 份备案文件 —— 包括 1219 4 号表格 和 201 8-K 文件 —— 数量少于节前周四。新闻流包含 236 篇文章，其中被报道最多的股票是 NVDA，报道量为 25。

波动股筛选器背后的反向拆股陷阱

14 的 15 次拆股为反向拆股（即股份合并，多发生于低价股），而1 次为正向拆股。反向拆股将多股旧股合并为一股，并按比例提高股价。在未经调整的筛选器中，这会被显示为三位数的“涨幅”，但实际上并没有产生任何收益。完整列表如下：

查询7月6日执行的所有拆分，及其拆分前后的未调整收盘价（排除无常规交易时段数据的拆分）
每个数字背后的完整 SQL
SELECT
    s.ticker AS ticker,
    toFloat64(s.split_from) AS old_shares,
    toFloat64(s.split_to) AS new_shares,
    round(toFloat64(s.split_from) / toFloat64(s.split_to), 0) AS old_shares_per_new,
    p.prev_close AS jul2_close,
    d.day_close AS jul6_close,
    round((d.day_close / p.prev_close - 1) * 100, 1) AS unadjusted_pct_chg
FROM (
    SELECT ticker, any(split_from) AS split_from, any(split_to) AS split_to
    FROM global_markets.stocks_splits
    WHERE execution_date = '2026-07-06'
    GROUP BY ticker
) s
INNER JOIN (
    SELECT ticker, round(toFloat64(argMax(close, window_start)), 2) AS prev_close
    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'
      AND ticker IN (SELECT ticker FROM global_markets.stocks_splits WHERE execution_date = '2026-07-06')
    GROUP BY ticker
    HAVING prev_close > 0
) p ON s.ticker = p.ticker
INNER JOIN (
    SELECT ticker, round(toFloat64(argMax(close, window_start)), 2) AS day_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-06 20:00:00'
      AND ticker IN (SELECT ticker FROM global_markets.stocks_splits WHERE execution_date = '2026-07-06')
    GROUP BY ticker
    HAVING day_close > 0
) d ON s.ticker = d.ticker
ORDER BY unadjusted_pct_chg DESC, ticker ASC

12 行中的每一行都在原始行情中显示了三位数或更高的“涨幅”——从顶部的 31450%（200 合并为 1，未调整收盘价从 $0.02 变为 $6.31）到最小比例的 226.1%（3 合并为 1）。表格中间有一个最典型的案例：一次 10 合并为 1 的反向拆股，使 TXXS 的未调整收盘价从周四的 $2.35 变为周一的 $24.34——这是十股变一股，而非十倍涨幅。使用原始价格变动进行筛选的工具会将此表中的所有股票排在真正的波动股之上；而我们的筛选器已剔除拆股影响。周四的 CRWD 正向拆股 则呈现了相反的假象，即暴跌。

交易时段确认 —— 假期后的首个交易日

查询交易时段检查：SPY 观测到的分钟线跨度、7月3日收盘及日历中的下一个交易日
每个数字背后的完整 SQL
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-06 13:30:00' AND window_start < '2026-07-06 20:00:00') AS regular_session_bars,
    uniqExactIf(toDate(toTimeZone(window_start, 'America/New_York')), window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-06 20:00:00') AS day_sessions,
    (SELECT count() FROM global_markets.delayed_stocks_minute_aggs
     WHERE ticker = 'SPY' AND window_start >= '2026-07-03 00:00:00' AND window_start < '2026-07-04 00:00:00') AS jul3_spy_bars,
    (SELECT replaceAll(formatDateTime(min(date), '%M %e, %Y'), '  ', ' ') FROM global_markets.stocks_market_holidays WHERE date > '2026-07-06' AND status = 'closed') AS next_closure_date,
    (SELECT argMin(name, date) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-06' AND status = 'closed') AS next_closure_name
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= '2026-07-06 00:00:00' AND window_start < '2026-07-07 00:00:00'

7月6日为完整交易时段，并非早盘收盘：SPY 的 K 线运行至纽约时间 04:00 至 19:59，共有 390 根常规时段 K 线。上周五（7月3日）共计生成了 0 根 SPY K 线 —— 由于7月4日独立日为周六，该交易日为完整收盘。下次收盘时间：Labor Day, September 7, 2026。假期前四周的交易情况请参见 周度回顾。

常见问题

2026年7月6日的股市表现如何？

四大指数 ETF 均收涨 —— QQQ 1.39%, SPY 0.87%, IWM 0.45%, DIA 0.42% —— 其中 62.4% 的高流动性股票上涨，涨幅主要源于隔夜跳空。

2026年7月6日的领涨板块是哪个？

科技板块 (XLK) 在 11 个板块 ETF 中表现最佳，涨幅为 1.71%；防御性板块表现最差，仅上涨 -1.08% —— 最差与最佳板块的利差为 2.79 个百分点，是 S&P 指数涨幅 0.87% 的数倍。

2026年独立日当天股市开盘了吗？

没有。由于 7 月 4 日是周六，交易所于 7 月 3 日（周五）休市庆祝独立日 —— 0 条 SPY 分时线记录了此次休市。7 月 6 日是复市后的首个交易日。

为什么部分股票在 7 月 6 日出现了巨大的单日涨幅？

因为执行了 14 反向拆股。将大量旧股按比例合并为一股并提高单价，会导致未经调整的行情显示出数百个百分点的“涨幅”，但持仓价值并未改变 —— 上文提到的 12 只股票均属于此类。

跳空开盘时的买卖价差是否较宽？

仅个股如此。SPY 在开盘前 12 分钟的中位数报价价差为 0.27 个基点，与午间水平一致；SanDisk 的报价价差比午间宽 12.9 个基点。

数据说明

  • 成交金额为分钟级代理指标 —— 即每分钟 K 线收盘价与成交量的乘积之和。
  • 板块篮子为自定义方法，而非供应商字段：包含 11 只标普板块 ETF（XLB, XLC, XLE, XLF, XLI, XLK, XLP, XLRE, XLU, XLV, XLY），每交易日保持一致。
  • 报价价差 为有效双向报价中 (卖价 − 买价) ÷ 中价的统计中位数；单向报价、零价差及交叉报价将被剔除，并计入面板统计。
  • 重复使用的代码列表 在完成实体验证前，暂不列入排行榜 (收据)。

方法论

  • 统计周期为单个交易日（1 交易时段，已通过观测 K 线验证）。时间戳以 UTC 存储，并在查询时转换为纽约时间。“收盘”指常规交易时段的最后一分钟 K 线；日期变更通过对比 7 月 6 日与 7 月 2 日得出——后者是 7 月 3 日休市前的上一个交易日，已通过 K 线验证，而非假设得出。
  • 在进行比例运算前，小数将被转换为 64 位浮点数。面板数据在编写时通过受限的只读路径读取一次。

每个面板均为存储的查询结果——图表、表格和 SQL 属于同一对象。您可以将其中任何内容粘贴到 Strasmore 终端进行自定义。前一交易日：7 月 2 日。下一交易日：7 月 7 日。

#recap#daily#spy#qqq#market structure