STRASMORE/EXPLORE 2,170 QUERIES

Signed SPY gamma exposure by expiry, next three weeks

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-22, from Open-Source GEX Dashboard: How It Works.

as of ranking 11×4read in context →
Signed SPY gamma exposure by expiry, next three weeks — 11 rows by 4 columns, computed from US exchange, SIP and OPRA data.
expirycall_gex_bnput_gex_bnnet_gex_bn
Aug 2027.78-189.79
Aug 217.78-7.140.64
Aug 241.68-1.020.67
Aug 250.49-0.51-0.02
Aug 260.5-0.460.04
Aug 270.21-0.140.07
Aug 280.65-0.530.13
Aug 310.29-0.44-0.15
Sep 10.04-0.030.02
Sep 20.02-0.03-0.02
Sep 40.16-0.25-0.09
Rows × columns
11 × 4
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Signed SPY gamma exposure by expiry, next three weeks, derived from the stored result.
ColumnTypeRangeNotes
expiry text 11 distinct values (Aug 20, Aug 21, Aug 24…)
call_gex_bn number 0.02 to 27.78
put_gex_bn number -18 to -0.03
net_gex_bn number -0.15 to 9.79

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

the exact SQL behind every number 
SELECT
    formatDateTime(expiry_date, '%b %e')                                    AS expiry,
    round(sumIf(gex, side = 'call') / 1e9, 2)                               AS call_gex_bn,
    round(-sumIf(gex, side = 'put') / 1e9, 2)                               AS put_gex_bn,
    round((sumIf(gex, side = 'call') - sumIf(gex, side = 'put')) / 1e9, 2)  AS net_gex_bn
FROM
(
    SELECT
        expiration_date                                        AS expiry_date,
        if(lower(option_type) LIKE 'c%', 'call', 'put')        AS side,
        toFloat64(gamma) * toFloat64(volume) * 100
            * pow(toFloat64(underlying_close), 2) * 0.01       AS gex
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND date = (SELECT max(date) FROM global_markets.options_greeks WHERE underlying_symbol = 'SPY')
      AND iv_converged = 1
      AND volume > 0
      AND days_to_expiry BETWEEN 0 AND 21
)
GROUP BY expiry_date
ORDER BY expiry_date

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisOpen-Source GEX Dashboard: How It Works
The same chain, a different question: in the money value by settlement price ranking 23×2 → Gross SPY call and put gamma against the net, trailing 60 calendar days series 41×5 → SPY gamma exposure by strike, latest session, contracts inside 30 days table 23×5 → SPY options median spread by expiration date, near-the-money strikes only ranking 25×4 → SPY contracts traded by strike, July 17 2026 expiry ranking 22×3 → A 15% cap and 9% buffer, seen from three entry points ranking 21×4 → See all 2,170 queries →