Strasmore Research
市場回顧 Matt Connor作者： Matt Connor · 更新於 2026-07-25

2026年6月30日盤勢數據回顧

第2季最後交易日：QQQ領漲但多數類股收黑，記憶體族群最強，尾盤同日到期選擇權值得留意。

2026年6月30日星期二——第2季最後一個交易日——科技股領漲，但整體市場多數收黑：QQQ上漲1.63%，SPY 0.73%，然而10檔標普類股基金中僅4檔收高（3,349檔流動性較高個股上漲，3,033檔下跌）。前一交易日：6月29日回顧。以下所有數據均來自儲存查詢——展開任一區塊即可查看SQL。

記分板

所有變動皆以6月30日最後一個正常交易時段收盤價，與6月29日週一進行比較。

查詢SPY / QQQ / DIA / IWM — 6月30日 對比 6月29日 收盤價，常規交易時段
每個數據背後的精確 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-06-29 13:30:00' AND window_start < '2026-06-29 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-06-30 13:30:00' AND window_start < '2026-06-30 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_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

SPY 開盤價 $741.29，收在 $746.32，接近當日高點 $748.02。QQQ 的 1.63% 對比 DIA 的 0.12%，就是當日格局：成長股領漲，藍籌股幾乎紋風不動，IWM 0.49%。

本日收盤的季度

6月30日為第2季 62 個交易日劃下句點，當日的市場傾向正是整季的縮影。

查詢2026年第2季全程：各指數ETF自4月1日開盤至6月30日收盤，常規交易時段
每個數據背後的精確 SQL 語法
WITH q2 AS (
    SELECT ticker,
           toDate(toTimeZone(window_start, 'America/New_York')) AS d,
           argMin(toFloat64(open), window_start) AS d_open,
           argMax(toFloat64(close), window_start) AS d_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'QQQ', 'DIA', 'IWM')
      AND window_start >= toDateTime('2026-04-01 00:00:00')
      AND window_start < toDateTime('2026-07-01 00:00:00')
      AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
    GROUP BY ticker, d
)
SELECT
    ticker,
    toString(min(d)) AS quarter_first_session,
    count() AS quarter_sessions,
    round(argMin(d_open, d), 2) AS quarter_open,
    round(argMax(d_close, d), 2) AS quarter_close,
    round((argMax(d_close, d) / argMin(d_open, d) - 1) * 100, 2) AS quarter_pct,
    countIf(d_close > d_open) AS up_sessions
FROM q2
GROUP BY ticker
ORDER BY quarter_pct DESC, ticker ASC

自4月1日開盤至6月30日收盤：QQQ +26.53%，IWM 20.21%，SPY 14.13%，DIA 12.08%。QQQ 在整季與6月30日當天均居領先，但中段班排名互換：SPY 在當日小幅領先 IWM，而 IWM 在整季表現領先 SPY。QQQ 在 62 個交易日中有 38 個交易日收高（第2季回顧逐項分析）。

當天是否異常？

查詢SPY 開盤至收盤變動，對比過去一個月交易日的排名（排名1 = 絕對變動最大）
每個數據背後的精確 SQL 語法
SELECT round(anyIf(oc_pct, d = toDate('2026-06-30')), 2) AS day_move_pct,
       arrayCount(x -> x > abs(anyIf(oc_pct, d = toDate('2026-06-30'))), groupArrayIf(abs(oc_pct), d != toDate('2026-06-30'))) + 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-01 00:00:00')
      AND window_start < toDateTime('2026-07-01 00:00:00')
      AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
    GROUP BY d
)

以盤中開盤到收盤的走勢來看——與收盤對收盤的計分板視角不同——SPY 變動幅度為 0.68%，在過去 21 個交易日中，絕對值大小排名第 7。指數表現平穩，但底層的個股動態並非如此。

市場廣度：微幅正向優勢

