SPY and SPX option volume by the minute, 15:45 to 16:25 ET

SELECT
    et_time,
    round(100 * spy_contracts / sum(spy_contracts) OVER (), 2) AS spy_pct,
    round(100 * spx_contracts / sum(spx_contracts) OVER (), 2) AS spx_pct
FROM
(
    SELECT
        concat(toString(intDiv(945 + grid.slot, 60)), ':',
               leftPad(toString(modulo(945 + grid.slot, 60)), 2, '0')) AS et_time,
        ifNull(tape.spy_contracts, 0)                                  AS spy_contracts,
        ifNull(tape.spx_contracts, 0)                                  AS spx_contracts
    FROM
    (
        SELECT arrayJoin(range(41)) AS slot
    ) AS grid
    LEFT JOIN
    (
        WITH
            extract(ticker, '^O:([A-Z]+)')                AS root,
            toTimeZone(sip_timestamp, 'America/New_York') AS et
        SELECT
            toHour(et) * 60 + toMinute(et) - 945 AS slot,
            sumIf(size, root = 'SPY')            AS spy_contracts,
            sumIf(size, root IN ('SPX', 'SPXW')) AS spx_contracts
        FROM global_markets.options_trades
        WHERE (ticker LIKE 'O:SPY%' OR ticker LIKE 'O:SPX%')
          AND root IN ('SPY', 'SPX', 'SPXW')
          AND sip_timestamp >= '2026-07-13 19:45:00'
          AND sip_timestamp <  '2026-07-17 20:30:00'
          AND (toHour(et) * 60 + toMinute(et)) BETWEEN 945 AND 985
        GROUP BY slot
    ) AS tape ON tape.slot = grid.slot
)
ORDER BY et_time