AAPL calls 1 to 5 percent in the money, by days left to expiry

SELECT
    dte_bucket,
    round(avg(vega_f), 3)  AS avg_vega,
    round(avg(delta_f), 3) AS avg_delta,
    count()                AS contracts
FROM
(
    SELECT
        toFloat64(vega)  AS vega_f,
        toFloat64(delta) AS delta_f,
        days_to_expiry,
        multiIf(days_to_expiry <= 1,  'under 2 days',
                days_to_expiry <= 3,  '2 to 3 days',
                days_to_expiry <= 7,  '4 to 7 days',
                days_to_expiry <= 14, '8 to 14 days',
                days_to_expiry <= 30, '15 to 30 days',
                                      '31 to 60 days') AS dte_bucket
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date >= today() - 120
      AND iv_converged = 1
      AND volume > 0
      AND delta > 0
      AND days_to_expiry BETWEEN 0 AND 60
      AND toFloat64(underlying_close) / toFloat64(strike_price) - 1 BETWEEN 0.01 AND 0.05
)
GROUP BY dte_bucket
ORDER BY min(days_to_expiry)