查詢6月30日交易金額至少$1M的標的，上漲家數 vs 下跌家數
每個數據背後的精確 SQL 語法
WITH per_ticker AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') AS day_dollar_volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE (window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
       OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 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,
    countIf(ticker IN ('XLB', 'XLE', 'XLF', 'XLI', 'XLK', 'XLP', 'XLRE', 'XLU', 'XLV', 'XLY')) AS sector_funds_counted,
    countIf(ticker IN ('XLB', 'XLE', 'XLF', 'XLI', 'XLK', 'XLP', 'XLRE', 'XLU', 'XLV', 'XLY')
        AND day_close > prior_close) AS sector_funds_up
FROM per_ticker
WHERE prior_close > 0 AND day_close > 0

3,349 檔上漲，3,033 檔下跌，88 檔持平：在 1.63% 成長指數收盤下，51.8% 的流動性標的收紅——近乎擲硬幣的機率。流動性篩選剔除了 11,525 檔雙邊交易標的中的 5,055（成交金額低於 100 萬美元），此處完整計入，未予隱藏。

逐產業檢視：資金實際流向何處

以每檔成分股一票的方式計算，會掩蓋資金真正的落腳處。以下十檔基金各持有標普500指數的一部分，最佳與最差者之間的差距，衡量出當日盤勢有多不均衡。

查詢十大S&P板塊基金於6月30日：較週一收盤變動，及各基金落後領先者的幅度
每個數據背後的精確 SQL 語法
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('XLB', 'XLE', 'XLF', 'XLI', 'XLK', 'XLP', 'XLRE', 'XLU', 'XLV', 'XLY')
      AND ((window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
        OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 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,
    if(day_close > prior_close, 1, 0) AS is_up,
    round(max((day_close / prior_close - 1) * 100) OVER () - (day_close / prior_close - 1) * 100, 2) AS pts_behind_leader,
    day_dollar_bn
FROM per_name
ORDER BY pct_chg DESC, ticker ASC

科技股（XLK）上漲 2.69%，獨占鰲頭：工業股 1.34%、原物料股 0.36% 與非必需消費股 0.15% 是僅有的其他收紅族群，盤面自金融股（-0.17%）以下一片慘綠，一路向下至公用事業股（-1.48%）、必需消費股（-1.53%），敬陪末座的是房地產股，跌幅達 -2%。最佳減最差：4.69 個百分點，4 檔基金中有 10 檔收紅。指數漲幅不到一個百分點，底下卻有四個百分點的落差：一個產業撐起全場。

今日全市場最大波動股

廣度衡量的是有多少檔股票上漲；這裡顯示的是哪些股票波動最大——在成交額達一千萬美元以上的標的中，依百分比變動列出前五名與後五名。

查詢6月30日交易金額$10M以上個股中，漲幅前5名與跌幅前5名（排除一檔重複代碼個股）
每個數據背後的精確 SQL 語法
WITH per_ticker AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') AS day_dollar_volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE (window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
       OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00')
    GROUP BY ticker
    HAVING prior_close > 1 AND day_close > 0 AND day_dollar_volume >= 10000000 AND ticker NOT IN ('SPCX')
)
SELECT
    board,
    ticker,
    prior_close,
    day_close,
    pct_chg,
    round(abs(pct_chg), 2) AS abs_pct_chg,
    dollar_volume_m,
    if(ticker IN (SELECT ticker FROM global_markets.stocks_splits
                  WHERE execution_date >= '2026-06-29' AND execution_date <= '2026-06-30'), 1, 0) AS split_record_on_file
FROM (
    SELECT 'top gainers' AS board, 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_dollar_volume / 1e6, 0) AS dollar_volume_m
    FROM per_ticker
    ORDER BY (day_close / prior_close) DESC, ticker ASC
    LIMIT 5
    UNION ALL
    SELECT 'top decliners' AS board, 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_dollar_volume / 1e6, 0) AS dollar_volume_m
    FROM per_ticker
    ORDER BY (day_close / prior_close) ASC, ticker ASC
    LIMIT 5
)
ORDER BY if(board = 'top gainers', 0, 1) ASC, pct_chg DESC, ticker ASC

