Strasmore Research
Deep Dives · Matt ConnorBy Matt Connor · · Updated 2026-07-25

NVDA: buong Hunyo 2026 ng NVIDIA, tick by tick

NVIDIA's June 2026: $235 pre-market peak, 7.4% slide sa 21 sessions, at fourth-pinakamalaking dollar volume sa US tape. Buwanang open, close, at lows kasama.

NVIDIA nagbukas ng Hunyo 2026 sa $215.77 at nagsara ang buwan sa $199.76 — isang -7.4% na pagbaba sa loob ng 21 na sesyon. Ang stock ay sumikat sa $235 sa pre-market trading noong 2026-06-02 04:00 ET, umabot sa regular-hours high na $232.28 noong 2026-06-02 09:59 ET, at bumaba sa $189.8 noong 2026-06-29 10:17 ET — lahat ay regular hours. Kabuuang volume: 2.75 bilyong shares, $571.9 bilyon na dollar turnover — ang fourth-pinakamalaking pangalan sa US tape ayon sa regular-hours dollar volume (batayan: Hunyo 1–30 regular hours; isang reused-symbol June listing na hindi kasama habang naghihintay ng entity verification). Bawat numero dito ay resulta ng stored query; palawakin ang anumang panel para sa eksaktong SQL.

QueryBuwan sa isang row: open, close, extremes, volume, at receipts
Ang eksaktong SQL sa likod ng bawat numero
WITH
    (
        SELECT (toString(argMax(et_date, c)), max(c), argMax(c, et_date))
        FROM (
            SELECT
                toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
                argMax(toFloat64(close), window_start) AS c
            FROM global_markets.delayed_stocks_minute_aggs
            WHERE ticker = 'NVDA'
              AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
              AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
            GROUP BY et_date
        )
    ) AS closes,
    (
        SELECT max(toFloat64(high)) FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
    ) AS hi,
    (
        SELECT min(toFloat64(low)) FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
    ) AS lo,
    (
        SELECT maxIf(toFloat64(high), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
    ) AS rth_hi,
    (
        SELECT minIf(toFloat64(low), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
    ) AS rth_lo,
    (
        SELECT count() FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND window_start >= toDateTime('2026-06-19 00:00:00') AND window_start < toDateTime('2026-06-20 00:00:00')
    ) AS spy_jun19
SELECT
    round(toFloat64(argMin(open, window_start)), 2) AS month_open,
    closes.3 AS month_close,
    round((closes.3 / toFloat64(argMin(open, window_start)) - 1) * 100, 1) AS month_change_pct,
    round((1 - closes.3 / toFloat64(argMin(open, window_start))) * 100, 1) AS month_decline_abs_pct,
    closes.1 AS peak_close_date,
    round(closes.2, 2) AS peak_close,
    round(hi, 2) AS month_high,
    formatDateTime(toTimeZone(minIf(window_start, toFloat64(high) >= hi - 0.011), 'America/New_York'), '%Y-%m-%d %H:%i') AS month_high_first_bar_et,
    countIf(toFloat64(high) >= hi - 0.011) AS bars_within_cent_of_high,
    argMinIf(transactions, window_start, toFloat64(high) >= hi - 0.011) AS high_minute_trades,
    round(rth_hi, 2) AS rth_month_high,
    formatDateTime(toTimeZone(minIf(window_start, toFloat64(high) >= rth_hi - 0.011 AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 'America/New_York'), '%Y-%m-%d %H:%i') AS rth_high_first_bar_et,
    countIf(toFloat64(high) >= rth_hi - 0.011 AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) AS rth_bars_near_high,
    round(lo, 2) AS month_low,
    formatDateTime(toTimeZone(minIf(window_start, toFloat64(low) <= lo + 0.011), 'America/New_York'), '%Y-%m-%d %H:%i') AS month_low_bar_et,
    countIf(toFloat64(low) <= lo + 0.011) AS bars_within_cent_of_low,
    argMin(transactions, toFloat64(low)) AS low_minute_trades,
    round(rth_lo, 2) AS rth_month_low,
    round(rth_lo - lo, 2) AS rth_minus_extended_low,
    round(toFloat64(sum(volume)) / 1e9, 2) AS month_shares_bn,
    round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 1) AS month_dollar_bn,
    round(sumIf(toFloat64(close) * toFloat64(volume), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / 1e9, 1) AS rth_dollar_bn,
    round(sumIf(toFloat64(volume), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / 1e9, 2) AS rth_shares_bn,
    uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) AS session_days_observed,
    spy_jun19 AS spy_bars_june19
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'NVDA'
  AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')

Ang arko ay isang steady downtrend na may isang matalim na gap pababa sa huling linggo. Ang NVDA ay nagsara sa itaas ng $224.43 nang isang beses lamang — noong 2026-06-01, ang unang sesyon. Ang mababang buwan ay na-print sa regular hours noong 2026-06-29 10:17 ET, na may 1 bar sa loob ng isang sentimo at 43131 trades sa minutong iyon. Ang pre-market na $235 peak noong 2026-06-02 04:00 ET ay isang extended-hours print; ang regular-hours high na $232.28 ay tumayo noong 2026-06-02 09:59 ET. Ang Hunyo 19 ay isang market-wide closure (0 SPY bars sa araw na iyon), kaya ang NVDA ay nagkaroon ng 21 na sesyon ng trading.

Sesyon bawat sesyon

Query21 sesyon: regular-hours close, close-over-close change, full-day volume
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    et_date,
    close_usd,
    round(if(prev_close = 0, NULL, (close_usd / prev_close - 1) * 100), 1) AS change_pct,
    shares_m,
    dollar_bn
FROM (
    SELECT et_date, close_usd, shares_m, dollar_bn,
           lagInFrame(close_usd) OVER (ORDER BY et_date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_close
    FROM (
        SELECT
            toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
            round(argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS close_usd,
            round(toFloat64(sum(volume)) / 1e6, 1) AS shares_m,
            round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 2) AS dollar_bn
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
        GROUP BY et_date
    )
)
ORDER BY et_date

Ang talahanayan ng sesyon ay nagpapakita ng patuloy na pagbaba. Ang unang pagsasara sa itaas ng $224.43 ang nagtakda ng pinakamataas na antas noong 2026-06-01. Ang pinakamatarik na pagbaba sa iisang sesyon ay -6.2% noong 2026-06-05 — isang Biyernes — kasabay ng pinakamataas na dami ng buwan sa 187.3 milyong bahagi. Ang tiyak na bahagi ay 5 sunod-sunod na pagbaba, 2026-06-22 hanggang 2026-06-26, na nagtapos sa pinakamababang pagsasara ng buwan na $191.72; ang huling dalawang sesyon ay nakabawi ng 1.7% at 2.5%. Ang dami ay nauna: 185.5 milyong bahagi sa unang araw, 119.6 milyon sa huling araw.

QueryLimang-sesyon na slide, bounded: bawat claim sa streak sentence bilang checked column
Ang eksaktong SQL sa likod ng bawat numero
WITH per_session AS (
    SELECT et_date, close_usd,
           lagInFrame(close_usd) OVER (ORDER BY et_date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_close
    FROM (
        SELECT
            toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
            round(argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS close_usd
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
        GROUP BY et_date
    )
)
SELECT
    toString(minIf(et_date, et_date >= toDate('2026-06-22') AND et_date <= toDate('2026-06-26'))) AS run_start,
    toString(maxIf(et_date, et_date >= toDate('2026-06-22') AND et_date <= toDate('2026-06-26'))) AS run_end,
    countIf(et_date >= toDate('2026-06-22') AND et_date <= toDate('2026-06-26')) AS sessions_in_run,
    countIf(et_date >= toDate('2026-06-22') AND et_date <= toDate('2026-06-26') AND close_usd < prev_close) AS declining_sessions,
    round(minIf(close_usd, et_date >= toDate('2026-06-22') AND et_date <= toDate('2026-06-26')), 2) AS run_low_close,
    toUInt8(min(close_usd) = minIf(close_usd, et_date >= toDate('2026-06-22') AND et_date <= toDate('2026-06-26'))) AS run_holds_month_low_close
FROM per_session

Hunyo kumpara sa nakaraang anim na buwan

Ang isang buwang tulad nito ba ay hindi karaniwan para sa NVDA, o ordinaryo? Ang panel sa ibaba ay muling kinukwenta ang parehong tatlong bilang para sa bawat isa sa huling anim na buwan sa isang pagdaan — ang hanay ng Hunyo ay ginawa ng eksaktong parehong query gaya ng limang nauna rito, sariwa mula sa warehouse sa oras ng pagbuo.

QueryTrailing anim na buwan, recomputed live: turnover, shares, at month return
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    toString(toStartOfMonth(toDate(toTimeZone(window_start, 'America/New_York')))) AS period_start,
    round(sumIf(toFloat64(close) * toFloat64(volume), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / 1e9, 1) AS rth_dollar_bn,
    round(toFloat64(sum(volume)) / 1e9, 2) AS shares_bn,
    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
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'NVDA'
  AND window_start >= toDateTime('2026-01-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
GROUP BY period_start
ORDER BY period_start

Sa turnover, ordinaryo ang Hunyo: $523 bilyon sa regular na oras ay nasa gitnang antas para sa window, mas mababa sa $557.5 bilyon ng Mayo at $572.5 bilyon ng Marso. Ang kolum ng return ang pinagkakaiba ng Hunyo: -7.4% ang pinakamatalim na buwanang pagbaba sa anim, laban sa -4.8% noong Pebrero at mga pagtaas noong Abril at Mayo.

Ang fourth-pinakamalaking ticker sa tape

QueryBuong US tape na nirank ayon sa June 2026 regular-hours dollar volume
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    ticker,
    round(sum(toFloat64(volume) * toFloat64(close)) / 1e9, 1) AS regular_hours_dollar_bn,
    round(100 * sum(toFloat64(volume) * toFloat64(close)) / max(sum(toFloat64(volume) * toFloat64(close))) OVER (), 1) AS pct_of_leader,
    toUInt8(ticker = 'NVDA') AS is_nvda
FROM global_markets.delayed_stocks_minute_aggs
WHERE window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
  AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
AND ticker NOT IN ('SPCX')
GROUP BY ticker
ORDER BY regular_hours_dollar_bn DESC
LIMIT 12

Niranggo ang NVDA bilang fourth sa buong US tape batay sa regular-hours dollar volume: $523 bilyon, $141.5 bilyon ang agwat sa SNDK na nasa ibaba nito, at nasa likod lamang ng MU ($995.7 bilyon), SPY ($771.5 bilyon), at QQQ ($672.8 bilyon). Ang batayan: Hunyo 1–30 regular hours, na may isang reused-symbol June listing na hindi isinama habang pinapatunayan pa ang entity — ang mga resibo nito ay nasa sariling malalimang pagsusuri nito. Sa tatlong pangalan na nasa itaas ng NVDA, ang 1 ay isang solong stock — MU, isa pang pangalan sa semiconductor; ang dalawa pa ay ang malalaking index ETF.

QueryRank receipt: lugar ni NVDA, lead nito sa susunod na pangalan, at basis — bilang checked columns
Ang eksaktong SQL sa likod ng bawat numero
WITH (
    SELECT sum(toFloat64(volume) * toFloat64(close))
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'NVDA'
      AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
      AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
) AS nvda_d
SELECT
    countIf(d > nvda_d AND ticker != 'NVDA') + 1 AS nvda_rank,
    round(nvda_d / 1e9, 1) AS nvda_dollar_bn,
    round((nvda_d - maxIf(d, d < nvda_d AND ticker != 'NVDA')) / 1e9, 1) AS lead_over_next_bn,
    countIf(d > nvda_d AND ticker NOT IN ('SPY', 'QQQ', 'NVDA')) AS single_stocks_above_nvda,
    round(100 * nvda_d / max(d), 1) AS pct_of_leader
FROM (
    SELECT ticker, sum(toFloat64(volume) * toFloat64(close)) AS d
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
      AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
)

Kung saan gawa ang tape

QueryBuong NVDA tape sa isang row: prints, print sizes, at quote census
Ang eksaktong SQL sa likod ng bawat numero
WITH
    (
        SELECT (round(count() / 1e6, 2),
                round(100.0 * countIf(bid_price > 0 AND ask_price > 0 AND ask_price > bid_price) / count(), 2),
                countIf(bid_price > 0 AND ask_price > 0 AND ask_price = bid_price),
                countIf(bid_price > 0 AND ask_price > 0 AND ask_price < bid_price),
                countIf(bid_price <= 0 OR ask_price <= 0))
        FROM global_markets.cache_stocks_quotes
        WHERE ticker = 'NVDA'
          AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
    ) AS quote_census
SELECT
    round(count() / 1e6, 2) AS prints_m,
    quantileDeterministic(0.5)(toFloat64(size), toUInt64(abs(sequence_number))) AS median_print_shares,
    round(avg(toFloat64(size)), 1) AS avg_print_shares,
    round(100.0 * countIf(size < 100) / count(), 1) AS odd_lot_pct_of_prints,
    round(100.0 * countIf(toFloat64(size) != round(toFloat64(size))) / count(), 2) AS fractional_pct_of_prints,
    quote_census.1 AS nbbo_updates_m,
    quote_census.2 AS clean_two_sided_pct,
    quote_census.3 AS locked_updates,
    quote_census.4 AS crossed_updates,
    quote_census.5 AS one_sided_or_empty_updates
FROM global_markets.stocks_trades
WHERE ticker = 'NVDA'
  AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)

Ang texture ay maliit na print at siksik sa quote: 55.64 milyong prints na may median na 5 shares (average na 72.9 — ang institutional crosses ang nagpapataas ng mean), 84.6% odd lots (sa ilalim ng 100 shares), 32.91% fractional — naaayon sa retail apps na naghihiwa-hiwalay ng orders sa market-maker inventory. Ang quote half: 55.7 milyong NBBO updates, 99.35% malinis na two-sided; 33941 pansamantalang crossed (bid na mas mataas sa ask), 329679 naka-lock (bid na katumbas ng ask), 63 one-sided o walang laman. Ang isang mega-cap ay nagpi-print ng mas maraming quotes sa isang buwan kaysa sa maraming pangalan sa isang dekada.

Nanatiling masikip ang spread

Ang isang mega-cap tulad ng NVDA ay may likas na makitid na bid-ask spread — ang tanong ay kung gaano katatag ang pagkamasikip na iyon sa loob ng isang buwan na may 20-puntong price range. Ipinapakita ng quote census sa itaas ang median sa antas ng buwan; sinusukat ng panel na ito ito bawat sesyon.

QuerySpread ayon sa sesyon: regular-hours median at time-weighted average (bps)
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    session,
    round(quantileDeterministicIf(0.5)(toFloat64(ask_price) - toFloat64(bid_price), toUInt64(toUnixTimestamp64Micro(sip_timestamp)), bid_price > 0 AND ask_price >= bid_price) * 100, 1) AS med_spread_cents,
    round(quantileDeterministicIf(0.5)((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, toUInt64(toUnixTimestamp64Micro(sip_timestamp)), bid_price > 0 AND ask_price >= bid_price), 2) AS med_spread_bps,
    count() AS quote_updates,
    countIf(NOT (bid_price > 0 AND ask_price > 0 AND ask_price >= bid_price)) AS invalid_dropped
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'NVDA'
  AND sip_timestamp >= toDateTime64('2026-06-01 13:30:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
  AND (toHour(sip_timestamp) * 60 + toMinute(sip_timestamp)) BETWEEN 810 AND 1199
GROUP BY toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session
ORDER BY session

Nanatili ang spread sa isang makitid na banda sa buong buwan: 1.34 bps noong 2026-06-01 at 1.01 bps noong 2026-06-30 — isang mega-cap spread na halos hindi gumalaw sa kabila ng 20-puntong pagbaba ng presyo. Ang pinakamalawak na sesyon ay 2026-06-05 sa 0.97 bps (araw ng pagbaba ng -6.2%), ang pinakamakitid ay 2026-06-15 sa 0.95 bps. Para sa paghahambing laban sa isang manipis na pangalan, tingnan ang malalimang pagsusuri ng microstructure noong Hunyo 29 kung saan sinasaklaw ng isang single-ticker spread panel ang parehong sesyon.

Options: 64.64 milyong kontrata, tawag sa bawat sesyon

QueryOptions market ni NVDA sa isang row: totals, expiry structure, flagship contracts
Ang eksaktong SQL sa likod ng bawat numero
WITH
    (
        SELECT (round(sum(toFloat64(price) * size) * 100 / 1e9, 2), round(sum(size) / 1e6, 1))
        FROM global_markets.options_trades
        WHERE startsWith(ticker, 'O:AAPL') AND length(ticker) = 21
          AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
    ) AS aapl,
    (
        SELECT (round(sum(toFloat64(price) * size) * 100 / 1e9, 2), round(sum(size) / 1e6, 1))
        FROM global_markets.options_trades
        WHERE startsWith(ticker, 'O:TSLA') AND length(ticker) = 21
          AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
    ) AS tsla,
    (
        SELECT concat('$', toString(round(toFloat64(toUInt32OrZero(substring(ticker, 14, 8))) / 1000, 2)),
               if(substring(ticker, 13, 1) = 'P', ' put', ' call'),
               ', expiry 20', substring(ticker, 7, 2), '-', substring(ticker, 9, 2), '-', substring(ticker, 11, 2))
        FROM global_markets.options_trades
        WHERE startsWith(ticker, 'O:NVDA') AND length(ticker) = 21
          AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
        GROUP BY ticker ORDER BY sum(size) DESC LIMIT 1
    ) AS busiest_name,
    (
        SELECT concat('$', toString(round(toFloat64(toUInt32OrZero(substring(ticker, 14, 8))) / 1000, 2)),
               if(substring(ticker, 13, 1) = 'P', ' put', ' call'),
               ', expiry 20', substring(ticker, 7, 2), '-', substring(ticker, 9, 2), '-', substring(ticker, 11, 2))
        FROM global_markets.options_trades
        WHERE startsWith(ticker, 'O:NVDA') AND length(ticker) = 21
          AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
        GROUP BY ticker ORDER BY sum(toFloat64(price) * size) DESC LIMIT 1
    ) AS premium_name,
    (
        SELECT round(toFloat64(toUInt32OrZero(substring(ticker, 14, 8))) / 1000, 2)
        FROM global_markets.options_trades
        WHERE startsWith(ticker, 'O:NVDA') AND length(ticker) = 21
          AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
        GROUP BY ticker ORDER BY sum(toFloat64(price) * size) DESC LIMIT 1
    ) AS premium_strike,
    (
        SELECT max(pc)
        FROM (
            SELECT round(toFloat64(sumIf(size, substring(ticker, 13, 1) = 'P')) / toFloat64(sumIf(size, substring(ticker, 13, 1) = 'C')), 3) AS pc
            FROM global_markets.options_trades
            WHERE startsWith(ticker, 'O:NVDA') AND length(ticker) = 21
              AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
            GROUP BY toDate(sip_timestamp)
        )
    ) AS max_daily_pc
SELECT
    formatDateTime(toTimeZone(min(sip_timestamp), 'America/New_York'), '%Y-%m-%d %H:%i:%S') AS first_print_et,
    uniqExact(toDate(sip_timestamp)) AS option_sessions,
    round(count() / 1e6, 2) AS prints_m,
    uniqExact(ticker) AS distinct_contracts,
    round(sum(size) / 1e6, 2) AS contracts_traded_m,
    round(sum(toFloat64(price) * size) * 100 / 1e9, 2) AS premium_notional_busd,
    round(toFloat64(sumIf(size, substring(ticker, 13, 1) = 'P')) / toFloat64(sumIf(size, substring(ticker, 13, 1) = 'C')), 2) AS month_put_call_ratio,
    max_daily_pc AS max_session_put_call_ratio,
    uniqExact(substring(ticker, 7, 6)) AS expiries_traded,
    concat('20', substring(max(substring(ticker, 7, 6)), 1, 2), '-', substring(max(substring(ticker, 7, 6)), 3, 2), '-', substring(max(substring(ticker, 7, 6)), 5, 2)) AS longest_expiry,
    round(100 * toFloat64(sumIf(size, substring(ticker, 7, 6) = '260618')) / toFloat64(sum(size)), 1) AS jun18_expiry_share_pct,
    busiest_name AS busiest_contract,
    premium_name AS top_premium_contract,
    premium_strike AS top_premium_strike_usd,
    aapl.1 AS aapl_premium_bn,
    aapl.2 AS aapl_contracts_m,
    tsla.1 AS tsla_premium_bn,
    tsla.2 AS tsla_contracts_m
FROM global_markets.options_trades
WHERE startsWith(ticker, 'O:NVDA') AND length(ticker) = 21
  AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)

Sa 21 sesyon ng opsyon: 8.9 milyong print sa 5163 natatanging kontrata, 64.64 milyong kontrata at $24.43 bilyon sa premium (presyo na pinarami ng 100-share multiplier). Ang put/call ratio ng buwan ay 0.55 — nalampasan ng mga tawag ang mga lagay sa bawat sesyon; ang arawang ratio ay umabot sa 0.782 at hindi umabot sa 1.0. 38 expiry ang na-trade, mula sa June 18 weekly hanggang sa 2028-12-15 LEAPS; ang June 18 expiry lamang ay umabot sa 10.5% ng volume ng buwan. Pinaka-abalang kontrata: $210 call, expiry 2026-06-18. Premium magnet: $0.5 call, expiry 2026-12-18 — isang deep-in-the-money na $0.5 strike. Para sa paghahambing, ang AAPL options ay nakakolekta ng $8.84 bilyon sa 27 milyong kontrata noong Hunyo; ang TSLA ay $33.68 bilyon sa 58 milyon.

QueryOptions sesyon bawat sesyon: contracts, call/put split, at put/call ratio
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    toDate(sip_timestamp) AS session,
    count() AS prints,
    toUInt64(sum(size)) AS contracts_traded,
    toUInt64(sumIf(size, substring(ticker, 13, 1) = 'C')) AS call_contracts,
    toUInt64(sumIf(size, substring(ticker, 13, 1) = 'P')) AS put_contracts,
    round(toFloat64(sumIf(size, substring(ticker, 13, 1) = 'P')) / toFloat64(sumIf(size, substring(ticker, 13, 1) = 'C')), 2) AS put_call_ratio,
    round(100 * toFloat64(sum(size)) / max(toFloat64(sum(size))) OVER (), 1) AS pct_of_busiest_session
FROM global_markets.options_trades
WHERE startsWith(ticker, 'O:NVDA') AND length(ticker) = 21
  AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
GROUP BY session
ORDER BY session

Ang pinaka-abalang sesyon ng opsyon ay 2026-06-05 — 5298529 kontrata, 100% ng pinakamataas ng buwan — ang parehong -6.2% araw ng pagbaba na nagtala ng pinakamataas na equity volume. Ang put/call ratio ay tumaas kasabay ng pagbaba ng presyo: ito ay bumaba sa 0.33 noong 2026-06-02 (malapit sa pinakamataas na presyo) at umakyat sa 0.61 pagsapit ng 2026-06-12 (ang sesyon na unang nagsara ang stock sa ibaba ng $205.14). Lumaki ang put volume habang bumagsak ang presyo — hedging activity o directional bets; ipinapakita ng datos ang sabay na paggalaw, hindi ang intensyon.

QueryKung saan dumapo ang contracts: call at put volume ayon sa strike bucket
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    concat('$', toString(toUInt32(bucket))) AS strike_bucket,
    call_contracts,
    put_contracts,
    round(100.0 * put_contracts / (call_contracts + put_contracts), 1) AS put_share_pct,
    round(100 * (call_contracts + put_contracts) / max(call_contracts + put_contracts) OVER (), 1) AS pct_of_biggest_bucket
FROM (
    SELECT
        least(floor(toFloat64(toUInt32OrZero(substring(ticker, 14, 8))) / 1000 / 25) * 25, 450) AS bucket,
        toUInt64(sumIf(size, substring(ticker, 13, 1) = 'C')) AS call_contracts,
        toUInt64(sumIf(size, substring(ticker, 13, 1) = 'P')) AS put_contracts
    FROM global_markets.options_trades
    WHERE startsWith(ticker, 'O:NVDA') AND length(ticker) = 21
      AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
    GROUP BY bucket
)
ORDER BY toUInt32OrZero(substring(strike_bucket, 2))

Ang strike map ay isang barbell sa paligid ng $200 trading range. Ang $200 bucket — at the money — ang kumuha ng pinakamaraming volume, nahati sa 32.7% puts (two-way traffic). Sa ibaba ng range, nangingibabaw ang puts (88.3% ng $150 bucket); sa itaas nito, pag-aari ng calls ang libro (6.3% puts sa $225, 120039 kontrata sa $450 ceiling). Ang istraktura ay textbook: protective puts sa ibaba, speculative calls sa itaas, isang two-way market sa at the money.

Ang daloy ng balita

QueryInformation flow sa isang row: volume, composition, at co-tags
Ang eksaktong SQL sa likod ng bawat numero
WITH
    (
        SELECT (toString(d), n)
        FROM (
            SELECT toDate(toTimeZone(published_utc, 'America/New_York')) AS d, count() AS n
            FROM global_markets.stocks_news
            WHERE has(tickers, 'NVDA')
              AND published_utc >= toDateTime('2026-06-01 00:00:00')
              AND published_utc < toDateTime('2026-07-01 04:00:00')
            GROUP BY d ORDER BY n DESC, d ASC LIMIT 1
        )
    ) AS peak_day,
    (
        SELECT (JSONExtractString(any(publisher), 'name'), count())
        FROM global_markets.stocks_news
        WHERE has(tickers, 'NVDA')
          AND published_utc >= toDateTime('2026-06-01 00:00:00')
          AND published_utc < toDateTime('2026-07-01 04:00:00')
        GROUP BY JSONExtractString(publisher, 'name') ORDER BY count() DESC LIMIT 1
    ) AS top_pub
SELECT
    count() AS june_articles,
    uniqExact(JSONExtractString(publisher, 'name')) AS publishers,
    toString(min(toDate(toTimeZone(published_utc, 'America/New_York')))) AS first_tagged_day,
    peak_day.1 AS peak_day_date,
    peak_day.2 AS peak_day_articles,
    top_pub.1 AS top_publisher,
    top_pub.2 AS top_publisher_articles,
    round(100.0 * top_pub.2 / count(), 0) AS top_publisher_pct,
    countIf(has(tickers, 'TSLA')) AS tsla_co_articles,
    countIf(has(tickers, 'AMD')) AS amd_co_articles,
    countIf(has(tickers, 'MSFT')) AS msft_co_articles,
    countIf(has(tickers, 'AAPL')) AS aapl_co_articles
FROM global_markets.stocks_news
WHERE has(tickers, 'NVDA')
  AND published_utc >= toDateTime('2026-06-01 00:00:00')
  AND published_utc < toDateTime('2026-07-01 04:00:00')

642 artikulong may tag na NVDA noong Hunyo mula sa 4 publisher. Kunin ang bilang na iyon nang may pag-aalinlangan: The Motley Fool lamang ang sumulat ng 63% — atensyon ng isang feed, hindi ng buong media. Ang pinakamataas na araw ay 2026-06-01 na may 45 artikulo. Ipinapakita ng mga co-tag ang pagkaka-frame: MSFT sa 169, AAPL sa 134, AMD sa 101, TSLA sa 69 — sinakop ng feed na ito ang NVDA bilang isang mega-cap tech story, hindi isang semiconductor story.

Ang mga short

QueryFINRA off-exchange short volume ayon sa sesyon: marked-short share at reported volume
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    date,
    round(toFloat64(any(short_volume)) / 1e6, 2) AS short_shares_m,
    round(toFloat64(any(total_volume)) / 1e6, 2) AS offexchange_total_m,
    round(100 * toFloat64(any(short_volume)) / toFloat64(any(total_volume)), 1) AS short_pct_of_offexchange
FROM global_markets.stocks_short_volume
WHERE ticker = 'NVDA' AND date >= toDate('2026-06-01') AND date <= toDate('2026-06-30')
GROUP BY date
ORDER BY date

Ang off-exchange short volume ay ang bahagi ng volume na iniulat sa FINRA na minarkahang short; karamihan dito ay mga market maker na nagbebenta ng short para punan ang mga bili ng customer — karaniwang plumbing ito, hindi short interest. Ang bahagi ng NVDA na minarkahang short ay mula 29.3% noong 2026-06-01 hanggang 48.1% noong 2026-06-30. Ang off-exchange na iniulat na volume ay sumikat sa 86.77 milyong bahagi noong 2026-06-02 at bumaba sa 43.31 milyon noong 2026-06-16, sa kabuuan ng 20 na sesyon na nasa file.

QueryOff-exchange peak at trough, bounded (deduped per session)
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    toString(argMax(date, offex_m)) AS peak_date,
    max(offex_m) AS peak_offex_m,
    toString(argMin(date, offex_m)) AS trough_date,
    min(offex_m) AS trough_offex_m,
    round(max(offex_m) - min(offex_m), 2) AS peak_minus_trough_m,
    count() AS sessions_on_file
FROM (
    SELECT date, round(toFloat64(any(total_volume)) / 1e6, 2) AS offex_m
    FROM global_markets.stocks_short_volume
    WHERE ticker = 'NVDA' AND date >= toDate('2026-06-01') AND date <= toDate('2026-06-30')
    GROUP BY date
)
QueryMid-June short-interest print
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    toString(max(settlement_date)) AS settlement,
    round(toFloat64(argMax(short_interest, settlement_date)) / 1e6, 2) AS shares_short_m,
    round(toFloat64(argMax(avg_daily_volume, settlement_date)) / 1e6, 2) AS avg_daily_volume_m,
    argMax(days_to_cover, settlement_date) AS reported_days_to_cover,
    round(toFloat64(argMax(short_interest, settlement_date)) / toFloat64(argMax(avg_daily_volume, settlement_date)), 2) AS implied_days_to_cover,
    count() AS june_settlements
FROM global_markets.stocks_short_interest
WHERE ticker = 'NVDA'
  AND settlement_date >= toDate('2026-06-01') AND settlement_date <= toDate('2026-06-30')

Ang aktuwal na short interest ay lumabas sa 2026-06-30: 310.13 milyong bahagi na short laban sa 155.99 milyong bahaging average araw. Iniulat ng vendor ang days-to-cover bilang 1.99; ang raw ratio ay 1.99 — kailangan ng mga short ng halos dalawang average na araw para masakop. Ang parehong settlement ng buwan ay nasa file (2 June prints); ang mga numero sa itaas ay nagdadala ng month-end June 30 settlement.

Mga tala ng datos

QueryNVDA fundamentals census: balance sheets, income statements, cash flows
Ang eksaktong SQL sa likod ng bawat numero
SELECT
    (SELECT count() FROM global_markets.stocks_balance_sheets WHERE has(tickers, 'NVDA')) AS balance_sheet_rows,
    (SELECT count() FROM global_markets.stocks_income_statements WHERE has(tickers, 'NVDA')) AS income_statement_rows,
    (SELECT count() FROM global_markets.stocks_cash_flow_statements WHERE has(tickers, 'NVDA')) AS cash_flow_rows
Buong tala ng datos
  • Entidad. Ang NVDA ay ang NVIDIA Corporation, CIK 0001045810, nakalista sa Nasdaq. Walang kalabuan sa simbolo; walang caveat sa hangganan ng entidad na naaangkop. Ang warehouse ay mayroong 83 na row ng balanse, 152 na row ng income statement, at 152 na row ng cash-flow statement para sa NVDA — umiiral ang mga pundamental, hindi katulad ng kaso ng malalimang pagsisiyasat sa microstructure noong Hunyo 29.
  • Sukdulan ng buwan. Ang pinakamataas na $235 ay naitala noong 2026-06-02 04:00 ET sa pre-market (4:00 AM); ang pinakamataas sa regular na oras na $232.28 ay naitala noong 2026-06-02 09:59 ET. Parehong ang pinakamababa ng buwan at ang pinakamababa sa regular na oras ay $189.8 — ang pinakamababa ay isang print sa regular na oras.
  • Pagsasara noong Hunyo 19. Ang warehouse ay mayroong 0 SPY bars para sa Hunyo 19 (Juneteenth), kaya sumasaklaw ang Hunyo ng NVDA sa 21 na sesyon. Ang talahanayan ng mga holiday ay hindi umaabot pabalik sa Hunyo 2026 (nagsisimula ito noong Hulyo 3 2026); ang obserbasyong walang bar ay ang resibo.
  • Dolyar na volume. Minutong pagsasara na minutong volume, pinagsama-sama — isang proxy na may timbang na pagsasara para sa notional. Ang pigura sa regular na oras ($523 bilyon) ay hindi kasama ang pre-market at post-close bars; ang pigura sa buong araw ($571.9 bilyon) ay kasama ang mga ito.
  • Pag-parse ng options. Ang expiry, type, at strike ay muling na-parse mula sa OCC ticker (ang expiration_date column ng talahanayan ay hindi maaasahan); ang notional ng premium ay ipinapalagay na ang 100-share multiplier.
  • Bawat-update na spread statistics ay binibigyan ng pantay na timbang ang bawat update ng NBBO; ang time-weighted na statistics ay nasa panel. Ang mga median ay gumagamit ng deterministikong quantiles.
  • Walang tick-dump guard na na-trigger. Ang lahat ng query sa tick-table ay pinagsama-sama; ang tape-texture query ay pinagsama ang buong trade table sa isang row.
  • Gap sa short-volume noong Hunyo 29. Ang file ng FINRA off-exchange short-volume para sa Hunyo 29 ay na-truncate sa buong merkado (ang source file ay nagtatapos sa gitna ng alpabeto); ang NVDA ay nasa unahan ng cutoff kaya wala ang row nito. Ang short-volume panel ay mayroong 20 na sesyon; nawawala ang row ng Hunyo 29 (truncation ng file sa buong merkado), hindi zero. Ang malalimang pagsisiyasat noong Hunyo 29 ay naglalaman ng resibo ng probe sa buong merkado.

Pamamaraan

  • Ang mga timestamp ay naka-imbak sa UTC at sinala gamit ang raw UTC bounds; ang Hunyo 2026 ay ganap na nasa EDT, kaya ang regular na oras ay 13:30–20:00 UTC (9:30 am–4:00 pm ET). Ang toTimeZone ay lumalabas lamang sa mga SELECT list.
  • Ang pagsasara ng session ay ang huling minutong bar ng regular na oras. Ang dollar volume ay minute close na pinarami ng minute volume, na pinagsama-sama.
  • Ang options expiry, type at strike ay muling nire-parse mula sa OCC ticker. Ang premium notional ay ipinapalagay ang 100-share multiplier.
  • Ang generation ay batch-only sa pamamagitan ng gated read-only path; ang pampublikong page ay hindi kailanman nag-query ng live. Ang warehouse ay nagpapanatili ng buong tick history na walang rolling expiry, kaya ang analysis na ito ay nagre-reproduce mula sa parehong mga table anumang oras. Ang warehouse state ay noong Hulyo 4, 2026.

Ang bawat panel ay isang stored object — chart, table at SQL. Kunin ang anumang query sa Strasmore terminal.

← All NVDA periods
#nvda#nvidia#deepdive#microstructure#options