Skip to main content
fastCRW Pergamon
Finance · US

CFTC Public Reporting

publicreporting.cftc.gov

Commitments of Traders and the CFTC's other public reporting datasets.

Showing the catalogue

1Request

Exact contract-and-exchange label. The Disaggregated report covers physical commodities only; 'CRUDE OIL, LIGHT SWEET - NEW YORK MERCANTILE EXCHANGE' is WTI.

1 credit⌘ ↵
Code follows the fields above
curl "https://api.fastcrw.com/v1/data/cftc/cot-disaggregated-futures?market_and_exchange_names=CRUDE+OIL%2C+LIGHT+SWEET+-+NEW+YORK+MERCANTILE+EXCHANGE" \
  -H "Authorization: Bearer $FASTCRW_API_KEY"

2Response example

A sample shape. Press Run to see live data from CFTC Public Reporting.

JSON
[
  {
    "id": "220201067651F",
    "market_and_exchange_names": "CRUDE OIL, LIGHT SWEET - NEW YORK MERCANTILE EXCHANGE",
    "report_date_as_yyyy_mm_dd": "2022-02-01T00:00:00.000",
    "yyyy_report_week_ww": "2022 Report Week 05",
    "contract_market_name": "WTI-PHYSICAL",
    "cftc_contract_market_code": "067651",
    "cftc_market_code": "NYME",
    "cftc_region_code": "NYC",
    "cftc_commodity_code": "067",
    "commodity_name": "CRUDE OIL",
    "open_interest_all": "2093735",
    "prod_merc_positions_long": "490091",
    "prod_merc_positions_short": "440135",
    "swap_positions_long_all": "107420",
    "swap__positions_short_all": "572034",
    "swap__positions_spread_all": "121691",
    "m_money_positions_long_all": "312271",
    "m_money_positions_short_all": "43136",
    "m_money_positions_spread": "558029",
    "other_rept_positions_long": "175335",
    "other_rept_positions_short": "75566",
    "other_rept_positions_spread": "229151",
    "tot_rept_positions_long_all": "1993988",
    "tot_rept_positions_short": "2039742",
    "nonrept_positions_long_all": "99747",
    "nonrept_positions_short_all": "53993",
    "open_interest_old": "2093735",
    "prod_merc_positions_long_1": "490091",
    "prod_merc_positions_short_1": "440135",
    "swap_positions_long_old": "107420",
    "swap__positions_short_old": "572034",
    "swap__positions_spread_old": "121691",
    "m_money_positions_long_old": "312271",
    "m_money_positions_short_old": "43136",
    "m_money_positions_spread_1": "558029",
    "other_rept_positions_long_1": "175335",
    "other_rept_positions_short_1": "75566",
    "other_rept_positions_spread_1": "229151",
    "tot_rept_positions_long_old": "1993988",
    "tot_rept_positions_short_1": "2039742",
    "nonrept_positions_long_old": "99747",
    "nonrept_positions_short_old": "53993",
    "open_interest_other": "0",
    "prod_merc_positions_long_2": "0",
    "prod_merc_positions_short_2": "0",
    "swap_positions_long_other": "0",
    "swap__positions_short_other": "0",
    "swap__positions_spread_other": "0",
    "m_money_positions_long_other": "0",
    "m_money_positions_short_other": "0",
    "m_money_positions_spread_2": "0",
    "other_rept_positions_long_2": "0",
    "other_rept_positions_short_2": "0",
    "other_rept_positions_spread_2": "0",
    "tot_rept_positions_long_other": "0",
    "tot_rept_positions_short_2": "0",
    "nonrept_positions_long_other": "0",
    "nonrept_positions_short_other": "0",
    "change_in_open_interest_all": "-2259",
    "change_in_prod_merc_long": "-41229",
    "change_in_prod_merc_short": "-38432",
    "change_in_swap_long_all": "-2230",
    "change_in_swap_short_all": "-11015",
    "change_in_swap_spread_all": "12840",
    "change_in_m_money_long_all": "3439",
    "change_in_m_money_short_all": "-1842",
    "change_in_m_money_spread": "30735",
    "change_in_other_rept_long": "-8143",
    "change_in_other_rept_short": "1649",
    "change_in_other_rept_spread": "832",
    "change_in_tot_rept_long_all": "-3756",
    "change_in_tot_rept_short": "-5233",
    "change_in_nonrept_long_all": "1497",
    "change_in_nonrept_short_all": "2974",
    "pct_of_open_interest_all": "100.0",
    "pct_of_oi_prod_merc_long": "23.4",
    "pct_of_oi_prod_merc_short": "21.0",
    "pct_of_oi_swap_long_all": "5.1",
    "pct_of_oi_swap_short_all": "27.3",
    "pct_of_oi_swap_spread_all": "5.8",
    "pct_of_oi_m_money_long_all": "14.9",
    "pct_of_oi_m_money_short_all": "2.1",
    "pct_of_oi_m_money_spread": "26.7",
    "pct_of_oi_other_rept_long": "8.4",
    "pct_of_oi_other_rept_short": "3.6",
    "pct_of_oi_other_rept_spread": "10.9",
    "pct_of_oi_tot_rept_long_all": "95.2",
    "pct_of_oi_tot_rept_short": "97.4",
    "pct_of_oi_nonrept_long_all": "4.8",
    "pct_of_oi_nonrept_short_all": "2.6",
    "pct_of_open_interest_old": "100.0",
    "pct_of_oi_prod_merc_long_1": "23.4",
    "pct_of_oi_prod_merc_short_1": "21.0",
    "pct_of_oi_swap_long_old": "5.1",
    "pct_of_oi_swap_short_old
…truncated

Attribution: Source: U.S. Commodity Futures Trading Commission

Licence: A work of the United States Government, not subject to domestic copyright under 17 U.S.C. 105, published by the agency as open data.

Ask with this source

A prompt for your agent that names this source and how to call it through the crw MCP.

  • COT Disaggregated, futures only

    Use CFTC Public Reporting (cftc) from fastCRW Pergamon, capability "COT Disaggregated, futures only" (cot-disaggregated-futures). You want to separate hedgers from swap dealers and managed money in an energy, metal or agricultural contract - the Legacy report cannot do that. Example options: market_and_exchange_names=CRUDE OIL, LIGHT SWEET - NEW YORK MERCANTILE EXCHANGE. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cftc" and capability "cot-disaggregated-futures". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>

  • COT Traders in Financial Futures, futures only

    Use CFTC Public Reporting (cftc) from fastCRW Pergamon, capability "COT Traders in Financial Futures, futures only" (cot-financial-futures). Your contract is a stock index, interest rate, Treasury or currency future and you want the asset-manager-versus-leveraged-fund split. Example options: market_and_exchange_names=E-MINI S&P 500 - CHICAGO MERCANTILE EXCHANGE. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cftc" and capability "cot-financial-futures". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>

  • COT Legacy, futures and options combined

    Use CFTC Public Reporting (cftc) from fastCRW Pergamon, capability "COT Legacy, futures and options combined" (cot-legacy-combined). You want Legacy COT positioning including options exposure rather than futures alone; history starts 1995. Example options: market_and_exchange_names=GOLD - COMMODITY EXCHANGE INC.. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cftc" and capability "cot-legacy-combined". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>

  • COT Legacy, futures only

    Use CFTC Public Reporting (cftc) from fastCRW Pergamon, capability "COT Legacy, futures only" (cot-legacy-futures). You want the classic commercial-vs-speculator positioning split for a futures contract; this is the COT series with the longest history, back to 1986. Example options: market_and_exchange_names=GOLD - COMMODITY EXCHANGE INC.. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cftc" and capability "cot-legacy-futures". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>