Maximum drawdown of the calmest names: the worst peak-to-trough fall over the past year

WITH d AS (
    SELECT ticker,
           toDate(toTimeZone(window_start, 'America/New_York')) AS dt,
           argMax(toFloat64(close), toTimeZone(window_start, 'America/New_York')) AS c
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY','KO','JNJ','PG','MCD','COST','SO','DUK')
      AND window_start >= now() - INTERVAL 400 DAY
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY ticker, dt
),
m AS (
    SELECT ticker, dt, c,
           max(c) OVER (PARTITION BY ticker ORDER BY dt ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS peak
    FROM d
    WHERE dt >= today() - 370
)
SELECT ticker,
       round(min(c / peak - 1) * 100, 1) AS max_drawdown_pct
FROM m
GROUP BY ticker
ORDER BY max_drawdown_pct DESC
LIMIT 15