SPX and SPXW are two option roots on the same index, the S&P 500, and data for one does not include the other. Most index option trades are under SPXW. If you pull only SPX, you miss most of the market in it.
SPX vs SPXW in OptionData files
-
Separate symbols: Yes: ordering one never includes the other
-
Row ratio: SPXW had about 35 times SPX's rows in the week of 2026-10-14
-
Same for: NDX / NDXP, RUT / RUTW, VIX / VIXW
What the two roots are
Both are options on the S&P 500 index. They differ in what they cover:
- SPX is the standard contract, with the monthly expirations.
- SPXW holds the weekly and daily expirations, including the contracts that expire every trading day.
Because most of the trading in S&P 500 index options is in short-dated contracts, most of the volume sits in SPXW. Each root is a separate symbol in OptionData's files, in trade files, option chain files and GEX levels files.
Other index pairs
The same split applies to three more indexes. Ordering one symbol of a pair does not include the other:
| Index | Root | Weekly and daily root |
|---|---|---|
| S&P 500 | SPX | SPXW |
| Nasdaq-100 | NDX | NDXP |
| Russell 2000 | RUT | RUTW |
| Cboe Volatility Index | VIX | VIXW |
How it shows up in the data
In the week of 2026-10-14, SPXW had about 35 times the rows of SPX in the trade files. An order for SPX alone would hold a small share of the index's trades. The order page therefore warns you before you pay whenever you choose only one symbol of a pair, and does not block the order.
Whole-market orders include every symbol, both roots of a pair. To see the split in a file you own, count rows per symbol:
SELECT symbol, count(*) AS trades
FROM 'trades_2026-10-20.parquet'
WHERE symbol IN ('SPX', 'SPXW')
GROUP BY symbol;In the chain and levels files
The option chain file has separate contracts for each root, and the GEX levels file has a separate row for each. Total gamma exposure for "the S&P 500" is therefore not one row: add the SPX and SPXW rows if you want the index as a whole.
What to do
- Whole market orders: nothing. Both roots are in every file.
- Chosen-symbol orders: include both roots of any pair you want, for example
SPX, SPXW. - Analysis: decide whether you want the whole index or one settlement style before you filter.
Order option trades for the whole market at $2 a trading day, or for chosen symbols at $1 per 10 million rows with a $2 minimum.
Frequently asked questions
Is SPXW a different index? No. It is a different option root on the same index.
Does a symbol order for SPX include SPXW? No. Order both.
Why does the order page warn me? An order with only one symbol of a pair misses most of that index's trades.