stock replacement — 4 answered market questions

One deep-ITM LEAPS vs 100 shares: cost, leverage, and delta

most recentas of 2026-07-16 series 3×7read in context →

One deep-ITM LEAPS vs 100 shares: cost, leverage, and delta — 3 rows by 7 columns, computed 2026-07-16 from US exchange, SIP and OPRA data.
date	spy_close	shares_cost	leaps_price	leaps_cost	leverage_x	delta
2025-07-01	617.93	61793	48.5	4850	12.7	0.689
2025-10-09	671.96	67196	82.03	8203	8.2	0.897
2025-12-01	679.98	67998	84.49	8449	8	0.938

the exact SQL behind every number

SELECT date,
       round(avg(underlying_close), 2) AS spy_close,
       round(avg(underlying_close) * 100, 0) AS shares_cost,
       round(avg(option_close), 2) AS leaps_price,
       round(avg(option_close) * 100, 0) AS leaps_cost,
       round(avg(underlying_close) / avg(option_close), 1) AS leverage_x,
       round(avg(delta), 3) AS delta
FROM global_markets.options_greeks
WHERE ticker = 'O:SPY260116C00600000' AND date IN ('2025-07-01', '2025-10-09', '2025-12-01') AND implied_volatility > 0.02
GROUP BY date ORDER BY date

More from this analysisDeep ITM LEAPS: Stock Replacement

SPY vs the LEAPS call, both indexed to 100 in early June 2025 series 33×3 → The LEAPS call's delta climbing toward 1 as it goes deep in the money series 33×2 → Time value as a share of premium, and daily theta, month by month series 8×3 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → See all 2,170 queries →