兩個排行榜看起來都不像大盤指數。JEM 以 +256.76% 領漲，成交額 141 百萬美元；SOC 下跌 55.89%，成交額 306 百萬美元。ABVX 上漲 38.56%，成交額 942 百萬美元，是兩個排行榜中週轉率最高的；NVCT 下跌 35.62%，UNCY 下跌 39.09%。分割記錄欄位確保了排行榜的真實性——一次 1 股換 10 股的反向股票分割在未調整的報價上會顯示為 +900% 的「漲幅」——而這裡的每一檔股票都帶有 0：真實的成交記錄。

有三列是同一筆交易出現兩次：CRCA（-35.16%）和 CRCG（-35.19%）下跌，而 CRCD 上漲 35.47%——每一檔的波動幅度都接近下方那檔加密貨幣相關標的 -17.53% 波動的兩倍：這些是槓桿型單一股票包裝產品。

今日焦點：半導體股進入季度轉折

六檔個股，一個主題，截然不同的結果——僅呈現共移性與幅度；數據並未說明原因。

查詢半導體與儲存類股：較週一收盤變動、區間振幅及成交金額
每個數據背後的精確 SQL 語法
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        maxIf(toFloat64(high), window_start >= '2026-06-30 00:00:00') AS day_high,
        minIf(toFloat64(low), window_start >= '2026-06-30 00:00:00') AS day_low,
        argMinIf(window_start, toFloat64(low), window_start >= '2026-06-30 00:00:00') AS low_bar,
        argMaxIf(window_start, toFloat64(high), window_start >= '2026-06-30 00:00:00') AS high_bar,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AMD', 'INTC', 'MU', 'SNDK', 'TSM', 'WDC')
      AND ((window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
        OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 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

SanDisk 上漲 10.79%，AMD 上漲 7.7%，Intel 上漲 5.93%，TSMC 上漲 4.86%——而 MU，這檔當日成交金額高達 $37.41 億的最大票，收盤僅上漲 0.52%，Western Digital（-2.01%）則未參與漲勢。這就是科技股 2.69% 類股表現背後的複雜面貌（MU 的六月逐筆交易明細）。

反向資金流則貫穿加密貨幣相關金融股，與大盤漲勢相悖：

查詢加密貨幣相關金融股：較週一收盤變動、區間振幅及成交金額
每個數據背後的精確 SQL 語法
WITH per_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-06-30 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-06-30 00:00:00')) AS day_close,
        maxIf(toFloat64(high), window_start >= '2026-06-30 00:00:00') AS day_high,
        minIf(toFloat64(low), window_start >= '2026-06-30 00:00:00') AS day_low,
        argMinIf(window_start, toFloat64(low), window_start >= '2026-06-30 00:00:00') AS low_bar,
        argMaxIf(window_start, toFloat64(high), window_start >= '2026-06-30 00:00:00') AS high_bar,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-06-30 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('COIN', 'CRCL', 'HOOD', 'MSTR')
      AND ((window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
        OR (window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 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

CRCL 收在 -17.53%，其 $62.52 的低點出現在美東時間 15:59——也就是該交易時段的最後一分鐘——MSTR -6.2%、COIN -3.61% 與 HOOD -1.53% 也同步走低。觀察到共移現象；未推斷因果關係。

新聞摘要所傳遞的內容

一份拒絕斷言因果關係的回顧，仍應向讀者交代當日實際刊出的報導。

查詢6月30日新聞資訊：文章數量及本期回顧中每檔個股當日最後一則標題
每個數據背後的精確 SQL 語法
SELECT
    names.n AS ticker,
    countIf(has(tickers, names.n)) AS articles_today,
    if(countIf(has(tickers, names.n)) = 0, 'none',
       formatDateTime(toTimeZone(argMaxIf(published_utc, (published_utc, id), has(tickers, names.n)), 'America/New_York'), '%H:%i')) AS latest_et,
    if(countIf(has(tickers, names.n)) = 0, 'no article in our feed this session',
       JSONExtractString(argMaxIf(publisher, (published_utc, id), has(tickers, names.n)), 'name')) AS publisher_name,
    if(countIf(has(tickers, names.n)) = 0, 'no article in our feed this session',
       argMaxIf(title, (published_utc, id), has(tickers, names.n))) AS latest_headline
FROM global_markets.stocks_news
CROSS JOIN (SELECT arrayJoin(['NVDA', 'MU', 'SNDK', 'CRCL', 'SOC', 'ABVX', 'JEM']) AS n) AS names
WHERE published_utc >= '2026-06-30 04:00:00' AND published_utc < '2026-07-01 04:00:00'
GROUP BY names.n
ORDER BY articles_today DESC, ticker ASC

報導數量最多的個股是 NVDA，共 21 篇——但它甚至不在當日波動最大的個股之列——該股當天最後一篇報導（美東時間 16:28，Investing.com）標題為「These Stocks Could Benefit as the Robotaxi Race Heats Up」。MU 獲得 7 篇報導；SanDisk 唯一的一篇報導（The Motley Fool）是全天唯一在標題中明確提及實際走勢的：「Why Sandisk Stock Is Skyrocketing Today」。

這個落差正是關鍵發現：當日跌幅最深、漲幅最大，以及跌幅最重的加密貨幣相關個股，各自僅獲得 0、0 與 0 篇報導——在總計 211 篇的資訊流中，三者皆為零。報導量並不能作為價格走勢的替代指標。

資金流向何處

查詢成交量領先者雙維度：成交金額前6名，成交股數前4名（一檔重複代碼個股排除，待實體驗證）
每個數據背後的精確 SQL 語法
SELECT ticker, leaderboard, dollar_volume_bn, if(dollar_volume_bn < 1, dollar_volume_m, NULL) AS dollar_value_m, 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(close) * toFloat64(volume)) / 1e6, 0) AS dollar_volume_m,
        round(sum(toFloat64(volume)) / 1e6, 1) AS shares_m
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 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(close) * toFloat64(volume)) / 1e6, 0) AS dollar_volume_m,
        round(sum(toFloat64(volume)) / 1e6, 1) AS shares_m
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 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

以金額計，美光（MU）的交易量壓倒一切，甚至超越指數基金：$37.41 億，對比 SPY 的 $31.84 億——這是它連續第二個交易日成交量超越這檔旗艦指數基金（週一回顧 記錄了首次超越）。個股排行榜則呈現不同面貌：SOXS，一檔三倍做空半導體 ETF（515.5 萬股），以及兩檔股價低於一美元的股票，其成交金額僅是美光當日成交額的零頭——成交量 有兩種解讀方式。

有一檔股票被刻意排除在兩個排行榜之外：一家六月上市的公司，其股票代碼先前屬於另一家不相關的企業，導致數據供應商的資訊將兩個不同實體標記為相同的三個字母（相關記錄在此）。

查詢每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-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'
GROUP BY et_time
ORDER BY et_time

開盤前半小時成交 2.05 億股，在 13:30 時出現 0.78 億股的日內低谷，而當日最大的成交區塊——2.69 億股——集中在季末收盤時段，此處正是收盤競價及其再平衡資金流印證的時刻（6 月 29 日的深入分析 揭示了數據背後的細節）。

選擇權交易紀錄

查詢選擇權全日概覽：成交量、當日到期量、SPY買賣權偏斜度按價內外程度分布、假期推移週次
每個數據背後的精確 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-06-30 00:00:00' AND sip_timestamp < '2026-07-01 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-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00'
    ) AS spy_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) = '260630') / sum(size), 1) AS same_day_expiry_pct,
    round(toFloat64(sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260702')) / 1e6, 2) AS thu_jul2_expiry_contracts_m,
    countIf(substring(ticker, length(ticker) - 14, 6) = '260703') AS fri_jul3_expiry_prints,
    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 = 'SPY' AND option_type = 'P'))
        / toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'C')), 2) AS spy_put_call_ratio,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'C'
        AND substring(ticker, length(ticker) - 14, 6) = '260630' AND toFloat64(strike_price) > spy_close)) / 1e6, 2) AS spy_0dte_otm_calls_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'C'
        AND substring(ticker, length(ticker) - 14, 6) = '260630' AND toFloat64(strike_price) <= spy_close)) / 1e6, 2) AS spy_0dte_itm_calls_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'P'
        AND substring(ticker, length(ticker) - 14, 6) = '260630' AND toFloat64(strike_price) < spy_close)) / 1e6, 2) AS spy_0dte_otm_puts_m,
    round(toFloat64(sumIf(size, underlying_symbol = 'SPY' AND option_type = 'P'
        AND substring(ticker, length(ticker) - 14, 6) = '260630' AND toFloat64(strike_price) >= spy_close)) / 1e6, 2) AS spy_0dte_itm_puts_m,
    top_contract.1 AS top_contract_underlying,
    top_contract.2 AS top_contract_strike,
    top_contract.3 AS top_contract_type,
    top_contract.4 AS top_contract_expiry,
    top_contract.5 AS top_contract_volume,
    round(top_contract.7, 3) AS top_contract_avg_price,
    round(top_contract.2 - spy_close, 2) AS top_strike_minus_spy_close
