STRASMORE/EXPLORE 2,170 QUERIES

AMZN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022

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-08-24, from AMZN Implied Volatility: IV Now & Its History.

as of series 50×4read in context →
AMZN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022 — 50 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthamzn_iv_pctspy_iv_pctqqq_iv_pct
2022-07-0147.822.929.8
2022-08-0135.619.725.8
2022-09-014425.932.5
2022-10-0151.628.234.8
2022-11-0143.722.328.3
2022-12-0142.120.926.6
2023-01-0149.119.425.6
2023-02-0139.318.625.4
2023-03-0138.920.225.2
2023-04-014315.921.1
2023-05-0130.515.218.9
2023-06-0129.812.318.5
2023-07-0139.512.218.6
2023-08-0129.714.119.5
2023-09-0128.413.918.5
2023-10-0139.816.921.6
2023-11-0125.412.716.6
2023-12-0124.811.915.5
2024-01-0133.81216.4
2024-02-01251216.6
2024-03-0125.212.417.1
2024-04-0137.814.719.1
2024-05-0123.611.915.9
2024-06-0124.811.815.6
2024-07-0138.212.918
2024-08-0127.515.721.8
2024-09-0128.115.120.4
2024-10-0137.515.920.7
2024-11-0126.513.317.7
2024-12-0125.912.216.1
2025-01-0135.214.119.1
2025-02-0128.113.818.7
2025-03-0134.619.425
2025-04-0148.827.232.1
2025-05-0130.718.122
2025-06-012815.518.8
2025-07-0133.914.117
2025-08-0124.913.216.8
2025-09-0127.61317
2025-10-0140.514.919.7
2025-11-0131.416.121.6
2025-12-0127.213.217.6
2026-01-0137.713.418.2
2026-02-0133.616.221.6
2026-03-0135.321.524.8
2026-04-0139.616.621.3
2026-05-0129.214.821.4
2026-06-0133.215.324.8
2026-07-0141.414.224.6
2026-08-0129.412.719.9
Rows × columns
50 × 4
Period covered
to
Computed
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

Column definitions for AMZN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022, derived from the stored result.
ColumnTypeRangeNotes
month date 2022-07-01 to 2026-08-01
amzn_iv_pct number 23.6 to 51.6 percent
spy_iv_pct number 11.8 to 28.2 percent
qqq_iv_pct number 15.5 to 34.8 percent

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 , and the query below is what returned them.

the exact SQL behind every number
SELECT toString(toStartOfMonth(date)) AS month,
       round(100 * quantileExactIf(0.5)(implied_volatility, underlying_symbol = 'AMZN'), 1) AS amzn_iv_pct,
       round(100 * quantileExactIf(0.5)(implied_volatility, underlying_symbol = 'SPY'), 1) AS spy_iv_pct,
       round(100 * quantileExactIf(0.5)(implied_volatility, underlying_symbol = 'QQQ'), 1) AS qqq_iv_pct
FROM global_markets.options_greeks
WHERE underlying_symbol IN ('AMZN', 'SPY', 'QQQ')
  AND date >= toDate('2022-07-01')
  AND iv_converged AND implied_volatility BETWEEN 0.02 AND 5
  AND abs(strike_price / underlying_close - 1) <= 0.05
  AND expiration_date BETWEEN date + 7 AND date + 60
GROUP BY month
HAVING countIf(underlying_symbol = 'AMZN') >= 50
ORDER BY month

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisAMZN Implied Volatility: IV Now & Its History
AMZN at-the-money implied volatility by session: trailing 90 days series 62×2 AMZN ATM implied volatility by time to expiration: latest session ranking 4×3 AAPL realized volatility: 20-session against 60-session lookback series 72×3 META at-the-money implied volatility by session: trailing 90 days series 62×2 TSLA at-the-money implied volatility by session: trailing 90 days series 62×2 SPY at-the-money implied volatility by session: trailing 90 days series 62×2 See all 2,170 queries →