Where SPY option volume sits, by strike distance from spot (June 2026)

WITH
    chain AS
    (
        SELECT
            multiIf(
                toFloat64(strike_price) / toFloat64(underlying_close) < 0.85, 1,
                toFloat64(strike_price) / toFloat64(underlying_close) < 0.95, 2,
                toFloat64(strike_price) / toFloat64(underlying_close) < 1.05, 3,
                toFloat64(strike_price) / toFloat64(underlying_close) < 1.15, 4,
                5)                          AS bucket_key,
            multiIf(
                bucket_key = 1, 'more than 15% below spot',
                bucket_key = 2, '5% to 15% below spot',
                bucket_key = 3, 'within 5% of spot',
                bucket_key = 4, '5% to 15% above spot',
                'more than 15% above spot') AS moneyness_bucket,
            volume
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'SPY'
          AND date >= '2026-06-01'
          AND date <  '2026-07-01'
          AND iv_converged = 1
          AND volume > 0
          AND days_to_expiry BETWEEN 30 AND 400
    ),
    totals AS
    (
        SELECT
            sum(volume) AS all_volume,
            count()     AS all_rows
        FROM chain
    )
SELECT
    moneyness_bucket,
    round(100 * count() / any(all_rows), 2)       AS contracts_pct,
    round(100 * sum(volume) / any(all_volume), 2) AS turnover_pct
FROM chain
CROSS JOIN totals
GROUP BY bucket_key, moneyness_bucket
ORDER BY bucket_key