Heston Model and the Volatility Smile
How far at-the-money implied volatility itself travelled (Jan to Jun 2026)ranking ·
2026-08-12 · 6×4
Near-the-money implied volatility by time to expiry (Jan to Jun 2026)ranking ·
2026-08-12 · 6×3
SPY implied volatility by strike distance, 20 to 45 days to expiry (Jan to Jun 2026)ranking ·
2026-08-12 · 13×4
Put-side versus call-side implied volatility, 20 to 45 days (Jan to Jun 2026)ranking ·
2026-08-12 · 6×4
Daily at-the-money implied volatility, SPY and NVDA (Apr to Jun 2026)series ·
2026-08-12 · 62×3
How far at-the-money implied volatility itself travelled (Jan to Jun 2026)
How far at-the-money implied volatility itself travelled (Jan to Jun 2026)
| symbol | low_iv_pct | high_iv_pct | swing_pts |
|---|---|---|---|
| AMZN | 28.21 | 74.42 | 46.22 |
| MSFT | 24.49 | 50.5 | 26.01 |
| NVDA | 34.49 | 53.94 | 19.45 |
| SPY | 12.86 | 26.3 | 13.44 |
| AAPL | 21.91 | 33.47 | 11.56 |
| KO | 14.31 | 25.06 | 10.75 |
the exact SQL behind every number
SELECT
symbol,
round(min(daily_iv) * 100, 2) AS low_iv_pct,
round(max(daily_iv) * 100, 2) AS high_iv_pct,
round((max(daily_iv) - min(daily_iv)) * 100, 2) AS swing_pts
FROM
(
SELECT
underlying_symbol AS symbol,
date,
avg(implied_volatility) AS daily_iv
FROM global_markets.options_greeks
WHERE underlying_symbol IN ('SPY', 'AAPL', 'MSFT', 'NVDA', 'AMZN', 'KO')
AND date BETWEEN '2026-01-02' AND '2026-06-30'
AND iv_converged = 1
AND volume > 0
AND days_to_expiry BETWEEN 20 AND 45
AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) <= 0.05
GROUP BY symbol, date
)
GROUP BY symbol
ORDER BY swing_pts DESC
More from this analysisHeston Model and the Volatility Smile
SPY implied volatility by strike distance, 20 to 45 days to expiry (Jan to Jun 2026)
ranking 13×4
→
Near-the-money implied volatility by time to expiry (Jan to Jun 2026)
ranking 6×3
→
Put-side versus call-side implied volatility, 20 to 45 days (Jan to Jun 2026)
ranking 6×4
→
Daily at-the-money implied volatility, SPY and NVDA (Apr to Jun 2026)
series 62×3
→
See all 2,170 queries →