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

Buying and Selling Call Options
One SPY $740 call, daily close over its 7-week lifeseries · 2026-07-16 · 31×2Preview: a 16-point series, ending higher. The same call at four exits: price, multiple of premium, and P&L per contracttable · 2026-07-16 · 4×5 SPY vs the call, both indexed to 100 on May 1series · 2026-07-16 · 31×3Preview: a 16-point series, ending higher.
What Is Option Delta? A Plain-English Guide
The $740 call's delta follows SPY across the strikeseries · 2026-07-15 · 31×3Preview: a 16-point series, ending higher. Call delta by moneyness: the S-curve (SPY, ~30 days out, 2026-07-13)ranking · 2026-07-15 · 5×2Preview: 5 ranked values, largest first.
One SPY $740 call, daily close over its 7-week life

One SPY $740 call, daily close over its 7-week life

most recentas of series 31×2read in context →
One SPY $740 call, daily close over its 7-week life — 31 rows by 2 columns, computed from US exchange, SIP and OPRA data.
datecall_price
2026-05-017.22
2026-05-045.99
2026-05-058.13
2026-05-0613.28
2026-05-0711.8
2026-05-0814.5
2026-05-1115.61
2026-05-1214.1
2026-05-1317.27
2026-05-1420.48
2026-05-1513.72
2026-05-1813.02
2026-05-1910.3
2026-05-2013.98
2026-05-2114.48
2026-05-2215.62
2026-05-2618.4
2026-05-2717.82
2026-05-2820.7
2026-05-2921.31
2026-06-0122.5
2026-06-0223.5
2026-06-0318.4
2026-06-0420
2026-06-057.27
2026-06-087.85
2026-06-096.73
2026-06-103.17
2026-06-117.02
2026-06-127.09
2026-06-1515.41
the exact SQL behind every number
SELECT date,
       round(avg(option_close), 2) AS call_price
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 ORDER BY date
$