Page tree
Skip to end of metadata
Go to start of metadata

This file contains information for all active contracts and their respective product as well as each product's primary component. A contract is cleared and settled each day. For additional information about contracts, see What are Products and Contracts?. An product may have multiple active contracts. The date in the file name indicates the date the contracts are available for trading.

File Cycle

The file is published daily at 22:00 CT for the next business date

Format

The file is comma separated value (CSV) with column headers in the first row

Name

OPC_CONTRACTS.CSV (Latest)

OPC_CONTRACTS.YYYYMMDD.CSV (Historical)

Connectivity

The public FTP server https://ftp.onechicago.com is accessible over general internet

Field Names and Definitions
Field NameField TypeLengthDescription

product_id

integer20Exchange-assigned numeric product identifier
product_symbolstring6Alphabetic product identifier assigned by the exchange
clearing_symbolstring6Alphabetic product identifier assigned by the exchange's clearing house
regulatory_symbolstring5Alphabetic product identifier assigned by the exchange's regulatory agency
product_multiplierdecimal12,6Specifies the number of units of the underlying per contract
is_cainteger1

Determines whether a product is a result of a corporate action

1 = True
0 = False

cfi_codestring6Classification of financial instrument code used to identify the product
listing_datedate
Date the product is first listed at the exchange
delisting_datedate
Date the product listing is removed from the exchange
dividend_exposurestring10

Short-code for identifying a product's dividend exposure

NDR = No dividend risk exposure
TRA = Traditional dividend treatment no daily adjustments

delivery_offset_daysinteger2Number of business days between a contract's expiration and delivery dates
delivery_typestring10

Short-code for identifying the method a product is taken to delivery

CASH = Cash Delivery
PHYS = Physical Delivery

component_id_bb_globalstring12Bloomberg-assigned 12-digit alpha-numeric identifier covering active and non-active securities for the primary component of a product
component_symbolstring10Security symbol for the primary component of a product
component_id_mic_prim_exchstring4Primary exchange MIC code for the primary component of a product
component_namestring100Security name for the primary component of a product
component_industry_sectorstring100Sector of industry used to describe the primary component of a product
component_industry_groupstring100Common line of business used to describe the primary component of a product
component_industry_subgroupstring100Specific line of business used to describe the primary component of a product
component_security_typestring50Security type for the primary component of a product
mpsecidinteger20Principal mpsecid of the cleared SSF. This is what is settled and how open interest is conveyed for the cleared product.
contract_idinteger20Exchange-assigned numeric contract identifier
last_trading_datedate
The last date the contract is available for trading. This date is equal to the expiration_date, unless the contract is terminated early.
delivery_datedate
Date the contract is taken to delivery
expiration_datedate
Date the contract expires
Sample
product_id,product_symbol,clearing_symbol,regulatory_symbol,product_multiplier,is_ca,cfi_code,listing_date,delisting_date,dividend_exposure,delivery_offset_days,delivery_type,component_id_bb_global,component_symbol,component_id_mic_prim_exch,component_name,component_industry_sector,component_industry_group,component_industry_subgroup,component_security_type,mpsecid,contract_id,last_trading_date,delivery_date,expiration_date
6020,A1D,A1D,AD1,100.000000,0,FFSPSX,2014-11-04,9999-12-31,NDR,2,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,10602011190816000000,1246847,2019-08-16,2019-08-20,2019-08-16
6020,A1D,A1D,AD1,100.000000,0,FFSPSX,2014-11-04,9999-12-31,NDR,2,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,10602011190920000000,1136326,2019-09-20,2019-09-24,2019-09-20
6020,A1D,A1D,AD1,100.000000,0,FFSPSX,2014-11-04,9999-12-31,NDR,2,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,10602011191220000000,1201125,2019-12-20,2019-12-24,2019-12-20
6020,A1D,A1D,AD1,100.000000,0,FFSPSX,2014-11-04,9999-12-31,NDR,2,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,10602011200320000000,1266810,2020-03-20,2020-03-24,2020-03-20
30798,A1I,A1I,ATNV1,100.000000,0,FFSPNX,2017-07-24,9999-12-31,NDR,2,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,13079811190906000000,1277274,2019-09-06,2019-09-10,2019-09-06
29795,A1J,A1J,ATNV1,100.000000,0,FFSPNX,2017-07-24,9999-12-31,NDR,2,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,12979511190913000000,1281742,2019-09-13,2019-09-17,2019-09-13
29293,A1K,A1K,ATNV1,100.000000,0,FFSPNX,2017-07-24,9999-12-31,NDR,2,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,12929311190823000000,1260932,2019-08-23,2019-08-27,2019-08-23
31251,A1L,A1L,ATNV1,100.000000,0,FFSPNX,2017-07-24,9999-12-31,NDR,2,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,13125111190830000000,1272349,2019-08-30,2019-09-04,2019-08-30
23159,A3F,A3F,AKRE1,100.000000,0,FFSPNX,2017-03-10,9999-12-31,NDR,1,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,12315911190816000000,1280465,2019-08-16,2019-08-19,2019-08-16
23155,A3M,A3M,AKRE1,100.000000,0,FFSPNX,2017-03-10,9999-12-31,NDR,1,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,12315511190819000000,1281343,2019-08-19,2019-08-20,2019-08-19
23156,A3T,A3T,AKRE1,100.000000,0,FFSPNX,2017-03-10,9999-12-31,NDR,1,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,12315611190820000000,1282714,2019-08-20,2019-08-21,2019-08-20
23157,A3W,A3W,AKRE1,100.000000,0,FFSPNX,2017-03-10,9999-12-31,NDR,1,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,12315711190821000000,1283593,2019-08-21,2019-08-22,2019-08-21
23163,A4H,A4H,AKRE1,100.000000,0,FFSPNX,2017-03-10,9999-12-31,NDR,1,PHYS,BBG000C2V541,A,XNYS,Agilent Technologies Inc,Industrial,Electronics,Electronic Measur Instr,Common Stock,12316311190822000000,1284472,2019-08-22,2019-08-23,2019-08-22