spy_term_structure

SELECT
    tenor_label                              AS tenor,
    round(100 * avg(implied_volatility), 1)  AS atm_iv_pct
FROM
(
    SELECT
        implied_volatility,
        multiIf(days_to_expiry <= 7,  '1-7 days',
                days_to_expiry <= 14, '8-14 days',
                days_to_expiry <= 21, '15-21 days',
                days_to_expiry <= 30, '22-30 days',
                days_to_expiry <= 45, '31-45 days',
                days_to_expiry <= 60, '46-60 days',
                                      '61-90 days') AS tenor_label,
        multiIf(days_to_expiry <= 7,  1,
                days_to_expiry <= 14, 2,
                days_to_expiry <= 21, 3,
                days_to_expiry <= 30, 4,
                days_to_expiry <= 45, 5,
                days_to_expiry <= 60, 6,
                                      7) AS tenor_order
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND date >= '2026-06-01'
      AND date <  '2026-07-01'
      AND iv_converged = 1
      AND volume > 0
      AND days_to_expiry BETWEEN 1 AND 90
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.02
)
GROUP BY tenor_label, tenor_order
ORDER BY tenor_order