OCC Equities Special Settlements
OCC Equities Special Settlements
Production
·
The Equities Special Settlements dataset is based on Options Clearing Corporation (OCC) data and offers detailed information on non-standard (adjusted) equity option contracts listed on US public exchanges. It includes core details such as the options symbol, underlying symbol, and additional settlement-specific information like how exercise and assignment activities were resolved. The dataset also captures the total number of delivery components associated with the settlement of the traded option symbol, providing a comprehensive view of these unique contracts. This dataset is available starting from November 1, 2017, and is structured on a daily basis to support in-depth market analysis.
Dataset Info
Dataset Name ID
occ_eq_spec_settl
Algoseek Dataset ID
US5001
Data Format
Reference
Data Class
Options
Data Type
Reference
Time Granularity
Event
Region
US
Universe
All equity options contracts from US exchanges
Version
1.0
Update Frequency Options
End of day
Start Date
01/01/2023
End Date
12/31/2023
Access Methods
SQL
Description
One year of data (2023) for the full universe of symbols
Data Size
910 KB / year
Update Size
3.6 KB
Update Frequency
1 Day
Start Date
2017-11-01
End Date
Ongoing
SQL (ArdaDB)
Easily connect to your data using SQL with a database connection. No complex setup, just instant access to your data - run queries, retrieve insights, and manage data effortlessly. Secure, fast, and built for developers, analysts, and teams who need reliable access without the hassle.
Data Fields
Preview Data
| # | name | data type | description |
|---|
CSV (S3)
Easily connect to your data stored in S3 and access CSV files without hassle. Streamline data retrieval with fast, secure, and scalable access, whether for analytics, processing, or integration.
occ-equity-special-settlements-yyyy
S3 Bucket Name
occ-equity-special-settlements-yyyy
Update Time
01:30 ET
S3 Bucket Path
yyyymmdd.csv
S3 Bucket Path Description
One CSV file per trading date where yyyymmdd is year, month, and day
S3 Start Year
2017
S3 End Year
N/A
S3 Bucket Size
910 KB / year
Sample Data File
Data Fields
Preview Data
| # | name | data type | description |
|---|---|---|---|
| 1 | ProcessDate | String | The date in yyyymmdd format on which the record was created by OCC |
| 2 | SettlementDate | String | The date in yyyymmdd format on which delivery of and payment for a product is due to |
| 3 | OptionTicker | String | Symbol name |
| 4 | UnderTicker | String | Underlying symbol name |
| 5 | UnderType | String | Type of underlying security |
| 6 | StrikeCurrency | String | The currency of the strike price |
| 7 | TotalDelivComponents | Integer | The total number of components of delivery associated with the settlement of the traded option symbol |
| 8 | DeliveryComponents | Integer | The number of a specific component of delivery that is represented by the record |
| 9 | SettlementMethod | String | The manner in which exercise and assignment activity will be settled |
| 10 | StrikePercent | Integer | Percentage of the strike price allocated for settlement |
| 11 | DeliverableUnits | Integer | The per contract number of deliverable units of cash, stocks, bonds, or currencies to be delivered or received upon settlement |
| 12 | CashAmount | Decimal | Per contract cash amount to be allocated upon settlement |