STRASMORE/EXPLORE 2,170 QUERIES

At-the-money SPY vega grows with 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-08-13, from What Is Option Vega? Volatility Sensitivity.

as of ranking 4×2read in context →
At-the-money SPY vega grows with time to expiry (2026-07-13) — 4 rows by 2 columns, computed from US exchange, SIP and OPRA data.
time_to_expiryavg_vega
0-7 days0.295
8-30 days0.594
31-90 days1.137
90+ days2.741
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 vega grows with 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_vega number 0.295 to 2.741

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(vega), 3) AS avg_vega
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 Vega? Volatility Sensitivity
SPY call vega peaks at the money (~30 days out, 2026-07-13) ranking 5×2 The SPY $740 call's implied volatility spiked when SPY fell, early June 2026 series 31×2 At-the-money implied volatility by stock (2026-07-13) ranking 7×2 SPY put IV rises as strikes fall: the volatility skew (2026-07-13) ranking 5×2 SPY at-the-money IV by time to expiry: the term structure (2026-07-13) ranking 4×2 One SPY $740 call's price over its 7-week life (expired Jun 18 2026) series 31×2 See all 2,170 queries →