STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

The Wheel Strategy: How the Loop Works
SPY's closing price across the contract window, May 1 to Jun 15 2026series · 2026-07-31 · 31×2Preview: a 16-point series, ending higher. The wheel pair at entry, the SPY peak, the dip, and the final sessiontable · 2026-07-31 · 4×5 The SPY $740 put split into intrinsic and time value, daily to Jun 15 2026series · 2026-07-31 · 31×3Preview: a 16-point series, ending higher. Both legs of the wheel: SPY $740 put vs $740 call, same Jun 18 2026 expiryseries · 2026-07-31 · 31×3Preview: a 16-point series, ending higher.
SPY's closing price across the contract window, May 1 to Jun 15 2026

SPY's closing price across the contract window, May 1 to Jun 15 2026

most recentas of series 31×2read in context →
SPY's closing price across the contract window, May 1 to Jun 15 2026 — 31 rows by 2 columns, computed from US exchange, SIP and OPRA data.
datespy_price
2026-05-01720
2026-05-04717.76
2026-05-05726.46
2026-05-06733
2026-05-07731.44
2026-05-08737.82
2026-05-11739.28
2026-05-12736.67
2026-05-13743.57
2026-05-14747.65
2026-05-15737.34
2026-05-18738.89
2026-05-19734.25
2026-05-20738.3
2026-05-21744.13
2026-05-22743.73
2026-05-26750.85
2026-05-27750.05
2026-05-28755.1
2026-05-29755.64
2026-06-01756.58
2026-06-02759.63
2026-06-03750.55
2026-06-04754.56
2026-06-05735.36
2026-06-08738.72
2026-06-09735.7
2026-06-10722.88
2026-06-11739.48
2026-06-12742.45
2026-06-15753.91
the exact SQL behind every number 
SELECT date,
       round(avg(underlying_close), 2) AS spy_price
FROM global_markets.options_greeks
WHERE ticker = 'O:SPY260618P00740000'
  AND date BETWEEN '2026-05-01' AND '2026-06-15'
  AND implied_volatility > 0.02
GROUP BY date
ORDER BY date
More from this analysisThe Wheel Strategy: How the Loop Works
The SPY $740 put split into intrinsic and time value, daily to Jun 15 2026 series 31×3 → Both legs of the wheel: SPY $740 put vs $740 call, same Jun 18 2026 expiry series 31×3 → The wheel pair at entry, the SPY peak, the dip, and the final session table 4×5 → Price path indexed to 100: two index funds and their covered call counterparts, month ends series 36×5 → See all 2,173 queries →
$