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

Heston Model and the Volatility Smile
How far at-the-money implied volatility itself travelled (Jan to Jun 2026)ranking · 2026-08-12 · 6×4Preview: 6 ranked values, largest first. Near-the-money implied volatility by time to expiry (Jan to Jun 2026)ranking · 2026-08-12 · 6×3Preview: 6 ranked values, smallest first. SPY implied volatility by strike distance, 20 to 45 days to expiry (Jan to Jun 2026)ranking · 2026-08-12 · 13×4Preview: 13 ranked values, largest first. Put-side versus call-side implied volatility, 20 to 45 days (Jan to Jun 2026)ranking · 2026-08-12 · 6×4Preview: 6 ranked values, smallest first. Daily at-the-money implied volatility, SPY and NVDA (Apr to Jun 2026)series · 2026-08-12 · 62×3Preview: a 16-point series, ending higher.
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)

most recentas of ranking 6×4read in context →
How far at-the-money implied volatility itself travelled (Jan to Jun 2026) — 6 rows by 4 columns, computed from US exchange, SIP and OPRA data.
symbollow_iv_pcthigh_iv_pctswing_pts
AMZN28.2174.4246.22
MSFT24.4950.526.01
NVDA34.4953.9419.45
SPY12.8626.313.44
AAPL21.9133.4711.56
KO14.3125.0610.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
$