STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

Buying Puts vs Buying Calls: Why Puts Cost More
The 25-delta wing spread on SPY, month by monthseries · 2026-09-30 · 24×4Preview: a 16-point series, roughly flat. SPY implied volatility at equal distance out of the money, puts against callsranking · 2026-09-30 · 6×4Preview: 6 ranked values, smallest first. Realised volatility inside SPY months, grouped by that month's returnranking · 2026-09-30 · 4×3Preview: 4 ranked values, largest first. At-the-money put minus call at the identical strike, six large capsranking · 2026-09-30 · 6×4Preview: 6 ranked values, largest first. Break-even move required on 5% out-of-the-money SPY puts and callsranking · 2026-09-30 · 4×4Preview: 4 ranked values, smallest first.
Box Spread Options and the Implied Loan Rate
Annualised cost of a hypothetical 10 cent fill error on a ten point boxranking · 2026-08-06 · 12×2Preview: 12 ranked values, largest first. Where SPY option volume sits, by strike distance from spot (June 2026)ranking · 2026-08-06 · 5×3Preview: 5 ranked values, largest first. A ten point box valued at every level SPY closed at in June 2026table · 2026-08-06 · 8×5 Net delta of a SPY box as the upper strike widens (June 1, 2026)ranking · 2026-08-06 · 9×4Preview: 9 ranked values, smallest first.
Put-Call Parity Explained, With Real Numbers
Call and put implied volatility near the money across AAPL monthly expirations, June 16 2026series · 2026-08-05 · 7×6Preview: a 7-point series, ending lower. Call and put implied volatility at matched AAPL strikes, Sep 18 2026 expiryranking · 2026-08-05 · 15×4Preview: 15 ranked values, smallest first.
The 25-delta wing spread on SPY, month by month

The 25-delta wing spread on SPY, month by month

most recentas of series 24×4read in context →
The 25-delta wing spread on SPY, month by month — 24 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthput_25d_iv_pctcall_25d_iv_pctskew_spread_pct
2024-09-0117.5111.95.61
2024-10-0118.7813.575.21
2024-11-0115.311.294.01
2024-12-0114.5410.14.44
2025-01-0116.0311.924.1
2025-02-0116.6211.225.4
2025-03-0122.1915.816.37
2025-04-0131.9924.67.39
2025-05-0121.3214.916.41
2025-06-0118.4912.535.97
2025-07-0116.3411.954.39
2025-08-011610.645.36
2025-09-0116.210.375.82
2025-10-0118.1912.85.39
2025-11-0120.1713.566.61
2025-12-0115.8910.765.14
2026-01-0116.111.324.78
2026-02-0120.212.817.39
2026-03-0126.1816.519.67
2026-04-0120.9313.587.35
2026-05-0117.5112.634.88
2026-06-0118.2512.915.34
2026-07-0117.3911.985.41
2026-08-0115.3810.974.42
the exact SQL behind every number
SELECT
    toString(toStartOfMonth(date))                                                       AS month,
    round(avgIf(toFloat64(implied_volatility), delta BETWEEN -0.30 AND -0.20) * 100, 2)  AS put_25d_iv_pct,
    round(avgIf(toFloat64(implied_volatility), delta BETWEEN  0.20 AND  0.30) * 100, 2)  AS call_25d_iv_pct,
    round((avgIf(toFloat64(implied_volatility), delta BETWEEN -0.30 AND -0.20)
         - avgIf(toFloat64(implied_volatility), delta BETWEEN  0.20 AND  0.30)) * 100, 2) AS skew_spread_pct
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND date >= '2024-09-01'
  AND date <  '2026-09-01'
  AND iv_converged = 1
  AND volume > 0
  AND days_to_expiry BETWEEN 20 AND 45
GROUP BY month
HAVING countIf(delta BETWEEN -0.30 AND -0.20) > 0
   AND countIf(delta BETWEEN 0.20 AND 0.30) > 0
ORDER BY month
$