Quoted volatility and delta across strikes, AAPL calls with 20 to 45 days left

SELECT
    strike_vs_spot,
    round(100 * quantileDeterministic(0.5)(iv, obs_id), 2)       AS quoted_vol_pct,
    round(quantileDeterministic(0.5)(contract_delta, obs_id), 2) AS typical_delta
FROM
(
    SELECT
        cityHash64(ticker, date)      AS obs_id,
        toFloat64(implied_volatility) AS iv,
        toFloat64(delta)              AS contract_delta,
        toInt32(round(100 * (toFloat64(strike_price) / toFloat64(underlying_close) - 1) / 2) * 2) AS moneyness_step,
        concat(if(moneyness_step > 0, '+', ''), toString(moneyness_step), '%')                    AS strike_vs_spot
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND toFloat64(delta) > 0
      AND date BETWEEN '2026-04-06' AND '2026-05-15'
      AND iv_converged = 1
      AND volume > 0
      AND days_to_expiry BETWEEN 20 AND 45
      AND implied_volatility > 0
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) <= 0.10
)
GROUP BY strike_vs_spot, moneyness_step
HAVING count() >= 20
ORDER BY moneyness_step ASC