Where near-the-money implied volatility sat across the traded options market (July 28, 2026)

WITH per_name AS (
    SELECT underlying_symbol AS u,
           100 * quantileExact(0.5)(implied_volatility) AS iv_pct
    FROM global_markets.options_greeks
    WHERE date = '2026-07-28'
      AND iv_converged AND implied_volatility BETWEEN 0.02 AND 5
      AND abs(strike_price / underlying_close - 1) <= 0.05
      AND expiration_date BETWEEN date + 20 AND date + 60
      AND underlying_symbol != 'SPCX'
    GROUP BY u
    HAVING sum(volume) >= 500 AND count() >= 10
),
banded AS (
    SELECT multiIf(iv_pct < 20, 'under 20%', iv_pct < 30, '20 to 30%', iv_pct < 40, '30 to 40%',
                   iv_pct < 60, '40 to 60%', iv_pct < 80, '60 to 80%', '80% and up') AS iv_band,
           min(iv_pct) AS lo,
           count() AS underlyings
    FROM per_name
    GROUP BY iv_band
)
SELECT iv_band,
       underlyings,
       round(100 * underlyings / (SELECT count() FROM per_name), 1) AS share_pct,
       round(100 * sum(underlyings) OVER (ORDER BY lo DESC) / (SELECT count() FROM per_name), 1) AS share_at_or_above_pct
FROM banded
ORDER BY lo