STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

META Implied Volatility: IV Now & Its History
META ATM implied volatility by time to expiration: latest sessionranking · 2026-08-25 · 4×3Preview: 4 ranked values, smallest first. META vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-25 · 50×4Preview: a 16-point series, ending lower. META at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-25 · 62×2Preview: a 16-point series, ending higher.
AMZN Implied Volatility: IV Now & Its History
AMZN ATM implied volatility by time to expiration: latest sessionranking · 2026-08-24 · 4×3Preview: 4 ranked values, smallest first. AMZN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-24 · 50×4Preview: a 16-point series, ending lower. AMZN at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-24 · 62×2Preview: a 16-point series, ending higher.
Why VIX Options Don't Track the VIX
SPY near-the-money implied volatility by distance to expirationranking · 2026-08-22 · 6×3Preview: 6 ranked values, smallest first. How far the long tenor travels on days the front end jumpsranking · 2026-08-22 · 5×4Preview: 5 ranked values, smallest first. Near-dated versus long-dated SPY implied volatility, session by sessionseries · 2026-08-22 · 81×3Preview: a 16-point series, ending lower. The near-to-far implied volatility gap across liquid namesranking · 2026-08-22 · 6×4Preview: 6 ranked values, largest first.
Why Stocks Halt: Limit Up-Limit Down Bands
Where listed symbols sit by price, and which band rule governs each zoneranking · 2026-08-22 · 6×3Preview: 6 ranked values, largest first. Average minute range through the session, five liquid namesseries · 2026-08-22 · 26×3Preview: a 16-point series, ending lower. How far eight stocks move in a five minute window, trailing yearranking · 2026-08-22 · 8×4Preview: 8 ranked values, largest first. What a 5 percent band is worth in dollars, by price levelranking · 2026-08-22 · 8×4Preview: 8 ranked values, largest first.
What Is VIX1D? The 1-Day Volatility Index
Implied daily move (IV / 16) against realized daily movement, SPY by monthseries · 2026-08-22 · 14×5Preview: a 14-point series, ending higher. SPY option volume by expiration through one session, June 17 2026series · 2026-08-22 · 14×4Preview: a 14-point series, ending lower. SPY near-the-money implied volatility by days to expiryranking · 2026-08-22 · 8×2Preview: 8 ranked values, largest first. SPY absolute daily move, median and 90th percentile by yearranking · 2026-08-22 · 8×4Preview: 8 ranked values, smallest first.
Volatility Targeting for Position Sizing
SPY realised volatility by month against a 10% targetseries · 2026-08-22 · 72×4Preview: a 16-point series, roughly flat. What the lookback window costs in daily turnover (SPY, 10% target, 2x cap)ranking · 2026-08-22 · 4×4Preview: 4 ranked values, largest first. One 10% risk budget, six names, six different weightsranking · 2026-08-22 · 6×4Preview: 6 ranked values, smallest first. Weekly realised volatility and the weight it implied, Nov 2019 to Apr 2020series · 2026-08-22 · 25×4Preview: a 16-point series, ending lower.
TSLA Implied Volatility: IV Now & Its History
TSLA ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, smallest first. TSLA vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×4Preview: a 16-point series, ending lower. TSLA at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
The Low-Volatility Anomaly
Growth of $100: a calm name (KO), the market (SPY), a wild name (NVDA), weeklyseries · 2026-08-22 · 115×4Preview: a 16-point series, ending higher. Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years)ranking · 2026-08-22 · 25×3Preview: 16 ranked values, smallest first. Volatility thirds: median return, and the range from worst to best name in eachtable · 2026-08-22 · 3×6
SPY Implied Volatility: IV Now & Its History
SPY ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, smallest first. SPY vs QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×3Preview: a 16-point series, ending lower. SPY at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
QQQ Implied Volatility: IV Now & Its History
QQQ ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, smallest first. QQQ vs SPY: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×3Preview: a 16-point series, ending lower. QQQ at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
PLTR Implied Volatility: IV Now & Its History
PLTR ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, smallest first. PLTR vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×4Preview: a 16-point series, ending lower. PLTR at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
NVDA Implied Volatility: IV Now & Its History
NVDA ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, largest first. NVDA vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×4Preview: a 16-point series, ending lower. NVDA at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
MSTR Implied Volatility: IV Now & Its History
MSTR ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, largest first. MSTR vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×4Preview: a 16-point series, ending lower. MSTR at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
MSFT Implied Volatility: IV Now & Its History
MSFT ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, smallest first. MSFT vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×4Preview: a 16-point series, ending lower. MSFT at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
The Lowest-Volatility Stocks
The calmest large caps: annualized realized volatility over the past year, lowest firstranking · 2026-08-22 · 15×2Preview: 15 ranked values, smallest first. Maximum drawdown of the calmest names: the worst peak-to-trough fall over the past yearranking · 2026-08-22 · 8×2Preview: 8 ranked values, largest first.
IV Rank vs IV Percentile: Formulas Explained
IV rank vs IV percentile, eight liquid names, 52 week lookbacktable · 2026-08-22 · 8×5 The same session scored at five different lookback windowsranking · 2026-08-22 · 5×4Preview: 5 ranked values, smallest first. Current, 52 week low and 52 week high ATM IV for each nametable · 2026-08-22 · 8×6 AAPL at the money implied volatility, weekly, trailing 52 weeksseries · 2026-08-22 · 53×5Preview: a 16-point series, ending higher. One stock, one session, three definitions of the IV inputtable · 2026-08-22 · 3×6
Historical Volatility vs Implied Volatility
SPY: monthly implied volatility against the next month's realized volatilityseries · 2026-08-22 · 18×4Preview: a 16-point series, roughly flat. Average implied volatility against next-month realized volatility, by nametable · 2026-08-22 · 6×5 Annualized historical volatility over three lookback windowsranking · 2026-08-22 · 6×4Preview: 6 ranked values, largest first. AAPL realized volatility: 20-session against 60-session lookbackseries · 2026-08-22 · 72×3Preview: a 16-point series, ending higher.
The Real Risk of One Stock
Annualized volatility: the S&P 500 index versus six single stocks (last ~250 sessions)ranking · 2026-08-22 · 7×2Preview: 7 ranked values, smallest first. Same $100 invested: one single stock versus the S&P 500 index, indexed to 100series · 2026-08-22 · 14×3Preview: a 14-point series, ending higher. Maximum drawdown: deepest peak-to-trough drop over the last yearranking · 2026-08-22 · 7×2Preview: 7 ranked values, smallest first.
COIN Implied Volatility: IV Now & Its History
COIN ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, largest first. COIN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×4Preview: a 16-point series, ending lower. COIN at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
AMD Implied Volatility: IV Now & Its History
AMD ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, smallest first. AMD vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×4Preview: a 16-point series, ending lower. AMD at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
AAPL Implied Volatility: IV Now & Its History
AAPL ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, smallest first. AAPL vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×4Preview: a 16-point series, ending lower. AAPL at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
What Is IV Crush? Measured on Real Earnings
The biggest one-day ATM implied volatility collapses, June 1 - July 15, 2026series · 2026-08-18 · 12×6Preview: a 12-point series, ending lower. AVGO at-the-money implied volatility, daily, around the June 2026 reportseries · 2026-08-18 · 15×3Preview: a 15-point series, ending lower. The filing receipt: Broadcom's 8-K, first week of June 2026scalar · 2026-08-18 · 1×21
Is High Implied Volatility Good? IV in Context
Implied volatility beside the movement each stock actually delivered over the prior 30 sessionsranking · 2026-08-17 · 11×4Preview: 11 ranked values, largest first. The same reading against each name's own 52-week implied volatility range (July 28, 2026)table · 2026-08-17 · 11×5 At-the-money implied volatility, eleven familiar tickers (July 28, 2026)ranking · 2026-08-17 · 11×2Preview: 11 ranked values, largest first. Where near-the-money implied volatility sat across the traded options market (July 28, 2026)ranking · 2026-08-17 · 6×4Preview: 6 ranked values, smallest first.
Highest IV Rank Stocks Right Now
Where IV percentile sits furthest above IV rank, latest sessiontable · 2026-08-15 · 12×6 How the screened universe distributes across IV rank, latest sessiontable · 2026-08-15 · 9×7 The top-ranked name's implied volatility by week, with its 52-week high and lowseries · 2026-08-15 · 53×4Preview: a 16-point series, roughly flat. Highest IV rank, screened US underlyings, latest options sessionseries · 2026-08-15 · 15×7Preview: a 15-point series, roughly flat. IV rank and IV percentile for twelve widely held tickers, latest sessionseries · 2026-08-15 · 12×7Preview: a 12-point series, ending higher.
What Is Volatility Skew? The Smile, Measured
SPY implied volatility by strike: OTM puts below spot, OTM calls above, July 15, 2026ranking · 2026-08-14 · 6×2Preview: 6 ranked values, largest first. OTM put IV vs OTM call IV across every active underlying, July 15, 2026scalar · 2026-08-14 · 1×4348 Steepest INVERTED skew: OTM calls pricier than OTM puts, July 15, 2026ranking · 2026-08-14 · 8×4Preview: 8 ranked values, largest first.
What Is the VIX? What It Really Measures
Median daily percent change: VXX against SPY, by calendar yearranking · 2026-08-14 · 7×4Preview: 7 ranked values, smallest first. SPY at-the-money implied volatility by time to expiry, July 15, 2026ranking · 2026-08-14 · 6×3Preview: 6 ranked values, smallest first. SPY at-the-money implied volatility near 30 days to expiry, monthly averages (Jul 2025 to Jul 2026)series · 2026-08-14 · 13×6Preview: a 13-point series, ending higher. Implied daily move against the realized daily move: SPY, month by monthseries · 2026-08-14 · 13×6Preview: a 13-point series, roughly flat.
Why Some Options Cost So Much More
One near-money call each, premium as a share of the stock (Jul 6 2026)ranking · 2026-08-14 · 2×4Preview: 2 ranked values, largest first. At-the-money implied volatility across six names (Jul 6 2026, Jul-17 expiry)ranking · 2026-08-14 · 6×3Preview: 6 ranked values, smallest first.
What Is Implied Volatility? IV, Explained
ATM implied volatility across every actively traded underlying, July 15, 2026scalar · 2026-08-13 · 1×5753 SPY at-the-money IV by time to expiry: the term structure (2026-07-13)ranking · 2026-08-13 · 4×2Preview: 4 ranked values, smallest first. SPY put IV rises as strikes fall: the volatility skew (2026-07-13)ranking · 2026-08-13 · 5×2Preview: 5 ranked values, smallest first. SPY at-the-money implied volatility, month by month (Jul 2025 – Jul 2026)series · 2026-08-13 · 13×2Preview: a 13-point series, ending lower. At-the-money implied volatility by stock (2026-07-13)ranking · 2026-08-13 · 7×2Preview: 7 ranked values, largest first.
Implied Volatility vs Vega: The Difference
Where vega peaks: AAPL vega and IV across strikes, 20 to 45 days out (July 2026)ranking · 2026-08-13 · 12×4Preview: 12 ranked values, largest first. Same underlying, same IV, rising vega: AAPL by days to expiry (July 2026)ranking · 2026-08-13 · 14×4Preview: 14 ranked values, largest first. Contract days behind the weekly IV series, by monthseries · 2026-08-13 · 12×5Preview: a 12-point series, ending higher. One input, three levels: weekly average IV for AAPL, NVDA and KO (20 to 45 days out)series · 2026-08-13 · 53×5Preview: a 16-point series, ending higher.
Why Trading Volume Dies at Midday: U-Shape
Share of regular-session volume by half hour, SPY and AAPLseries · 2026-08-10 · 13×3Preview: a 13-point series, ending lower.
page 1 of 2
META ATM implied volatility by time to expiration: latest session

META ATM implied volatility by time to expiration: latest session

most recentas of ranking 4×3read in context →
META ATM implied volatility by time to expiration: latest session — 4 rows by 3 columns, computed from US exchange, SIP and OPRA data.
expiry_bucketatm_iv_pctcontracts
Under 2 weeks35186
2-6 weeks35.7109
6 weeks - 4 months39.844
Beyond 4 months4292
the exact SQL behind every number
SELECT multiIf(days_to_expiry <= 14, 'Under 2 weeks', days_to_expiry <= 45, '2-6 weeks',
               days_to_expiry <= 120, '6 weeks - 4 months', 'Beyond 4 months') AS expiry_bucket,
       round(100 * quantileExact(0.5)(implied_volatility), 1) AS atm_iv_pct,
       count() AS contracts
FROM global_markets.options_greeks
WHERE underlying_symbol = 'META'
  AND date = (SELECT max(date) FROM global_markets.options_greeks)
  AND iv_converged AND implied_volatility BETWEEN 0.02 AND 5
  AND abs(strike_price / underlying_close - 1) <= 0.05
GROUP BY expiry_bucket
HAVING count() >= 5
ORDER BY min(days_to_expiry)
$