Historical Data
SpiderRock has a suite of historical data products in multiple asset classes and the ability to deliver this data to a broad range of clients who don’t require the high-speed infrastructure or routing engines of the SpiderRock Trading platform.
We offer robust historical market data and analytics enabling our clients to gain insights and make data-driven decisions.
All datasets are well-documented with an extensive data dictionary. Data is point-in-time.
SpiderRock evaluates the data for validity and accuracy and performs statistical checks on the production databases daily to verify completeness.
SpiderRock includes multiple error codes and surface quality parameters to identify when input data does not support accurate options analytic calculations.
Stocks
Our historical stock datasets recap the days’ trading activity in the underlying security. Files show open/high/low/close/volume data for stocks, ETFs, and indexes from US exchanges. Delisted stocks are included for backtesting purposes.
Stock Closing Marks – Created immediately after the market close when exchanges publish official marks. These records contain closing quotes and prices. Stock data also includes prior day opening and closing data with adjustments for corporate actions and daily returns. Single stocks, ETFs, and index data are tracked with reference data and security IDs that enable users to link symbol data with other corporate reference information.
Stock Minute Bars – Created once per minute for each open stock and index market. Data in this set includes high/low values, spread data, print information, and bid/ask data.
Stock Print Set – Created for each trade with trade cost analysis (TCA). Records are updated 1-minute and 10-minutes after the print.
Stock Imbalances – Files contain buy and sell imbalance records during auctions throughout the trading day. This data is available for both the NYSE and ARCA listed securities.
Options and Greeks
Our options data is captured directly from the OPRA market data feeds. Our analytics include implied volatility, Greeks, and theoretical surfaces derived from underlying markets with critical supporting reference data to ensure highly accurate estimates, resulting in tradable market data.
Options Close Marks (EOD) – Created immediately after the market closes and when exchanges publish official marks. These records contain closing quotes and prices, as well as markup details for all outright options. SpiderRock uses algorithms that estimate the correct theoretical price when creating the SpiderRock closing marks.
Options Quote Intervals – Created every 5 minutes while options markets are open. They contain the call and put prices and sizes, as well as the underlying stock price for each outright options strike. They also include SpiderRock fitted surface implied volatilities and Greeks.
Options at-the-money (ATM) Volatility Minutes Bars – Created at 1-minute intervals for all at-the-money options markets by symbol expiration. Data in this set includes open/high/low/close values and volatility data.
Options Print Set – Created on every option print along with the quote, surface, size, and trade volume at the print time plus all relevant options analytics. The print set also contains exchange published print types (single, complex, auction, block, sweep, etc.) and SpiderRock estimates of the trade side (buy, sell). Records also contain T+1M and T+10M forward mark details to support trade cost analysis (TCA).
Historical Greeks Data
Our historical data packages contain all the option Greeks, including:
- Delta – Measures the rate of change of option price with respect to a 1-point change in the underlying price.
- Gamma – Measures the rate of change of Delta with respect to a 1-point change in the underlying price.
- Vega – Measures the rate of change of the option price with respect to a 1% change in volatility.
- Theta – Measures the rate of change of the option price with respect to 1-day change in time to expiration.
- Rho – Measures the rate of change of the option price with respect to a 1% change in the interest rate.
- Phi – Measures the rate of change of the option price with respect to a 1% change in the dividend rate.
Historical Implied Volatility Calculations
SpiderRock historical implied volatility data uses a family of proprietary pricing models to compute prices, implied volatilities, common options Greeks (delta, gamma, theta, vega, rho, phi, volga, and vanna), and various scenario risk slides for equity and futures options.
SpiderRock pricing models are solutions (sometimes numeric) to the standard generalized Black-Scholes equation. The general form of this equation has several regions of interest for different types of options and within different regions of the skew curve. SpiderRock’s general pricing model is a patchwork of distinct sub-models for a variety of regions of interest to address these different pricing situations in practice.
Learn more about SpiderRock's analytics here.
Futures
Our futures datasets provide individual prices, prints, volume, and other price-related data for all exchange-traded products listed on the CME, CBOT, NYMEX, and COMEX. The wide range of futures data includes indexes, treasuries, currency, metals, agriculture, energy, and more.
Futures Closing Marks
Created immediately after the market closes when the exchanges publish official marks and at the top of the daily rotation. SpiderRock creates and broadcasts a closing mark record for both Futures and Options on Futures. The file is comprised of a unique set of over 30 data fields including the SpiderRock closing mark. Data featured includes:
- Closing quotes
- Closing prices
- Closing underlier bid
- Options bid, ask, and marks
- Option implied bid/ask volatilities
- Greeks
- Theoretical surface prices and volatilities
- Prior day closing quotes and prices are included. SpiderRock’s proprietary approach selects the most appropriate closing price for the given security type.
Options on Futures Quote Intervals Records
Options on Futures intraday records are created every 5 minutes while markets are open. They contain the call and put prices and sizes, as well as the underlying stock price for each outright options strike.
They also contain SpiderRock fitted surface implied volatilities and Greeks.
Supported Futures
SpiderRock datasets and feeds include equity index products from the CME, CFE, and CBOE.
- Index Products – Top indexes by volume, including S&P 500, Dow, VIX, Nasdaq, and Russell traded on CME and CFE. Datasets also include broad-based ETFs and other volatility index products.
SpiderRock can also offer other historical commodities datasets from NYMEX, COMEX, CBOT.
- Energy products – Top 20 traded futures and futures spread for oil, natural gas, refined products primality traded on NYMEX
- Treasuries – Top 20 treasuries futures and futures options Including T-bill, and Treasury Bonds (5, 10, 30 year), and various spread products traded on CBOT
- Metals –Top Gold, Silver, and other commercial or precious metals traded on COMEX
- Agricultural products – Wheat, Corn, Soybeans traded on the CME and CBOT
Minute Bars
Future minute bar records contain open, high, low, close, vwap, volume, and other price-related data for all futures and options on futures based on SpiderRock live market data streams.
Bars for options on futures are created every 1 minute and contain open/high/low/close volatility at-the-money for each expiration.
Print Sets
Print set records contain every print along with quotes, surface, and SpiderRock trade details at print time.
These records are created for every print at the time of print and are published 10 minutes later when T + 10M forward marks are available to evaluate trade performance.
Historical Price Data for Volatility
Volatility is a crucial feature of the options market and superior options data forms the foundation for insightful volatility analysis. Smoothed volatility curves with a constant maturity format allow for easy incorporation of data into models and analysis. Researchers can use skew curves on a standard grid as indicators of directional market pressure.
Theoretical volatility surfaces are models of the fair market value of an option between the bid and offer. These surfaces reflect the best fit of current markets and are subject to change if or when market conditions change.
SpiderRock continually computes dynamic implied volatility surfaces for all options expiration months, updating these surfaces as new live market quotes are received. Each curve record contains the spline parameters for the shape of a surface, the live calibrated at-the-money volatility, the stock dividend rate, any price offset, and other related curve adjustments.
SpiderRock has multiple volatility surface datasets. These datasets include surfaces for each expiration at end-of-day and 10-minute intervals archived at the market close. SpiderRock produces daily subscription feeds for both intra-day and EOD surfaces.
All SpiderRock options datasets for equities or futures on options include documented theoretical surface prices and volatilities for each option strike.
VOL2G Database
A new SpiderRock analytics database for US stock and equity options pricing and volatility designed to meet the needs of institutional and academic researchers who depend on high-quality historical volatility analytics.
Live Surface Curve
This table contains spline curve parameters, implied volatility surfaces, Greeks, and hedge deltas for all options expiration months with live market quotes.
The records backing each SpiderRock surface represent a two-dimensional curve with strikes in the X-axis expressed in terms of moneyness (i.e., standardized lognormal or normal) and options volatilities in the Y-axis expressed as a multiple of at-the-money volatility.
Live Surface Grid Records (Skew Surfaces)
This table contains a fixed grid of volatility for a given expiration as a function of delta for uncensored curves. The file also includes days until the next earnings date and implied earnings moves.
Live Surface Fixed Term
This dataset contains snapshots of the censored at-the-money volatility term structure with the impact of implied earnings events removed for each ticker. Censored curves are created by eliminating the earnings volatility from the observed fitted curve which enables the user to better understand the ticker’s underlying volatility.
Each snapshot contains at-the-money volatilities for fixed-term expirations: atm5d, atm10d, atm21d, atm42d, atm63d, atm84d, atm105d, atm126d, atm189d, atm252d, atm378d, and atm504d (two years).
The data also includes historical earnings move history, estimated implied earnings moves, uncensored curves with earnings events included, and censored curves with the impact of implied earnings events removed.
Data and Analytics Product Offerings
Stocks
Item | Frequency | History | Prices | Volume | Size | Greeks | Implied Vol | Vol Surfaces |
---|---|---|---|---|---|---|---|---|
Stock Close Marks | EOD | Jan-10 | X | X | X | - | - | - |
Stock Minute Bars | 1 Min | Jan-10 | X | X | - | - | - | - |
Stock Print Set | Trades | Jan-16 | X | X | X | - | - | - |
Stock Imbalances | Every Tick | Aug-10 | X | X | - | - | - | - |
Equity Options
Item | Frequency | History | Prices | Volume | Size | Greeks | Implied Vol | Vol Surfaces |
---|---|---|---|---|---|---|---|---|
Option Close Marks | EOD | Jan-10 | X | X | X | X | X | X |
Option Price History ID | 20 Min | Sep-14 | X | X | X | X | X | X |
Option Price History HID | 5 Min | Jan-20 | X | X | X | X | X | X |
Option 1 Minute Bars ATM | 1 Min | Aug-20 | X | - | - | X | X | - |
Options Print Set | Trades | Jan-16 | X | X | X | X | X | X |
US Futures Indexes, ETFs, Index Options
Item | Frequency | History | Prices | Volume | Size | Greeks | Implied Vol | Vol Surfaces |
---|---|---|---|---|---|---|---|---|
Futures Close Marks | EOD | Jan-19 | X | X | - | - | - | - |
Futures Minute Bars | 1 Min | Jan-16 | X | X | - | - | - | - |
Futures Print Set | Trades | Jan-16 | X | X | X | - | - | - |
Options (F) Close Marks | EOD | Jan-10 | X | X | - | X | X | X |
Options (F) Price History HID | 5 Min | Aug-20 | X | X | X | X | X | X |
Options (F) Minute Bars ATM | 1 Min | Aug-20 | X | - | - | - | X | - |
Options (F) Print Set | Trades | Jan-19 | X | X | X | X | X | X |
Options Volatility Surfaces
Item | Frequency | History | Prices | Volume | Size | Greeks | Implied Vol | Vol Surfaces |
---|---|---|---|---|---|---|---|---|
Surface Curves EOD | EOD | Jan-10 | X | - | - | X | X | X |
Fixed Grid Surface EOD | EOD | Jan-10 | - | - | - | - | X | X |
Fixed Term Surface ATM EOD | EOD | Jan-10 | - | - | - | - | X | X |
Surface Curves ID | 30 Min | Mar-16 | X | - | - | X | X | X |
Fixed Grid Surface ID | 30 Min | Mar-16 | - | - | - | - | X | X |
Fixed Term Surface ATM ID | 30 Min | Mar-16 | = | = | = | = | X | X |
Surface Curves ID | 5 Min | Aug-20 | X | - | - | X | X | X |
Fixed Grid Surface ID | 5 Min | Dec-20 | - | - | - | - | X | X |
Fixed Term Surfaces ATM ID | 5 Min | Dec-20 | - | - | - | - | X | X |
VOL2G Equity Options Volatility Bundle
Item | Frequency | History | Prices | Volume | Size | Greeks | Implied Vol | Vol Surfaces |
---|---|---|---|---|---|---|---|---|
Stock Close Marks | EOD | Jan-10 | X | X | - | - | - | - |
Options Close Marks | EOD | Jan-10 | X | X | X | X | X | X |
Fixed Grid Surfaces | EOD | Jan-10 | - | - | - | - | X | X |
Fixed Term Surfaces ATM | EOD | Jan-10 | - | - | - | - | X | X |
Volatility History by Ticker | EOD | Jan-10 | X | X | - | X | X | X |
Equity References Tables | EOD | Jan-10 | X | X | - | - | - | - |