How July 10's same-day SPY contracts finished: expired at zero vs. settled with value

WITH (
    SELECT round(argMax(close, window_start), 2)
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-07-10 09:30:00', 'America/New_York')
      AND window_start < toDateTime('2026-07-10 16:01:00', 'America/New_York')
) AS spy_close
SELECT if(expired_at_zero, 'Expired at zero (out of the money)',
                           'Settled with value (in the money)') AS at_the_bell,
       count() AS strikes,
       round(sum(vol) / 1e6, 2) AS contracts_m,
       round(100.0 * sum(vol) / sum(sum(vol)) OVER (), 1) AS pct_of_spy_same_day_volume
FROM (
    SELECT substring(ticker, length(ticker) - 8, 1) AS opt_type,
           toFloat64(substring(ticker, length(ticker) - 7, 8)) / 1000 AS strike,
           (opt_type = 'C' AND strike > spy_close) OR (opt_type = 'P' AND strike < spy_close) AS expired_at_zero,
           sum(toFloat64(volume)) AS vol
    FROM global_markets.options_minute_aggs
    WHERE window_start >= toDateTime('2026-07-10 08:00:00')
      AND window_start < toDateTime('2026-07-11 04:00:00')
      AND startsWith(ticker, 'O:SPY260710')
    GROUP BY ticker, opt_type, strike, expired_at_zero
)
GROUP BY expired_at_zero
ORDER BY expired_at_zero DESC