Dataset Name: spiderrock_optionclosemarkhist_eqt
Group: options
Vendor: SpiderRock
Symbol Set: US Options
Asset Class: Options
Data Update Time(s): 6:40 AM EST
Data Update Frequency: day
Option Print Set records contain every option print along with quote, surface, and SR probability details at EOD.
Data Contained in this Dataset
| Column | Type | Description |
|---|---|---|
| _seq | int64 | Internal sequence number used to keep data rows in order |
| muts | int64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. |
| timestamp | string | Timestamp of the Data - America/New York Time. |
| symbol | string | Trading Symbol or Ticker |
| okey_at | string | Option underlying asset type |
| okey_ts | string | Option ticker source |
| okey_tk | string | Option underlying symbol |
| okey_yr | int64 | Option expiration year |
| okey_mn | int64 | Option expiration month |
| okey_dy | int64 | Option expiration day |
| okey_xx | double | Option strike |
| okey_cp | string | Option call/put indicator |
| tradingDate | int64 | Trading Date in UTC |
| tradingDate_str | string | Trading Date in UTC - string format |
| tradingSession | string | Trading session ('None','RegularMkt','PreMkt','PostMkt','PostMktETF','NextDay') |
| undSecKey_at | string | Underlying asset type |
| undSecKey_ts | string | Underlying security trade source |
| undSecKey_tk | string | Underlying ticker |
| undSecKey_yr | int64 | Underlying asset expiration year - futures only |
| undSecKey_mn | int64 | Underlying asset expiration month - futures only |
| undSecKey_dy | int64 | Underlying asset expiration day - futures only |
| undSecType | string | Underlying security type |
| srCloseTime | int64 | SpiderRock closing mark time (created between 14:59 and 15:00 CDT for all equity names and 1 minute before the close of the trading session for futures) |
| srCloseTime_str | string | SpiderRock closing mark time (created between 14:59 and 15:00 CDT for all equity names and 1 minute before the close of the trading session for futures) |
| uBid | double | Underlying bid at srCloseTime |
| uAsk | double | Underlying ask at srCloseTime |
| uSrCls | double | SpiderRock underlying closing mark at srCloseTime |
| uClose | double | Official underlying market close from exchange |
| bidPrc | double | The best price for which somebody is willing to buy something, whether it be a security, asset, commodity, service, or contract. |
| askPrc | double | Option ask at srCloseTime |
| srClsPrc | double | SpiderRock option closing mark at srCloseTime; estimated surface price |
| closePrc | double | Option bid-ask midpoint at 2:59 using OPRA NBBO |
| bidIV | double | Implied vol of bid price |
| askIV | double | Implied vol of ask price |
| srPrc | double | SpiderRock calculated option price from srVol |
| srVol | double | SpiderRock surface volatility at srCloseTime |
| iSlope | double | slope of SR surface (Change in SRVol relative to change in Uprc; assuming expiry curve slides left/right with no shape change) |
| eSlope | double | slope of SR surface (Change in SRVol relative to change in Uprc; from historical/empirical model) |
| de | double | Option Delta calculated using srVol |
| ga | double | Option Gamma calculated using srVol |
| th | double | Option Theta calculated using srVol |
| ve | double | Option Vega calculated using srVol |
| rh | double | Option Rho calculated using srVol |
| ph | double | Option Phi calculated using srVol |
| vo | double | Option Volga calculated using srVol |
| va | double | Option Vanna calculated using srVol |
| deDecay | double | Option Delta time decay calculated using srVol (Charm, Delta Bleed) |
| sdiv | double | SpiderRock implied continuous dividend rate |
| ddiv | double | Sum of dividends paid to expiration |
| rate | double | SpiderRock calibrated risk free rate |
| years | double | SpiderRock time to expiration in years |
| error | int64 | For internal use by SpiderRock. |
| openInterest | int64 | Open Interest |
| prtCount | int64 | Number of trades for the day |
| prtVolume | int64 | Total volume of contracts traded for the day |
| priorDate | int64 | Prior Trading Day Date/Reserved for future use |
| priorDate_str | string | Prior Trading Day Date/Reserved for future use |
| prcAdjValue | double | Corp action adjustment value (0.0 on most days); [todayPrice = priorPrice * prcAdjRatio + prcAdjValue]/Reserved for future use |
| prcAdjRatio | double | Corp action adjustment factor (1.0 on most days)/Reserved for future use |
| priorSRClsPrc | double | Value archived in the previous trading period/Reserved for future use |
| priorClosePrc | double | Prior Trading Day Closing Price/Reserved for future use |
| timestamp_utc | int64 | Timestamp of last update to record - UTC |
| timestamp_utc_str | string | Timestamp of last update to record - UTC |
| srClsPrcSrc | string | Calculation method of srClsPrc |
| closePrcSrc | string | Calculation method of closePrcSrc |
| timestamp_cst | int64 | Time stamp of last update to record - local Chicago time |
| timestamp_cst_str | string | Time stamp of last update to record - local Chicago time |
| securityID | int64 | Security Identification Code for the data source vendor |
| osiKey | string | Options Symbology Initiative 21-character symbol |