2,170 answered market questions

WITH mny AS
(
    SELECT
        floor((toFloat64(strike_price) / toFloat64(underlying_close) - 1) * 50) / 50 AS strike_offset,
        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 20 AND 45
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) <= 0.12
    GROUP BY strike_offset
    HAVING count() >= 30
)
SELECT
    concat(toString(toInt32(round(strike_offset * 100))), '% from spot') AS strike_vs_spot,
    round(iv_avg * 100, 1)                                              AS avg_iv_pct,
    round(vega_avg / max(vega_avg) OVER (), 2)                          AS vega_vs_peak,
    toUInt32(contract_days)                                             AS contract_day_count
FROM mny
ORDER BY strike_offset