MU: pinakamalaking tape ng Hunyo 2026 Micron
Ang Hunyo 2026 ng Micron: 995.7 bilyong dolyar na regular-hours turnover, first-ranked tape sa merkado, habang ang June repricing ay lumamig sa 14 porsyento.
Ginugol ng Micron ang unang kalahati ng 2026 sa marahas na pag-reprice — at noong Hunyo, lumamig ang presyo habang ang tape ay hindi. Nagsara ang MU noong Hunyo sa $1151.01, tumaas ng 14% — ang pinakatahimik nitong buwan mula noong Pebrero, pagkatapos ng 89.8% na Mayo — habang ang $995.7 bilyon nitong regular-hours turnover ay nagranggo rito bilang first sa buong US tape, nauna pa sa mismong SPY. Kung susukatin araw-araw, ito rin ang pinakapabagu-bagong buwan ng kalahati (127.6% annualized): ang katahimikan ay isang ilusyon ng endpoint. Narito ang mga resibo ng Hunyo — tape, earnings-week filings, volatility, peers, spread, options, shorts, at ang anim-na-buwang arko. Bawat numero ay isang stored query; palawakin ang anumang panel para sa SQL nito.
Ang buwan sa isang hilera
Ang eksaktong SQL sa likod ng bawat numero
WITH
(
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 max(toFloat64(high)) FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU'
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 = 'MU'
AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
) AS lo
SELECT
round(argMinIf(toFloat64(open), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS month_open,
round(argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 2) AS month_close,
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,
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,
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_first_bar_et,
round(minIf(toFloat64(low), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) - lo, 2) AS rth_minus_extended_low,
round(toFloat64(sum(volume)) / 1e9, 2) AS month_shares_bn,
round(sumIf(toFloat64(close) * toFloat64(volume), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / 1e9, 1) AS rth_dollar_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 = 'MU'
AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')Ang intramonth range ay napakalaki para sa isang pangalan na ganito kalaki: mula $850.1 na mababa (2026-06-05 16:34 ET) hanggang $1255 na mataas (2026-06-25 09:35 ET) — mas malawak pa kaysa sa buong taon ng karamihan sa mga stock. Ang Hunyo 19 ay isang market-wide closure (0 SPY bars), kaya ang buwan ay tumakbo ng 21 na sesyon.
Hunyo laban sa anim-na-buwang arko
Malaki ba ang +14%? Para sa ticker na ito, sa kalahating ito, ito ang tahimik. Ang panel ay nagre-recompute bawat buwan nang pareho, live.
Ang eksaktong SQL sa likod ng bawat numero
SELECT toString(toStartOfMonth(toDate(toTimeZone(window_start, 'America/New_York')))) AS period_start,
round((argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) / argMinIf(toFloat64(open), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) - 1) * 100, 1) AS month_return_pct,
round(argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959), 2) AS month_close,
round(sumIf(toFloat64(close) * toFloat64(volume), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) / 1e9, 1) AS rth_dollar_bn
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU'
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_startAng arko: 40.5% noong Enero, isang patag na 0% Pebrero, isang -15.9% Marso na nagmarka ng pinakamababang close ng kalahati ($337.62), pagkatapos ay 48.4% noong Abril at 89.8% noong Mayo — $414.73 hanggang $1151.01 sa loob ng anim na buwan. Umakyat ang turnover kasabay nito: $235.8 bilyon noong Enero hanggang $995.7 bilyon noong Hunyo. Ang paggalaw ng presyo noong Hunyo ang pinakamaliit mula pa noong Pebrero; ang tape noong Hunyo ang pinakamalaki sa window.
Lumamig ang presyo. Hindi ang volatility.
Ang isang +14% buwan bang kalmado? Ang realized volatility — ang araw-araw na paggalaw ng closing, annualized — ay ibang-iba ang pagbasa sa Hunyo.
Ang eksaktong SQL sa likod ng bawat numero
SELECT
toString(toStartOfMonth(et_date)) AS period_start,
round(stddevSamp(log_ret) * sqrt(252) * 100, 1) AS realized_vol_ann_pct,
round(100 * stddevSamp(log_ret) / max(stddevSamp(log_ret)) OVER (), 1) AS pct_of_peak_vol,
round(avg(day_range_pct), 1) AS avg_day_range_pct,
round(max(abs(day_move_pct)), 1) AS biggest_day_move_pct,
count() AS return_days
FROM (
SELECT et_date, day_range_pct,
if(prev_close > 0, ln(close_usd / prev_close), NULL) AS log_ret,
if(prev_close > 0, (close_usd / prev_close - 1) * 100, NULL) AS day_move_pct
FROM (
SELECT et_date, close_usd, day_range_pct,
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,
argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS close_usd,
(maxIf(toFloat64(high), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) / minIf(toFloat64(low), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) - 1) * 100 AS day_range_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU'
AND window_start >= toDateTime('2026-01-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
GROUP BY et_date
)
)
)
WHERE isFinite(log_ret) AND log_ret IS NOT NULL
GROUP BY period_start
ORDER BY period_startAng Hunyo ang pinakamagulong buwan ng half ayon sa sukat na ito: 127.6% annualized, mas mataas pa sa 101.4% ng Mayo, na may 7.6% average session range at isang close-over-close na galaw na 15.8%. Tahimik ang mga endpoint; ang mga araw sa pagitan ay hindi.
Session by session
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
FROM (
SELECT et_date, close_usd, shares_m,
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
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU'
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_dateAng talahanayan ay lumiliko nang husto sa magkabilang direksiyon — mula $1034.83 noong 2026-06-01 sa pamamagitan ng kaguluhan hanggang $1151.01 sa huling sesyon. Ito ang nakatago sa "+14% sa buwan": ang mga dulo lamang ang tahimik. Ang pinakamabibigat na hanay ay nasa linggo ng earnings — susunod.
Nakaayon ba ang mga paggalaw sa isang naiulat na quarter?
Maaari itong i-date — ang papel-trail ng MU noong Hunyo mula sa mismong index ng SEC, kasabay ng ginawa ng tape sa mga petsang iyon.
Ang eksaktong SQL sa likod ng bawat numero
WITH
(
SELECT maxIf(filing_date, form_type = '8-K')
FROM global_markets.stocks_sec_edgar_index
WHERE cik = '0000723125' AND filing_date >= toDate('2026-06-01') AND filing_date <= toDate('2026-06-30')
) AS last_8k_date,
(
SELECT minIf(filing_date, form_type = '10-Q')
FROM global_markets.stocks_sec_edgar_index
WHERE cik = '0000723125' AND filing_date >= toDate('2026-06-01') AND filing_date <= toDate('2026-06-30')
) AS tenq_date,
(
SELECT (count(), countIf(form_type = '8-K'), countIf(form_type = '4'))
FROM global_markets.stocks_sec_edgar_index
WHERE cik = '0000723125' AND filing_date >= toDate('2026-06-01') AND filing_date <= toDate('2026-06-30')
) AS filing_census,
(
SELECT toDate(toTimeZone(min(window_start), 'America/New_York'))
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU'
AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
AND toFloat64(high) >= (
SELECT max(toFloat64(high)) FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU' AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
) - 0.011
) AS month_high_date
SELECT
toString(last_8k_date) AS earnings_8k_filed,
if(last_8k_date = toDate('2026-06-24'), 1, 0) AS eightk_on_jun24,
toString(tenq_date) AS tenq_filed,
dateDiff('day', last_8k_date, tenq_date) AS days_8k_to_10q,
filing_census.1 AS june_filings_total,
filing_census.2 AS eightk_filings,
filing_census.3 AS form4_filings,
round((anyIf(close_usd, et_date = toDate('2026-06-25')) / anyIf(close_usd, et_date = toDate('2026-06-24')) - 1) * 100, 1) AS next_session_move_pct,
round(anyIf(shares_m, et_date = toDate('2026-06-25')), 1) AS next_session_shares_m,
round(anyIf(shares_m, et_date = toDate('2026-06-25')) - maxIf(shares_m, et_date != toDate('2026-06-25')), 1) AS shares_lead_over_next_busiest_m,
if(month_high_date = toDate('2026-06-25'), 1, 0) AS month_high_on_jun25
FROM (
SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) AS close_usd,
toFloat64(sum(volume)) / 1e6 AS shares_m
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU'
AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
GROUP BY et_date
)Ang quarterly 8-K ng MU ay may petsang 2026-06-24, ang 10-Q ay 1 araw pagkatapos nito (8 na mga filing noong Hunyo, 3 insider Form 4). Ang sesyon pagkatapos ng petsa ng 8-K ay nagsara ng 15.8% mas mataas sa 77.2 milyong bahagi — ang pinakamabigat ng buwan, 5.9 milyong higit sa susunod na pinaka-abala — at ang $1255 na pinakamataas ng buwan ay lumabas sa parehong sesyon na iyon (2026-06-25 09:35 ET; ang kolum ng kasunduan ang nagpapatunay sa tugma). Ang pagkakahanay ay ang obserbasyon; dito nagtatapos ang pahinang ito.
Isang kuwento ng Micron, o kuwento ng memorya?
Gumalaw din ba ang iba pang bahagi ng memory at storage complex? Ang basket ay nakapirmi at idineklara: ang tatlong pangalan ng storage na pinakamadalas na itinambal ng balita noong Hunyo sa MU, kasama ang NVDA at SPY bilang mga yardstick.
Ang eksaktong SQL sa likod ng bawat numero
WITH (
SELECT (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
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU' AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
) AS mu_return
SELECT ticker,
round(june_return_pct, 1) AS june_return_pct,
round(june_return_pct - mu_return, 1) AS vs_mu_pct_points,
rth_dollar_bn,
round(100 * rth_dollar_bn / max(rth_dollar_bn) OVER (), 1) AS pct_of_top_turnover
FROM (
SELECT ticker,
(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 AS june_return_pct,
round(sumIf(toFloat64(close) * toFloat64(volume), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / 1e9, 1) AS rth_dollar_bn
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('MU', 'SNDK', 'WDC', 'INTC', 'NVDA', 'SPY')
AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
GROUP BY ticker
)
ORDER BY june_return_pct DESCIto ay isang paggalaw ng memorya — at nahuli ito ng MU. SNDK tumaas ng 31.3%, INTC 27.5%, WDC 19.1% — bawat pangalan ng storage ay tinalo ang MU ng 5.1 hanggang 17.3 puntos — habang ang SPY at NVDA ay nagsara ng Hunyo na mas mababa. Ang natatangi sa MU: ang turnover nito ang pinakamataas sa lahat ng row dito.
Ang pinakamalaking ticker sa tape
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
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 10Ang eksaktong SQL sa likod ng bawat numero
WITH (
SELECT sum(toFloat64(volume) * toFloat64(close))
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU'
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 mu_d
SELECT
countIf(d > mu_d AND ticker != 'MU') + 1 AS mu_rank,
round(mu_d / 1e9, 1) AS mu_dollar_bn,
round((mu_d - maxIf(d, d < mu_d AND ticker != 'MU')) / 1e9, 1) AS lead_over_next_bn
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
)Nakakuha ang MU ng first sa lahat ng US-listed na simbolo batay sa regular-hours dollar volume noong Hunyo — $995.7 bilyon, $224.3 bilyon ang agwat sa SPY na nasa pangalawa. Isang kumpanya lang ang lumampas sa flagship index fund sa loob ng isang buwan — bihirang tape structure ito; ang earnings-week at peer sections sa itaas ang nagbibigay ng konteksto. Batayan: Hunyo 1–30 regular hours, hindi kasama ang isang reused-symbol listing habang hindi pa beripikado ang entity (ang mga resibo nito). Ang market-wide view ay nasa June recap.
Kung ano ang binubuo ng tape
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 OR ask_price <= 0))
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'MU'
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 crossed_updates,
quote_census.4 AS one_sided_or_empty_updates
FROM global_markets.stocks_trades
WHERE ticker = 'MU'
AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)35.17 milyong prints sa median na 8 shares — at 91.7% odd lots, isa sa pinakamaraming retail-sliced tape na nasukat namin (ang June run ng NVDA ay mas mababa; ang malalimang pagsusuri nito ay may twin panel). Sa presyong apat na digit, ang "round lot" ay malaking pera, kaya ang maliliit na prints ay nangingibabaw ayon sa disenyo; ang fractional prints (9.04%) ay tumuturo sa parehong direksyon. Ang quote half: 19.64 milyong NBBO updates, 99.86% malinis na two-sided, 16963 crossed, 78 one-sided o walang laman — isinapubliko, hindi ibinagsak.
Ang spread sa panahon ng repricing
Ang stock na halos nag-triple sa isang quarter ay nagtataas ng tanong tungkol sa spread sa ibang paraan: nanatili ba itong mahigpit na naka-quote habang ang presyo ay nakahanap ng bagong antas?
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 = 'MU'
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 sessionSa basis points, ang spread ay nanatiling institutional-grade sa buong galaw: 3.96 bps noong 2026-06-01, 4.19 bps sa huling sesyon — ang kolum ng sentimo ay halong sumusunod sa antas ng presyo mismo. Para sa mekanika, tingnan ang paliwanag ng spread.
Options: isang dalawang-daanang libro
Ang eksaktong SQL sa likod ng bawat numero
SELECT
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, 11, 1) = 'P')) / toFloat64(sumIf(size, substring(ticker, 11, 1) = 'C')), 2) AS month_put_call_ratio,
uniqExact(substring(ticker, 5, 6)) AS expiries_traded,
round(intDiv(toUInt32OrZero(substring(argMax(ticker, sz), 12, 8)), 1000), 0) AS busiest_strike_usd
FROM (
SELECT ticker, price, size, sum(size) OVER (PARTITION BY ticker) AS sz
FROM global_markets.options_trades
WHERE startsWith(ticker, 'O:MU') AND length(ticker) = 19
AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
)16.76 milyong kontrata sa 11789 natatanging kontrata, para sa $77.13 bilyong premium — at dalawang-daanan ang libro: isang buwang put/call ratio na 0.99, halos parity (ang NVDA's June ay tumakbo na call-heavy; ikumpara). Ang malapit sa parity sa gitna ng marahas na repricing ay ang options market na nahati sa magkabilang panig ng galaw — ang datos ang nagpapakita ng hati, hindi ang intensyon.
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
FROM (
SELECT
least(floor(toFloat64(toUInt32OrZero(substring(ticker, 12, 8))) / 1000 / 100) * 100, 1500) AS bucket,
toUInt64(sumIf(size, substring(ticker, 11, 1) = 'C')) AS call_contracts,
toUInt64(sumIf(size, substring(ticker, 11, 1) = 'P')) AS put_contracts
FROM global_markets.options_trades
WHERE startsWith(ticker, 'O:MU') AND length(ticker) = 19
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 sumasaklaw sa isang range na magiging katawa-tawa noong January — tunay na volume mula sa $0 bucket hanggang sa $1500+ ceiling, isang bakas kung gaano kalayo ang galaw ng underlying. Magkano ang halaga ng pagmamay-ari ng galaw na iyon? Ang huling sesyon ng buwan ang nagpresyo nito:
Ang eksaktong SQL sa likod ng bawat numero
WITH (
SELECT argMaxIf(toFloat64(close), window_start, (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'MU' AND window_start >= toDateTime('2026-06-30 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
) AS spot
SELECT
toString(any(expiry)) AS nearest_expiry,
dateDiff('day', toDate('2026-06-30'), any(expiry)) AS calendar_days_to_expiry,
round(spot, 2) AS spot_close,
argMin(strike_usd, (dist, strike_usd)) AS atm_strike,
round(argMin(call_last + put_last, (dist, strike_usd)), 2) AS straddle_usd,
round(argMin(call_last + put_last, (dist, strike_usd)) / spot * 100, 2) AS straddle_pct_of_spot,
count() AS two_sided_strikes
FROM (
SELECT expiry, strike_usd, abs(strike_usd - spot) AS dist,
anyIf(last_px, opt_type = 'C') AS call_last,
anyIf(last_px, opt_type = 'P') AS put_last
FROM (
SELECT
toDateOrNull(concat('20', substring(ticker, 5, 2), '-', substring(ticker, 7, 2), '-', substring(ticker, 9, 2))) AS expiry,
substring(ticker, 11, 1) AS opt_type,
toFloat64(toUInt32OrZero(substring(ticker, 12, 8))) / 1000 AS strike_usd,
argMax(toFloat64(price), (sip_timestamp, toFloat64(price))) AS last_px
FROM global_markets.options_trades
WHERE startsWith(ticker, 'O:MU') AND length(ticker) = 19
AND sip_timestamp >= toDateTime64('2026-06-30 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
GROUP BY expiry, opt_type, strike_usd
)
WHERE expiry > toDate('2026-06-30')
GROUP BY expiry, strike_usd
HAVING countIf(opt_type = 'C') > 0 AND countIf(opt_type = 'P') > 0
)
WHERE expiry = (
SELECT min(toDateOrNull(concat('20', substring(ticker, 5, 2), '-', substring(ticker, 7, 2), '-', substring(ticker, 9, 2))))
FROM global_markets.options_trades
WHERE startsWith(ticker, 'O:MU') AND length(ticker) = 19
AND sip_timestamp >= toDateTime64('2026-06-30 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
AND toDateOrNull(concat('20', substring(ticker, 5, 2), '-', substring(ticker, 7, 2), '-', substring(ticker, 9, 2))) > toDate('2026-06-30')
)Simula ng June 30 close, ang pinakamalapit na expiry ay 2 araw ng kalendaryo ang layo; ang at-the-money pair — isang call at isang put sa $1150 strike — huling nag-trade para sa pinagsamang $69.95: 6.08% ng $1151.01 share price. Kailangan ng buyer ng galaw na ganoon kalaki, sa alinmang direksyon, sa loob ng 2 araw na iyon para makabreak even — nagtapos ang June na naka-presyo pa rin para sa sobrang laking galaw.
Ang daloy ng balita
Ang eksaktong SQL sa likod ng bawat numero
WITH
(
SELECT (JSONExtractString(any(publisher), 'name'), count())
FROM global_markets.stocks_news
WHERE has(tickers, 'MU')
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,
top_pub.1 AS top_publisher,
round(100.0 * top_pub.2 / count(), 0) AS top_publisher_pct,
countIf(has(tickers, 'NVDA')) AS nvda_co_articles,
countIf(has(tickers, 'SNDK')) AS sndk_co_articles,
countIf(has(tickers, 'INTC')) AS intc_co_articles
FROM global_markets.stocks_news
WHERE has(tickers, 'MU')
AND published_utc >= toDateTime('2026-06-01 00:00:00') AND published_utc < toDateTime('2026-07-01 04:00:00')195 artikulong may tag na MU mula sa 4 publisher — basahin nang may pag-aalinlangan, The Motley Fool lang ang sumulat ng 59% sa mga ito. Ang mga co-tag ay bumubuo ng isang kuwento tungkol sa semiconductor: NVDA sa 86 artikulo, SNDK sa 32, INTC sa 21. Ano ang tungkol dito? Ang sariling mga tag ng artikulo ng vendor ay nagbibigay ng bokabularyo nang hindi ito ginagamit:
Ang eksaktong SQL sa likod ng bawat numero
SELECT keyword, count() AS articles,
round(100.0 * count() / (SELECT count() FROM global_markets.stocks_news WHERE has(tickers, 'MU') AND published_utc >= toDateTime('2026-06-01 00:00:00') AND published_utc < toDateTime('2026-07-01 04:00:00')), 1) AS pct_of_articles
FROM global_markets.stocks_news
ARRAY JOIN keywords AS keyword
WHERE has(tickers, 'MU')
AND published_utc >= toDateTime('2026-06-01 00:00:00') AND published_utc < toDateTime('2026-07-01 04:00:00')
GROUP BY keyword
ORDER BY articles DESC, keyword ASC
LIMIT 10"AI infrastructure" ang nangunguna sa 49 ng 195 artikulo, kasunod ang "memory chips", "DRAM" at "high-bandwidth memory" — isang bokabularyo ng AI-memory, iniulat bilang bilang ng tag, hindi bilang paliwanag.
Lumiit ang mga short — at may butas pa rin sa coverage
Ang eksaktong SQL sa likod ng bawat numero
SELECT toString(date) AS d,
round(toFloat64(any(short_volume)) / 1e6, 2) AS short_shares_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 = 'MU' AND date >= toDate('2026-06-01') AND date <= toDate('2026-06-30')
GROUP BY date
ORDER BY dateCoverage muna: Ang June short-volume file ng MU ay may lamang 16 sa 21 na sesyon — bukod sa market-wide truncation noong June 29, ilang MU row ang simpleng wala — kaya walang month-level ratio na kinompyut; ang per-day rows ay totoo, ang mga butas ay isinapubliko.
Ang eksaktong SQL sa likod ng bawat numero
SELECT
toString(maxIf(settlement_date, settlement_date <= toDate('2026-06-20'))) AS mid_june_settlement,
round(toFloat64(maxIf(short_interest, settlement_date <= toDate('2026-06-20'))) / 1e6, 2) AS mid_june_shares_short_m,
toString(maxIf(settlement_date, settlement_date > toDate('2026-06-20'))) AS eom_settlement,
round(toFloat64(maxIf(short_interest, settlement_date > toDate('2026-06-20'))) / 1e6, 2) AS eom_shares_short_m,
round((toFloat64(maxIf(short_interest, settlement_date <= toDate('2026-06-20'))) - toFloat64(maxIf(short_interest, settlement_date > toDate('2026-06-20')))) / 1e6, 2) AS decline_m_shares,
round(toFloat64(maxIf(short_interest, settlement_date > toDate('2026-06-20'))) / toFloat64(maxIf(avg_daily_volume, settlement_date > toDate('2026-06-20'))), 2) AS eom_days_to_cover
FROM global_markets.stocks_short_interest
WHERE ticker = 'MU' AND settlement_date >= toDate('2026-06-01') AND settlement_date <= toDate('2026-06-30')Kumpleto ang settlement pair: 41.59 milyong shares na short sa 2026-06-15 settlement ay bumagsak sa 31.67 milyon pagsapit ng 2026-06-30 — isang 9.92 milyong-share na pagbaba sa ikalawang kalahati, ang kalahating naglaman ng earnings week. Ang month-end position ay katumbas ng 0.53 araw ng average volume — maliit para sa tape na ito. Unang lumabas ang page na ito habang nakabinbin ang print na iyon (normal ang lag); ang numero sa itaas ay ang pagdating nito.
Ang mga pundasyon sa ilalim ng tape
Ano ang ipinapakita ng sariling pahayag ng kumpanya? Isang babala: ang feed ay nahuhuli sa filing calendar — ang pinakabagong row ay nauuna sa June 10-Q, kaya ang trend ang dapat pagtuunan, hindi ang front edge.
Ang eksaktong SQL sa likod ng bawat numero
SELECT quarter_end, revenue_bn,
round(100 * revenue_bn / max(revenue_bn) OVER (), 1) AS pct_of_peak_revenue,
net_income_bn, diluted_eps
FROM (
SELECT toString(period_end) AS quarter_end,
round(toFloat64(revenue) / 1e9, 2) AS revenue_bn,
round(toFloat64(net_income_loss_attributable_common_shareholders) / 1e9, 2) AS net_income_bn,
round(toFloat64(diluted_earnings_per_share), 2) AS diluted_eps
FROM global_markets.stocks_income_statements
WHERE has(tickers, 'MU') AND timeframe = 'quarterly'
ORDER BY period_end DESC
LIMIT 6
)
ORDER BY quarter_end ASCSa anim na quarter na nasa file, ang revenue ay mula $7.75 bilyon (2024-08-29) hanggang $13.64 bilyon (2025-11-27) — ang pinakabagong row ang pinakamataas sa window — na may $5.24 bilyong net income at $4.6 diluted EPS sa quarter na iyon. Hindi ito straight line, ngunit ang window ay nagtatapos sa pinakamataas nito.
Ano ang dapat bantayan mula rito
Mga katotohanan sa kalendaryo lamang: ang susunod na short-interest settlement ay darating sa kalagitnaan ng Hulyo, ilalathala sa karaniwang lag ng FINRA; ang quarter na inihain noong Hunyo ay magiging isang hanay ng fundamentals kapag naabutan ng vendor feed; at ang tape ng Hulyo ay makakakuha ng ganitong pagtrato sa susunod na edisyon ng serye.
FAQ
Bakit nagkaroon ng malaking paggalaw ang MU stock noong Hunyo 2026?
Sinusukat ng pahinang ito ang paggalaw, hindi ipinapaliwanag: ang MU ay nag-trade sa pagitan ng $850.1 at $1255; ang quarterly 8-K ay may petsang 2026-06-24, at ang sumunod na sesyon ay tumaas ng 15.8% sa pinakamabigat na volume ng buwan; ang buong memory basket ay gumalaw sa parehong direksyon sa panahong iyon.
Gaano ka-volatile ang MU noong Hunyo 2026?
Ang pinaka-volatile na buwan ng kalahating taon nito: 127.6% annualized realized volatility at 7.6% average session range, laban sa endpoint-to-endpoint return na 14% lamang.
Ang paggalaw ba ng MU noong Hunyo ay dahil sa kompanya o sa buong sektor?
Dahil sa buong sektor, kung saan ang MU ang pinakahuli sa mga tumaas: tumaas ng 31.3% ang SNDK at lahat ng storage name ay nalampasan ang 14% ng MU, habang ang SPY at NVDA ay nagsara nang mas mababa. Ang pinagkaiba ng MU ay ang turnover: $995.7 bilyon, pinakamalaki sa basket.
Mataas ba ang short interest ng MU?
Maliit kumpara sa sarili nitong trading: 31.67 milyong shares sa 2026-06-30 settlement — mga 0.53 araw ng average volume para ma-cover, bumaba ng 9.92 milyon mula kalagitnaan ng Hunyo. Ang short interest ay laging nagpe-publish na may settlement lag.
Ano ang ibig sabihin ng put/call ratio ng MU?
Ang ratio ng Hunyo na 0.99 ay nangangahulugang ang puts at calls ay nag-trade sa halos pantay na volume — isang two-way market, hindi isang one-sided bet. Ang mas mababa sa isa ay nagpapahiwatig ng call-tilted (ginawa ng NVDA noong Hunyo), ang mas mataas sa isa ay put-tilted.
Mga tala sa datos
Buong tala sa datos
- Entity. Ang MU ay Micron Technology, Inc., CIK 0000723125 — iisang tuloy-tuloy na EDGAR identity; walang caveat sa paggamit muli ng simbolo.
- Short-volume coverage. Ang file ng Hunyo ay sumasaklaw sa 16 ng 21 na sesyon (ang truncation noong Hunyo 29 kasama ang mga partikular na pagliban ng MU); ang mga ratio ay ipinapakita bawat araw lamang.
- Peer basket. SNDK, WDC, INTC — ang pinakamadalas na storage co-tags sa news flow ng MU noong Hunyo — kasama ang NVDA at SPY bilang yardsticks; idineklara nang maaga, hindi kailanman binuo pagkatapos ng pangyayari.
- Options parsing. Ang expiry/type/strike ay muling na-parse mula sa OCC symbol (mga posisyon 5/11/12); ang premium ay ipinapalagay ang 100-share multiplier.
- Straddle method. Ang huling TRADED na presyo (hindi quotes) sa strike na pinakamalapit sa huling close, pinakamalapit na expiry pagkatapos ng katapusan ng buwan — isang trade receipt, hindi model-implied volatility.
- Fundamentals lag. Ang income-statement feed ay nahuhuli sa filing calendar; ang pinakabagong MU row nito ay nauuna sa June 10-Q — trend context lamang.
- June 19 closure na-verify sa pamamagitan ng zero-SPY-bars scoreboard receipt.
- Spread panels ay hindi kasama ang crossed/one-sided quotes, na may drop counts na isinisiwalat sa-row.
- Market-wide context — kasama ang ticker na ito sa tuktok ng whole-tape leaderboard — ay nasa June 2026 recap.
Pamamaraan
- Ang panahon ay Hunyo 1–30, 2026 (21 na sesyon, na-verify mula sa naobserbahang mga bar). Ang mga returns ay mula sa unang regular-hours open hanggang sa huling regular-hours close; ang Hunyo ay ganap na nasa EDT, kaya ang regular hours ay 13:30–20:00 UTC bilang raw bounds. Ang trailing panels ay sumasaklaw sa mga buwan ng EST at gumagamit ng Eastern-clock filter sa halip.
- Realized volatility = sample stddev ng daily close-over-close log returns (regular-hours closes), annualized sa pamamagitan ng square root ng 252; ang unang return ng isang buwan ay tumatawid sa hangganan ng buwan at binibilang sa susunod na buwan.
- Ang trailing comparisons ay nagre-recompute nang live, hindi kailanman mula sa isang stored value.
- Ang generation ay batch-only sa pamamagitan ng gated read-only path; ang public page ay hindi kailanman nag-query nang live. Warehouse simula noong July 12, 2026.
Ang bawat panel ay isang stored object — chart, table, SQL. Kunin ang anumang query sa Strasmore terminal.