Traded price against intrinsic value, by days to expiry

SELECT
    days_to_expiry,
    round(avg(price), 2)                   AS avg_traded_price,
    round(avg(payoff_now), 2)              AS avg_intrinsic_value,
    round(avg(abs(price - payoff_now)), 2) AS avg_gap
FROM
(
    SELECT
        days_to_expiry,
        toFloat64(option_close) AS price,
        greatest(
            if(option_type IN ('call', 'C'),
               toFloat64(underlying_close) - toFloat64(strike_price),
               toFloat64(strike_price) - toFloat64(underlying_close)),
            0.0) AS payoff_now
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND date >= '2026-01-02'
      AND date <  '2026-07-01'
      AND volume > 0
      AND iv_converged = 1
      AND days_to_expiry BETWEEN 0 AND 30
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.02
)
GROUP BY days_to_expiry
ORDER BY days_to_expiry