SPY option volume by days to expiry, trailing six weeks

SELECT
    bucket                                              AS days_to_expiry_bucket,
    round(contracts / 1e6, 2)                           AS contracts_traded_millions,
    round(100 * contracts / sum(contracts) OVER (), 1)  AS share_of_volume_pct
FROM
(
    SELECT
        multiIf(days_to_expiry <= 1,  '0 to 1 days',
                days_to_expiry <= 7,  '2 to 7 days',
                days_to_expiry <= 30, '8 to 30 days',
                days_to_expiry <= 90, '31 to 90 days',
                                      'over 90 days')  AS bucket,
        min(days_to_expiry)                            AS bucket_floor,
        sum(volume)                                    AS contracts
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND date >= today() - 45
      AND volume > 0
    GROUP BY bucket
)
ORDER BY bucket_floor