FROM global_markets.options_trades
WHERE sip_timestamp >= '2026-06-30 00:00:00' AND sip_timestamp < '2026-07-01 00:00:00'

選擇權交易量達 61.95 百萬口合約，分佈在 10.06 百萬筆成交中；買權佔全市場成交量的 57.3%，其中 28% 於該週二到期。SPY 的情況則相反：12.04 百萬口合約，賣權/買權比率為 1.09 —— 在基金當日上漲的日子裡，賣權多於買權。

將 SPY 當日到期的合約與其 $746.32 的收盤價對照，偏斜結構便清晰可見：3.33 百萬口價外賣權（履約價低於收盤價）和 2.28 百萬口價外買權，對比 1.77 百萬口價內買權和 0.63 百萬口價內賣權 —— 到期歸零的下跌履約價區間，是 SPY 0DTE 交易日中最活躍的部分。沒有任何一筆 7 月 3 日星期五到期的代碼成交（0 筆成交 —— 該週五市場休市）；週四的每週選擇權成交量為 10.52 百萬口。

查詢6月30日成交量最大的六檔選擇權合約，按合約成交量排序
每個數據背後的精確 SQL 語法
SELECT
    concat(underlying, ' $', toString(strike), ' ', if(typ = 'C', 'call', 'put')) AS contract,
    toString(expiry) AS expires,
    formatDateTimeInJodaSyntax(expiry, 'MMMM d, yyyy') AS expires_label,
    if(expiry = toDate('2026-06-30'), 1, 0) AS is_same_day,
    contracts,
    round(avg_px, 3) AS avg_premium,
    round(100 * contracts / max(contracts) OVER (), 1) AS pct_of_busiest
