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.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

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

SQL to run

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

⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent

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 3,214 queries →