STRASMORE/EXPLORE 2,170 QUERIES

At-the-money SPY time decay accelerates near 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 Theta? Time Decay Explained.

as of series 4×2read in context →
At-the-money SPY time decay accelerates near expiry (2026-07-13) — 4 rows by 2 columns, computed from US exchange, SIP and OPRA data.
time_to_expirypct_of_price_per_day
0-7 days-19.3
8-30 days-3.9
31-90 days-1
90+ days-0.2
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 time decay accelerates near 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…)
pct_of_price_per_day number -19.3 to -0.2 percent

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(theta/option_close)*100, 1) AS pct_of_price_per_day
FROM global_markets.options_greeks
WHERE date = '2026-07-13' AND underlying_symbol = 'SPY' AND abs(delta) BETWEEN 0.45 AND 0.55 AND option_close > 0.5
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 Theta? Time Decay Explained
The SPY $740 call's daily time decay deepens into expiry (May–Jun 2026) 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 → The $740 call's greeks, day by day (delta, gamma, theta, vega, IV%) series 31×7 → See all 2,170 queries →