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

2,170 answered market questions

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

What Are Put Options?
One SPY $740 put vs the stock's distance from the strike (expired Jun 18 2026)series · 2026-08-13 · 31×3Preview: a 16-point series, ending lower. The same put at SPY's June peak vs its June troughseries · 2026-08-13 · 2×6Preview: a 2-point series, ending lower. The SPY put's delta stayed negative through its whole lifeseries · 2026-08-13 · 31×2Preview: a 16-point series, ending higher.
One SPY $740 put vs the stock's distance from the strike (expired Jun 18 2026)

One SPY $740 put vs the stock's distance from the strike (expired Jun 18 2026)

most recentas of series 31×3read in context →
One SPY $740 put vs the stock's distance from the strike (expired Jun 18 2026) — 31 rows by 3 columns, computed from US exchange, SIP and OPRA data.
datespy_vs_strike_pctput_price
2026-05-01-2.723.05
2026-05-04-3.0126.59
2026-05-05-1.8321.89
2026-05-06-0.9516.52
2026-05-07-1.1617.22
2026-05-08-0.2914.77
2026-05-11-0.114.43
2026-05-12-0.4514.68
2026-05-130.4812.38
2026-05-141.039.99
2026-05-15-0.3614.32
2026-05-18-0.1513.2
2026-05-19-0.7815.45
2026-05-20-0.2311.69
2026-05-210.569.98
2026-05-220.58.79
2026-05-261.476.82
2026-05-271.365.95
2026-05-282.044.3
2026-05-292.113.9
2026-06-012.243.34
2026-06-022.652.79
2026-06-031.433.79
2026-06-041.972.75
2026-06-05-0.6312.79
2026-06-08-0.178.93
2026-06-09-0.5810.83
2026-06-10-2.3118.7
2026-06-11-0.078.91
2026-06-120.335.44
2026-06-151.881.16
the exact SQL behind every number
SELECT date,
       round(avg((underlying_close - 740) / 740 * 100), 2) AS spy_vs_strike_pct,
       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
$