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

This file contains information for all active exchange products, along with information for the product's primary component. A product is a single stock future comprised of one or many underlying components. 

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_PRODUCTS.CSV (Latest)

OPC_PRODUCTS.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
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
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
23149,A1F,A1F,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
23148,A1H,A1H,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
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
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
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
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
23145,A1M,A1M,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
23146,A1T,A1T,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
23147,A1W,A1W,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
23154,A2F,A2F,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
23153,A2H,A2H,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
23150,A2M,A2M,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
23151,A2T,A2T,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
23152,A2W,A2W,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
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
23158,A3H,A3H,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
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
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
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
23164,A4F,A4F,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
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
23160,A4M,A4M,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
23161,A4T,A4T,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
23162,A4W,A4W,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
23169,A5F,A5F,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
23168,A5H,A5H,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
23165,A5M,A5M,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
23166,A5T,A5T,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
23167,A5W,A5W,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