FROM (
    SELECT any(underlying_symbol) AS underlying,
           any(toFloat64(strike_price)) AS strike,
           any(option_type) AS typ,
           any(toDateOrNull(concat('20', substring(ticker, length(ticker) - 14, 6)))) AS expiry,
           sum(size) AS contracts,
           avg(toFloat64(price)) AS avg_px,
           any(ticker) AS occ
    FROM global_markets.options_trades
    WHERE sip_timestamp >= '2026-06-30 00:00:00' AND sip_timestamp < '2026-07-01 00:00:00'
    GROUP BY ticker
    ORDER BY contracts DESC, occ ASC
    LIMIT 6
)
ORDER BY contracts DESC, contract ASC

全市場最活躍的合約是當日到期的 SPY $747 買權 —— 821,361 口合約，平均權利金為 $0.641，最終價格比 SPY 最後一根常規 K 線收盤價高出 $0.68，且到期歸零。其後的排行就是教訓：交易紀錄上最活躍的六檔合約中，有五檔是圍繞收盤價、履約價相差一美元的當日到期 SPY 合約（其次是 SPY $748 call），每口僅以數美分交易。唯一的例外是 KWEB $29 call 到期 December 18, 2026，並非當日到期合約，其成交量僅為榜首的 65.1%：在五張午後樂透彩券之中，夾雜著一筆六個月期的部位。

