The eleven SPDR sector ETFs: July 2 close vs July 1 close, regular hours

Name: The eleven SPDR sector ETFs: July 2 close vs July 1 close, regular hours
Creator: Strasmore
Published: 2026-07-26
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-07-26, from Market Recap: July 2, 2026, The Day in Numbers.

as of 2026-07-26 table 11×6read in context →

The eleven SPDR sector ETFs: July 2 close vs July 1 close, regular hours — 11 rows by 6 columns, computed 2026-07-26 from US exchange, SIP and OPRA data.
ticker	prior_close	day_close	pct_chg	pts_above_worst_sector	day_dollar_bn
XLB	51	51.99	1.94	4.65	0.57
XLC	109.74	109.6	-0.13	2.58	0.83
XLE	52.82	53.23	0.78	3.48	1.46
XLF	54.79	55.61	1.5	4.2	2.36
XLI	183.41	183.91	0.27	2.98	1.15
XLK	185.54	180.52	-2.71	0	2.43
XLP	83.33	85	2	4.71	1.33
XLRE	44.18	44.69	1.15	3.86	0.22
XLU	44.76	45.76	2.23	4.94	1.05
XLV	159.57	163.77	2.63	5.34	2.01
XLY	118.07	117.11	-0.81	1.89	1.2

Rows × columns: 11 × 6
Computed: 2026-07-26
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for The eleven SPDR sector ETFs: July 2 close vs July 1 close, regular hours, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	11 distinct values (XLB, XLC, XLE…)
`prior_close`	number	44.18 to 185.54	US dollars
`day_close`	number	44.69 to 183.91	US dollars
`pct_chg`	number	-2.71 to 2.63	percent
`pts_above_worst_sector`	number	0 to 5.34
`day_dollar_bn`	number	0.22 to 2.43

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-07-26, and the query below is what returned them.

the exact SQL behind every number

WITH per_etf AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-07-02 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-02 00:00:00')) AS day_close,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-02 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-01 13:30:00' AND window_start < '2026-07-01 20:00:00')
        OR (window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 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_close / prior_close - 1) * 100 - min((day_close / prior_close - 1) * 100) OVER (), 2) AS pts_above_worst_sector,
    day_dollar_bn
FROM per_etf
ORDER BY ticker

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisMarket Recap: July 2, 2026, The Day in Numbers

Volume leaders two ways: top 6 by dollars traded, top 4 by shares traded (one reused-symbol listing excluded pending entity verification) table 10×6 → Median quoted spread in basis points, regular hours: index ETFs, megacaps, and the memory names table 8×6 → SPY / QQQ / DIA / IWM: July 2 vs the July 1 close, regular hours table 4×8 → The memory and storage names: change vs Wednesday's close, range timing, and dollar volume table 4×10 → Megacap rotation: change vs Wednesday's close, range timing, and dollar volume table 4×10 → Shares traded per 30-minute bucket, regular hours (billions) series 13×3 → See all 2,170 queries →