Fourteen chip names: prior close, day close, day range, dollar volume, low/high minute ET

Name: Fourteen chip names: prior close, day close, day range, dollar volume, low/high minute ET
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 8, 2026, The Day in Numbers.

as of 2026-07-26 table 14×10read in context →

Fourteen chip names: prior close, day close, day range, dollar volume, low/high minute ET — 14 rows by 10 columns, computed 2026-07-26 from US exchange, SIP and OPRA data.
ticker	prior_close	day_close	pct_chg	range_pct	day_low	day_high	low_minute_et	high_minute_et	day_dollar_bn
AMD	516.57	517.26	0.13	4.81	498.15	522.98	683	587	8.93
AVGO	370.79	388.67	4.82	4.91	376.89	395.09	570	778	9.39
INTC	110.5	110.27	-0.21	5.5	104.41	110.49	713	957	9.48
KLAC	216.52	221.03	2.08	4.2	214.3	223.4	685	929	1.79
LRCX	326.12	332.93	2.09	4.53	322.72	337.5	570	587	2.1
MRVL	230.81	231.66	0.37	5.12	224.98	236.79	570	593	4.57
MU	938.95	949.37	1.11	6.24	900.41	959	570	600	32.02
NVDA	196.93	204.14	3.66	5.13	195.06	205.16	570	937	24.17
SNDK	1619.26	1729.4	6.8	8.94	1590	1734.69	570	959	16.82
SOXL	165.27	174.84	5.79	10.82	158.87	176.75	570	816	8.12
SOXS	4.82	4.52	-6.22	11	4.46	4.99	929	570	2.97
STX	827.4	859.68	3.9	6.18	811.27	862.41	570	959	3.46
TER	343.1	351.56	2.47	5.6	335.06	354.27	686	587	0.77
WDC	532.34	550.71	3.45	6.91	526	562.76	570	600	3.03

Rows × columns: 14 × 10
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 Fourteen chip names: prior close, day close, day range, dollar volume, low/high minute ET, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	14 distinct values (AMD, AVGO, INTC…)
`prior_close`	number	4.82 to 1,619.26	US dollars
`day_close`	number	4.52 to 1,729.4	US dollars
`pct_chg`	number	-6.22 to 6.8	percent
`range_pct`	number	4.2 to 11	percent
`day_low`	number	4.46 to 1,590	US dollars
`day_high`	number	4.99 to 1,734.69	US dollars
`low_minute_et`	number	570 to 929	US dollars
`high_minute_et`	number	570 to 959	US dollars
`day_dollar_bn`	number	0.77 to 32.02

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_name AS (
    SELECT
        ticker,
        toFloat64(argMaxIf(close, window_start, window_start < '2026-07-08 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-08 00:00:00')) AS day_close,
        maxIf(toFloat64(high), window_start >= '2026-07-08 00:00:00') AS day_high,
        minIf(toFloat64(low), window_start >= '2026-07-08 00:00:00') AS day_low,
        argMinIf(window_start, (toFloat64(low), toInt64(toUnixTimestamp(window_start))), window_start >= '2026-07-08 00:00:00') AS low_bar,
        argMaxIf(window_start, (toFloat64(high), -toInt64(toUnixTimestamp(window_start))), window_start >= '2026-07-08 00:00:00') AS high_bar,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-08 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AMD', 'AVGO', 'INTC', 'KLAC', 'LRCX', 'MRVL', 'MU', 'NVDA', 'SNDK', 'SOXL', 'SOXS', 'STX', 'TER', 'WDC')
      AND ((window_start >= '2026-07-07 13:30:00' AND window_start < '2026-07-07 20:00:00')
        OR (window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 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 - day_low) / prior_close) * 100, 2) AS range_pct,
    round(toFloat64(day_low), 2) AS day_low,
    round(toFloat64(day_high), 2) AS day_high,
    toUInt32(toHour(toTimeZone(low_bar, 'America/New_York')) * 60 + toMinute(toTimeZone(low_bar, 'America/New_York'))) AS low_minute_et,
    toUInt32(toHour(toTimeZone(high_bar, 'America/New_York')) * 60 + toMinute(toTimeZone(high_bar, 'America/New_York'))) AS high_minute_et,
    day_dollar_bn
FROM per_name
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 8, 2026, The Day in Numbers

Top 6 by dollars traded, top 4 by shares traded: July 8 regular hours table 10×6 → Rotation check: eight names, defensives, mega-caps, biotech table 8×8 → SPY / QQQ / DIA / IWM: July 8 vs the July 7 close, regular hours table 4×10 → Shares per 30-minute ET bucket, regular hours, with % of the day's biggest bucket series 13×3 → Treasury yields: July 8 vs July 7, populated maturities + 2s10s ranking 8×3 → SPY / QQQ / NVDA / TSLA / MU / SNDK / AVGO: RTH median quoted spread in basis points ranking 7×2 → See all 2,170 queries →