Apple option activity by strike distance, 20 to 45 days to expiry, May and June 2026

SELECT
    moneyness_bucket,
    round(quantileExact(0.5)(toFloat64(volume)), 0) AS median_daily_volume,
    round(100 * countIf(volume < 10) / count(), 1)  AS share_under_10_lots_pct
FROM
(
    SELECT
        abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) AS gap,
        multiIf(gap < 0.02, '0% to 2% from spot',
                gap < 0.05, '2% to 5% from spot',
                gap < 0.10, '5% to 10% from spot',
                gap < 0.20, '10% to 20% from spot',
                            'more than 20% from spot') AS moneyness_bucket,
        multiIf(gap < 0.02, 1, gap < 0.05, 2, gap < 0.10, 3, gap < 0.20, 4, 5) AS bucket_order,
        volume
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date >= '2026-05-01'
      AND date <  '2026-07-01'
      AND days_to_expiry BETWEEN 20 AND 45
      AND underlying_close > 0
)
GROUP BY moneyness_bucket
ORDER BY min(bucket_order)