2,170 answered market questions

SELECT
    toYear(session_date)                       AS year,
    round(stddevPop(daily_pct) * sqrt(252), 1) AS realized_vol_pct,
    round(min(daily_pct), 1)                   AS worst_day_pct,
    countIf(abs(daily_pct) >= 2)               AS days_over_2pct_count
FROM
(
    SELECT
        date AS session_date,
        (toFloat64(close) / lagInFrame(toFloat64(close), 1) OVER (ORDER BY date ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) - 1) * 100 AS daily_pct
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= '2007-01-01'
      AND date <  '2026-07-01'
)
WHERE isFinite(daily_pct)
GROUP BY year
ORDER BY year