How far AAPL moves inside a single minute, by New York hour

SELECT
    et_hour,
    round(quantileDeterministic(0.5)(move_bps, obs_id), 1) AS median_move_bps,
    round(quantileDeterministic(0.9)(move_bps, obs_id), 1) AS p90_move_bps,
    count()                                                AS minute_bars
FROM
(
    SELECT
        formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:00') AS et_hour,
        cityHash64(ticker, window_start)                                      AS obs_id,
        10000 * abs(toFloat64(close) / toFloat64(open) - 1)                   AS move_bps
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= '2026-04-06 04:00:00'
      AND window_start <  '2026-05-16 04:00:00'
      AND open > 0
      AND volume > 0
)
GROUP BY et_hour
HAVING count() >= 1200
ORDER BY et_hour ASC