The memory complex and the megacaps: change vs Tuesday's close, range timing, and dollar volume

Name: The memory complex and the megacaps: change vs Tuesday's close, range timing, and dollar volume
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 1, 2026, The Day in Numbers.

as of 2026-07-26 table 8×9read in context →

The memory complex and the megacaps: change vs Tuesday's close, range timing, and dollar volume — 8 rows by 9 columns, computed 2026-07-26 from US exchange, SIP and OPRA data.
ticker	prior_close	day_close	pct_chg	day_high_et	day_low_et	low_minute_et	range_pct	day_dollar_bn
AMD	580.82	540.89	-6.87	09:51	15:57	957	4.71	12
META	562.94	612.92	8.88	11:05	09:30	570	5.58	22.72
MRVL	297.79	271.95	-8.68	10:08	15:58	958	7.8	7.14
MU	1151.01	1033.29	-10.23	09:48	15:59	959	6.28	42.94
NVDA	199.76	197.58	-1.09	15:09	09:33	573	3.31	21.73
SNDK	2272.59	2035.07	-10.45	09:51	14:49	889	6.39	18.38
STX	964.55	915.25	-5.11	09:51	09:35	575	5.69	2.84
WDC	638.57	598.37	-6.3	09:51	10:46	646	5.39	4

Rows × columns: 8 × 9
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 memory complex and the megacaps: change vs Tuesday's close, range timing, and dollar volume, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	8 distinct values (AMD, META, MRVL…)
`prior_close`	number	199.76 to 2,272.59	US dollars
`day_close`	number	197.58 to 2,035.07	US dollars
`pct_chg`	number	-10.45 to 8.88	percent
`day_high_et`	text	5 distinct values (09:48, 09:51, 10:08…)
`day_low_et`	text	8 distinct values (09:30, 09:33, 09:35…)
`low_minute_et`	number	570 to 959	US dollars
`range_pct`	number	3.31 to 7.8	percent
`day_dollar_bn`	number	2.84 to 42.94

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-01 00:00:00')) AS prior_close,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-01 00:00:00')) AS day_close,
        maxIf(toFloat64(high), window_start >= '2026-07-01 00:00:00') AS day_high,
        minIf(toFloat64(low), window_start >= '2026-07-01 00:00:00') AS day_low,
        argMinIf(window_start, (toFloat64(low), toInt64(toUnixTimestamp(window_start))), window_start >= '2026-07-01 00:00:00') AS low_bar,
        argMaxIf(window_start, (toFloat64(high), -toInt64(toUnixTimestamp(window_start))), window_start >= '2026-07-01 00:00:00') AS high_bar,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-01 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AMD', 'META', 'MRVL', 'MU', 'NVDA', 'SNDK', 'STX', 'WDC')
      AND ((window_start >= '2026-06-30 13:30:00' AND window_start < '2026-06-30 20:00:00')
        OR (window_start >= '2026-07-01 13:30:00' AND window_start < '2026-07-01 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,
    formatDateTime(toTimeZone(high_bar, 'America/New_York'), '%H:%i') AS day_high_et,
    formatDateTime(toTimeZone(low_bar, 'America/New_York'), '%H:%i') AS day_low_et,
    toHour(toTimeZone(low_bar, 'America/New_York')) * 60 + toMinute(toTimeZone(low_bar, 'America/New_York')) AS low_minute_et,
    round((day_high / day_low - 1) * 100, 2) AS range_pct,
    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 1, 2026, The Day in Numbers

The day's last twelve news articles tagging MU, SNDK, STX, WDC or META (one licensed feed) table 12×4 → The eleven S&P sector ETFs on July 1, best to worst vs Tuesday's close table 11×7 → 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 → The biggest names going ex-dividend on July 1, ranked by the day's dollar volume table 8×7 → The volatility complex on July 1: VIX-futures ETFs vs Tuesday's close, with SPY as the anchor table 5×5 → SPY / QQQ / DIA / IWM: July 1 vs the June 30 close, regular hours table 4×8 → See all 2,170 queries →