STRASMORE/EXPLORE 2,170 QUERIES

At-the-money SPY gamma by time to expiry (2026-07-13)

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-07-15, from What Is Option Gamma? Delta's Accelerator.

as of ranking 4×2read in context →
At-the-money SPY gamma by time to expiry (2026-07-13) — 4 rows by 2 columns, computed from US exchange, SIP and OPRA data.
time_to_expiryavg_gamma
0-7 days0.0398
8-30 days0.0209
31-90 days0.0099
90+ days0.0039
Rows × columns
4 × 2
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 At-the-money SPY gamma by time to expiry (2026-07-13), derived from the stored result.
ColumnTypeRangeNotes
time_to_expiry text 4 distinct values (0-7 days, 31-90 days, 8-30 days…)
avg_gamma number 0.0039 to 0.0398

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 multiIf(days_to_expiry<=7,'0-7 days',days_to_expiry<=30,'8-30 days',
               days_to_expiry<=90,'31-90 days','90+ days') AS time_to_expiry,
       round(avg(gamma), 4) AS avg_gamma
FROM global_markets.options_greeks
WHERE date = '2026-07-13' AND underlying_symbol = 'SPY' AND abs(delta) BETWEEN 0.45 AND 0.55
GROUP BY time_to_expiry ORDER BY min(days_to_expiry)

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 analysisWhat Is Option Gamma? Delta's Accelerator
SPY call gamma peaks at the money (~30 days out, 2026-07-13) ranking 5×2 The $740 call's gamma climbs as expiry nears series 31×2 One SPY $740 call's price over its 7-week life (expired Jun 18 2026) series 31×2 The stock both options tracked: SPY, May 1 to Jun 15 2026 series 31×3 The $740 put's greeks, day by day (delta, gamma, theta, vega, IV%) series 31×7 Call vs put on the same $740 strike: mirror-image prices series 31×4 See all 2,170 queries →