June 2026: open to close, range, and regular-hours turnover for the four index ETFs

Name: June 2026: open to close, range, and regular-hours turnover for the four index ETFs
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: June 2026.

as of 2026-07-26 table 4×7read in context →

June 2026: open to close, range, and regular-hours turnover for the four index ETFs — 4 rows by 7 columns, computed 2026-07-26 from US exchange, SIP and OPRA data.
ticker	month_open	month_close	month_return_pct	month_high	month_low	rth_dollar_bn
DIA	509.85	522.28	2.4	526.57	500.1	54.1
IWM	288.37	300.42	4.2	301.5	277.62	162.4
QQQ	737.04	735.76	-0.2	748.65	686.37	672.8
SPY	755.36	746.32	-1.2	760.4	716.58	771.5

Rows × columns: 4 × 7
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 June 2026: open to close, range, and regular-hours turnover for the four index ETFs, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	4 distinct values (DIA, IWM, QQQ…)
`month_open`	number	288.37 to 755.36	US dollars
`month_close`	number	300.42 to 746.32	US dollars
`month_return_pct`	number	-1.2 to 4.2	percent
`month_high`	number	301.5 to 760.4	US dollars
`month_low`	number	277.62 to 716.58	US dollars
`rth_dollar_bn`	number	54.1 to 771.5

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

SELECT ticker,
    round(argMinIf(toFloat64(open), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS month_open,
    round(argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS month_close,
    round((argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / argMinIf(toFloat64(open), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) - 1) * 100, 1) AS month_return_pct,
    round(maxIf(toFloat64(high), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS month_high,
    round(minIf(toFloat64(low), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS month_low,
    round(sumIf(toFloat64(close) * toFloat64(volume), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / 1e9, 1) AS rth_dollar_bn
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('SPY', 'QQQ', 'DIA', 'IWM')
  AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
GROUP BY ticker
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: June 2026

Every June on the tape: SPY, recomputed identically by year (session counts shown) ranking 23×3 → Ex-dividend events by day through June ranking 22×2 → Treasury yields through June: 10-year, 2-year, and the 2s10s spread ranking 21×4 → SPY, all 21 June sessions: close and close-over-close change series 21×3 → Monthly returns, January through June 2026, recomputed live (SPY and QQQ) ranking 12×4 → June regular-hours dollar volume, whole tape (one reused-symbol listing excluded pending entity verification) ranking 8×3 → See all 2,170 queries →