SPY realized volatility by calendar year, with the biggest day and the count of 2%+ sessions

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-16, from What Is a High VIX? Levels and Extremes.

Rows × columns

23 × 4

Computed

2026-09-16

Completeness

No missing values

Source

US exchange, SIP and OPRA market data

Licence

Strasmore terms · free, no signup

Formats

JSON · CSV · the SQL below

What each column holds

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-09-16, and the query below is what returned them.

SELECT
    toYear(d)                                                AS year,
    round(stddevSamp(log(c / prev_c)) * sqrt(252) * 100, 1)  AS realized_vol_pct,
    round(max(abs(c / prev_c - 1)) * 100, 1)                 AS largest_move_pct,
    countIf(abs(c / prev_c - 1) >= 0.02)                     AS moves_over_2pct
FROM
(
    SELECT
        d,
        c,
        lagInFrame(c, 1) OVER (ORDER BY d ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_c
    FROM
    (
        SELECT
            date                    AS d,
            toFloat64(any(close))   AS c
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SPY'
          AND date >= '2003-12-01'
        GROUP BY d
    )
)
WHERE d >= '2004-01-01'
  AND prev_c > 0
GROUP BY year
ORDER BY year