Share of late session option volume printed after 4:00 p.m. ET, July 15, 2026

SELECT
    underlying,
    round(100 * late_contracts / window_contracts, 2) AS pct_after_4pm,
    concat(toString(intDiv(last_minute, 60)), ':',
           leftPad(toString(modulo(last_minute, 60)), 2, '0')) AS last_print_et
FROM
(
    WITH
        extract(ticker, '^O:([A-Z]+)')                AS root,
        toTimeZone(sip_timestamp, 'America/New_York') AS et
    SELECT
        if(root = 'SPXW', 'SPX', root)                       AS underlying,
        sum(size)                                            AS window_contracts,
        sumIf(size, (toHour(et) * 60 + toMinute(et)) >= 960) AS late_contracts,
        max(toHour(et) * 60 + toMinute(et))                  AS last_minute
    FROM global_markets.options_trades
    WHERE (ticker LIKE 'O:AAPL%' OR ticker LIKE 'O:MSFT%' OR ticker LIKE 'O:NVDA%'
           OR ticker LIKE 'O:SPY%' OR ticker LIKE 'O:QQQ%' OR ticker LIKE 'O:IWM%'
           OR ticker LIKE 'O:SPX%')
      AND root IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'QQQ', 'IWM', 'SPX', 'SPXW')
      AND sip_timestamp >= '2026-07-15 19:45:00'
      AND sip_timestamp <  '2026-07-15 20:30:00'
      AND (toHour(et) * 60 + toMinute(et)) BETWEEN 945 AND 990
    GROUP BY underlying
)
ORDER BY pct_after_4pm DESC