STRASMORE/EXPLORE 2,170 QUERIES

Eight mega-caps and defensives: gap at the open vs the rest of the day, July 9

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 9, 2026, The Day in Numbers.

as of table 8×8read in context →
Eight mega-caps and defensives: gap at the open vs the rest of the day, July 9 — 8 rows by 8 columns, computed from US exchange, SIP and OPRA data.
tickerprior_closeday_openday_closegap_pctintraday_pctpct_chgday_dollar_bn
AAPL313.26310.51316.17-0.881.820.9311.14
AMZN243.55239.82246.95-1.532.971.46.79
CVX175.92174.63174.05-0.73-0.33-1.060.91
GOOGL361.64354.31358.89-2.031.29-0.766.75
JNJ263.36260.63259.1-1.04-0.59-1.621.25
META603.03583.99631.31-3.168.14.6912.69
MSFT383.05374.45384.33-2.252.640.338.27
TSLA393.92393.99406.560.023.193.2112.67
Rows × columns
8 × 8
Computed
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 Eight mega-caps and defensives: gap at the open vs the rest of the day, July 9, derived from the stored result.
ColumnTypeRangeNotes
ticker text 8 distinct values (AAPL, AMZN, CVX…)
prior_close number 175.92 to 603.03 US dollars
day_open number 174.63 to 583.99 US dollars
day_close number 174.05 to 631.31 US dollars
gap_pct number -3.16 to 0.02 percent
intraday_pct number -0.59 to 8.1 percent
pct_chg number -1.62 to 4.69 percent
day_dollar_bn number 0.91 to 12.69

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 , 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-09 00:00:00')) AS prior_close,
        toFloat64(argMinIf(open, window_start, window_start >= '2026-07-09 00:00:00')) AS day_open,
        toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-09 00:00:00')) AS day_close,
        round(sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-09 00:00:00') / 1e9, 2) AS day_dollar_bn
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL', 'AMZN', 'CVX', 'GOOGL', 'JNJ', 'META', 'MSFT', 'TSLA')
      AND ((window_start >= '2026-07-08 13:30:00' AND window_start < '2026-07-08 20:00:00')
        OR (window_start >= '2026-07-09 13:30:00' AND window_start < '2026-07-09 20:00:00'))
    GROUP BY ticker
)
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    round(day_open, 2) AS day_open,
    round(day_close, 2) AS day_close,
    round((day_open / prior_close - 1) * 100, 2) AS gap_pct,
    round((day_close / day_open - 1) * 100, 2) AS intraday_pct,
    round((day_close / prior_close - 1) * 100, 2) AS pct_chg,
    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 9, 2026, The Day in Numbers
Fourteen chip names: gap at the open vs the rest of the day, July 9 table 14×8 → Top 6 by dollars traded, top 4 by shares traded: July 9 regular hours table 10×6 → Named catalysts on file: news articles and SEC filings per name, Wednesday's close through Thursday's table 9×5 → Eight declared sector baskets, three names each: July 9 close-over-close, equal-weighted table 8×6 → Premarket path, 4:00-9:29 am ET: last premarket print vs Wednesday's close, and the open that followed table 6×8 → SPY / QQQ / DIA / IWM: July 9 vs the July 8 close, regular hours table 4×10 → See all 2,170 queries →