Maximum drawdown: deepest peak-to-trough drop over the last year

SELECT ticker,
       round(abs(min(c / peak - 1)) * 100, 1) AS max_drawdown_pct
FROM (
    SELECT ticker, dt, c,
           max(c) OVER (PARTITION BY ticker ORDER BY dt
                        ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS peak
    FROM (
        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', 'NVDA', 'TSLA', 'PLTR')
          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
    )
    WHERE dt >= today() - 370
)
GROUP BY ticker
ORDER BY max_drawdown_pct