Net delta of a SPY box as the upper strike widens (June 1, 2026)

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH
    chain AS
    (
        SELECT
            toFloat64(strike_price)           AS strike,
            avg(toFloat64(underlying_close))  AS spot,
            round(avgIf(delta, delta > 0), 4) AS call_delta,
            round(avgIf(delta, delta < 0), 4) AS put_delta
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'SPY'
          AND date = '2026-06-01'
          AND expiration_date = '2026-12-18'
          AND iv_converged = 1
          AND volume > 0
        GROUP BY strike
        HAVING countIf(delta > 0) > 0
           AND countIf(delta < 0) > 0
    ),
    lower_leg AS
    (
        SELECT
            strike     AS k1,
            call_delta AS c1,
            put_delta  AS p1
        FROM chain
        ORDER BY abs(strike - spot)
        LIMIT 1
    )
SELECT
    toUInt32(strike - k1)                      AS strike_width,
    round(c1 - call_delta, 4)                  AS call_leg_delta,
    round(put_delta - p1, 4)                   AS put_leg_delta,
    round(c1 - call_delta + put_delta - p1, 4) AS box_net_delta
FROM chain
CROSS JOIN lower_leg
WHERE strike > k1
  AND strike <= k1 + 60
ORDER BY strike