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
Related
- Asset hub: Futures
- Symbols: ES, NQ, YM, RTY, CL, GC
- Docs: API Reference: Settlements and COT Positioning
- Learn: How to Read the COT Report, Open Interest: What It Tells You and What It Doesn't