Apple: implied volatility and the expected move at six horizons, one session

SELECT multiIf(days_to_expiry <= 7, '1 week',
               days_to_expiry <= 14, '2 weeks',
               days_to_expiry <= 45, '1 month',
               days_to_expiry <= 120, '3 months',
               days_to_expiry <= 240, '6 months',
               '1 year') AS horizon,
       round(avg(days_to_expiry), 0) AS avg_days,
       round(100 * avg(toFloat64(implied_volatility)), 1) AS iv_pct,
       round(100 * avg(toFloat64(implied_volatility)) * sqrt(avg(days_to_expiry) / 365), 2) AS expected_move_pct,
       round(avg(toFloat64(underlying_close)) * avg(toFloat64(implied_volatility))
             * sqrt(avg(days_to_expiry) / 365), 2) AS expected_move_usd,
       round(avg(toFloat64(underlying_close)), 2) AS underlying_price,
       formatDateTime(max(date), '%b %e, %Y') AS as_of
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
  AND date = (SELECT max(date)
              FROM global_markets.options_greeks
              WHERE underlying_symbol = 'AAPL'
                AND date <= toDate('2026-07-15'))
  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 horizon
HAVING count() >= 3
ORDER BY avg_days