STRASMORE/EXPLORE 2,170 QUERIES

SPY at-the-money implied volatility near 30 days to expiry, monthly averages (Jul 2025 to Jul 2026)

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-14, from What Is the VIX? What It Really Measures.

as of series 13×6read in context →
SPY at-the-money implied volatility near 30 days to expiry, monthly averages (Jul 2025 to Jul 2026) — 13 rows by 6 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelavg_iv_pctlowest_print_pcthighest_print_pctcontracts
2025-07-01July 202513.58.717.9508
2025-08-01August 202512.58.818.2561
2025-09-01September 202512.68.818.8587
2025-10-01October 202514.711.522733
2025-11-01November 202516.411.126.7695
2025-12-01December 202512.89.919.2660
2026-01-01January 202613.310.720573
2026-02-01February 202615.812.124.9742
2026-03-01March 202621.213.633.31136
2026-04-01April 202617.38.842.2801
2026-05-01May 202614.611.820740
2026-06-01June 202615.210.528.4814
2026-07-01July 202614.210.719.9804
Rows × columns
13 × 6
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 SPY at-the-money implied volatility near 30 days to expiry, monthly averages (Jul 2025 to Jul 2026), derived from the stored result.
ColumnTypeRangeNotes
month date 2025-07-01 to 2026-07-01
month_label text 13 distinct values (April 2026, August 2025, December 2025…)
avg_iv_pct number 12.5 to 21.2 percent
lowest_print_pct number 8.7 to 13.6 percent
highest_print_pct number 17.9 to 42.2 percent
contracts number 508 to 1,136 count

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 toStartOfMonth(date) AS month,
       formatDateTimeInJodaSyntax(toStartOfMonth(date), 'MMMM yyyy') AS month_label,
       round(avg(implied_volatility) * 100, 1) AS avg_iv_pct,
       round(min(implied_volatility) * 100, 1) AS lowest_print_pct,
       round(max(implied_volatility) * 100, 1) AS highest_print_pct,
       count() AS contracts
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND date >= toDate('2025-07-01')
  AND date < toDate('2026-08-01')
  AND abs(delta) BETWEEN 0.45 AND 0.55
  AND days_to_expiry BETWEEN 23 AND 37
  AND iv_converged
  AND implied_volatility BETWEEN 0.02 AND 3
GROUP BY month
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 analysisWhat Is the VIX? What It Really Measures
Implied daily move against the realized daily move: SPY, month by month series 13×6 Median daily percent change: VXX against SPY, by calendar year ranking 7×4 SPY at-the-money implied volatility by time to expiry, July 15, 2026 ranking 6×3 Near-dated versus long-dated SPY implied volatility, session by session series 81×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 See all 2,170 queries →