STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

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

ZM Implied Volatility: Zoom IV and Earnings
ZM at-the-money IV by days to expiry, most recent week of dataranking · 2026-11-07 · 5×4Preview: 5 ranked values, largest first. ZM at-the-money 30-day implied volatility, recent sessionsseries · 2026-11-07 · 85×4Preview: a 16-point series, roughly flat. ZM at-the-money IV by calendar year: average, low and hightable · 2026-11-07 · 8×5 ZM at-the-money IV before and on the biggest one-session drop in each quartertable · 2026-11-07 · 9×5
ZM at-the-money IV by days to expiry, most recent week of data

ZM at-the-money IV by days to expiry, most recent week of data

most recentas of ranking 5×4read in context →
ZM at-the-money IV by days to expiry, most recent week of data — 5 rows by 4 columns, computed from US exchange, SIP and OPRA data.
dte_bucketatm_iv_pctcontract_countas_of
0 to 10 days56.5128Nov 6, 2026
11 to 30 days51.9176Nov 6, 2026
31 to 60 days53.863Nov 6, 2026
61 to 120 days46.250Nov 6, 2026
over 120 days4667Nov 6, 2026
the exact SQL behind every number
SELECT
    multiIf(days_to_expiry <= 10,  '0 to 10 days',
            days_to_expiry <= 30,  '11 to 30 days',
            days_to_expiry <= 60,  '31 to 60 days',
            days_to_expiry <= 120, '61 to 120 days',
                                   'over 120 days')   AS dte_bucket,
    round(100 * avg(toFloat64(implied_volatility)), 1) AS atm_iv_pct,
    count()                                            AS contract_count,
    formatDateTime(max(date), '%b %e, %Y')             AS as_of
FROM global_markets.options_greeks
WHERE underlying_symbol = 'ZM'
  AND iv_converged = 1
  AND volume > 0
  AND toFloat64(underlying_close) > 0
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
  AND date >= (
        SELECT max(date)
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'ZM' AND iv_converged = 1
      ) - 7
GROUP BY dte_bucket
ORDER BY min(days_to_expiry)
$