SPY intraday travel: close, high and low against the open, June 1 to July 10, 2026

SELECT toString(session_date) AS date,
       formatDateTimeInJodaSyntax(session_date, 'MMM d') AS session_label,
       round(100 * (close_px / open_px - 1), 2) AS close_vs_open_pct,
       round(100 * (high_px / open_px - 1), 2) AS session_high_pct,
       round(100 * (low_px / open_px - 1), 2) AS session_low_pct
FROM (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
           argMin(open, window_start) AS open_px,
           argMax(close, window_start) AS close_px,
           max(high) AS high_px,
           min(low) AS low_px
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-06-01 09:30:00', 'America/New_York')
      AND window_start < toDateTime('2026-07-11 16:01:00', 'America/New_York')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY session_date
)
ORDER BY session_date