calendar spread — 4 answered market questions

Near the money implied volatility by expiry band, three names

most recentas of 2026-10-04 ranking 6×4read in context →

Near the money implied volatility by expiry band, three names — 6 rows by 4 columns, computed 2026-10-04 from US exchange, SIP and OPRA data.
dte_band	aapl_iv_pct	spy_iv_pct	ko_iv_pct
1-10 DTE	27.6	16.8	23.2
11-25 DTE	23.7	13.2	18.6
26-45 DTE	25.4	13.7	19.7
46-90 DTE	26.3	14.4	20.7
91-180 DTE	26.5	15.2	20.3
181+ DTE	27.8	16.9	20.8

the exact SQL behind every number

SELECT
    multiIf(days_to_expiry <= 10,  '1-10 DTE',
            days_to_expiry <= 25,  '11-25 DTE',
            days_to_expiry <= 45,  '26-45 DTE',
            days_to_expiry <= 90,  '46-90 DTE',
            days_to_expiry <= 180, '91-180 DTE',
                                   '181+ DTE')                            AS dte_band,
    round(avgIf(implied_volatility, underlying_symbol = 'AAPL') * 100, 1)  AS aapl_iv_pct,
    round(avgIf(implied_volatility, underlying_symbol = 'SPY')  * 100, 1)  AS spy_iv_pct,
    round(avgIf(implied_volatility, underlying_symbol = 'KO')   * 100, 1)  AS ko_iv_pct
FROM global_markets.options_greeks
WHERE underlying_symbol IN ('AAPL', 'SPY', 'KO')
  AND date >= today() - 30
  AND date <= today() - 2
  AND iv_converged = 1
  AND volume > 0
  AND days_to_expiry BETWEEN 1 AND 400
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
GROUP BY dte_band
HAVING countIf(underlying_symbol = 'AAPL') > 0
   AND countIf(underlying_symbol = 'SPY')  > 0
   AND countIf(underlying_symbol = 'KO')   > 0
ORDER BY min(days_to_expiry)

More from this analysisWhat Is a Calendar Spread in Options?

Theta and vega across expiry bands, near the money AAPL ranking 6×3 → How often front volatility sat above back volatility ranking 5×4 → AAPL front band against back band implied volatility, trailing months series 81×4 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → See all 3,256 queries →