STRASMORE/EXPLORE 2,170 QUERIES

One AAPL contract, re-solved every session into its July 17, 2026 expiry

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-25, from How Implied Volatility Is Calculated.

as of series 29×3read in context →
One AAPL contract, re-solved every session into its July 17, 2026 expiry — 29 rows by 3 columns, computed from US exchange, SIP and OPRA data.
dateimplied_vol_pctdays_to_expiry
2026-06-0125.146
2026-06-0224.945
2026-06-0315.544
2026-06-0426.143
2026-06-0525.742
2026-06-0825.639
2026-06-0923.438
2026-06-1025.937
2026-06-1122.536
2026-06-1221.535
2026-06-1522.132
2026-06-1621.931
2026-06-1720.930
2026-06-182329
2026-06-2225.125
2026-06-2322.824
2026-06-2426.623
2026-06-2526.322
2026-06-2625.321
2026-06-2925.818
2026-06-3024.817
2026-07-0124.616
2026-07-022415
2026-07-0628.211
2026-07-0723.710
2026-07-0832.49
2026-07-0937.18
2026-07-1029.17
2026-07-1326.64
Rows × columns
29 × 3
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 One AAPL contract, re-solved every session into its July 17, 2026 expiry, derived from the stored result.
ColumnTypeRangeNotes
date date 2026-06-01 to 2026-07-13
implied_vol_pct number 15.5 to 37.1 percent
days_to_expiry number 4 to 46

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
WITH (
         SELECT ticker
         FROM global_markets.options_greeks
         WHERE underlying_symbol = 'AAPL'
           AND date = toDate('2026-06-30')
           AND expiration_date = toDate('2026-07-17')
           AND iv_converged = 1
           AND volume > 0
         ORDER BY volume DESC
         LIMIT 1
     ) AS pinned_contract
SELECT date,
       round(100 * avg(toFloat64(implied_volatility)), 1) AS implied_vol_pct,
       round(avg(days_to_expiry)) AS days_to_expiry
FROM global_markets.options_greeks
WHERE ticker = pinned_contract
  AND date BETWEEN toDate('2026-06-01') AND toDate('2026-07-17')
  AND iv_converged = 1
  AND volume > 0
GROUP BY date
ORDER BY date

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 analysisHow Implied Volatility Is Calculated
At the money implied volatility and solver convergence, eight names, June 30, 2026 ranking 8×4 Where the Newton step misbehaves: AAPL vega by strike zone, June 30, 2026 ranking 6×3 One solve per contract: AAPL implied volatility by strike zone, June 30, 2026 ranking 6×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 AMZN at-the-money implied volatility by session: trailing 90 days series 62×2 See all 2,170 queries →