early exercise — 4 answered market questions

Time value left in AAPL contracts by depth in the money

most recentas of 2026-08-22 table 5×5read in context →

Time value left in AAPL contracts by depth in the money — 5 rows by 5 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
itm_depth	call_avg_vega	put_avg_vega	call_contracts	put_contracts
under 1%	0.207	0.208	692	650
1 to 3%	0.185	0.191	1221	1146
3 to 5%	0.153	0.162	965	868
5 to 10%	0.116	0.13	1603	889
over 10%	0.071	0.101	2407	321

the exact SQL behind every number

SELECT
    depth_bucket                            AS itm_depth,
    round(avgIf(vega_f, side = 'call'), 3)  AS call_avg_vega,
    round(avgIf(vega_f, side = 'put'), 3)   AS put_avg_vega,
    countIf(side = 'call')                  AS call_contracts,
    countIf(side = 'put')                   AS put_contracts
FROM
(
    SELECT
        if(delta > 0, 'call', 'put') AS side,
        toFloat64(vega)              AS vega_f,
        if(delta > 0,
           toFloat64(underlying_close) / toFloat64(strike_price) - 1,
           toFloat64(strike_price) / toFloat64(underlying_close) - 1) AS depth,
        multiIf(depth < 0.01, 'under 1%',
                depth < 0.03, '1 to 3%',
                depth < 0.05, '3 to 5%',
                depth < 0.10, '5 to 10%',
                              'over 10%') AS depth_bucket
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date >= today() - 120
      AND iv_converged = 1
      AND volume > 0
      AND days_to_expiry BETWEEN 3 AND 30
      AND toFloat64(underlying_close) > 0
      AND toFloat64(strike_price) > 0
      AND toFloat64(delta) != 0
      AND depth > 0
)
GROUP BY depth_bucket
HAVING countIf(side = 'call') > 0 AND countIf(side = 'put') > 0
ORDER BY min(depth)

More from this analysisWhen Short Options Get Assigned Early

AAPL calls 1 to 5 percent in the money, by days left to expiry ranking 6×4 → Latest cash dividend per share, and what it is worth against the stock series 6×4 → Put versus call implied volatility, near the money, 20 to 45 days out ranking 5×4 → NVDA on July 17, 2026: the close and the post close window table 30×3 → See all 2,170 queries →