SPY's expiring June 18, 2026 series: contracts traded by strike, and each strike's distance from the closing price

WITH spy_close AS (
    SELECT toFloat64(argMax(close, window_start)) AS px
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-06-18 09:30:00', 'America/New_York')
      AND window_start < toDateTime('2026-06-18 16:00:00', 'America/New_York')
),
strikes AS (
    SELECT toFloat64(substring(ticker, length(ticker) - 7, 8)) / 1000 AS strike,
           sum(toFloat64(size)) AS contracts
    FROM global_markets.options_trades
    WHERE ticker LIKE 'O:SPY260618%'
      AND sip_timestamp >= '2026-06-18 08:00:00'
      AND sip_timestamp < '2026-06-19 01:00:00'
    GROUP BY strike
)
SELECT concat('$', toString(toInt32(s.strike))) AS strike,
       round(s.contracts / 1000, 1) AS contracts_k,
       round(s.strike - c.px, 2) AS strike_minus_close,
       round(abs(s.strike - c.px) / c.px * 100, 2) AS pct_from_close
FROM strikes AS s
CROSS JOIN spy_close AS c
ORDER BY s.contracts DESC, s.strike ASC
LIMIT 12