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

Buying and Selling Put Options
One SPY $740 put's price over its life (expired Jun 18 2026)series · 2026-07-16 · 31×3Preview: a 16-point series, ending lower. SPY's closing price over the same windowseries · 2026-07-16 · 31×3Preview: a 16-point series, ending higher.
One SPY $740 put's price over its life (expired Jun 18 2026)

One SPY $740 put's price over its life (expired Jun 18 2026)

most recentas of series 31×3read in context →
One SPY $740 put's price over its life (expired Jun 18 2026) — 31 rows by 3 columns, computed from US exchange, SIP and OPRA data.
datelabelput_price
2026-05-01May 123.05
2026-05-04May 426.59
2026-05-05May 521.89
2026-05-06May 616.52
2026-05-07May 717.22
2026-05-08May 814.77
2026-05-11May 1114.43
2026-05-12May 1214.68
2026-05-13May 1312.38
2026-05-14May 149.99
2026-05-15May 1514.32
2026-05-18May 1813.2
2026-05-19May 1915.45
2026-05-20May 2011.69
2026-05-21May 219.98
2026-05-22May 228.79
2026-05-26May 266.82
2026-05-27May 275.95
2026-05-28May 284.3
2026-05-29May 293.9
2026-06-01Jun 13.34
2026-06-02Jun 22.79
2026-06-03Jun 33.79
2026-06-04Jun 42.75
2026-06-05Jun 512.79
2026-06-08Jun 88.93
2026-06-09Jun 910.83
2026-06-10Jun 1018.7
2026-06-11Jun 118.91
2026-06-12Jun 125.44
2026-06-15Jun 151.16
the exact SQL behind every number
SELECT date,
       formatDateTime(date, '%b %e') AS label,
       round(avg(option_close), 2) AS put_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
$