Strasmore Research
市场回顾 Matt Connor作者： Matt Connor

2026年7月20日市场周报

7月期权到期后首周：SPY、DIA、IWM、QQQ涨跌幅对比，板块离散度与周度宽度分析，资金流向追踪。

2026年7月20日这一周是7月月度期权到期后的第一个完整交易周，期间包含5个交易日且无休市。SPY本周收盘价相对上周的变动为-0.59%，若以开盘价至收盘价衡量，其在过去一年中的周度排名为43/53。以下每个数字均来自存储查询，每个时间窗口均绑定具体日期，因此重新运行SQL将得到相同结果。

本周行情概览

周度变动统计区间为7月17日（周五）常规收盘至7月24日（周五）。最后一列显示前一周数据，两列并列呈现。各行按字母顺序排列。

查询SPY / QQQ / DIA / IWM：7月20日当周对比7月17日收盘，附前周变动
每个数字背后的完整 SQL
SELECT ticker,
    round(argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00'), 2) AS prior_week_close,
    round(argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-24 13:30:00' AND window_start < '2026-07-24 20:00:00'), 2) AS week_close,
    round((argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-24 13:30:00' AND window_start < '2026-07-24 20:00:00')
         / argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00') - 1) * 100, 2) AS week_change_pct,
    round((argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
         / argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00') - 1) * 100, 2) AS prior_week_change_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('SPY', 'QQQ', 'DIA', 'IWM')
  AND ((window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')
    OR (window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
    OR (window_start >= '2026-07-24 13:30:00' AND window_start < '2026-07-24 20:00:00'))
GROUP BY ticker
ORDER BY ticker

本周表现：DIA变动-0.38%，IWM变动-0.98%，QQQ变动-1.59%，SPY变动-0.59%，最终收于738.85美元。前一周数据按相同字母顺序排列为-0.95%、-0.63%、-4.17%、-1.55%。四大指数间的差距是行情板衡量的首要指标，且这种差距并非总是微小。

当周在滚动年度中的表现

单周数据若缺乏其背后的分布情况，则意义有限。本板块采用统一逻辑重新计算每个滚动周的表现（从开盘到收盘，涵盖常规交易时段），并据此对当前周进行排名。

查询SPY周度在滚动年度背景下的表现（开盘至收盘周回报）
每个数字背后的完整 SQL
SELECT round(anyIf(ret, wk = toDate('2026-07-20')), 2) AS week_open_to_close_pct,
       arrayCount(x -> x > anyIf(ret, wk = toDate('2026-07-20')), groupArrayIf(ret, wk != toDate('2026-07-20'))) + 1 AS rank_best,
       count() AS weeks_compared,
       toString(min(wk)) AS first_week,
       anyIf(sessions_measured, wk = toDate('2026-07-20')) 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_measured,
           (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-21 00:00:00')
      AND window_start < toDateTime('2026-07-25 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_measured >= 3
)

按此方法计算，SPY 的回报率为 -1.1%，在回溯至 2025-07-21 的 53 周中排名第 43 位。请注意定义上的差异：此数据从当周首个常规交易时段开盘价开始计算，而上方记分板则从前一周收盘价开始计算。两者在各自出现的位置均已标注。

五个交易日，一条主线

查询SPY按交易时段：收盘价、变动及成交量，7月20-24日
每个数字背后的完整 SQL
SELECT toString(d) AS date,
       round(c, 2) AS spy_close,
       round((c / prev_c - 1) * 100, 2) AS change_pct,
       round(shares_m, 1) AS spy_shares_m
FROM (
    SELECT d, c, shares_m,
           lagInFrame(c) OVER (ORDER BY d ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_c
    FROM (
        SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d,
               argMax(toFloat64(close), window_start) AS c,
               toFloat64(sum(volume)) / 1e6 AS shares_m
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND ((window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
            OR (window_start >= '2026-07-20 13:30:00' AND window_start < '2026-07-24 20:00:00'))
          AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
        GROUP BY d
    )
)
WHERE d >= '2026-07-20'
ORDER BY date

逐日来看，SPY的涨跌幅分别为：周一-0.15%、周二0.84%、周三-0.12%、周四-1.22%、周五0.08%，最终收于738.85美元，成交量为40.1万股。周一的涨跌幅以7月17日收盘价为基准计算，该交易日紧邻本周期之前。

市场宽度，逐日观察

指数水平只是一个数字。市场宽度统计的是与指数同向波动的股票数量，它决定了上涨周是广泛还是狭窄。

查询每日涨跌家数，成交额超500万美元个股，7月20-24日
每个数字背后的完整 SQL
SELECT toString(d) AS date, advancers, decliners, unchanged, measured_names
FROM (
    SELECT d,
           countIf(c > prev_c) AS advancers,
           countIf(c < prev_c) AS decliners,
           countIf(c = prev_c) AS unchanged,
           count() AS measured_names
    FROM (
        SELECT d, c, dv,
               lagInFrame(c) OVER (PARTITION BY ticker ORDER BY d ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_c
        FROM (
            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-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
                OR (window_start >= '2026-07-20 13:30:00' AND window_start < '2026-07-24 20:00:00'))
              AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
            GROUP BY ticker, d
        )
    )
    WHERE d >= '2026-07-20' AND prev_c > 0 AND dv >= 5000000
    GROUP BY d
)
ORDER BY date

周一，1268只3945统计范围内的股票上涨，2632只下跌。到周五，3950只股票中，2273只上涨，1635只下跌。某交易日收盘数据缺失的股票被排除在外，因此统计总数每日略有浮动。

同一问题，按整周统计一次：

查询周度广度：7月24日常规收盘对比7月17日，当周成交额超500万美元个股
每个数字背后的完整 SQL
SELECT
    countIf(cw > cp AND liquid) AS advancers,
    countIf(cw < cp AND liquid) AS decliners,
    countIf(cw = cp AND liquid) AS unchanged,
    countIf(liquid) AS measured_names,
    countIf(NOT liquid) AS dropped_by_liquidity_filter,
    round(100.0 * countIf(cw > cp AND liquid) / countIf(liquid), 1) AS advancer_pct
FROM (
    SELECT ticker, cp, cw, dv >= 5000000 AS liquid
    FROM (
        SELECT ticker,
               argMaxIf(toFloat64(close), window_start, window_start < '2026-07-18 00:00:00') AS cp,
               argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-24 13:30:00') AS cw,
               sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-20 13:30:00') AS dv
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ((window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
            OR (window_start >= '2026-07-20 13:30:00' AND window_start < '2026-07-25 00:00:00'))
          AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
        GROUP BY ticker
        HAVING cp > 0 AND cw > 0
    )
)

在6100只日均常规交易时段成交额超过五百万美元的股票中，2437只收于7月17日收盘价之上，3630只收于其下，上涨股占比为40%。流动性筛选标准排除了5099只当周成交额未达该门槛的股票。这些股票在此处被计入统计，而非直接剔除。

行业板块计分板

11只SPDR行业板块ETF，从7月17日收盘到7月24日收盘，按表现从优到劣排列。

查询行业ETF全周变动：7月24日收盘对比7月17日收盘
每个数字背后的完整 SQL
SELECT sector, week_pct, round(max(week_pct) OVER () - week_pct, 2) AS points_behind_best
FROM (
    SELECT multiIf(ticker = 'XLK', 'Technology', ticker = 'XLC', 'Communications', ticker = 'XLE', 'Energy',
                   ticker = 'XLF', 'Financials', ticker = 'XLI', 'Industrials', ticker = 'XLB', 'Materials',
                   ticker = 'XLP', 'Staples', ticker = 'XLRE', 'Real Estate', ticker = 'XLU', 'Utilities',
                   ticker = 'XLV', 'Health Care', 'Consumer Discretionary') AS sector,
           round((cw / cp - 1) * 100, 2) AS week_pct
    FROM (
        SELECT ticker,
               argMaxIf(toFloat64(close), window_start, window_start < '2026-07-18 00:00:00') AS cp,
               argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-24 13:30:00') AS cw
        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-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
            OR (window_start >= '2026-07-24 13:30:00' AND window_start < '2026-07-24 20:00:00'))
        GROUP BY ticker
        HAVING cp > 0 AND cw > 0
    )
)
ORDER BY week_pct DESC

Energy 以3.33%的表现雄踞榜首。Consumer Discretionary 以-5.2%垫底，落后8.53个百分点。这个差距即为本周的板块离散度，其本身值得关注：若所有11个板块彼此差距均在一个百分点之内，则市场状态与板块间分化达到两位数的情况截然不同。

资金流向何处

查询常规交易时段成交额领先个股，7月20-24日全周
每个数字背后的完整 SQL
SELECT ticker, week_dollar_bn, round(100 * week_dollar_bn / max(week_dollar_bn) OVER (), 1) AS pct_of_leader
FROM (
    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-20 13:30:00' AND window_start < '2026-07-24 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 8
)
ORDER BY week_dollar_bn DESC

MU 在五个交易日中录得158.1亿美元的常规交易时段成交额，超过SPY的133.9亿美元和QQQ的101.5亿美元。排名第八的AAPL成交额仅为领头羊的34.5%。成交额记录反映市场一周的博弈焦点，未必与价格走势一致。该指标的个股版本称为相对成交量。

本周最大涨跌股

拆股会改变报价数字，但不会改变实际价值：反向拆股会人为制造出四位数的虚假涨幅，正向拆股则会制造同等规模的虚假暴跌。本周共发生25次反向拆股和11次正向拆股，以下两个表格均剔除了在7月17日收盘至7月24日收盘期间（即涨跌幅统计的精确区间）执行拆股的股票。两个表格还要求常规交易时段成交额达到500万美元。

查询周度异动股：十大涨幅及跌幅，常规收盘，成交额超500万美元，不含拆股
每个数字背后的完整 SQL
SELECT ticker, board, week_pct, week_dollar_m, sessions_traded,
       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, sessions_traded
    FROM (
        SELECT ticker,
               argMaxIf(toFloat64(close), window_start, window_start < '2026-07-18 00:00:00') AS cp,
               argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-24 13:30:00') AS cw,
               sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-20 13:30:00') AS dv,
               uniqExactIf(toDate(toTimeZone(window_start, 'America/New_York')), window_start >= '2026-07-20 13:30:00') AS sessions_traded
        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-17' AND execution_date <= '2026-07-24')
          AND ((window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
            OR (window_start >= '2026-07-20 13:30:00' AND window_start < '2026-07-25 00:00:00'))
          AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
        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, sessions_traded
    FROM (
        SELECT ticker,
               argMaxIf(toFloat64(close), window_start, window_start < '2026-07-18 00:00:00') AS cp,
               argMaxIf(toFloat64(close), window_start, window_start >= '2026-07-24 13:30:00') AS cw,
               sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-20 13:30:00') AS dv,
               uniqExactIf(toDate(toTimeZone(window_start, 'America/New_York')), window_start >= '2026-07-20 13:30:00') AS sessions_traded
        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-17' AND execution_date <= '2026-07-24')
          AND ((window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
            OR (window_start >= '2026-07-20 13:30:00' AND window_start < '2026-07-25 00:00:00'))
          AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
        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

要进入任一表格，都需要有真实的涨跌。表格中涨幅最小的股票上涨了92.3%，跌幅最小的股票下跌了-47.8%。在极端情况下，STAK上涨了383.7%，成交额为251.6百万美元；LBGJ下跌了-98.8%，成交额为47.7百万美元。该跌幅已接近该股票的全部报价价值，因此表格附带了其交易记录：LBGJ在五个交易日中的5个交易日出现了常规交易时段的价格柱，且在该表格统计的两个收盘价之间，该股票未执行任何拆股。

逐日报价价差

价格是头条。完成交易的成本是报价价差，这里按每次交易时段对SPY进行测量，数据直接来自原始NBBO记录，而非任何汇总数据。

查询SPY中位报价价差及NBBO更新次数，常规时段，7月20-24日
每个数字背后的完整 SQL
SELECT toString(toDate(sip_timestamp)) AS date,
       round(quantileExactIf(0.5)(
           10000 * (toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2),
           bid_price > 0 AND ask_price > 0 AND ask_price >= bid_price), 2) AS median_spread_bps,
       round(count() / 1e6, 2) AS quote_updates_m,
       countIf(bid_price <= 0 OR ask_price <= 0) AS one_sided_quote_count,
       countIf(bid_price > ask_price AND bid_price > 0 AND ask_price > 0) AS crossed_quote_count
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'SPY'
  AND sip_timestamp >= '2026-07-20 13:30:00'
  AND sip_timestamp < '2026-07-24 20:00:00'
  AND (toHour(sip_timestamp) * 60 + toMinute(sip_timestamp)) BETWEEN 810 AND 1199
GROUP BY toDate(sip_timestamp)
HAVING countIf(bid_price > 0 AND ask_price > 0 AND ask_price >= bid_price) > 0
ORDER BY toDate(sip_timestamp)

SPY的报价价差中位数周一为0.27个基点（以中间价衡量），周五为0.27个基点，基于3.89万条和4.4万条NBBO更新数据。最后两列是披露而非发现：0个单边报价和1084个交叉报价被计入周一的中位数计算，而非被静默剔除。交叉报价（买价高于卖价）是合并数据流的常见产物，该数据流由多个交易场所的纳秒级分辨率数据拼接而成。

月度期权到期后的交易周

7月的月度到期日落在本周开盘前的周五，因此这五个交易日中交易的每一份合约都是该到期日的幸存者。到期时间安排决定了当日交易者遵循的节奏。

查询期权合约、同日股票及看涨期权份额，按交易时段，7月20-24日
每个数字背后的完整 SQL
SELECT toString(toDate(sip_timestamp)) AS date,
       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,
       round(100.0 * sumIf(size, substring(ticker, length(ticker) - 8, 1) = 'C') / sum(size), 1) AS pct_call,
       round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260724') / sum(size), 1) AS pct_expiring_jul24
FROM global_markets.options_trades
WHERE sip_timestamp >= '2026-07-20 00:00:00' AND sip_timestamp < '2026-07-25 00:00:00'
GROUP BY toDate(sip_timestamp)
ORDER BY toDate(sip_timestamp)

周一合约成交量为64百万份，周五为71.1百万份。当日合约占比（即交易当天到期的合约）周一为40.2%，周五（本周到期日）为49%。看涨期权占周五合约成交量的53.5%。而周五的吸引力从开盘交易时段便已显现：周一15.1%的成交量已集中在到期日为周五的合约中。

本周利率走势

查询国债收益率曲线按交易时段，7月17日收盘至7月24日
每个数字背后的完整 SQL
SELECT toString(date) AS date,
       round(toFloat64(yield_2_year), 2) AS yield_2y_pct,
       round(toFloat64(yield_10_year), 2) AS yield_10y_pct,
       round(toFloat64(yield_30_year), 2) AS yield_30y_pct,
       round((toFloat64(yield_10_year) - toFloat64(yield_2_year)) * 100) AS spread_2s10s_bp,
       round((toFloat64(yield_10_year) - (SELECT toFloat64(any(yield_10_year)) FROM global_markets.treasury_yields WHERE date = '2026-07-17')) * 100) AS chg_10y_from_prior_close_bp
FROM global_markets.treasury_yields
WHERE date >= '2026-07-17' AND date <= '2026-07-24'
ORDER BY date

以7月17日数据为基准，十年期收益率变动16个基点，至最新记录4.71%；两年期收益率为4.37%，三十年期为5.17%。两年与十年期利差在序列结束时为34个基点。美国财政部数据文件较实时行情滞后约一个交易日，因此本面板包含5个数据点，每个数据点日期已在表中标注。

空头：每日文件

FINRA 发布每日卖空量文件。卖空量是每日总流量而非持仓数据，这些文件有时会截断传输，因此在引用任何比率之前需先衡量覆盖范围。

查询每日卖空量文件覆盖：文件内代码及卖空股数，7月20-24日
每个数字背后的完整 SQL
SELECT date, tickers_on_file, short_shares_bn,
       round(100.0 * tickers_on_file / max(tickers_on_file) OVER (), 1) AS pct_of_fullest_file
FROM (
    SELECT toString(date) AS date,
           uniqExact(ticker) AS tickers_on_file,
           round(sum(short_shares) / 1e9, 2) AS short_shares_bn
    FROM (
        SELECT date, ticker, max(short_volume) AS short_shares
        FROM global_markets.stocks_short_volume
        WHERE date >= '2026-07-20' AND date <= '2026-07-24'
        GROUP BY date, ticker
    )
    GROUP BY date
)
ORDER BY date

本周有 5 份每日文件可用。第一份包含 15098 个股票代码和 4.71 亿股标记为空头的股票；最后一份包含 15062 个股票代码，即最完整文件股票代码数量的 99.7%。任何从明显低于相邻文件的文件中提取的个股卖空量数据，在该文件重新提交前均无法验证。

本周日历

查询SEC文件按交易时段及表格类型，7月20-24日
每个数字背后的完整 SQL
SELECT toString(filing_date) AS date,
       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-20' AND filing_date <= '2026-07-24'
GROUP BY filing_date
ORDER BY date

存档中的首个交易日包含 3012 份申报文件，其中 632 份为内部人士提交的表格4报告，166 份为8-K表格。最后一个交易日则包含 3814 份文件，其中 644 份为表格4，223 份为8-K表格。本周 5 的交易日均有EDGAR每日索引存档；该索引按自身时间表发布，偶尔会滞后于实时数据流。

查询本周公司日历：股息、拆股、上市、新闻
每个数字背后的完整 SQL
SELECT
    (SELECT count() FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-20' AND filing_date <= '2026-07-24') AS filings_week,
    (SELECT uniqExact(filing_date) FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-20' AND filing_date <= '2026-07-24') AS filing_days_on_file,
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-20' AND ex_dividend_date <= '2026-07-24') AS ex_dividends_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-20' AND ex_dividend_date <= '2026-07-24') AS household_ex_dividends_week,
    (SELECT countIf(toFloat64(split_from) > toFloat64(split_to)) FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-20' AND execution_date <= '2026-07-24') AS reverse_splits_week,
    (SELECT countIf(toFloat64(split_to) > toFloat64(split_from)) FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-20' AND execution_date <= '2026-07-24') AS forward_splits_week,
    (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date >= '2026-07-20' AND listing_date <= '2026-07-24') AS listings_week,
    (SELECT count() FROM global_markets.stocks_news WHERE published_utc >= '2026-07-20 04:00:00' AND published_utc < '2026-07-25 04:00:00') AS news_week,
    (SELECT uniqExact(JSONExtractString(publisher, 'name')) FROM global_markets.stocks_news WHERE published_utc >= '2026-07-20 04:00:00' AND published_utc < '2026-07-25 04:00:00') AS news_publishers_week

本周其余文书工作包括：5 个索引日内的 17106 份SEC申报文件、592 条除息记录（其中 1 条来自本面板追踪的十家知名企业）、25 次反向拆股和 11 次正向拆股、4 只新股上市，以及来自 2 家出版商的 1704 篇文章。最后两项指标衡量的是单一信息源的关注度，而非全球媒体整体情况。

交易时段，已核实

查询交易时段验证：时段、K线、假日行、上涨及下跌收盘、下次休市
每个数字背后的完整 SQL
WITH spy AS (
    SELECT d, c, lagInFrame(c) OVER (ORDER BY d ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS p
    FROM (
        SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d,
               argMax(toFloat64(close), window_start) AS c
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND ((window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
            OR (window_start >= '2026-07-20 13:30:00' AND window_start < '2026-07-24 20:00:00'))
          AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
        GROUP BY d
    )
)
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,
    count() AS regular_bars_in_week,
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date >= '2026-07-20' AND date <= '2026-07-24') AS holiday_rows_in_week,
    (SELECT countIf(c > p) FROM spy WHERE d >= '2026-07-20') AS up_sessions,
    (SELECT countIf(c < p) FROM spy WHERE d >= '2026-07-20') AS down_sessions,
    (SELECT toString(min(date)) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-24' AND date <= '2026-12-31' AND status = 'closed') AS next_closure_date,
    (SELECT argMin(name, date) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-24' AND date <= '2026-12-31' AND status = 'closed') AS next_closure_name
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
  AND window_start >= '2026-07-20 13:30:00' AND window_start < '2026-07-24 20:00:00'
  AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199

5 个交易时段，从 2026-07-20 到 2026-07-24，窗口内任意位置包含 0 个假日行。SPY 在这些时段内共生成 1950 根常规交易时段分钟柱。2 个交易时段收盘价高于前收盘价，3 个收盘价低于前收盘价。下一个计划内收盘时间为 2026-09-07 的 Labor Day。

即将到来

下周，请关注我方表格数据：

查询下周日历：休市、除息、拆股及期权到期
每个数字背后的完整 SQL
SELECT
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date >= '2026-07-27' AND date <= '2026-07-31' AND status != 'open') AS closures_next_week,
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-27' AND ex_dividend_date <= '2026-07-31') 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-27' AND ex_dividend_date <= '2026-07-31') AS household_ex_div_next_week,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-27' AND execution_date <= '2026-07-31') AS splits_next_week,
    (SELECT round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260731') / sum(size), 1) FROM global_markets.options_trades WHERE sip_timestamp >= '2026-07-24 00:00:00' AND sip_timestamp < '2026-07-25 00:00:00') AS jul31_expiry_pct_of_friday_volume,
    (SELECT toString(max(settlement_date)) FROM global_markets.stocks_short_interest WHERE settlement_date <= '2026-07-24') AS latest_short_interest_settlement

节假日表格显示，下周将有 0 个市场休市日。368 个除息记录落在该周内，其中 0 个来自家庭板块，另有 15 个计划中的股票分拆。在周五的期权成交量中，14.2% 已存在于下周五到期的合约中。存档中最新的空头头寸结算日期为 2026-07-15——该数据的发布延迟较长，足以拥有独立的说明页面。

常见问题

2026年7月20日当周股市表现如何？

SPY在7月17日至24日期间收盘价对收盘价变动了-0.59%，QQQ为-1.59%，DIA为-0.38%，IWM为-0.98%。在流动性较好的股票中，2437上涨，3630下跌。

2026年7月20日当周哪个板块领涨？

Energy，涨幅为3.33%。十一只SPDR行业ETF中表现最弱的是Consumer Discretionary，跌幅为-5.2%，落后8.53个百分点。

2026年7月20日当周有多少个交易日？

5，时间从2026-07-20到2026-07-24，窗口期内有0个假日数据行。下一个计划休市日为Labor Day。

2026年7月20日当周哪只股票成交额最高？

MU，常规交易时段成交额为158.1十亿美元，领先于SPY的133.9十亿美元。

数据说明

所有存储的时间戳均为协调世界时（UTC）；常规交易时段为每场 13:30-20:00 UTC 分钟，周度边界从7月17日常规收盘延伸至7月24日。此处每个收盘价对比面板均读取比较区间两侧最后一根常规交易时段分钟柱，因此盘后交易价格永远不会设定周度收盘价。滚动年度排名使用开盘至收盘的周度收益率，因此不会与收盘价对比排行榜匹配；两种定义在出现处均有标注。周度宽度与涨跌板采用500万美元常规交易时段成交额过滤器，宽度数据会公布被该过滤器剔除的股票数量。涨跌板排除所有在7月17日收盘后至7月24日期间（即变动衡量精确区间）执行拆股的股票，这既涵盖标注在中间周末的拆股，也涵盖标注在交易日的拆股；涨跌板不排除杠杆及反向ETF，这类产品在趋势性周度中可能主导榜单。下跌板底部可能接近该周报价价值的完全损失，该板块会公布每只股票在五个交易日中出现的次数。SPY价差面板统计单边报价与交叉报价而非直接剔除，中位数基于剩余有效报价计算。美国财政部文件比实时行情滞后约一个交易日，EDGAR每日索引按自身时间表发布，因此利率与申报面板会公布实际持有的天数。此处不出现隐含波动率指数：该系列未获授权进入本数据库，因此波动率通过价格区间、同日期权占比及报价行为从行情数据中读取。

方法论

  • 市场数据来源：统一行情带。delayed_stocks_minute_aggs 用于价格与成交量，cache_stocks_quotes 用于NBBO面板，options_trades 用于期权周。
  • 收盘价：交易时段最后一根常规时段分钟柱，绝不采用假设的16:00打印值或盘后打印值。
  • 交易时段：通过节假日表加实际观测柱验证，绝不依据日历假设。
  • 时区处理：WHERE子句使用原始UTC字面量，toTimeZone仅出现在SELECT列表中用于东部时间标签。
  • 小数处理：价格、规模与成交量列在进行除法或乘积运算前均转换为Float64类型。
  • 确定性聚合：全程使用精确分位数，散文中任何排序或符号声明均编码为合理性边界。
  • 仓库数据截止日期：2026年7月26日。

交叉链接：本系列周报上一期、买卖价差定义、期权到期机制、空头持仓与空头成交量的区别、两年期与十年期利差。

若需将窗口指向其他周，上述所有查询在Strasmore终端上均可直接运行，无需修改。

#recap#weekly#spy#sectors#期权#market structure