{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "ed9764ab", "metadata": {}, "outputs": [], "source": [ "import icepython as ice" ] }, { "cell_type": "code", "execution_count": 2, "id": "e59ca06c", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "('Classifications',\n", " 'County',\n", " 'Countries',\n", " 'Currency',\n", " 'Day',\n", " 'Exchanges',\n", " 'Locations',\n", " 'Markets',\n", " 'Mic',\n", " 'Months',\n", " 'Option Types',\n", " 'Parents',\n", " 'Roots',\n", " 'States',\n", " 'Strike',\n", " 'Suffix',\n", " 'Suppliers',\n", " 'Term',\n", " 'Types',\n", " 'Years')" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#See all facets for filtering\n", "facets = ice.get_search_facets()\n", "facets" ] }, { "cell_type": "code", "execution_count": 3, "id": "420a1003", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(('F.EX', 'Exchanges', 1),\n", " ('F.EX.0', 'U.S. Equities', 2),\n", " ('F.EX.0.0', 'New York Stock Exchange', 3),\n", " ('F.EX.0.1', 'NASDAQ', 3),\n", " ('F.EX.0.2', 'NYSE American', 3),\n", " ('F.EX.0.3', 'OTC Equities', 3),\n", " ('F.EX.0.4', 'NYSE ARCA Listed (ARCX)', 3),\n", " ('F.EX.0.5', 'Cboe Equities (fka Bats) Listed', 3),\n", " ('F.EX.0.6', 'US Mutual Funds and UIT', 3),\n", " ('F.EX.0.7', 'US Money Funds', 3),\n", " ('F.EX.1', 'U.S. Indices', 2),\n", " ('F.EX.1.0', 'Bloomberg UBS Indices', 3),\n", " ('F.EX.1.1', 'Cboe Global Indices Feed (CGIF)', 3),\n", " ('F.EX.1.2', 'Cboe Indices- CCCY/ FTSE/ INAV/ MSCI', 3),\n", " ('F.EX.1.3', 'CME Cryptocurrency Indices', 3),\n", " ('F.EX.1.4', 'Dow Jones Indices', 3),\n", " ('F.EX.1.5', 'Dow Jones Global Indices', 3),\n", " ('F.EX.1.6', 'Dow Jones US Corporate Bond Indices', 3),\n", " ('F.EX.1.7', 'Global Index Feed (ICE / NYSE)', 3),\n", " ('F.EX.1.8', 'ICE Data Indices', 3),\n", " ('F.EX.1.9', 'NASDAQ Stock Exchange Indices', 3),\n", " ('F.EX.1.10', 'New York Stock Exchange ETF Indices', 3),\n", " ('F.EX.1.11', 'MSCI EOD Indices', 3),\n", " ('F.EX.1.12', 'MSCI Intraday Indices', 3),\n", " ('F.EX.1.13', 'OPRA Indices', 3),\n", " ('F.EX.1.14', 'Russell Indices', 3),\n", " ('F.EX.1.15', 'S&P Indices (CME Sourced)', 3),\n", " ('F.EX.1.16', 'Market Statistics', 3),\n", " ('F.EX.2', 'U.S. Futures', 2),\n", " ('F.EX.2.0', 'Cboe Futures', 3),\n", " ('F.EX.2.1', 'Chicago Board of Trade', 3),\n", " ('F.EX.2.2', 'Chicago Mercantile', 3),\n", " ('F.EX.2.3', 'CBOT Globex', 3),\n", " ('F.EX.2.4', 'CME Globex', 3),\n", " ('F.EX.2.5', 'COMEX Globex', 3),\n", " ('F.EX.2.6', 'NYMEX Globex', 3),\n", " ('F.EX.2.7', 'Comex Metals', 3),\n", " ('F.EX.2.8', 'ICE Futures US', 3),\n", " ('F.EX.2.9', 'ICE US Financial Global LNG', 3),\n", " ('F.EX.2.10', 'Minneapolis Grain Exchange', 3),\n", " ('F.EX.2.11', 'New York Mercantile', 3),\n", " ('F.EX.2.12', 'S&P Indices (CME Sourced)', 3),\n", " ('F.EX.2.13', 'The Small Exchange', 3),\n", " ('F.EX.3', 'Canada Securities', 2),\n", " ('F.EX.3.0', 'Aequitas Listed', 3),\n", " ('F.EX.3.1', 'Canadian Securities Exchange', 3),\n", " ('F.EX.3.2', 'Canadian Mutual Funds (Cannex)', 3),\n", " ('F.EX.3.3', 'CanDeal Benchmark Treasuries', 3),\n", " ('F.EX.3.4', 'ICE Futures US - Canadian Grains', 3),\n", " ('F.EX.3.5', 'Montreal Futures Exchange', 3),\n", " ('F.EX.3.6', 'Toronto Stock Exchange (TSX)', 3),\n", " ('F.EX.3.7', 'TSX Venture Exchange (TSXV)', 3),\n", " ('F.EX.4', 'Mexico / So. America Securities', 2),\n", " ('F.EX.4.0', 'Brazil SOMA', 3),\n", " ('F.EX.4.1', 'Bovespa Stock Exchange', 3),\n", " ('F.EX.4.2', 'Bolsa de Mercadorias & Futuros (BMF)', 3),\n", " ('F.EX.4.3', 'Buenos Aires Stock Exchange', 3),\n", " ('F.EX.4.4', 'Caracas Stock Exchange', 3),\n", " ('F.EX.4.5', 'Colombia Stock Exchange', 3),\n", " ('F.EX.4.6', 'Jamaica Stock Exchange', 3),\n", " ('F.EX.4.7', 'Lima Stock Exchange', 3),\n", " ('F.EX.4.8', 'Matba Rofex Exchange', 3),\n", " ('F.EX.4.9', 'Mexico Derivatives Exchange', 3),\n", " ('F.EX.4.10', 'Mexico Stock Exchange', 3),\n", " ('F.EX.4.11', 'Mexico SE Bonds', 3),\n", " ('F.EX.4.12', 'Santiago Stock Exchange', 3),\n", " ('F.EX.4.13', 'Trinidad & Tobago Stock Exchange', 3),\n", " ('F.EX.5', 'Foreign Exchange, Bonds and Money Rates', 2),\n", " ('F.EX.5.0', 'Blockstream Cryptocurrency', 3),\n", " ('F.EX.5.1', 'CanDeal Benchmark Treasuries', 3),\n", " ('F.EX.5.2', 'EMMI Euribor', 3),\n", " ('F.EX.5.3', 'Foreign Currencies (Forex) & Metals', 3),\n", " ('F.EX.5.4', 'FX Professional', 3),\n", " ('F.EX.5.5', 'Global Treasuries', 3),\n", " ('F.EX.5.6', 'ICE Benchmark Administration (IBA)', 3),\n", " ('F.EX.5.7', 'ICE/LBMA Gold Fixings', 3),\n", " ('F.EX.5.8', 'ICE/LBMA Silver Fixings', 3),\n", " ('F.EX.5.9', 'LME/LBMA Platinum and Palladium Fixings', 3),\n", " ('F.EX.5.10', 'International Money Rates', 3),\n", " ('F.EX.5.11', 'CEP US Agency Debentures', 3),\n", " ('F.EX.5.12', 'CEP US Bank Loans', 3),\n", " ('F.EX.5.13', 'CEP US Corporate High Yield', 3),\n", " ('F.EX.5.14', 'CEP US Corporate Investment Grade', 3),\n", " ('F.EX.5.15', 'CEP US Convertibles', 3),\n", " ('F.EX.5.16', 'CEP US Index Linked Notes', 3),\n", " ('F.EX.5.17', 'CEP US Long Term CDs', 3),\n", " ('F.EX.5.18', 'CEP US MBS Pass Throughs', 3),\n", " ('F.EX.5.19', 'CEP US MBS TBAs', 3),\n", " ('F.EX.5.20', 'CEP US Money Markets', 3),\n", " ('F.EX.5.21', 'CEP US Munis', 3),\n", " ('F.EX.5.22', 'CEP US Municipal Derivatives', 3),\n", " ('F.EX.5.23', 'CEP US Municipal Money Markets', 3),\n", " ('F.EX.5.24', 'CEP US Preferreds', 3),\n", " ('F.EX.5.25', 'CEP US Treasury Bills, Notes and Bonds', 3),\n", " ('F.EX.5.26', 'CEP US Treasury STRIPS', 3),\n", " ('F.EX.5.27', 'CEP European Fixed Income', 3),\n", " ('F.EX.5.28', 'CEP European Money Markets', 3),\n", " ('F.EX.5.29', 'CEP Asian Fixed Income', 3),\n", " ('F.EX.5.30', 'CEP Asian Money Markets', 3),\n", " ('F.EX.5.31', 'CEP Latin American Bonds', 3),\n", " ('F.EX.5.32', 'Listed NYSE Corp. Bonds', 3),\n", " ('F.EX.5.33', 'FINRA Agencies', 3),\n", " ('F.EX.5.34', 'FINRA TRACE Corporate Bonds', 3),\n", " ('F.EX.5.35', 'MSRB Munis', 3),\n", " ('F.EX.5.36', 'MTS Group', 3),\n", " ('F.EX.5.37', 'NIBOR Rates', 3),\n", " ('F.EX.5.38', 'OMX FX Fixings', 3),\n", " ('F.EX.5.39', 'Swiss Reference Rates', 3),\n", " ('F.EX.6', 'Deutsche Boerse, Euronext, LSE', 2),\n", " ('F.EX.6.0', 'Deutsche Boerse Spot Xetra Core', 3),\n", " ('F.EX.6.1', 'Euronext Continental Equities', 3),\n", " ('F.EX.6.2', 'iBoxx EUR Consolidated', 3),\n", " ('F.EX.6.3', 'iBoxx GBP Consolidated', 3),\n", " ('F.EX.6.4', 'LSE International Market Service', 3),\n", " ('F.EX.6.5', 'LSE TRADEcho (BOAT)', 3),\n", " ('F.EX.6.6', 'LSE UK Level 1', 3),\n", " ('F.EX.6.7', 'Tradegate', 3),\n", " ('F.EX.7', 'Europe Futures', 2),\n", " ('F.EX.7.0', 'Athens Derivatives (ATHEX)', 3),\n", " ('F.EX.7.1', 'Baltic Exchange', 3),\n", " ('F.EX.7.2', 'Bucharest Futures', 3),\n", " ('F.EX.7.3', 'Budapest Futures', 3),\n", " ('F.EX.7.4', 'Cboe Europe Futures', 3),\n", " ('F.EX.7.5', 'Eurex', 3),\n", " ('F.EX.7.6', 'Eurex Repo Market', 3),\n", " ('F.EX.7.7', 'Euronext Commodities', 3),\n", " ('F.EX.7.8', 'Euronext Equity & Index Derivatives', 3),\n", " ('F.EX.7.9', 'European Energy Exchange (EEX)', 3),\n", " ('F.EX.7.10', 'European Energy Exchange (EEX) Gas', 3),\n", " ('F.EX.7.11', 'ICE Futures Europe (ICE)', 3),\n", " ('F.EX.7.12', 'ICE Endex', 3),\n", " ('F.EX.7.13', 'ICE Europe Financials', 3),\n", " ('F.EX.7.14', 'Istanbul Futures', 3),\n", " ('F.EX.7.15', 'Italian Derivatives', 3),\n", " ('F.EX.7.16', 'London Metal Exchange', 3),\n", " ('F.EX.7.17', 'MEFF Futures', 3),\n", " ('F.EX.7.18', 'OMX Commodities', 3),\n", " ('F.EX.7.19', 'OMX Futures', 3),\n", " ('F.EX.7.20', 'Warsaw SE Futures', 3),\n", " ('F.EX.8', 'Europe Branded Indices', 2),\n", " ('F.EX.8.0', 'Athens FTSE Indices', 3),\n", " ('F.EX.8.1', 'Cboe Europe Indices', 3),\n", " ('F.EX.8.2', 'DAX Indices & Xetra ETF', 3),\n", " ('F.EX.8.3', 'Deutsche Boerse iBoxx Indices', 3),\n", " ('F.EX.8.4', 'Deutsche Boerse Volatility Indices', 3),\n", " ('F.EX.8.5', 'Euronext All Indices', 3),\n", " ('F.EX.8.6', 'FTSE Index Values', 3),\n", " ('F.EX.8.7', 'FTSE Italia Indices', 3),\n", " ('F.EX.8.8', 'MSCI EOD Indices', 3),\n", " ('F.EX.8.9', 'MSCI Intraday Indices', 3),\n", " ('F.EX.8.10', 'OMX VINX Indices', 3),\n", " ('F.EX.8.11', 'STOXX Indices', 3),\n", " ('F.EX.8.12', 'Swiss Stock Exchange Indices', 3),\n", " ('F.EX.8.13', 'Wiener Borse Vienna Stock Exchange Indices', 3),\n", " ('F.EX.9', 'Nordic Europe Stocks & Indices', 2),\n", " ('F.EX.9.0', 'Nordic Growth Market (NGM)', 3),\n", " ('F.EX.9.1', 'NGM Spotlight', 3),\n", " ('F.EX.9.2', 'OMX Baltic Equities (Riga / Tallinn / Vilnius)', 3),\n", " ('F.EX.9.3', 'OMX Nordic Equities', 3),\n", " ('F.EX.9.4', 'OMX Nordic Fixed Income', 3),\n", " ('F.EX.9.5', 'Oslo Stock Exchange', 3),\n", " ('F.EX.10', 'Other Europe Stocks & Indices', 2),\n", " ('F.EX.10.0', 'Aquis Exchange', 3),\n", " ('F.EX.10.1', 'Aquis AQSE', 3),\n", " ('F.EX.10.2', 'Athens Stock Exchange', 3),\n", " ('F.EX.10.3', 'Belgrade Stock Exchange', 3),\n", " ('F.EX.10.4', 'Bratislava Stock Exchange', 3),\n", " ('F.EX.10.5', 'Bucharest Stock Exchange', 3),\n", " ('F.EX.10.6', 'Budapest Stock Exchange', 3),\n", " ('F.EX.10.7', 'Bulgaria Stock Exchange', 3),\n", " ('F.EX.10.8', 'BX Swiss (Berne)', 3),\n", " ('F.EX.10.9', 'Cboe European Equities (BXE)', 3),\n", " ('F.EX.10.10', 'Cboe European Equities (CXE)', 3),\n", " ('F.EX.10.11', 'Cboe European Equities (DXE)', 3),\n", " ('F.EX.10.12', 'Cyprus Stock Exchange', 3),\n", " ('F.EX.10.13', 'Equiduct', 3),\n", " ('F.EX.10.14', 'Euro TLX', 3),\n", " ('F.EX.10.15', 'Euronext Dublin Exchange', 3),\n", " ('F.EX.10.16', 'Euronext Dublin Bonds & Funds', 3),\n", " ('F.EX.10.17', 'IDCO Real-Time FVIS', 3),\n", " ('F.EX.10.18', 'Istanbul Stock Exchange', 3),\n", " ('F.EX.10.19', 'Istanbul SE Bonds', 3),\n", " ('F.EX.10.20', 'Ljubljana Stock Exchange', 3),\n", " ('F.EX.10.21', 'Luxembourg Stock Exchange', 3),\n", " ('F.EX.10.22', 'Macedonia Stock Exchange', 3),\n", " ('F.EX.10.23', 'Madrid SE Fixed Income', 3),\n", " ('F.EX.10.24', 'Madrid SE Warrants', 3),\n", " ('F.EX.10.25', 'Madrid Stock Exchange', 3),\n", " ('F.EX.10.26', 'Malta Stock Exchange', 3),\n", " ('F.EX.10.27', 'Milan Stock Exchange', 3),\n", " ('F.EX.10.28', 'Milan SE Bonds', 3),\n", " ('F.EX.10.29', 'Prague Stock Exchange', 3),\n", " ('F.EX.10.30', 'Stuttgart Stock Exchange', 3),\n", " ('F.EX.10.31', 'Swiss Exchange', 3),\n", " ('F.EX.10.32', 'Swiss Scoach', 3),\n", " ('F.EX.10.33', 'Swiss Investment Funds', 3),\n", " ('F.EX.10.34', 'TRAX APA Trade', 3),\n", " ('F.EX.10.35', 'Turquoise', 3),\n", " ('F.EX.10.36', 'Warsaw Stock Exchange', 3),\n", " ('F.EX.10.37', 'Wiener Borse Vienna Stock Exchange', 3),\n", " ('F.EX.10.38', 'Wiener Borse Vienna Stock Exchange OTC', 3),\n", " ('F.EX.10.39', 'Zagreb Stock Exchange', 3),\n", " ('F.EX.11', 'Africa Stocks and Futures', 2),\n", " ('F.EX.11.0', 'Botswana Stock Exchange', 3),\n", " ('F.EX.11.1', 'Bourse Regionale des Valeurs Mobilieres', 3),\n", " ('F.EX.11.2', 'Casablanca Stock Exchange', 3),\n", " ('F.EX.11.3', 'Egypt Stock Exchange', 3),\n", " ('F.EX.11.4', 'FTSE JSE Indices', 3),\n", " ('F.EX.11.5', 'Johannesburg Stock Exchange', 3),\n", " ('F.EX.11.6', 'JSE Derivatives (SAFEX)', 3),\n", " ('F.EX.11.7', 'Nairobi Stock Exchange', 3),\n", " ('F.EX.11.8', 'Namibian Stock Exchange', 3),\n", " ('F.EX.11.9', 'Nigerian Stock Exchange', 3),\n", " ('F.EX.11.10', 'Stock Exchange of Mauritius', 3),\n", " ('F.EX.11.11', 'Tunis Stock Exchange', 3),\n", " ('F.EX.12', 'Middle East Stocks and Indices', 2),\n", " ('F.EX.12.0', 'Abu Dhabi Securities Exchange', 3),\n", " ('F.EX.12.1', 'Amman Stock Exchange', 3),\n", " ('F.EX.12.2', 'Bahrain Stock Exchange', 3),\n", " ('F.EX.12.3', 'Dubai Financial Market', 3),\n", " ('F.EX.12.4', 'Kuwait Stock Exchange', 3),\n", " ('F.EX.12.5', 'Muscat Stock Exchange', 3),\n", " ('F.EX.12.6', 'NASDAQ Dubai Stock Exchange', 3),\n", " ('F.EX.12.7', 'Qatar Stock Exchange (Doha)', 3),\n", " ('F.EX.12.8', 'Saudi Arabia Stock Exchange (Tadawul)', 3),\n", " ('F.EX.12.9', 'Tel Aviv Stock Exchange', 3),\n", " ('F.EX.13', 'Middle East Futures', 2),\n", " ('F.EX.13.0', 'Abu Dhabi SE Futures', 3),\n", " ('F.EX.13.1', 'Dubai Financial Market Futures', 3),\n", " ('F.EX.13.2', 'Dubai Gold & Commodities Exchange', 3),\n", " ('F.EX.13.3', 'Dubai Mercantile Exchange (DME)', 3),\n", " ('F.EX.13.4', 'ICE Futures Abu Dhabi', 3),\n", " ('F.EX.13.5', 'NASDAQ Dubai Futures', 3),\n", " ('F.EX.13.6', 'Tel Aviv SE Futures', 3),\n", " ('F.EX.14', 'Asia / Pacific Stocks & Indices', 2),\n", " ('F.EX.14.0', 'Australia Securities Exchange', 3),\n", " ('F.EX.14.1', 'Bombay Stock Exchange', 3),\n", " ('F.EX.14.2', 'Bursa Malaysia', 3),\n", " ('F.EX.14.3', 'Cboe Australia', 3),\n", " ('F.EX.14.4', 'Cboe Japan', 3),\n", " ('F.EX.14.5', 'Colombo Stock Exchange', 3),\n", " ('F.EX.14.6', 'Dhaka Stock Exchange', 3),\n", " ('F.EX.14.7', 'Hanoi Stock Exchange', 3),\n", " ('F.EX.14.8', 'Hanoi UPCoM', 3),\n", " ('F.EX.14.9', 'Ho Chi Minh Stock Exchange', 3),\n", " ('F.EX.14.10', 'Hong Kong Stock Exchange', 3),\n", " ('F.EX.14.11', 'IDCO Real-Time FVIS', 3),\n", " ('F.EX.14.12', 'Indonesia Stock Exchange (fka Jakarta)', 3),\n", " ('F.EX.14.13', 'Japannext B Market', 3),\n", " ('F.EX.14.14', 'Japannext J Market', 3),\n", " ('F.EX.14.15', 'Japannext X Market', 3),\n", " ('F.EX.14.16', 'Japannext U Market', 3),\n", " ('F.EX.14.17', 'Korea Stock Exchange', 3),\n", " ('F.EX.14.18', 'Korea SE Equity Products (ETF)', 3),\n", " ('F.EX.14.19', 'Korea Securities B', 3),\n", " ('F.EX.14.20', 'Nagoya Stock Exchange', 3),\n", " ('F.EX.14.21', 'National Stock Exchange India (NSE)', 3),\n", " ('F.EX.14.22', 'NSE International (IFSC) Equities', 3),\n", " ('F.EX.14.23', 'NSE Wholesale Debt Market', 3),\n", " ('F.EX.14.24', 'New Zealand Stock Exchange', 3),\n", " ('F.EX.14.25', 'Pakistan Stock Exchange', 3),\n", " ('F.EX.14.26', 'Philippines Stock Exchange', 3),\n", " ('F.EX.14.27', 'Shanghai Stock Exchange', 3),\n", " ('F.EX.14.28', 'Shenzhen Stock Exchange', 3),\n", " ('F.EX.14.29', 'Singapore Stock Exchange', 3),\n", " ('F.EX.14.30', 'Taiwan OTC (Gre Tai)', 3),\n", " ('F.EX.14.31', 'Taiwan Stock Exchange', 3),\n", " ('F.EX.14.32', 'Thailand Stock Exchange', 3),\n", " ('F.EX.14.33', 'Tokyo Stock Exchange', 3),\n", " ('F.EX.15', 'Asia / Pacific Futures', 2),\n", " ('F.EX.15.0', 'Australia Securities Exchange Futures', 3),\n", " ('F.EX.15.1', 'Bombay SE Futures', 3),\n", " ('F.EX.15.2', 'Bursa Malaysia Derivatives', 3),\n", " ('F.EX.15.3', 'China Financial Futures', 3),\n", " ('F.EX.15.4', 'Dalian Commodity Exchange', 3),\n", " ('F.EX.15.5', 'Hanoi Derivatives Exchange', 3),\n", " ('F.EX.15.6', 'Hong Kong Futures Exchange', 3),\n", " ('F.EX.15.7', 'ICE Singapore', 3),\n", " ('F.EX.15.8', 'Korea Derivatives', 3),\n", " ('F.EX.15.9', 'Malaysia Rubber Board Exchange', 3),\n", " ('F.EX.15.10', 'Metropolitan SE (fka MCX-SX) Futures', 3),\n", " ('F.EX.15.11', 'Multi Commodity Exchange', 3),\n", " ('F.EX.15.12', 'National Commodity & Derivatives Exchange (NCDEX)', 3),\n", " ('F.EX.15.13', 'New Zealand Futures', 3),\n", " ('F.EX.15.14', 'NSE India Futures', 3),\n", " ('F.EX.15.15', 'NSE International (IFSC) Futures', 3),\n", " ('F.EX.15.16', 'Osaka Commodity Derivatives (fka TOCOM)', 3),\n", " ('F.EX.15.17', 'Osaka JGB Futures', 3),\n", " ('F.EX.15.18', 'Osaka Futures', 3),\n", " ('F.EX.15.19', 'Shanghai Futures', 3),\n", " ('F.EX.15.20', 'Shanghai International Energy (INE)', 3),\n", " ('F.EX.15.21', 'Singapore Futures (SGX)', 3),\n", " ('F.EX.15.22', 'Singapore SGX Commodity', 3),\n", " ('F.EX.15.23', 'Singapore SGX FX', 3),\n", " ('F.EX.15.24', 'Sydney Futures (ASX24)', 3),\n", " ('F.EX.15.25', 'Taiwan Futures Exchange (TAIFEX)', 3),\n", " ('F.EX.15.26', 'Thailand Futures Exchange', 3),\n", " ('F.EX.15.27', 'Tokyo Financial Futures', 3),\n", " ('F.EX.15.28', 'Zhengzhou Commodity Exchange', 3),\n", " ('F.EX.16', 'Asia / Pacific Branded Indices', 2),\n", " ('F.EX.16.0', 'China Exchange Services (CES) Indices', 3),\n", " ('F.EX.16.1', 'FTSE Bursa Malaysia Indices', 3),\n", " ('F.EX.16.2', 'FTSE Singapore Indices', 3),\n", " ('F.EX.16.3', 'Hang Seng Indices', 3),\n", " ('F.EX.16.4', 'JPXI TOPIX Indices', 3),\n", " ('F.EX.16.5', 'Korea Group 2 Indices', 3),\n", " ('F.EX.16.6', 'Nikkei Indices', 3),\n", " ('F.EX.16.7', 'Nikkei / JPX Indices (fka TOCOM)', 3),\n", " ('F.EX.16.8', 'Nikkei Osaka Indices', 3),\n", " ('F.EX.16.9', 'MSCI EOD Indices', 3),\n", " ('F.EX.16.10', 'MSCI Intraday Indices', 3),\n", " ('F.EX.16.11', 'S&P New Zealand Sector Indices', 3),\n", " ('F.EX.17', 'ACER', 2),\n", " ('F.EX.17.0', 'ACER', 3),\n", " ('F.EX.18', 'ADNOC', 2),\n", " ('F.EX.18.0', 'ADNOC', 3),\n", " ('F.EX.19', 'AESO - Alberta Electric System Operator', 2),\n", " ('F.EX.19.0', 'AESO - Alberta Electric System Operator', 3),\n", " ('F.EX.20', 'American Petroleum Institute', 2),\n", " ('F.EX.20.0', 'American Petroleum Institute', 3),\n", " ('F.EX.21', 'Argus', 2),\n", " ('F.EX.21.0', 'Argus Air Daily', 3),\n", " ('F.EX.21.1', 'Argus Americas Asphalt', 3),\n", " ('F.EX.21.2', 'Argus Americas Base Oils', 3),\n", " ('F.EX.21.3', 'Argus Americas Biofuels', 3),\n", " ('F.EX.21.4', 'Argus Americas Crude', 3),\n", " ('F.EX.21.5', 'Argus Ammonia', 3),\n", " ('F.EX.21.6', 'Argus Aromatics Solvents', 3),\n", " ('F.EX.21.7', 'Argus Asia-Pacific Products', 3),\n", " ('F.EX.21.8', 'Argus Base Oils', 3),\n", " ('F.EX.21.9', 'Argus Base Oils Outlook', 3),\n", " ('F.EX.21.10', 'Argus Benzene and Derivatives', 3),\n", " ('F.EX.21.11', 'Argus Benzene Daily', 3),\n", " ('F.EX.21.12', 'Argus Biofuels', 3),\n", " ('F.EX.21.13', 'Argus Biomass Markets', 3),\n", " ('F.EX.21.14', 'Argus Bitumen', 3),\n", " ('F.EX.21.15', 'Argus Butadiene', 3),\n", " ('F.EX.21.16', 'Argus C5 and Hydrocarbon Resins', 3),\n", " ('F.EX.21.17', 'Argus Caspian Markets (English)', 3),\n", " ('F.EX.21.18', 'Argus Caspian Markets (Russian)', 3),\n", " ('F.EX.21.19', 'Argus Caspian Transportation (Russian)', 3),\n", " ('F.EX.21.20', 'Argus China Base Oils', 3),\n", " ('F.EX.21.21', 'Argus China Petroleum', 3),\n", " ('F.EX.21.22', 'Argus Chlor-Alkali and Derivatives', 3),\n", " ('F.EX.21.23', 'Argus Coal Daily', 3),\n", " ('F.EX.21.24', 'Argus Coal Daily International', 3),\n", " ('F.EX.21.25', 'Argus Coal Transportation', 3),\n", " ('F.EX.21.26', 'Argus Crude', 3),\n", " ('F.EX.21.27', 'Argus Crude Expiry Day Bulletin', 3),\n", " ('F.EX.21.28', 'Argus Ethanol Brazil (Portuguese)', 3),\n", " ('F.EX.21.29', 'Argus Ethylene and Derivatives', 3),\n", " ('F.EX.21.30', 'Argus European Electricity', 3),\n", " ('F.EX.21.31', 'Argus European Emissions Markets', 3),\n", " ('F.EX.21.32', 'Argus European Natural Gas', 3),\n", " ('F.EX.21.33', 'Argus European Products', 3),\n", " ('F.EX.21.34', 'Argus Ferrous Markets', 3),\n", " ('F.EX.21.35', 'Argus Fertilizer Brazil', 3),\n", " ('F.EX.21.36', 'Argus Fertilizer Europe', 3),\n", " ('F.EX.21.37', 'Argus Freight', 3),\n", " ('F.EX.21.38', 'Argus FSU Energy', 3),\n", " ('F.EX.21.39', 'Argus Fuels and Octane', 3),\n", " ('F.EX.21.40', 'Argus Fundamentals', 3),\n", " ('F.EX.21.41', 'Argus Global LNG', 3),\n", " ('F.EX.21.42', 'Argus Global Markets', 3),\n", " ('F.EX.21.43', 'Argus Global Waxes', 3),\n", " ('F.EX.21.44', 'Argus Handel', 3),\n", " ('F.EX.21.45', 'Argus International LPG', 3),\n", " ('F.EX.21.46', 'Argus Jet Fuel', 3),\n", " ('F.EX.21.47', 'Argus Latin America Energy', 3),\n", " ('F.EX.21.48', 'Argus Latin Markets', 3),\n", " ('F.EX.21.49', 'Argus LNG Daily', 3),\n", " ('F.EX.21.50', 'Argus LPG World', 3),\n", " ('F.EX.21.51', 'Argus Marine Fuels', 3),\n", " ('F.EX.21.52', 'Argus Metal Prices', 3),\n", " ('F.EX.21.53', 'Argus Metals International', 3),\n", " ('F.EX.21.54', 'Argus Methanol', 3),\n", " ('F.EX.21.55', 'Argus Methanol Daily', 3),\n", " ('F.EX.21.56', 'Argus Mexico Fuel Markets', 3),\n", " ('F.EX.21.57', 'Argus Middle East Gulf and Indian Ocean Products', 3),\n", " ('F.EX.21.58', 'Argus Natural Gas Americas', 3),\n", " ('F.EX.21.59', 'Argus Neftetransport', 3),\n", " ('F.EX.21.60', 'Argus NGL Americas', 3),\n", " ('F.EX.21.61', 'Argus Nitrogen', 3),\n", " ('F.EX.21.62', 'Argus North American Fertilizer', 3),\n", " ('F.EX.21.63', 'Argus North American Sulphur', 3),\n", " ('F.EX.21.64', 'Argus NPKs', 3),\n", " ('F.EX.21.65', 'Argus Petrochemicals', 3),\n", " ('F.EX.21.66', 'Argus Petroleum', 3),\n", " ('F.EX.21.67', 'Argus Petroleum Coke', 3),\n", " ('F.EX.21.68', 'Argus Petroleum Transportation North America', 3),\n", " ('F.EX.21.69', 'Argus Phosphates', 3),\n", " ('F.EX.21.70', 'Argus Polymers', 3),\n", " ('F.EX.21.71', 'Argus Potash', 3),\n", " ('F.EX.21.72', 'Argus Propylene and Derivatives', 3),\n", " ('F.EX.21.73', 'Argus Russian Coal', 3),\n", " ('F.EX.21.74', 'Argus Russian Crude Exports', 3),\n", " ('F.EX.21.75', 'Argus Russian Domestic Crude Market', 3),\n", " ('F.EX.21.76', 'Argus Russian Fertilizer Netbacks', 3),\n", " ('F.EX.21.77', 'Argus Russian Fuel Oil', 3),\n", " ('F.EX.21.78', 'Argus Russian Generation Fuels and Power', 3),\n", " ('F.EX.21.79', 'Argus Russian LPG and Condensate', 3),\n", " ('F.EX.21.80', 'Argus Russian Motor Fuels', 3),\n", " ('F.EX.21.81', 'Argus Russian Product Exports', 3),\n", " ('F.EX.21.82', 'Argus Seaborne Thermal Coal Outlook', 3),\n", " ('F.EX.21.83', 'Argus Spot Ticker Benchmark Data', 3),\n", " ('F.EX.21.84', 'Argus Sulphur', 3),\n", " ('F.EX.21.85', 'Argus Sulphuric Acid', 3),\n", " ('F.EX.21.86', 'Argus Toluene and Xylenes Daily', 3),\n", " ('F.EX.21.87', 'Argus Toluene, Xylenes and Isomers/PET', 3),\n", " ('F.EX.21.88', 'Argus Turkish Energy Markets', 3),\n", " ('F.EX.21.89', 'Argus Ukrainian Motor Fuels', 3),\n", " ('F.EX.21.90', 'Argus US Electricity', 3),\n", " ('F.EX.21.91', 'Argus US Products', 3),\n", " ('F.EX.21.92', 'Argus West Africa Oil', 3),\n", " ('F.EX.21.93', 'Argus/Coalindo Indonesian Coal Index Report', 3),\n", " ('F.EX.21.94', 'Argus/IHS McCloskey Coking Coal Price Index', 3),\n", " ('F.EX.21.95', \"Argus/McCloskey's Coal Price Index Report\", 3),\n", " ('F.EX.22', 'Argus Forward Curves', 2),\n", " ('F.EX.22.0', 'Argus Forward Curves', 3),\n", " ('F.EX.23', 'Baker Hughes Rig Counts', 2),\n", " ('F.EX.23.0', 'Baker Hughes Rig Counts', 3),\n", " ('F.EX.24', 'CFTC Commitment of Traders', 2),\n", " ('F.EX.24.0', 'CFTC Commitment of Traders', 3),\n", " ('F.EX.25', 'CMA Calculations', 2),\n", " ('F.EX.25.0', 'CMA Calculations', 3),\n", " ('F.EX.26', 'Commodity3', 2),\n", " ('F.EX.26.0', 'Commodity3', 3),\n", " ('F.EX.27', 'Criterion Research', 2),\n", " ('F.EX.27.0', 'Criterion Research', 3),\n", " ('F.EX.28', 'EIA Data Sets', 2),\n", " ('F.EX.28.0', 'EIA Data Sets', 3),\n", " ('F.EX.29', 'EIA Statistics', 2),\n", " ('F.EX.29.0', 'EIA Statistics', 3),\n", " ('F.EX.30', 'FRED', 2),\n", " ('F.EX.30.0', 'FRED', 3),\n", " ('F.EX.31', 'General Index', 2),\n", " ('F.EX.31.0', 'General Index', 3),\n", " ('F.EX.32', 'GIE - Gas Infrastructure Europe', 2),\n", " ('F.EX.32.0', 'GIE - Gas Infrastructure Europe', 3),\n", " ('F.EX.33', 'ICE Data Services', 2),\n", " ('F.EX.33.0', 'ICE Data Services', 3),\n", " ('F.EX.34', 'ICE Fundamentals', 2),\n", " ('F.EX.34.0', 'ICE Fundamentals', 3),\n", " ('F.EX.35', 'ICE Reports', 2),\n", " ('F.EX.35.0', 'ICE Reports', 3),\n", " ('F.EX.36', 'ICIS Heren', 2),\n", " ('F.EX.36.0', 'Energy LNG (ELNG)', 3),\n", " ('F.EX.36.1', 'European Daily Electricity (EDEM)', 3),\n", " ('F.EX.36.2', 'European Spot Gas Market (ESGM)', 3),\n", " ('F.EX.37', 'IEA Refinery Yields', 2),\n", " ('F.EX.37.0', 'IEA Refinery Yields', 3),\n", " ('F.EX.38', 'IIR', 2),\n", " ('F.EX.38.0', 'IIR', 3),\n", " ('F.EX.39', 'Joint Organisations Data Initiative (JODI)', 2),\n", " ('F.EX.39.0', 'Joint Organisations Data Initiative (JODI)', 3),\n", " ('F.EX.40', 'Magellan', 2),\n", " ('F.EX.40.0', 'Magellan', 3),\n", " ('F.EX.41', 'NatGasHub', 2),\n", " ('F.EX.41.0', 'NatGasHub', 3),\n", " ('F.EX.42', 'Natural Gas Exchange', 2),\n", " ('F.EX.42.0', 'Natural Gas Exchange Indices', 3),\n", " ('F.EX.43', 'Natural Gas Intelligence', 2),\n", " ('F.EX.43.0', 'Daily Gas Price Index', 3),\n", " ('F.EX.43.1', 'MidDay Price Alert', 3),\n", " ('F.EX.43.2', 'Weekly Gas Price Index', 3),\n", " ('F.EX.43.3', 'Bidweek Survey', 3),\n", " ('F.EX.43.4', 'Shale Price Index', 3),\n", " ('F.EX.43.5', 'Mexico Natural Gas Prices', 3),\n", " ('F.EX.43.6', 'Sistrangas Summary Flow Data', 3),\n", " ('F.EX.43.7', 'Forward Look', 3),\n", " ('F.EX.44', 'OPEC Monthly Statistics', 2),\n", " ('F.EX.44.0', 'OPEC Monthly Statistics', 3),\n", " ('F.EX.45', 'OPIS', 2),\n", " ('F.EX.45.0', 'OPIS Feedstocks', 3),\n", " ('F.EX.45.0.0', 'OPIS Feedstocks', 4),\n", " ('F.EX.45.1', 'OPIS North America LP', 3),\n", " ('F.EX.45.1.0', 'OPIS LP - Mt. Belvieu TET', 4),\n", " ('F.EX.45.1.1', 'OPIS LP - Mt. Belvieu Non-TET', 4),\n", " ('F.EX.45.1.2', 'OPIS LP - Mt. Belvieu Other', 4),\n", " ('F.EX.45.1.3', 'OPIS LP - Conway / Bushton', 4),\n", " ('F.EX.45.1.4', 'OPIS LP - Hattiesburg', 4),\n", " ('F.EX.45.1.5', 'OPIS LP - Canada', 4),\n", " ('F.EX.45.1.6', 'OPIS LP - California', 4),\n", " ('F.EX.45.1.7', 'OPIS LP - Geismer / Sorrento', 4),\n", " ('F.EX.45.1.8', 'OPIS LP - Napoleonville', 4),\n", " ('F.EX.45.2', 'OPIS West Coast Spots', 3),\n", " ('F.EX.45.2.0', 'OPIS Spots - Los Angeles', 4),\n", " ('F.EX.45.2.1', 'OPIS Spots - San Francisco', 4),\n", " ('F.EX.45.2.2', 'OPIS Spots - Pacific Northwest', 4),\n", " ('F.EX.45.2.3', 'OPIS Spots - California', 4),\n", " ('F.EX.45.3', 'OPIS East of Rockies Spots', 3),\n", " ('F.EX.45.3.0', 'OPIS Spots New York', 4),\n", " ('F.EX.45.3.1', 'OPIS Spots Gulf Coast', 4),\n", " ('F.EX.45.3.2', 'OPIS Spots Chicago', 4),\n", " ('F.EX.45.3.3', 'OPIS Spots Dallas', 4),\n", " ('F.EX.45.3.4', 'OPIS Spots Group 3', 4),\n", " ('F.EX.45.3.5', 'OPIS Spots Nebraska', 4),\n", " ('F.EX.45.3.6', 'OPIS Spots Tampa', 4),\n", " ('F.EX.45.4', 'OPIS US RINS', 3),\n", " ('F.EX.45.4.0', 'OPIS US RINS', 4),\n", " ('F.EX.45.5', 'OPIS NGL Forwards', 3),\n", " ('F.EX.45.5.0', 'OPIS NGL Forwards', 4),\n", " ('F.EX.45.6', 'OPIS Racks', 3),\n", " ('F.EX.45.6.0', 'AK', 4),\n", " ('F.EX.45.6.0.0', 'Anchorage', 5),\n", " ('F.EX.45.6.0.1', 'Fairbanks', 5),\n", " ('F.EX.45.6.1', 'AL', 4),\n", " ('F.EX.45.6.1.0', 'Anniston/Oxford', 5),\n", " ('F.EX.45.6.1.1', 'Birmingham', 5),\n", " ('F.EX.45.6.1.2', 'Boligee', 5),\n", " ('F.EX.45.6.1.3', 'Mobile', 5),\n", " ('F.EX.45.6.1.4', 'Montgomery', 5),\n", " ('F.EX.45.6.1.5', 'Sheffield', 5),\n", " ('F.EX.45.6.2', 'AR', 4),\n", " ('F.EX.45.6.2.0', 'El Dorado', 5),\n", " ('F.EX.45.6.2.1', 'Ft. Smith', 5),\n", " ('F.EX.45.6.2.2', 'Jonesboro', 5),\n", " ('F.EX.45.6.2.3', 'Little Rock', 5),\n", " ('F.EX.45.6.2.4', 'Rogers', 5),\n", " ('F.EX.45.6.2.5', 'West Memphis', 5),\n", " ('F.EX.45.6.3', 'AZ', 4),\n", " ('F.EX.45.6.3.0', 'Phoenix', 5),\n", " ('F.EX.45.6.3.1', 'Tucson', 5),\n", " ('F.EX.45.6.4', 'CA', 4),\n", " ('F.EX.45.6.4.0', 'Bakersfield', 5),\n", " ('F.EX.45.6.4.1', 'Barstow', 5),\n", " ('F.EX.45.6.4.2', 'Brisbane', 5),\n", " ('F.EX.45.6.4.3', 'Carson', 5),\n", " ('F.EX.45.6.4.4', 'Chico', 5),\n", " ('F.EX.45.6.4.5', 'Colton', 5),\n", " ('F.EX.45.6.4.6', 'Eureka', 5),\n", " ('F.EX.45.6.4.7', 'Fresno', 5),\n", " ('F.EX.45.6.4.8', 'Fremont', 5),\n", " ('F.EX.45.6.4.9', 'Imperial', 5),\n", " ('F.EX.45.6.4.10', 'Los Angeles', 5),\n", " ('F.EX.45.6.4.11', 'Los Angeles Proper', 5),\n", " ('F.EX.45.6.4.12', 'Montebello', 5),\n", " ('F.EX.45.6.4.13', 'Orange', 5),\n", " ('F.EX.45.6.4.14', 'Richmond', 5),\n", " ('F.EX.45.6.4.15', 'Sacramento', 5),\n", " ('F.EX.45.6.4.16', 'San Diego', 5),\n", " ('F.EX.45.6.4.17', 'San Francisco', 5),\n", " ('F.EX.45.6.4.18', 'San Jose', 5),\n", " ('F.EX.45.6.4.19', 'Stockton', 5),\n", " ('F.EX.45.6.4.20', 'Van Nuys', 5),\n", " ('F.EX.45.6.4.21', 'Wilmington', 5),\n", " ('F.EX.45.6.5', 'CO', 4),\n", " ('F.EX.45.6.5.0', 'Colorado Springs', 5),\n", " ('F.EX.45.6.5.1', 'Denver', 5),\n", " ('F.EX.45.6.5.2', 'Fountain', 5),\n", " ('F.EX.45.6.5.3', 'Grand Junction', 5),\n", " ('F.EX.45.6.5.4', 'La Junta', 5),\n", " ('F.EX.45.6.6', 'CT', 4),\n", " ('F.EX.45.6.6.0', 'Hartford/Rocky Hill', 5),\n", " ('F.EX.45.6.6.1', 'New Haven', 5),\n", " ('F.EX.45.6.7', 'DE', 4),\n", " ('F.EX.45.6.7.0', 'Wilmington', 5),\n", " ('F.EX.45.6.8', 'FL', 4),\n", " ('F.EX.45.6.8.0', 'Cape Canaveral', 5),\n", " ('F.EX.45.6.8.1', 'Ft. Lauderdale', 5),\n", " ('F.EX.45.6.8.2', 'Jacksonville', 5),\n", " ('F.EX.45.6.8.3', 'Miami', 5),\n", " ('F.EX.45.6.8.4', 'Niceville', 5),\n", " ('F.EX.45.6.8.5', 'Orlando', 5),\n", " ('F.EX.45.6.8.6', 'Panama City', 5),\n", " ('F.EX.45.6.8.7', 'Pensacola', 5),\n", " ('F.EX.45.6.8.8', 'Pt. Everglades', 5),\n", " ('F.EX.45.6.8.9', 'Taft', 5),\n", " ('F.EX.45.6.8.10', 'Tampa', 5),\n", " ('F.EX.45.6.8.11', 'West Palm Beach', 5),\n", " ('F.EX.45.6.9', 'GA', 4),\n", " ('F.EX.45.6.9.0', 'Albany', 5),\n", " ('F.EX.45.6.9.1', 'Americus', 5),\n", " ('F.EX.45.6.9.2', 'Athens', 5),\n", " ('F.EX.45.6.9.3', 'Atlanta', 5),\n", " ('F.EX.45.6.9.4', 'Bainbridge', 5),\n", " ('F.EX.45.6.9.5', 'Chattahoochee', 5),\n", " ('F.EX.45.6.9.6', 'Columbus', 5),\n", " ('F.EX.45.6.9.7', 'Griffin', 5),\n", " ('F.EX.45.6.9.8', 'Macon', 5),\n", " ('F.EX.45.6.9.9', 'Rome', 5),\n", " ('F.EX.45.6.9.10', 'Savannah', 5),\n", " ('F.EX.45.6.10', 'IA', 4),\n", " ('F.EX.45.6.10.0', 'Bettendorf', 5),\n", " ('F.EX.45.6.10.1', 'Council Bluffs', 5),\n", " ('F.EX.45.6.10.2', 'Denison', 5),\n", " ('F.EX.45.6.10.3', 'Des Moines', 5),\n", " ('F.EX.45.6.10.4', 'Dubuque', 5),\n", " ('F.EX.45.6.10.5', 'Ft. Dodge', 5),\n", " ('F.EX.45.6.10.6', 'Ft. Madison', 5),\n", " ('F.EX.45.6.10.7', 'Iowa City', 5),\n", " ('F.EX.45.6.10.8', 'Lemars', 5),\n", " ('F.EX.45.6.10.9', 'Mason Cty/Clr.Lk.', 5),\n", " ('F.EX.45.6.10.10', 'Milford', 5),\n", " ('F.EX.45.6.10.11', 'Ottumwa', 5),\n", " ('F.EX.45.6.10.12', 'Rock Rapids', 5),\n", " ('F.EX.45.6.10.13', 'Sioux City', 5),\n", " ('F.EX.45.6.10.14', 'Waterloo', 5),\n", " ('F.EX.45.6.11', 'ID', 4),\n", " ('F.EX.45.6.11.0', 'Boise', 5),\n", " ('F.EX.45.6.11.1', 'Burley', 5),\n", " ('F.EX.45.6.11.2', 'Pocatello', 5),\n", " ('F.EX.45.6.12', 'IL', 4),\n", " ('F.EX.45.6.12.0', 'Amboy', 5),\n", " ('F.EX.45.6.12.1', 'Argo', 5),\n", " ('F.EX.45.6.12.2', 'Blue Island', 5),\n", " ('F.EX.45.6.12.3', 'Champaign', 5),\n", " ('F.EX.45.6.12.4', 'Chicago', 5),\n", " ('F.EX.45.6.12.5', 'Decatur/Forsythe', 5),\n", " ('F.EX.45.6.12.6', 'Des Plaines', 5),\n", " ('F.EX.45.6.12.7', 'Forestview', 5),\n", " ('F.EX.45.6.12.8', 'Heyworth', 5),\n", " ('F.EX.45.6.12.9', 'Kankakee', 5),\n", " ('F.EX.45.6.12.10', 'Lemont', 5),\n", " ('F.EX.45.6.12.11', 'Lockport', 5),\n", " ('F.EX.45.6.12.12', 'Menard', 5),\n", " ('F.EX.45.6.12.13', 'Mt. Prospect', 5),\n", " ('F.EX.45.6.12.14', 'Norris City', 5),\n", " ('F.EX.45.6.12.15', 'Robinson', 5),\n", " ('F.EX.45.6.12.16', 'Rockford', 5),\n", " ('F.EX.45.6.12.17', 'Wood River', 5),\n", " ('F.EX.45.6.13', 'IN', 4),\n", " ('F.EX.45.6.13.0', 'Evansville', 5),\n", " ('F.EX.45.6.13.1', 'Evansville Proper', 5),\n", " ('F.EX.45.6.13.2', 'Hammond', 5),\n", " ('F.EX.45.6.13.3', 'Huntington', 5),\n", " ('F.EX.45.6.13.4', 'Indianapolis', 5),\n", " ('F.EX.45.6.13.5', 'Logansport', 5),\n", " ('F.EX.45.6.13.6', 'Muncie', 5),\n", " ('F.EX.45.6.13.7', 'Peru', 5),\n", " ('F.EX.45.6.13.8', 'Princeton', 5),\n", " ('F.EX.45.6.13.9', 'Seymour', 5),\n", " ('F.EX.45.6.13.10', 'Switz', 5),\n", " ('F.EX.45.6.14', 'KS', 4),\n", " ('F.EX.45.6.14.0', 'Coffeyville', 5),\n", " ('F.EX.45.6.14.1', 'Concordia', 5),\n", " ('F.EX.45.6.14.2', 'El Dorado', 5),\n", " ('F.EX.45.6.14.3', 'Great Bend', 5),\n", " ('F.EX.45.6.14.4', 'Hutchinson', 5),\n", " ('F.EX.45.6.14.5', 'KC/Magellan', 5),\n", " ('F.EX.45.6.14.6', 'KC/Sugar Creek', 5),\n", " ('F.EX.45.6.14.7', 'Kansas City', 5),\n", " ('F.EX.45.6.14.8', 'McPherson', 5),\n", " ('F.EX.45.6.14.9', 'Olathe', 5),\n", " ('F.EX.45.6.14.10', 'Salina', 5),\n", " ('F.EX.45.6.14.11', 'Scott City', 5),\n", " ('F.EX.45.6.14.12', 'Topeka', 5),\n", " ('F.EX.45.6.14.13', 'Wathena', 5),\n", " ('F.EX.45.6.14.14', 'Wichita', 5),\n", " ('F.EX.45.6.15', 'KY', 4),\n", " ('F.EX.45.6.15.0', 'Ashland', 5),\n", " ('F.EX.45.6.15.1', 'Covington', 5),\n", " ('F.EX.45.6.15.2', 'Henderson', 5),\n", " ('F.EX.45.6.15.3', 'Lexington', 5),\n", " ('F.EX.45.6.15.4', 'Louisville', 5),\n", " ('F.EX.45.6.15.5', 'Owensboro', 5),\n", " ('F.EX.45.6.15.6', 'Paducah', 5),\n", " ('F.EX.45.6.16', 'LA', 4),\n", " ('F.EX.45.6.16.0', 'Alexandria', 5),\n", " ('F.EX.45.6.16.1', 'Arcadia', 5),\n", " ('F.EX.45.6.16.2', 'Archie', 5),\n", " ('F.EX.45.6.16.3', 'Baton Rouge', 5),\n", " ('F.EX.45.6.16.4', 'Chalmette', 5),\n", " ('F.EX.45.6.16.5', 'Convent/Garyville', 5),\n", " ('F.EX.45.6.16.6', 'Lake Charles', 5),\n", " ('F.EX.45.6.16.7', 'Monroe', 5),\n", " ('F.EX.45.6.16.8', 'New Orleans', 5),\n", " ('F.EX.45.6.16.9', 'Opelousas', 5),\n", " ('F.EX.45.6.16.10', 'Shreveport', 5),\n", " ('F.EX.45.6.17', 'MA', 4),\n", " ('F.EX.45.6.17.0', 'Boston', 5),\n", " ('F.EX.45.6.17.1', 'Braintree', 5),\n", " ('F.EX.45.6.17.2', 'Chelsea', 5),\n", " ('F.EX.45.6.17.3', 'Everett', 5),\n", " ('F.EX.45.6.17.4', 'Revere', 5),\n", " ('F.EX.45.6.17.5', 'Springfield', 5),\n", " ('F.EX.45.6.18', 'MD', 4),\n", " ('F.EX.45.6.18.0', 'Baltimore', 5),\n", " ('F.EX.45.6.18.1', 'Salisbury', 5),\n", " ('F.EX.45.6.19', 'ME', 4),\n", " ('F.EX.45.6.19.0', 'Bangor', 5),\n", " ('F.EX.45.6.19.1', 'Bar Harbor', 5),\n", " ('F.EX.45.6.19.2', 'Portland', 5),\n", " ('F.EX.45.6.19.3', 'Searsport', 5),\n", " ('F.EX.45.6.20', 'MI', 4),\n", " ('F.EX.45.6.20.0', 'Albion', 5),\n", " ('F.EX.45.6.20.1', 'Bay City', 5),\n", " ('F.EX.45.6.20.2', 'Cheboygan', 5),\n", " ('F.EX.45.6.20.3', 'Detroit', 5),\n", " ('F.EX.45.6.20.4', 'Detroit Proper', 5),\n", " ('F.EX.45.6.20.5', 'Ferrysburg', 5),\n", " ('F.EX.45.6.20.6', 'Flint', 5),\n", " ('F.EX.45.6.20.7', 'Holland', 5),\n", " ('F.EX.45.6.20.8', 'Jackson', 5),\n", " ('F.EX.45.6.20.9', 'Lansing', 5),\n", " ('F.EX.45.6.20.10', 'Marshall', 5),\n", " ('F.EX.45.6.20.11', 'Muskegon', 5),\n", " ('F.EX.45.6.20.12', 'Niles', 5),\n", " ('F.EX.45.6.20.13', 'Novi', 5),\n", " ('F.EX.45.6.20.14', 'River Rouge', 5),\n", " ('F.EX.45.6.20.15', 'Romulus', 5),\n", " ('F.EX.45.6.20.16', 'Taylor', 5),\n", " ('F.EX.45.6.21', 'MN', 4),\n", " ('F.EX.45.6.21.0', 'Alexandria', 5),\n", " ('F.EX.45.6.21.1', 'Duluth', 5),\n", " ('F.EX.45.6.21.2', 'Duluth/Esko', 5),\n", " ('F.EX.45.6.21.3', 'Duluth/Wrenshall', 5),\n", " ('F.EX.45.6.21.4', 'Mankato', 5),\n", " ('F.EX.45.6.21.5', 'Marshall', 5),\n", " ('F.EX.45.6.21.6', 'Minneapolis', 5),\n", " ('F.EX.45.6.21.7', 'Moorhead', 5),\n", " ('F.EX.45.6.21.8', 'Pn Bnd/FlntHlsRs', 5),\n", " ('F.EX.45.6.21.9', 'Rochester', 5),\n", " ('F.EX.45.6.21.10', 'Roseville/Magellan', 5),\n", " ('F.EX.45.6.21.11', 'Rsvile/FlntHlsRs', 5),\n", " ('F.EX.45.6.21.12', 'Sauk Centre', 5),\n", " ('F.EX.45.6.21.13', 'St. Paul/Marathon', 5),\n", " ('F.EX.45.6.22', 'MO', 4),\n", " ('F.EX.45.6.22.0', 'Cape Girardeau', 5),\n", " ('F.EX.45.6.22.1', 'Carrollton', 5),\n", " ('F.EX.45.6.22.2', 'Carthage', 5),\n", " ('F.EX.45.6.22.3', 'Columbia', 5),\n", " ('F.EX.45.6.22.4', 'Jefferson City', 5),\n", " ('F.EX.45.6.22.5', 'Mt. Vernon', 5),\n", " ('F.EX.45.6.22.6', 'Palmyra', 5),\n", " ('F.EX.45.6.22.7', 'Springfield', 5),\n", " ('F.EX.45.6.22.8', 'St. Louis', 5),\n", " ('F.EX.45.6.23', 'MS', 4),\n", " ('F.EX.45.6.23.0', 'Aberdeen', 5),\n", " ('F.EX.45.6.23.1', 'Collins', 5),\n", " ('F.EX.45.6.23.2', 'Greenville', 5),\n", " ('F.EX.45.6.23.3', 'Meridian', 5),\n", " ('F.EX.45.6.23.4', 'Natchez', 5),\n", " ('F.EX.45.6.23.5', 'Pascagoula', 5),\n", " ('F.EX.45.6.23.6', 'Vicksburg', 5),\n", " ('F.EX.45.6.24', 'MT', 4),\n", " ('F.EX.45.6.24.0', 'Billings', 5),\n", " ('F.EX.45.6.24.1', 'Bozeman', 5),\n", " ('F.EX.45.6.24.2', 'Glendive', 5),\n", " ('F.EX.45.6.24.3', 'Great Falls', 5),\n", " ('F.EX.45.6.24.4', 'Helena', 5),\n", " ('F.EX.45.6.24.5', 'Missoula', 5),\n", " ('F.EX.45.6.25', 'NC', 4),\n", " ('F.EX.45.6.25.0', 'Charlotte', 5),\n", " ('F.EX.45.6.25.1', 'Fayetteville', 5),\n", " ('F.EX.45.6.25.2', 'Greensboro', 5),\n", " ('F.EX.45.6.25.3', 'Raleigh/Apex', 5),\n", " ('F.EX.45.6.25.4', 'Selma', 5),\n", " ('F.EX.45.6.25.5', 'Wilmington', 5),\n", " ('F.EX.45.6.26', 'ND', 4),\n", " ('F.EX.45.6.26.0', 'Bismarck/Mandan', 5),\n", " ('F.EX.45.6.26.1', 'Dickinson', 5),\n", " ('F.EX.45.6.26.2', 'Fargo', 5),\n", " ('F.EX.45.6.26.3', 'Grand Forks', 5),\n", " ('F.EX.45.6.26.4', 'Jamestown', 5),\n", " ('F.EX.45.6.26.5', 'Minot', 5),\n", " ('F.EX.45.6.27', 'NE', 4),\n", " ('F.EX.45.6.27.0', 'Columbus', 5),\n", " ('F.EX.45.6.27.1', 'Doniphan', 5),\n", " ('F.EX.45.6.27.2', 'Geneva', 5),\n", " ('F.EX.45.6.27.3', 'Lincoln', 5),\n", " ('F.EX.45.6.27.4', 'Norfolk', 5),\n", " ('F.EX.45.6.27.5', 'North Platte', 5),\n", " ('F.EX.45.6.27.6', 'Omaha', 5),\n", " ('F.EX.45.6.27.7', 'Osceola', 5),\n", " ('F.EX.45.6.28', 'NH', 4),\n", " ('F.EX.45.6.28.0', 'Newington', 5),\n", " ('F.EX.45.6.29', 'NJ', 4),\n", " ('F.EX.45.6.29.0', 'Elizabeth', 5),\n", " ('F.EX.45.6.29.1', 'Linden', 5),\n", " ('F.EX.45.6.29.2', 'Newark', 5),\n", " ('F.EX.45.6.29.3', 'Newark Proper', 5),\n", " ('F.EX.45.6.29.4', 'Paulsboro', 5),\n", " ('F.EX.45.6.29.5', 'Pennsauken', 5),\n", " ('F.EX.45.6.29.6', 'Sewaren', 5),\n", " ('F.EX.45.6.29.7', 'Trenton', 5),\n", " ('F.EX.45.6.30', 'NM', 4),\n", " ('F.EX.45.6.30.0', 'Albuquerque', 5),\n", " ('F.EX.45.6.30.1', 'Artesia', 5),\n", " ('F.EX.45.6.30.2', 'Bloomfield', 5),\n", " ('F.EX.45.6.30.3', 'Ciniza', 5),\n", " ('F.EX.45.6.30.4', 'Moriarty', 5),\n", " ('F.EX.45.6.31', 'NV', 4),\n", " ('F.EX.45.6.31.0', 'Las Vegas', 5),\n", " ('F.EX.45.6.31.1', 'Sparks/Reno', 5),\n", " ('F.EX.45.6.32', 'NY', 4),\n", " ('F.EX.45.6.32.0', 'Albany', 5),\n", " ('F.EX.45.6.32.1', 'Big Flats', 5),\n", " ('F.EX.45.6.32.2', 'Binghamton/Vestal', 5),\n", " ('F.EX.45.6.32.3', 'Bronx', 5),\n", " ('F.EX.45.6.32.4', 'Buffalo', 5),\n", " ('F.EX.45.6.32.5', 'Holtsville', 5),\n", " ('F.EX.45.6.32.6', 'Inwood', 5),\n", " ('F.EX.45.6.32.7', 'Lawrence', 5),\n", " ('F.EX.45.6.32.8', 'Long Island', 5),\n", " ('F.EX.45.6.32.9', 'Mt. Vernon/Westchest', 5),\n", " ('F.EX.45.6.32.10', 'New York', 5),\n", " ('F.EX.45.6.32.11', 'Newburgh', 5),\n", " ('F.EX.45.6.32.12', 'Oyster Bay', 5),\n", " ('F.EX.45.6.32.13', 'Rochester', 5),\n", " ('F.EX.45.6.32.14', 'Syracuse', 5),\n", " ('F.EX.45.6.32.15', 'Utica', 5),\n", " ('F.EX.45.6.33', 'OH', 4),\n", " ('F.EX.45.6.33.0', 'Akron/Canton', 5),\n", " ('F.EX.45.6.33.1', 'Cincinnati', 5),\n", " ('F.EX.45.6.33.2', 'Cleveland', 5),\n", " ('F.EX.45.6.33.3', 'Columbus', 5),\n", " ('F.EX.45.6.33.4', 'Dayton', 5),\n", " ('F.EX.45.6.33.5', 'Greenville', 5),\n", " ('F.EX.45.6.33.6', 'Heath', 5),\n", " ('F.EX.45.6.33.7', 'Lebanon', 5),\n", " ('F.EX.45.6.33.8', 'Lima', 5),\n", " ('F.EX.45.6.33.9', 'Lorain', 5),\n", " ('F.EX.45.6.33.10', 'Marietta', 5),\n", " ('F.EX.45.6.33.11', 'Steubenville', 5),\n", " ('F.EX.45.6.33.12', 'Toledo', 5),\n", " ('F.EX.45.6.33.13', 'Youngstown', 5),\n", " ('F.EX.45.6.34', 'OK', 4),\n", " ('F.EX.45.6.34.0', 'Ardmore', 5),\n", " ('F.EX.45.6.34.1', 'Enid', 5),\n", " ('F.EX.45.6.34.2', 'Oklahoma City', 5),\n", " ('F.EX.45.6.34.3', 'Ponca City', 5),\n", " ('F.EX.45.6.34.4', 'Tulsa', 5),\n", " ('F.EX.45.6.34.5', 'Wynnewood', 5),\n", " ('F.EX.45.6.35', 'OR', 4),\n", " ('F.EX.45.6.35.0', 'Eugene', 5),\n", " ('F.EX.45.6.35.1', 'Portland', 5),\n", " ('F.EX.45.6.35.2', 'Umatilla', 5),\n", " ('F.EX.45.6.36', 'PA', 4),\n", " ('F.EX.45.6.36.0', 'Altoona', 5),\n", " ('F.EX.45.6.36.1', 'Coraopolis', 5),\n", " ('F.EX.45.6.36.2', 'Delmont', 5),\n", " ('F.EX.45.6.36.3', 'Greensburg', 5),\n", " ('F.EX.45.6.36.4', 'Harrisburg', 5),\n", " ('F.EX.45.6.36.5', 'Indianola', 5),\n", " ('F.EX.45.6.36.6', 'Macungie', 5),\n", " ('F.EX.45.6.36.7', 'Midland', 5),\n", " ('F.EX.45.6.36.8', 'Neville Island', 5),\n", " ('F.EX.45.6.36.9', 'Northumberland', 5),\n", " ('F.EX.45.6.36.10', 'Philadelphia', 5),\n", " ('F.EX.45.6.36.11', 'Pittsburgh', 5),\n", " ('F.EX.45.6.36.12', 'Pittsburgh Proper', 5),\n", " ('F.EX.45.6.36.13', 'Scranton', 5),\n", " ('F.EX.45.6.36.14', 'Sinking Springs', 5),\n", " ('F.EX.45.6.36.15', 'Warren', 5),\n", " ('F.EX.45.6.36.16', 'Williamsport', 5),\n", " ('F.EX.45.6.37', 'RI', 4),\n", " ('F.EX.45.6.37.0', 'Providence', 5),\n", " ('F.EX.45.6.38', 'SC', 4),\n", " ('F.EX.45.6.38.0', 'Belton', 5),\n", " ('F.EX.45.6.38.1', 'Charleston', 5),\n", " ('F.EX.45.6.38.2', 'North Augusta', 5),\n", " ('F.EX.45.6.38.3', 'Spartanburg', 5),\n", " ('F.EX.45.6.39', 'SD', 4),\n", " ('F.EX.45.6.39.0', 'Aberdeen', 5),\n", " ('F.EX.45.6.39.1', 'Mitchell', 5),\n", " ('F.EX.45.6.39.2', 'Pierre', 5),\n", " ('F.EX.45.6.39.3', 'Rapid City', 5),\n", " ('F.EX.45.6.39.4', 'Sioux Falls', 5),\n", " ('F.EX.45.6.39.5', 'Watertown', 5),\n", " ('F.EX.45.6.39.6', 'Wolsey', 5),\n", " ('F.EX.45.6.39.7', 'Yankton', 5),\n", " ('F.EX.45.6.40', 'TN', 4),\n", " ('F.EX.45.6.40.0', 'Chattanooga', 5),\n", " ('F.EX.45.6.40.1', 'Greenville', 5),\n", " ('F.EX.45.6.40.2', 'Knoxville', 5),\n", " ('F.EX.45.6.40.3', 'Memphis', 5),\n", " ('F.EX.45.6.40.4', 'Nashville', 5),\n", " ('F.EX.45.6.41', 'TX', 4),\n", " ('F.EX.45.6.41.0', 'Abilene', 5),\n", " ('F.EX.45.6.41.1', 'Amarillo', 5),\n", " ('F.EX.45.6.41.2', 'Austin', 5),\n", " ('F.EX.45.6.41.3', 'Beaumont', 5),\n", " ('F.EX.45.6.41.4', 'Big Spring', 5),\n", " ('F.EX.45.6.41.5', 'Borger', 5),\n", " ('F.EX.45.6.41.6', 'Bryan', 5),\n", " ('F.EX.45.6.41.7', 'Brownsville', 5),\n", " ('F.EX.45.6.41.8', 'Caddo Mills', 5),\n", " ('F.EX.45.6.41.9', 'Center', 5),\n", " ('F.EX.45.6.41.10', 'Corpus Christi', 5),\n", " ('F.EX.45.6.41.11', 'Dallas Metro', 5),\n", " ('F.EX.45.6.41.12', 'Dallas Proper', 5),\n", " ('F.EX.45.6.41.13', 'Dallas/Aledo', 5),\n", " ('F.EX.45.6.41.14', 'Dallas/Ft. Worth', 5),\n", " ('F.EX.45.6.41.15', 'Dallas/Grapevine', 5),\n", " ('F.EX.45.6.41.16', 'Dallas/Southlake', 5),\n", " ('F.EX.45.6.41.17', 'Edinburg', 5),\n", " ('F.EX.45.6.41.18', 'El Paso', 5),\n", " ('F.EX.45.6.41.19', 'Frost', 5),\n", " ('F.EX.45.6.41.20', 'Harlingen', 5),\n", " ('F.EX.45.6.41.21', 'Hearne', 5),\n", " ('F.EX.45.6.41.22', 'Houston', 5),\n", " ('F.EX.45.6.41.23', 'Laredo', 5),\n", " ('F.EX.45.6.41.24', 'Lubbock', 5),\n", " ('F.EX.45.6.41.25', 'Midland/Odessa', 5),\n", " ('F.EX.45.6.41.26', 'Mt. Pleasant', 5),\n", " ('F.EX.45.6.41.27', 'San Angelo', 5),\n", " ('F.EX.45.6.41.28', 'San Antonio', 5),\n", " ('F.EX.45.6.41.29', 'Sheerin', 5),\n", " ('F.EX.45.6.41.30', 'Three Rivers', 5),\n", " ('F.EX.45.6.41.31', 'Tyler', 5),\n", " ('F.EX.45.6.41.32', 'Victoria/Placedo', 5),\n", " ('F.EX.45.6.41.33', 'Waco', 5),\n", " ('F.EX.45.6.41.34', 'Waskom', 5),\n", " ('F.EX.45.6.41.35', 'Wichita Falls', 5),\n", " ('F.EX.45.6.42', 'UT', 4),\n", " ('F.EX.45.6.42.0', 'Cedar City', 5),\n", " ('F.EX.45.6.42.1', 'Salt Lake City', 5),\n", " ('F.EX.45.6.43', 'VA', 4),\n", " ('F.EX.45.6.43.0', 'Fairfax', 5),\n", " ('F.EX.45.6.43.1', 'Norfolk', 5),\n", " ('F.EX.45.6.43.2', 'Richmond', 5),\n", " ('F.EX.45.6.43.3', 'Roanoke', 5),\n", " ('F.EX.45.6.43.4', 'Yorktown', 5),\n", " ('F.EX.45.6.44', 'VT', 4),\n", " ('F.EX.45.6.44.0', 'Burlington', 5),\n", " ('F.EX.45.6.44.1', 'Rutland', 5),\n", " ('F.EX.45.6.45', 'WA', 4),\n", " ('F.EX.45.6.45.0', 'Anacortes', 5),\n", " ('F.EX.45.6.45.1', 'Moses Lake', 5),\n", " ('F.EX.45.6.45.2', 'Pasco', 5),\n", " ('F.EX.45.6.45.3', 'Seattle', 5),\n", " ('F.EX.45.6.45.4', 'Spokane', 5),\n", " ('F.EX.45.6.45.5', 'Tacoma', 5),\n", " ('F.EX.45.6.46', 'WI', 4),\n", " ('F.EX.45.6.46.0', 'Chippewa Falls', 5),\n", " ('F.EX.45.6.46.1', 'Green Bay', 5),\n", " ('F.EX.45.6.46.2', 'Junction City', 5),\n", " ('F.EX.45.6.46.3', 'Madison', 5),\n", " ('F.EX.45.6.46.4', 'Milwaukee', 5),\n", " ('F.EX.45.6.46.5', 'Superior', 5),\n", " ('F.EX.45.6.46.6', 'Waupun', 5),\n", " ('F.EX.45.6.47', 'WV', 4),\n", " ('F.EX.45.6.47.0', 'Charleston', 5),\n", " ('F.EX.45.6.48', 'WY', 4),\n", " ('F.EX.45.6.48.0', 'Casper', 5),\n", " ('F.EX.45.6.48.1', 'Cheyenne', 5),\n", " ('F.EX.45.6.48.2', 'New Castle', 5),\n", " ('F.EX.45.6.48.3', 'Rock Springs', 5),\n", " ('F.EX.45.6.48.4', 'Sheridan', 5),\n", " ('F.EX.45.6.48.5', 'Sinclair', 5),\n", " ('F.EX.46', 'PJK by Insights Global', 2),\n", " ('F.EX.46.0', 'PJK by Insights Global', 3),\n", " ('F.EX.47', 'Platts', 2),\n", " ('F.EX.47.0', 'Platts Market Data', 3),\n", " ('F.EX.47.0.0', 'Agriculture', 4),\n", " ('F.EX.47.0.0.0', 'Biofuels (BF)', 5),\n", " ('F.EX.47.0.0.1', 'Biofuels Non-Platts Data (BX)', 5),\n", " ('F.EX.47.0.0.2', 'Grains Corn (GRC)', 5),\n", " ('F.EX.47.0.0.3', 'Grains Dry Bulk (GRY)', 5),\n", " ('F.EX.47.0.0.4', 'Grains Wheat (GRW)', 5),\n", " ('F.EX.47.0.0.5', 'Sugar (SG)', 5),\n", " ('F.EX.47.0.0.6', 'Sugar Freight (SY)', 5),\n", " ('F.EX.47.0.0.7', 'Sugar Non-Platts Data (SP)', 5),\n", " ('F.EX.47.0.1', 'Bunkers', 4),\n", " ('F.EX.47.0.1.0', 'Bunkers (BA)', 5),\n", " ('F.EX.47.0.1.1', 'Bunkers: Latin America (BL)', 5),\n", " ('F.EX.47.0.2', 'Coal', 4),\n", " ('F.EX.47.0.2.0', 'Dry Bulk Freight (CRY)', 5),\n", " ('F.EX.47.0.2.1', 'International + US Export Prices (CI)', 5),\n", " ('F.EX.47.0.2.2', 'Metallurgical Coal (MC)', 5),\n", " ('F.EX.47.0.2.3', 'Misc Non-Platts Data (HX)', 5),\n", " ('F.EX.47.0.2.4', 'Thermal Coal Fundamental Data (CTA)', 5),\n", " ('F.EX.47.0.2.5', 'US Daily Assmts + Weekly Indexes (CO)', 5),\n", " ('F.EX.47.0.3', 'Crude Netbacks', 4),\n", " ('F.EX.47.0.3.0', 'Caribbean (NJ)', 5),\n", " ('F.EX.47.0.3.1', 'Europe ARA (NW)', 5),\n", " ('F.EX.47.0.3.2', 'Freight Rates (NP)', 5),\n", " ('F.EX.47.0.3.3', 'Italy (NQ)', 5),\n", " ('F.EX.47.0.3.4', 'Singapore (NX)', 5),\n", " ('F.EX.47.0.3.5', 'US East Coast (NV)', 5),\n", " ('F.EX.47.0.3.6', 'US Gulf Coast (NM)', 5),\n", " ('F.EX.47.0.3.7', 'US Midwest (NK)', 5),\n", " ('F.EX.47.0.3.8', 'US West Coast (NT)', 5),\n", " ('F.EX.47.0.4', 'Crude Postings', 4),\n", " ('F.EX.47.0.4.0', 'Canadian (PA)', 5),\n", " ('F.EX.47.0.4.1', 'Official Selling Prices (OS)', 5),\n", " ('F.EX.47.0.4.2', 'US (PC)', 5),\n", " ('F.EX.47.0.5', 'Crude Yields', 4),\n", " ('F.EX.47.0.5.0', 'Caribbean (YC)', 5),\n", " ('F.EX.47.0.5.1', 'Europe ARA (YR)', 5),\n", " ('F.EX.47.0.5.2', 'Italy (YI)', 5),\n", " ('F.EX.47.0.5.3', 'Singapore (YS)', 5),\n", " ('F.EX.47.0.5.4', 'US East Coast (YN)', 5),\n", " ('F.EX.47.0.5.5', 'US Gulf Coast (YH)', 5),\n", " ('F.EX.47.0.5.6', 'US Mid-Continent (YU)', 5),\n", " ('F.EX.47.0.5.7', 'US West Coast (YL)', 5),\n", " ('F.EX.47.0.6', 'Crudes', 4),\n", " ('F.EX.47.0.6.0', 'At 14:15 Houston (RU)', 5),\n", " ('F.EX.47.0.6.1', 'At 16:30 London (RI)', 5),\n", " ('F.EX.47.0.6.2', 'At 16:30 Singapore (RP)', 5),\n", " ('F.EX.47.0.6.3', 'Canadian (RC)', 5),\n", " ('F.EX.47.0.6.4', 'Feeders - Weekly (RW)', 5),\n", " ('F.EX.47.0.6.5', 'Latin America (CL)', 5),\n", " ('F.EX.47.0.6.6', 'Market Parity Prices (MPP)', 5),\n", " ('F.EX.47.0.6.7', 'Russian Domestic Market (RA)', 5),\n", " ('F.EX.47.0.7', 'Derivatives', 4),\n", " ('F.EX.47.0.7.0', 'Coal (DC)', 5),\n", " ('F.EX.47.0.7.1', 'FtS Americas London Crude (ULC)', 5),\n", " ('F.EX.47.0.7.2', 'FtS Americas London Fuel Oil (ULF)', 5),\n", " ...)" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#See main content filters (sources)\n", "filters = ice.get_search_filters()\n", "filters" ] }, { "cell_type": "code", "execution_count": 4, "id": "9f23f6d8", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(('F.TYP', 'Types', 1),\n", " ('F.TYP.6', 'Fundamental', 2),\n", " ('F.TYP.7', 'Bond', 2),\n", " ('F.TYP.3', 'Spread', 2),\n", " ('F.TYP.1', 'Future Option', 2),\n", " ('F.TYP.8', 'Stock', 2),\n", " ('F.TYP.9', 'Stock Option', 2),\n", " ('F.TYP.2', 'Cash Energy', 2),\n", " ('F.TYP.0', 'Future', 2),\n", " ('F.TYP.10', 'Assessment', 2),\n", " ('F.TYP.4', 'Index', 2),\n", " ('F.TYP.11', 'Fund', 2),\n", " ('F.TYP.5', 'Forex', 2),\n", " ('F.TYP.12', 'ETF', 2),\n", " ('F.TYP.13', 'Treasury', 2))" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#See other filters based on facets, above\n", "filters = ice.get_search_filters('types')\n", "filters" ] }, { "cell_type": "code", "execution_count": 5, "id": "63d27653", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(('BRN 23N-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 23Q-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 23U-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 23V-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 23X-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 23Z-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24F-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24G-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24H-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24J-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24K-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24M-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24N-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24Q-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24U-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24V-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24X-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 24Z-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25F-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25G-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25H-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25J-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25K-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25M-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25N-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25Q-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25U-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25V-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25X-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 25Z-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26F-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26G-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26H-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26J-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26K-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26M-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26N-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26Q-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26U-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26V-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26X-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 26Z-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27F-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27G-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27H-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27J-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27K-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27M-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27N-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27Q-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27U-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27V-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27X-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 27Z-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28F-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28G-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28H-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28J-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28K-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28M-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28N-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28Q-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28U-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28V-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28X-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 28Z-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29F-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29G-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29H-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29J-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29K-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29M-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29N-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29Q-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29U-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29V-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29X-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 29Z-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 30F-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 30G-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 30H-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN #OI-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN #V-ICE', 'Brent Crude Oil', 'ICE', 'Future'),\n", " ('BRN 23NC500-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NP500-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NC600-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NP600-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NC700-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NP700-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NC800-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NP800-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NC900-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NP900-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NC1000-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NP1000-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NC1100-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NP1100-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NC1200-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NP1200-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'),\n", " ('BRN 23NC1300-ICE', 'Brent Crude Oil', 'ICE', 'Future Option'))" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#Search on keyword and filters\n", "results = ice.get_search('brn', rows=100, filters='F.EX.7.11')\n", "results" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.7" } }, "nbformat": 4, "nbformat_minor": 5 }