SPY on a calm day vs. a fast day: session range, per-minute movement, and quoted spread

WITH quotes AS (
    SELECT toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS d,
           round(quantileDeterministicIf(0.5)(toFloat64(ask_price - bid_price) * 100, cityHash64(ticker, sip_timestamp), bid_price > 0 AND ask_price > bid_price), 1) AS median_spread_cents
    FROM global_markets.cache_stocks_quotes
    WHERE ticker = 'SPY'
      AND ((sip_timestamp >= '2026-07-08 04:00:00' AND sip_timestamp < '2026-07-09 04:00:00')
        OR (sip_timestamp >= '2025-04-09 04:00:00' AND sip_timestamp < '2025-04-10 04:00:00'))
      AND (toHour(toTimeZone(sip_timestamp, 'America/New_York')) * 60 + toMinute(toTimeZone(sip_timestamp, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY d
    HAVING countIf(bid_price > 0 AND ask_price > bid_price) > 0
),
bars AS (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d,
           round(avg(toFloat64(high - low) * 100), 1) AS avg_minute_range_cents,
           round(max(toFloat64(high - low) * 100), 0) AS worst_minute_range_cents,
           round((max(high) - min(low)) / argMin(toFloat64(open), window_start) * 100, 1) AS session_range_pct
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND ((window_start >= '2026-07-08 04:00:00' AND window_start < '2026-07-09 04:00:00')
        OR (window_start >= '2025-04-09 04:00:00' AND window_start < '2025-04-10 04:00:00'))
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY d
)
SELECT formatDateTime(quotes.d, '%Y-%m-%d') AS session,
       bars.session_range_pct,
       bars.avg_minute_range_cents,
       bars.worst_minute_range_cents,
       quotes.median_spread_cents
FROM quotes INNER JOIN bars ON quotes.d = bars.d
ORDER BY quotes.d DESC