Same underlying, same IV, rising vega: AAPL by days to expiry (July 2026)

WITH ntm AS
(
    SELECT
        intDiv(days_to_expiry, 30) * 30 AS dte_floor,
        avg(toFloat64(vega))            AS vega_avg,
        avg(implied_volatility)         AS iv_avg,
        count()                         AS contract_days
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date >= '2026-07-01'
      AND date <  '2026-08-01'
      AND iv_converged = 1
      AND volume > 0
      AND days_to_expiry BETWEEN 1 AND 545
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
    GROUP BY dte_floor
    HAVING count() >= 50
)
SELECT
    concat(toString(dte_floor), ' to ', toString(dte_floor + 29), ' days') AS dte_bucket,
    round(iv_avg * 100, 1)                                                 AS avg_iv_pct,
    round(vega_avg / first_value(vega_avg) OVER (ORDER BY dte_floor ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING), 2) AS vega_vs_front,
    toUInt32(contract_days)                                                AS contract_day_count
FROM ntm
ORDER BY dte_floor