SPY vs the call, both indexed to 100 on May 1

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-07-16, from Buying and Selling Call Options.

Rows × columns

31 × 3

Period covered

2026-05-01 to 2026-06-15

Computed

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

SELECT date,
       round(spy / first_value(spy) OVER w * 100, 1) AS spy_index,
       round(opt / first_value(opt) OVER w * 100, 1) AS call_index
FROM (
  SELECT date, avg(underlying_close) AS spy, avg(option_close) AS opt
  FROM global_markets.options_greeks
  WHERE ticker = 'O:SPY260618C00740000' AND date BETWEEN '2026-05-01' AND '2026-06-15' AND implied_volatility > 0.02
  GROUP BY date
)
WINDOW w AS (ORDER BY date)
ORDER BY date