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

How Earnings Move Option Greeks
The Tesla $400 May call through its Q1 earnings (Apr 8 - May 6 2026)series · 2026-08-24 · 21×5Preview: a 16-point series, roughly flat. Tesla's 8-K filings across Q1 2026 (EDGAR index)table · 2026-08-24 · 4×3 Near-the-money Tesla May-expiry implied volatility around the printseries · 2026-08-24 · 21×3Preview: a 16-point series, ending higher.
What Is IV Crush? Measured on Real Earnings
The biggest one-day ATM implied volatility collapses, June 1 - July 15, 2026series · 2026-08-18 · 12×6Preview: a 12-point series, ending lower. AVGO at-the-money implied volatility, daily, around the June 2026 reportseries · 2026-08-18 · 15×3Preview: a 15-point series, ending lower. The filing receipt: Broadcom's 8-K, first week of June 2026scalar · 2026-08-18 · 1×21
Where to Get Historical Implied Volatility Data
Three ways to build a 30-day IV for SPY, from one set of rowsseries · 2026-08-15 · 53×6Preview: a 16-point series, ending higher. One name, one month: implied volatility by time to expiry (AAPL, June 2026)table · 2026-08-15 · 6×5 Median near-the-money IV, 20 to 45 days to expiry (June 2026)ranking · 2026-08-15 · 8×3Preview: 8 ranked values, largest first. Underlying names with converged daily IV, by quartertable · 2026-08-15 · 49×2
The Option Greeks Explained: Delta to Rho
One SPY $740 call's price over its 7-week life (expired Jun 18 2026)series · 2026-08-15 · 31×2Preview: a 16-point series, ending higher. Median greeks by time to expiration: every near-the-money US option, July 15, 2026table · 2026-08-15 · 5×6
What Is Volatility Skew? The Smile, Measured
SPY implied volatility by strike: OTM puts below spot, OTM calls above, July 15, 2026ranking · 2026-08-14 · 6×2Preview: 6 ranked values, largest first. OTM put IV vs OTM call IV across every active underlying, July 15, 2026scalar · 2026-08-14 · 1×4348 Steepest INVERTED skew: OTM calls pricier than OTM puts, July 15, 2026ranking · 2026-08-14 · 8×4Preview: 8 ranked values, largest first.
What Is Option Vega? Volatility Sensitivity
SPY call vega peaks at the money (~30 days out, 2026-07-13)ranking · 2026-08-13 · 5×2Preview: 5 ranked values, largest first. At-the-money SPY vega grows with time to expiry (2026-07-13)ranking · 2026-08-13 · 4×2Preview: 4 ranked values, smallest first. The SPY $740 call's implied volatility spiked when SPY fell, early June 2026series · 2026-08-13 · 31×2Preview: a 16-point series, ending higher.
What Is Implied Volatility? IV, Explained
ATM implied volatility across every actively traded underlying, July 15, 2026scalar · 2026-08-13 · 1×5753 SPY at-the-money IV by time to expiry: the term structure (2026-07-13)ranking · 2026-08-13 · 4×2Preview: 4 ranked values, smallest first. SPY put IV rises as strikes fall: the volatility skew (2026-07-13)ranking · 2026-08-13 · 5×2Preview: 5 ranked values, smallest first. SPY at-the-money implied volatility, month by month (Jul 2025 – Jul 2026)series · 2026-08-13 · 13×2Preview: a 13-point series, ending lower. At-the-money implied volatility by stock (2026-07-13)ranking · 2026-08-13 · 7×2Preview: 7 ranked values, largest first.
What Is Option Rho? The Interest Rate Greek
Weekly average rho: SPY January 2027 calls against a rolling front-month seriesseries · 2026-08-07 · 52×3Preview: a 16-point series, ending higher. Average SPY option rho by time to expiration, indexed to the front monthranking · 2026-08-07 · 6×4Preview: 6 ranked values, smallest first. Average rho on long-dated SPY options, by strike against the share priceranking · 2026-08-07 · 7×4Preview: 7 ranked values, largest first. Start-to-end change in Treasury yields by calendar year, in basis pointsranking · 2026-08-07 · 13×3Preview: 13 ranked values, smallest first.
How Option Greeks Change Over Time
The stock both options tracked: SPY, May 1 to Jun 15 2026series · 2026-07-16 · 31×3Preview: a 16-point series, ending higher. The $740 put's greeks, day by day (delta, gamma, theta, vega, IV%)series · 2026-07-16 · 31×7Preview: a 16-point series, ending higher. Call vs put on the same $740 strike: mirror-image pricesseries · 2026-07-16 · 31×4Preview: a 16-point series, ending lower. The $740 call's greeks, day by day (delta, gamma, theta, vega, IV%)series · 2026-07-16 · 31×7Preview: a 16-point series, ending higher.
What Is Option Theta? Time Decay Explained
The SPY $740 call's daily time decay deepens into expiry (May–Jun 2026)series · 2026-07-15 · 31×2Preview: a 16-point series, ending lower. At-the-money SPY time decay accelerates near expiry (2026-07-13)series · 2026-07-15 · 4×2Preview: a 4-point series, ending higher.
What Is Option Gamma? Delta's Accelerator
The $740 call's gamma climbs as expiry nearsseries · 2026-07-15 · 31×2Preview: a 16-point series, ending higher. SPY call gamma peaks at the money (~30 days out, 2026-07-13)ranking · 2026-07-15 · 5×2Preview: 5 ranked values, largest first. At-the-money SPY gamma by time to expiry (2026-07-13)ranking · 2026-07-15 · 4×2Preview: 4 ranked values, largest first.
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.
The Tesla $400 May call through its Q1 earnings (Apr 8 - May 6 2026)

The Tesla $400 May call through its Q1 earnings (Apr 8 - May 6 2026)

most recentas of series 21×5read in context →
The Tesla $400 May call through its Q1 earnings (Apr 8 - May 6 2026) — 21 rows by 5 columns, computed from US exchange, SIP and OPRA data.
datetslacall_priceiv_pctdelta
2026-04-08341.174.4147.50.171
2026-04-09344.944.6546.70.181
2026-04-10351.34.8143.80.194
2026-04-13353.334.844.50.197
2026-04-143667.644.60.276
2026-04-15393.5719.4548.50.49
2026-04-16388.1816.5148.40.448
2026-04-17401.0921.546.10.543
2026-04-20392.416.2546.90.47
2026-04-21388.9913.745.40.436
2026-04-22386.313.7549.60.421
2026-04-23373.186.543.10.28
2026-04-24375.266.542.20.288
2026-04-27377.876.743.70.302
2026-04-28377.885.4340.50.278
2026-04-29372.84.0841.50.227
2026-04-30381.4641.40.306
2026-05-01391.348.739.90.412
2026-05-04391.898.6440.415
2026-05-05387.266.846.10.355
2026-05-06396.8510.246.30.476
the exact SQL behind every number
SELECT date,
       round(underlying_close, 2) AS tsla,
       round(option_close, 2) AS call_price,
       round(implied_volatility * 100, 1) AS iv_pct,
       round(delta, 3) AS delta
FROM global_markets.options_greeks
WHERE ticker = 'O:TSLA260515C00400000' AND date BETWEEN '2026-04-08' AND '2026-05-06' AND implied_volatility > 0.02
ORDER BY date
$