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

Protective Puts: Portfolio Insurance
The SPY $740 put's value over its final weeks (expired Jun 18 2026)series · 2026-07-16 · 11×2Preview: a 11-point series, roughly flat. 100 SPY shares alone vs. the same shares with one $740 put held against themseries · 2026-07-16 · 11×3Preview: a 11-point series, ending lower. The SPY $760 call you could sell to finance the put (early June 2026)series · 2026-07-16 · 5×2Preview: a 5-point series, ending lower.
The SPY $740 put's value over its final weeks (expired Jun 18 2026)

The SPY $740 put's value over its final weeks (expired Jun 18 2026)

most recentas of series 11×2read in context →
The SPY $740 put's value over its final weeks (expired Jun 18 2026) — 11 rows by 2 columns, computed from US exchange, SIP and OPRA data.
dateput_price
2026-06-013.34
2026-06-022.79
2026-06-033.79
2026-06-042.75
2026-06-0512.79
2026-06-088.93
2026-06-0910.83
2026-06-1018.7
2026-06-118.91
2026-06-125.44
2026-06-151.16
the exact SQL behind every number 
SELECT date,
       round(avg(option_close), 2) AS put_price
FROM global_markets.options_greeks
WHERE ticker = 'O:SPY260618P00740000' AND date BETWEEN '2026-06-01' AND '2026-06-15' AND implied_volatility > 0.02
GROUP BY date ORDER BY date
More from this analysisProtective Puts: Portfolio Insurance
100 SPY shares alone vs. the same shares with one $740 put held against them series 11×3 → The SPY $760 call you could sell to finance the put (early June 2026) series 5×2 → One SPY $740 put vs the stock's distance from the strike (expired Jun 18 2026) series 31×3 → The SPY put's delta stayed negative through its whole life series 31×2 → See all 2,173 queries →
$