NVDA: Juni 2026 kamili, tick kwa tick
Juni 2026 ya NVIDIA kamili: kilele cha kabla ya soko cha $235, mteremko wa 7.4% katika vikao 21, na kiasi cha dola cha fourth-kubwa kwenye tape ya Marekani.
NVIDIA ilifungua Juni 2026 kwa $215.77 na kufunga mwezi huo kwa $199.76 — ikiwa ni punguzo la -7.4% katika kipindi cha vikao 21. Hisa ilifikia kilele cha $235 katika biashara ya kabla ya soko saa 2026-06-02 04:00 ET, ikafika kiwango cha juu cha saa za kawaida cha $232.28 saa 2026-06-02 09:59 ET, na ikashuka hadi chini kabisa $189.8 saa 2026-06-29 10:17 ET — vyote katika saa za kawaida. Jumla ya kiasi: bilioni 2.75 hisa, $571.9 bilioni katika mauzo ya dola — jina la fourth-kubwa kwenye tape ya Marekani kwa mauzo ya dola ya saa za kawaida (msingi: Juni 1–30 saa za kawaida; jina moja la Juni lililotumika tena halijajumuishwa likisubiri uthibitishaji wa chombo). Kila namba hapa ni matokeo ya swala lililohifadhiwa; panua paneli yoyote kwa SQL kamili.
SQL halisi nyuma ya kila namba
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')Mwelekeo huo ni mteremko thabiti wa kushuka na pengo moja kali la kushuka katika wiki ya mwisho. NVDA ilifunga juu ya $224.43 mara moja tu — mnamo 2026-06-01, kikao cha kwanza. Kiwango cha chini cha mwezi kilichapishwa katika saa za kawaida saa 2026-06-29 10:17 ET, ikiwa na 1 baa ndani ya senti moja na 43131 biashara katika dakika hiyo. Kilele cha $235 cha kabla ya soko saa 2026-06-02 04:00 ET ni chapisho la saa zilizopanuliwa; kiwango cha juu cha saa za kawaida cha $232.28 kilisimama saa 2026-06-02 09:59 ET. Juni 19 ilikuwa kufungwa kwa soko zima (0 baa za SPY siku hiyo), kwa hivyo NVDA ilikuwa na vikao 21 vya biashara.
Kikao kwa kikao
SQL halisi nyuma ya kila namba
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_dateJedwali la vikao linaonyesha mteremko unaoendelea. Kufunga kwa mara ya kwanza juu ya $224.43 kuliweka kiwango cha juu zaidi mnamo 2026-06-01. Kushuka kwa kasi zaidi kwa kikao kimoja kulikuwa -6.2% mnamo 2026-06-05 — Ijumaa — sambamba na kiasi cha juu zaidi cha mwezi cha hisa milioni 187.3. Kipindi muhimu kilikuwa mfululizo wa 5 wa kushuka mfululizo, 2026-06-22 hadi 2026-06-26, kikimalizia kwa kufunga kwa chini kabisa kwa mwezi cha $191.72; vikao viwili vya mwisho vilipona 1.7% na 2.5%. Kiasi kilijikita mwanzoni: hisa milioni 185.5 siku ya kwanza, hisa milioni 119.6 siku ya mwisho.
SQL halisi nyuma ya kila namba
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_sessionJuni ikilinganishwa na miezi sita iliyopita
Je, mwezi kama huu si wa kawaida kwa NVDA, au ni wa kawaida? Jedwali lililo hapa chini linakokotoa tena takwimu hizo tatu kwa kila mwezi kati ya sita iliyopita kwa mpango mmoja — safu ya Juni inatolewa na swala sawa kabisa na ile mitano iliyotangulia, moja kwa moja kutoka kwenye ghala la data wakati wa kuzalisha.
SQL halisi nyuma ya kila namba
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_startKwa mauzo, Juni ilikuwa ya kawaida: $523 bilioni katika saa za kawaida zilikaa katikati ya kiwango cha dirisha, chini ya $557.5 bilioni za Mei na $572.5 bilioni za Machi. Safu ya faida ndipo Juni inapojitokeza: -7.4% ilikuwa punguzo kubwa zaidi la mwezi kati ya sita, dhidi ya -4.8% mwezi Februari na faida mwezi Aprili na Mei.
Kichwa cha fourth kikubwa zaidi kwenye orodha
SQL halisi nyuma ya kila namba
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 12NVDA ilishika nafasi ya fourth kwenye orodha nzima ya Marekani kwa thamani ya dola katika saa za kawaida: $523 bilioni, ikitangulia kwa $141.5 bilioni SNDK iliyo chini yake, ikifuatiwa tu na MU ($995.7 bilioni), SPY ($771.5 bilioni), na QQQ ($672.8 bilioni). Msingi: Juni 1–30 saa za kawaida, isipokuwa orodha moja ya Juni yenye alama iliyotumiwa tena iliyotengwa hadi uthibitishaji wa taasisi ukamilike — risiti zake ziko katika uchambuzi wake wa kina. Kati ya majina matatu yaliyo juu ya NVDA, 1 ni hisa moja — MU, jina lingine la semiconductor; mengine mawili ni ETF kubwa za fahirisi.
SQL halisi nyuma ya kila namba
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
)Kile ambacho tepu ilitengenezwa nacho
SQL halisi nyuma ya kila namba
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)Muundo wake ni wa maandishi madogo na wenye wingi wa nukuu: 55.64 milioni za prints kwa wastani wa 5 hisa (wastani wa 72.9 — misalaba ya taasisi huvuta wastani juu), 84.6% kura zisizo za kawaida (chini ya hisa 100), 32.91% sehemu ndogo — sawia na programu za rejareja zinazogawanya maagizo katika hifadhi ya soko. Upande wa nukuu: 55.7 milioni za sasisho za NBBO, 99.35% safi zenye pande mbili; 33941 zilivuka kwa muda mfupi (bei ya kununua juu ya bei ya kuuza), 329679 zimefungwa (bei ya kununua ni sawa na bei ya kuuza), 63 zenye upande mmoja au tupu. Kampuni yenye mtaji mkubwa huchapisha nukuu nyingi zaidi kwa mwezi kuliko majina mengi yanavyochapisha kwa muongo mmoja.
Mwanya ulibaki finyu
Kampuni kubwa kama NVDA hubeba mwanya wa bei ya kununua na kuuza ulio finyu kwa asili — swali ni jinsi mwanya huo ulivyokuwa thabiti katika mwezi ulio na anuwai ya bei ya pointi 20. Sensa ya nukuu hapo juu inaonyesha wastani wa kiwango cha mwezi; paneli hii inapima kwa kila kikao.
SQL halisi nyuma ya kila namba
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 sessionMwanya ulibaki katika ukanda finyu mwezi mzima: 1.34 bps tarehe 2026-06-01 na 1.01 bps tarehe 2026-06-30 — mwanya wa kampuni kubwa ambao haukubadilika sana wakati wa kushuka kwa bei kwa pointi 20. Kikao kikubwa zaidi kilikuwa 2026-06-05 kwa 0.97 bps (siku ya kushuka kwa -6.2%), na kikao kidogo zaidi 2026-06-15 kwa 0.95 bps. Kwa kulinganisha na jina jembamba, angalia uchambuzi wa kina wa muundo mdogo wa Juni 29 ambapo paneli ya mwanya wa ticker moja inashughulikia kikao kile kile.
Chaguzi: Mkataba milioni 64.64, simu katika kila kikao
SQL halisi nyuma ya kila namba
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)Katika vikao vya chaguzi 21: alama milioni 8.9 katika mikataba tofauti 5163, mikataba milioni 64.64 na dola bilioni 24.43 za malipo (bei ikizidishwa na kizidishi cha hisa 100). Uwiano wa kuweka/simu wa mwezi ulikuwa 0.55 — simu zilizidi kuweka katika kila kikao; uwiano wa kila siku ulifikia kilele cha 0.782 na haukufikia 1.0 kamwe. Muda wa mwisho 38 ulifanyika biashara, kutoka kwa wiki ya Juni 18 hadi LEAPS 2028-12-15; muda wa mwisho wa Juni 18 pekee ulichukua 10.5% ya kiasi cha mwezi. Mkataba wenye shughuli nyingi: $210 call, expiry 2026-06-18. Kivutio cha malipo: $0.5 call, expiry 2026-12-18 — strike ya ndani kabisa ya $0.5. Kwa kulinganisha, chaguzi za AAPL zilikusanya dola bilioni 8.84 kwenye mikataba milioni 27 mwezi Juni; TSLA dola bilioni 33.68 kwenye mikataba milioni 58.
SQL halisi nyuma ya kila namba
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 sessionKikao cha chaguzi chenye shughuli nyingi kilikuwa 2026-06-05 — mikataba 5298529, 100% ya kilele cha mwezi — siku hiyo hiyo ya kushuka kwa -6.2% iliyoweka kiasi cha juu cha hisa. Uwiano wa kuweka/simu uliongezeka pamoja na kushuka kwa bei: ulishuka chini hadi 0.33 mnamo 2026-06-02 (karibu na kilele cha bei) na kupanda hadi 0.61 kufikia 2026-06-12 (kikao ambacho hisa ilifunga chini ya $205.14 kwa mara ya kwanza). Kiasi cha kuweka kilikua bei iliposhuka — shughuli za kukinga au dau za mwelekeo; data inaonyesha mwendo-shirikishi, si nia.
SQL halisi nyuma ya kila namba
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))Ramani ya strike ni barbell kuzunguka safu ya biashara ya $200. Kundi la $200 — kwenye bei ya sasa — lilichukua kiasi kikubwa zaidi, likigawanywa 32.7% kuweka (biashara ya pande mbili). Chini ya safu kuweka hutawala (88.3% ya kundi la $150); juu yake simu zinamiliki kitabu (6.3% kuweka kwa $225, mikataba 120039 kwenye dari ya $450). Muundo ni wa kitabu: kuweka kwa ulinzi chini, simu za kubahatisha juu, soko la pande mbili kwenye bei ya sasa.
Mtiririko wa habari
SQL halisi nyuma ya kila namba
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 makala zenye lebo ya NVDA mwezi Juni kutoka kwa 4 wachapishaji. Soma hesabu hizo kwa mashaka: The Motley Fool pekee iliandika 63% — ni umakini wa mlisho mmoja, si vyombo vya habari vya dunia. Siku ya kilele ilikuwa 2026-06-01 ikiwa na 45 makala. Lebo-shirikishi zinaonyesha muktadha: MSFT katika 169, AAPL katika 134, AMD katika 101, TSLA katika 69 — mlisho huu ulimshughulikia NVDA kama hadithi ya teknolojia ya mega-cap, si hadithi ya semiconductor.
Fupi
SQL halisi nyuma ya kila namba
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 dateKiasi cha mauzo mafupi cha nje ya soko ni sehemu ya kiasi kinachoripotiwa na FINDA kilichowekwa alama kuwa mafupi; sehemu kubwa yake ni wafanyabiashara wa soko wanaouza mafupi kujaza ununuzi wa wateja — ni utaratibu wa kawaida, si riba ya mauzo mafupi. Sehemu ya mauzo mafupi ya NVDA iliyowekwa alama ilianzia 29.3% tarehe 2026-06-01 hadi 48.1% tarehe 2026-06-30. Kiasi cha mauzo cha nje ya soko kilichoripotiwa kilifikia kilele cha hisa milioni 86.77 tarehe 2026-06-02 na kushuka chini hadi milioni 43.31 tarehe 2026-06-16, katika vipindi 20 vilivyorekodiwa.
SQL halisi nyuma ya kila namba
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
)SQL halisi nyuma ya kila namba
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')Riba halisi ya mauzo mafupi ilichapishwa 2026-06-30, hisa milioni 310.13 zikiwa fupi dhidi ya wastani wa siku wa hisa milioni 155.99. Mtoa taarifa anaripoti siku za kufidia kama 1.99; uwiano ghafi ni 1.99 — wafupi walihitaji takriban siku mbili za wastani kufidia. Makazi yote mawili ya mwezi yamo kwenye faili (2 machapisho ya Juni); takwimu zilizo hapo juu zinabeba makazi ya mwisho wa mwezi Juni 30.
Vidokezo vya data
SQL halisi nyuma ya kila namba
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_rowsVidokezo kamili vya data
- Huluki. NVDA ni NVIDIA Corporation, CIK 0001045810, iliyoorodheshwa kwenye Nasdaq. Hakuna utata wa kutumia tena alama; hakuna vikwazo vya mipaka ya huluki vinavyotumika. Ghala hubeba safu 83 za mizania, 152 za taarifa ya mapato, na 152 za taarifa ya mtiririko wa fedha kwa NVDA — misingi ipo, tofauti na uchambuzi wa kina wa muundo wa soko wa Juni 29.
- Viwango vya juu na chini vya mwezi. Kiwango cha juu cha $235 kilichapishwa saa 2026-06-02 04:00 ET katika soko la kabla ya saa za kawaida (4:00 AM); kiwango cha juu cha saa za kawaida cha $232.28 kilichapishwa saa 2026-06-02 09:59 ET. Kiwango cha chini cha mwezi na kiwango cha chini cha saa za kawaida vyote ni $189.8 — kiwango cha chini kilikuwa chapisho la saa za kawaida.
- Kufungwa kwa Juni 19. Ghala hubeba pau 0 za SPY kwa Juni 19 (Juneteenth), kwa hivyo Juni ya NVDA inajumuisha vikao 21. Jedwali la likizo halirejei nyuma hadi Juni 2026 (linaanza Julai 3 2026); uchunguzi wa pau-sifuri ni risiti.
- Kiasi cha dola. Kiasi cha dakika kwa nyakati za kufunga dakika, kilichojumlishwa — kiwakilishi cha kiasi cha dhamana kinachozingatia bei ya kufunga. Takwimu ya saa za kawaida ($523 bilioni) haijumuishi pau za kabla ya soko na baada ya kufunga; takwimu ya siku nzima ($571.9 bilioni) inazijumuisha.
- Uchanganuzi wa chaguo. Muda wa kuisha, aina, na bei ya utekelezaji huchanganuliwa upya kutoka kwa alama ya OCC (safu ya tarehe ya kuisha kwenye jedwali haina uhakika); dhamana ya malipo inachukua kizidishi cha hisa 100.
- Takwimu za usambaaji kwa kila sasisho hupima kila sasisho la NBBO kwa usawa; takwimu zilizopimwa kwa wakati ziko kwenye paneli. Wastani wa kati hutumia quantiles za uhakika.
- Hakuna ulinzi wa kukata tick ulioanzishwa. Maswali yote ya jedwali la tick yamejumlishwa; swali la muundo wa tape linajumlisha jedwali kamili la biashara katika safu moja.
- Pengo la kiasi cha short mnamo Juni 29. Faili ya FINRA ya kiasi cha short nje ya soko la Juni 29 ilikatwa kwa kiwango cha soko (faili chanzo inaisha katikati ya alfabeti); NVDA inapangwa kabla ya kukatwa kwa hivyo safu yake haipo. Paneli ya kiasi cha short hubeba vikao 20; safu ya Juni 29 haipo (kukatwa kwa faili kwa kiwango cha soko), si sifuri. Uchambuzi wa kina wa Juni 29 unabeba risiti ya uchunguzi wa kiwango cha soko.
Mbinu
- Nyakati za muda huhifadhiwa kwa UTC na huchujwa kwa mipaka ya UTC ghafi; Juni 2026 ni EDT kwa ukamilifu, hivyo saa za kawaida ni 13:30–20:00 UTC (saa 9:30 asubuhi–saa 4:00 jioni ET). toTimeZone inaonekana tu katika orodha za SELECT.
- Kufunga kwa kikao ni upau wa dakika wa mwisho wa saa za kawaida. Kiasi cha dola ni bei ya kufunga ya dakika ikizidishwa na kiasi cha dakika, hujumlishwa.
- Mwisho wa chaguo, aina na bei ya utekelezaji hutafsiriwa upya kutoka kwa ticker ya OCC. Notisi ya malipo ya kiwango inachukua kizidishi cha hisa 100.
- Uzalishaji ni wa kundi tu kupitia njia ya usomaji iliyozuiliwa; ukurasa wa umma hauwahi kuuliza data za moja kwa moja. Ghala huhifadhi historia kamili ya ticki bila tarehe ya mwisho inayozunguka, hivyo uchambuzi huu unaweza kuzalishwa tena kutoka kwa majedwali yale yale wakati wowote. Hali ya ghala kufikia Julai 4, 2026.
Kila paneli ni kitu kimoja kilichohifadhiwa — chati, jedwali na SQL. Chukua swali lolote zaidi kwenye terminal ya Strasmore.