How July 6's same-day SPY contracts finished: out of the money vs. in the money

WITH (
    SELECT round(argMax(close, window_start), 2)
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-07-06 09:30:00', 'America/New_York')
      AND window_start < toDateTime('2026-07-06 16:01:00', 'America/New_York')
) AS spy_close
SELECT if(expired_at_zero, 'Out of the money at the close (expired at zero)',
                           'In the money at the close (settled with value)') AS at_the_bell,
       count() AS contracts,
       round(sumIf(vol, opt_type = 'C') / 1e6, 2) AS call_contracts_mm,
       round(sumIf(vol, opt_type = 'P') / 1e6, 2) AS put_contracts_mm,
       round(100.0 * sum(vol) / sum(sum(vol)) OVER (), 1) AS pct_of_spy_zero_dte_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-06 08:00:00')
      AND window_start < toDateTime('2026-07-07 04:00:00')
      AND startsWith(ticker, 'O:SPY260706')
    GROUP BY ticker, opt_type, strike, expired_at_zero
)
GROUP BY expired_at_zero
ORDER BY expired_at_zero DESC