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

Why Some Options Cost So Much More
One near-money call each, premium as a share of the stock (Jul 6 2026)ranking · 2026-08-14 · 2×4Preview: 2 ranked values, largest first. At-the-money implied volatility across six names (Jul 6 2026, Jul-17 expiry)ranking · 2026-08-14 · 6×3Preview: 6 ranked values, smallest first.
What Are Call Options?
One SPY $740 call vs SPY, indexed to 100 on May 1 (expired Jun 18 2026)series · 2026-07-16 · 31×3Preview: a 16-point series, ending higher. The $740 call split into intrinsic and time value, five key sessionsseries · 2026-07-16 · 5×4Preview: a 5-point series, ending lower. SPY vs its $740 call, May 1 to June 2 (the SPY peak)ranking · 2026-07-16 · 2×4Preview: 2 ranked values, largest first.
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.
One near-money call each, premium as a share of the stock (Jul 6 2026)

One near-money call each, premium as a share of the stock (Jul 6 2026)

most recentas of ranking 2×4read in context →
One near-money call each, premium as a share of the stock (Jul 6 2026) — 2 rows by 4 columns, computed from US exchange, SIP and OPRA data.
instrumentspotcall_premiumpremium_pct_of_spot
SPY7517.350.98
TSLA417163.84
the exact SQL behind every number
SELECT underlying_symbol AS instrument,
       round(avg(underlying_close), 0) AS spot,
       round(avg(option_close), 2) AS call_premium,
       round(avg(option_close) / avg(underlying_close) * 100, 2) AS premium_pct_of_spot
FROM global_markets.options_greeks
WHERE date = '2026-07-06'
  AND implied_volatility > 0.02
  AND ticker IN ('O:SPY260717C00750000', 'O:TSLA260717C00415000')
GROUP BY instrument
ORDER BY premium_pct_of_spot
$