Share of contract volume by days to expiry, SPX and SPY

WITH flow AS
(
    SELECT
        replaceOne(underlying_symbol, 'I:', '') AS sym,
        days_to_expiry                          AS dte,
        volume                                  AS vol
    FROM global_markets.options_greeks
    WHERE date >= today() - 90
      AND sym IN ('SPX', 'SPY')
      AND volume > 0
      AND days_to_expiry >= 0
),
totals AS
(
    SELECT
        sumIf(vol, sym = 'SPX') AS spx_all,
        sumIf(vol, sym = 'SPY') AS spy_all
    FROM flow
)
SELECT
    multiIf(dte = 0,    '0 (same session)',
            dte <= 7,   '1 to 7 days',
            dte <= 30,  '8 to 30 days',
            dte <= 90,  '31 to 90 days',
            dte <= 365, '91 to 365 days',
                        'over 1 year')                     AS dte_bucket,
    round(100 * sumIf(vol, sym = 'SPX') / any(spx_all), 1)  AS spx_share_pct,
    round(100 * sumIf(vol, sym = 'SPY') / any(spy_all), 1)  AS spy_share_pct
FROM flow
CROSS JOIN totals
GROUP BY dte_bucket
ORDER BY min(dte)