利率：長端殖利率在半年收盤前走升

查詢美國公債殖利率曲線，6月30日收盤 vs 6月29日（僅顯示有報價之年期）
每個數據背後的精確 SQL 語法
SELECT
    t.1 AS curve_point,
    round(t.2, 2) AS jun30_yield_pct,
    round((t.2 - t.3) * 100) AS one_day_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-06-30') AS d,
         (SELECT * FROM global_markets.treasury_yields WHERE date = '2026-06-29') AS p
)

長端殖利率在半年最後一個交易日回彈：10年期上升 6 個基點至 4.44%，2年期上升 4 個基點至 4.14%，2年10年期利差則陡峭化 2 個基點至 0.3 個點。長端殖利率在盤中走升，當日表現最弱的板塊房地產（-2%）與第三弱的公用事業（-1.48%）均為典型的利率敏感族群：此一現象值得留意，但並非本數據所能證明的因果機制（上半年回顧載有該半年的殖利率曲線走勢）。

當日背後的日曆

查詢6月30日公司行事曆與資訊流，一行顯示（申報索引缺口一覽）
每個數據背後的精確 SQL 語法
WITH
    (
        SELECT (count(), uniqExact(publisher))
        FROM global_markets.stocks_news
        WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-06-30'
    ) 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-06-30'
            )
            WHERE t != 'SPCX'
            GROUP BY t
        )
    ) AS top_news
SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-06-30') AS ex_dividend_records,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date = '2026-06-30') AS splits_executed,
    (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date = '2026-06-30') AS ipos_listed,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-06-30') AS sec_filings,
    (SELECT uniqExactIf(accession_number, form_type = '4') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-06-30') AS insider_form4_filings,
    (SELECT uniqExactIf(accession_number, form_type = '8-K') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-06-30') AS filings_8k,
    (SELECT arrayStringConcat(groupArray(concat(ticker, ' — ', issuer_name)), '; ') FROM (
        SELECT ticker, issuer_name FROM global_markets.stocks_ipos WHERE listing_date = '2026-06-30' ORDER BY ticker
    )) AS ipo_names,
    news.1 AS news_articles,
    news.2 AS news_publishers,
    top_news.1 AS most_covered_ticker,
    top_news.2 AS most_covered_articles,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-06-29')) AS filings_prior_session

704 筆除息紀錄在該季最後一個交易日除息——典型的季末浪潮，大多數美國公司按季配息——另有 7 次股票分割與 2 檔新掛牌（AACU — Ares Acquisition Corp III; OSPRU — Osprey Acquisition Corp. III）。申報量才是數據品質的頭條：SEC 索引在 6 月 30 日這一天收錄了 31 份申報文件——0 份內部人 Form 4、0 份 8-K——相較之下，前一個交易日為 4439 份。這是月效應在數據饋送中的典型模式，已在月末缺口說明中診斷；任何包含這一天的統計，在資料補齊之前都會被低估。

已驗證的完整交易時段

查詢交易時段檢查：SPY 所觀測到的分鐘K線跨度
每個數據背後的精確 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-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00') AS regular_session_bars,
    uniqExactIf(toDate(toTimeZone(window_start, 'America/New_York')), window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00') AS day_sessions
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= '2026-06-30 00:00:00' AND window_start < '2026-07-01 00:00:00'

SPY 的 K 棒涵蓋紐約時間 04:00 至 19:59，精確包含 390 根常規交易時段 K 棒——此為經由逐筆成交資料驗證的完整交易時段（交易所日曆資料集僅包含未來的休市日期）。

這場交易到底說明了什麼

一個 0.73% 的 SPY 收盤，搭配 51.8% 的個股上漲、4 的 10 檔板塊 ETF 收紅，以及最佳與最差板塊之間 4.69 點的差距——這不是一次廣泛的漲勢，而是一個板塊的漲勢披著指數的外衣，是它在一場季末定價拍賣中，最沉重的半小時。指數的變動只是一個平均值，而這一次，它是由科技股獨力扛起，其他多數板塊卻在下跌：在相信那支箭頭之前，先檢查一下內部的分歧程度。

常見問題

2026年6月30日股市表現如何？

大盤收高：SPY 較6月29日收盤上漲 0.73%，QQQ 上漲 1.63%。漲勢廣度較窄——流動性較佳的個股中有 51.8% 上漲，4 檔 S&P 類股 ETF 中 10 檔收紅。

2026年6月30日哪個類股領漲？

科技股：XLK 上漲 2.69%，工業股次之，上漲 1.34%，不動產表現最差，上漲 -2%——最佳與最差類股之間差距 4.69 個百分點。

2026年6月30日波動最大的股票有哪些？

在成交金額達一千萬美元以上的個股中，JEM 漲幅最大（+256.76%），SOC 跌幅最深（55.89%）。兩者均無股票分割紀錄：這些都是真實的價格變動，並非公司行動造成的假象。

2026年第2季股市表現如何？

從4月1日開盤到6月30日收盤，歷經 62 個交易日：QQQ +26.53%，IWM 20.21%，SPY 14.13%，DIA 12.08%——這是一個由成長股主導的季度，並以一個由成長股主導的交易日作結。

為何最後半小時成交量如此龐大？

最後半小時成交 2.69 億股，而開盤時段為 2.05 億股。收盤集合競價透過單次撮合決定每檔股票的官方收盤價，指數基金在此交易以追蹤該價格；季末再平衡進一步集中了交易流量。

資料說明與方法

  • 觀察籃股。 類股面板為其面板中列出的十檔 SPDR 類股基金——每節皆為相同籃股，因此離散度數值可跨日比較。波動個股面板要求成交額達一千萬美元且前收盤價高於 1 美元，排除上方重複使用的代碼列表，並附有分割記錄欄位。
  • 注意事項。 成交金額為每分鐘的近似值（收盤價 × 每根 K 棒成交量）。6 月 30 日的申報索引幾乎為空（月底缺口說明對此進行了診斷）。新聞計數來自單一供應商資訊源：此處無文章並不代表其他地方未曾發布任何內容。
  • 方法。 單一節（1，根據觀察到的 K 棒驗證）；時間戳記以 UTC 儲存，在查詢中轉換為紐約時間；「收盤價」為最後一根常規分鐘 K 棒，而非集合競價列印價。選擇權到期日根據 OCC 代碼重新解析（表格自身的欄位有誤）；價內外程度以 SPY 最後一根常規 K 棒衡量。面板在撰寫時，透過受限的唯讀路徑執行一次。資料倉儲截至 2026 年 7 月 13 日。

每個面板都是一個儲存的查詢結果——圖表、表格與 SQL 整合於單一物件中。可將任一查詢結果貼入 Strasmore 終端機。下一節：7 月 1 日。

#recap#daily#spy#qqq#market structure