STRASMORE/EXPLORE 3,293 QUERIES

SPY implied volatility by strike, June 20, 2025 expiry, as of May 15, 2025

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-18, from Where to Find Options Trade Data (OPRA Prints).

as of table 29×4read in context →
SPY implied volatility by strike, June 20, 2025 expiry, as of May 15, 2025 — 29 rows by 4 columns, computed from US exchange, SIP and OPRA data.
strikeput_iv_pctcall_iv_pctcontracts_volume
5731815.6430
57418.214.9487
57517.71717465
57617.615.6940
57717.215.8378
57817.316.8868
57917.215.61696
58016.916.16640
58117.115.2574
58216.614.7450
58316.815.2909
58416.515.1475
58516.315.47892
58616.214.52163
5871614.42827
58815.8152069
58915.814.81670
59015.714.67707
59115.614.71059
59216.214.42371
59315.414.2480
59415.813.62473
59515.3142645
59616.114616
59716.213.9325
59815.513.8539
59915.713.3244
60015.113.610169
60515.513.28151
Rows × columns
29 × 4
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 implied volatility by strike, June 20, 2025 expiry, as of May 15, 2025, derived from the stored result.
ColumnTypeRangeNotes
strike text 29 distinct values (573, 574, 575…)
put_iv_pct number 15.1 to 18.2 percent
call_iv_pct number 13.2 to 17 percent
contracts_volume number 244 to 17,465 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.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    toString(toFloat64(strike_price))                                                    AS strike,
    round(maxIf(implied_volatility, lower(toString(option_type)) LIKE 'p%') * 100, 1)   AS put_iv_pct,
    round(maxIf(implied_volatility, lower(toString(option_type)) LIKE 'c%') * 100, 1)   AS call_iv_pct,
    sum(volume)                                                                          AS contracts_volume
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND date = '2025-05-15'
  AND expiration_date = '2025-06-20'
  AND iv_converged = 1
  AND volume > 0
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.03
GROUP BY strike_price
HAVING countIf(lower(toString(option_type)) LIKE 'p%') > 0
   AND countIf(lower(toString(option_type)) LIKE 'c%') > 0
ORDER BY strike_price
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysisWhere to Find Options Trade Data (OPRA Prints)
SPY option prints by exchange, May 15, 2025 table 18×5 → The ten largest single SPY option prints of May 15, 2025, one per contract table 10×7 → SPY option prints per half hour, May 15, 2025 (ET) series 14×5 → Traded volume across strikes, one AAPL expiry (Sep 16, 2026) table 55×3 → US options exchanges on the official participant list table 20×4 → Where AAPL option volume printed across venues, September 15, 2026 ranking 18×3 → See all 3,293 queries →