Early access is open. Free sample datasets are live now. Download a sample

Data product · Early access

COT Report Data: CFTC Commitments of Traders

Who is long and who is short in each futures market every week: dealers, asset managers, hedge funds, producers and small traders, in one clean table instead of the CFTC's wide text files.

Coverage

What you get

Item Detail
Product code FUT-POSITIONING
Coverage All three CFTC reports: legacy, disaggregated and Traders in Financial Futures (TFF), futures-only and futures-and-options
Granularity Weekly
History Legacy reports from 1986; disaggregated and TFF from 2006 (the CFTC's own start dates)
Delivery REST and CSV or Parquet files
Update speed Weekly. Positions are as of Tuesday; the CFTC usually publishes on Friday, and we update after release

The CFTC publishes this data for free, but in formats that change between report types and years, with market names instead of tickers. We map each market to our root symbol where one exists (ES, CL, GC), rename the columns once, and keep the full history in one place.

Schema

Schema

Field Type Required Description
symbol string yes Our root where one exists (ES), else the CFTC code
cftc_code string yes CFTC contract market code, e.g. 13874A
market string yes CFTC market name
exchange string yes Exchange name as the CFTC reports it
report_type string yes legacy, disaggregated, financial (TFF)
scope string yes futures_only or futures_and_options
date string yes Position date (Tuesday), YYYY-MM-DD
release_date string yes Publication date (usually Friday)
open_interest number yes Total open interest
change_in_open_interest number yes Week-on-week change
dealer_long, dealer_short, dealer_spreading number TFF Dealer/intermediary positions
asset_manager_long, asset_manager_short, asset_manager_spreading number TFF Asset manager positions
leveraged_funds_long, leveraged_funds_short, leveraged_funds_spreading number TFF Hedge fund and CTA positions
other_reportable_long, other_reportable_short number TFF Other reportables
producer_long, producer_short, swap_dealer_long, swap_dealer_short, managed_money_long, managed_money_short number disaggregated Commodity categories
noncommercial_long, noncommercial_short, commercial_long, commercial_short number legacy Legacy categories
nonreportable_long, nonreportable_short number yes Small traders
leveraged_funds_net number optional, derived Long minus short
net_position_percentile_3y number optional, derived 0 to 100 rank of the net position over 156 weeks

Example record (illustrative):

{
  "symbol": "MES",
  "cftc_code": "13874U",
  "market": "MICRO E-MINI S&P 500 INDEX",
  "exchange": "CHICAGO MERCANTILE EXCHANGE",
  "report_type": "financial",
  "scope": "futures_only",
  "date": "2026-11-10",
  "release_date": "2026-11-13",
  "open_interest": 303128,
  "change_in_open_interest": 29929,
  "dealer_long": 17625,
  "dealer_short": 59259,
  "asset_manager_long": 24657,
  "asset_manager_short": 0,
  "leveraged_funds_long": 165332,
  "leveraged_funds_short": 81646,
  "leveraged_funds_net": 83686
}

Sample data

Sample data

Futures Positioning (CFTC Commitments of Traders). The last three weekly TFF reports for every financial future. In this sample symbol still holds the CFTC code; root mapping comes with the product. First 10 rows:

symbol date market exchange cftc_code open_interest dealer_long dealer_short asset_manager_long asset_manager_short leveraged_funds_long leveraged_funds_short change_in_open_interest
343603 2026-10-27 10 YEAR ERIS SOFR SWAP CHICAGO BOARD OF TRADE 343603 256103 25261 24830 20158 11571 6770 118885 29573
343603 2026-11-03 10 YEAR ERIS SOFR SWAP CHICAGO BOARD OF TRADE 343603 260978 25261 30095 23858 11571 7620 122194 4875
343603 2026-11-10 10 YEAR ERIS SOFR SWAP CHICAGO BOARD OF TRADE 343603 275384 25291 30835 27558 11554 8670 137870 14406
172LM2 2026-10-27 1K SHIB PERP COINBASE DERIVATIVES, LLC 172LM2 3996 0 0 0 0 2051 3699 -284
172LM2 2026-11-03 1K SHIB PERP COINBASE DERIVATIVES, LLC 172LM2 3666 0 0 0 0 1824 3381 -330
172LM2 2026-11-10 1K SHIB PERP COINBASE DERIVATIVES, LLC 172LM2 3914 0 0 0 0 2165 3516 248
342603 2026-10-27 2 YEAR ERIS SOFR SWAP CHICAGO BOARD OF TRADE 342603 232856 57479 15111 0 103339 147674 20227 -6207
342603 2026-11-03 2 YEAR ERIS SOFR SWAP CHICAGO BOARD OF TRADE 342603 232760 55745 15111 0 104443 149082 21084 -96
342603 2026-11-10 2 YEAR ERIS SOFR SWAP CHICAGO BOARD OF TRADE 342603 213637 42996 28861 0 76243 142756 22304 -19123
344606 2026-10-27 3 YEAR ERIS SOFR SWAP CHICAGO BOARD OF TRADE 344606 77932 21385 25327 0 7602 24035 4183 -375

Source: CFTC

Use cases

Use cases

Crowded positioning. Compute leveraged_funds_long minus leveraged_funds_short per market and rank it against the last three years (Starter gives you net_position_percentile_3y directly). A reading near 0 or 100 means hedge funds are at an extreme, which is when positioning matters most for a reversal.

Asset managers versus hedge funds. In equity index futures, asset managers tend to hold structural longs while leveraged funds trade around them. Plot asset_manager_long minus asset_manager_short next to the leveraged funds net to see who is driving a move.

Commodity hedging pressure. In the disaggregated report, producer_short rising while managed_money_long climbs tells you producers are locking in prices into a rally. Oil and grain traders watch that spread every Friday.

Open interest confirmation. A price rise with change_in_open_interest positive points to new money entering. A rise with falling open interest is more often short covering.

Code

Code examples

Example: the latest financial report for ES.

curl "https://api.marketdata.co/v1/futures/cot?symbol=ES&report_type=financial&scope=futures_only&limit=1" \
  -H "Authorization: Bearer $MARKETDATA_API_KEY"

Example: Python, leveraged funds net position from the free sample.

import pandas as pd

cot = pd.read_csv("cftc-traders-in-financial-futures.csv", parse_dates=["date"])
cot["lev_net"] = cot["leveraged_funds_long"] - cot["leveraged_funds_short"]
latest = cot[cot["date"] == cot["date"].max()]
print(latest.sort_values("lev_net")[["market", "lev_net", "open_interest"]].head(10))

Pricing

Pricing

Plan COT data
Free, $0 Every raw CFTC report (legacy, disaggregated, TFF), full history
Starter, $29/mo Adds derived fields (net positions, weekly change by category, 3-year percentile) and history back to 1986 in one call

The full raw history is also a free bulk download. We found no confirmed public price for COT data by API among the providers we studied.

Side by side

How we compare

Only 3 of the 50 providers we studied sell COT data, and only 1 of them through an API. The others offer web charts or a text news wire. Since the source is public, we give the raw reports away and charge only for the derived numbers that take work to compute. Same schema as our futures bars, joined on symbol, files you keep.

FAQ

Frequently asked questions

Why is the data a few days old when it comes out?

The CFTC collects positions as of Tuesday and usually publishes them on Friday afternoon US Eastern time. date holds the Tuesday and release_date the publication day, so you can backtest without lookahead.

Which report should I use?

Use financial (TFF) for equity index, rates and currency futures, disaggregated for commodities, and legacy when you need history before 2006. All three are in the same table, filtered by report_type.

Are the numbers adjusted?

No. We publish the CFTC's numbers as released. Derived fields on Starter are computed from those raw values and labelled as derived.

What does "futures and options combined" mean?

The CFTC also publishes positions with options converted to futures-equivalent contracts. Set scope to futures_and_options to get that version.

Is there a licence restriction?

No. CFTC data is a US government work in the public domain. You can use it commercially; credit the CFTC as the source.

What formats are available?

JSON from the API and CSV or Parquet files. The free sample ZIP has CSV and JSON.

Keep reading