Shares a 1% move forces per 100 at-the-money SPY contracts, by time left (June 2026)

SELECT
    multiIf(bucket = 1, '0-2 days',
            bucket = 2, '3-7 days',
            bucket = 3, '8-21 days',
            bucket = 4, '22-45 days',
                        '46-90 days')            AS expiry_window,
    toUInt32(round(avg(shares_per_contract) * 100)) AS hedge_shares
FROM
(
    SELECT
        multiIf(days_to_expiry <= 2,  1,
                days_to_expiry <= 7,  2,
                days_to_expiry <= 21, 3,
                days_to_expiry <= 45, 4,
                                      5) AS bucket,
        toFloat64(gamma) * toFloat64(underlying_close) AS shares_per_contract
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND iv_converged = 1
      AND volume > 0
      AND underlying_close > 0
      AND days_to_expiry BETWEEN 0 AND 90
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) <= 0.01
      AND date >= '2026-06-01'
      AND date <  '2026-07-01'
)
GROUP BY bucket
ORDER BY bucket