# CFTC · Legacy report, futures only

Get market and financial data with CFTC · Legacy report, futures only from Alexandria through one Spiral API key. The report most commentary means by 'the COT': speculators versus hedgers, futures positions only, back to 1986 for every market. Filter by `cftc_contract_market_code` or `commodity_name` and order by `report_date_as_yyyy_mm_dd DESC` for the latest week. It runs in the background and returns structured JSON. Pay as you go, with no subscription.

- Provider: Alexandria
- Category: Finance
- Runs: In the background
- Returns: json
- Tool id: `alexandria` / `cftc/legacy/futures-only`
- Page: https://spiral.ai/tools/alexandria/cftc/legacy/futures-only

## Pricing

$0.001746 per call.

## Limits

- Longest queue wait: 1 hour
- Run deadline: 5 minutes
- Longest run, end to end: 225 minutes
- Largest inline input: 1 MB
- Largest input file: 2 GB
- Largest output: 5 GB

## Input

| Field | Kind | Allowed | Default | Description |
| --- | --- | --- | --- | --- |
| `$limit` | number |  | 1000 | Rows to return. The default is 1,000; the datasets hold hundreds of thousands, so a date or market filter is what keeps a page useful rather than this. |
| `$order` | text |  | — | Sort, as `column ASC\|DESC`, comma-separated for several. Defaults to `report_date_as_yyyy_mm_dd DESC` for ordinary row queries. With `$select`, no default order is added; supply an order compatible with the selected columns. |
| `$where` | text |  | — | A SoQL filter for anything the column filters cannot say: `report_date_as_yyyy_mm_dd > '2026-01-01' AND commodity_name = 'GOLD'`, `open_interest_all > 100000`, `market_and_exchange_names like '%CRUDE%'`. An unknown column answers HTTP 400 with the failing query echoed back. |
| `$offset` | number |  | — | Rows to skip, for paging past `$limit`. |
| `$select` | text |  | — | Columns to return, comma-separated, in place of all of them. `count(*)` on its own answers how many rows match. A selected subset no longer matches the declared fields, so read the declared list as what the full row carries. |
| `commodity_name` | text |  | — | Commodity name, `GOLD` or `CRUDE OIL`. Exact match, upper case. One commodity can span several markets. |
| `cftc_market_code` | text |  | — | Exchange code: `CBT`, `CME`, `NYME`, `CMX`, `ICUS`, `ICEU`. Exact match, and unreliable on its own: a quarter of the rows store the code with trailing spaces (`CMX ` beside `CMX`, the latest gold row among them), and equality on `CMX` misses every one of those. Filter on `cftc_contract_market_code` instead, or use `$where=cftc_market_code like 'CMX%'`. |
| `yyyy_report_week_ww` | text |  | — | Report week label, `2026 Report Week 34`. Exact match. |
| `commodity_group_name` | text |  | — | Top-level commodity group: `AGRICULTURE`, `FINANCIAL INSTRUMENTS` or `NATURAL RESOURCES`. |
| `cftc_contract_market_code` | text |  | — | CFTC contract market code, `088691` for COMEX gold. The stable id for a market across weeks and report types - names get edited, codes do not. Exact match. |
| `market_and_exchange_names` | text |  | — | Market and exchange as the report prints them, `GOLD - COMMODITY EXCHANGE INC.`. Exact match, upper case; use `$where` with `upper()` or `like` for anything looser. |
| `report_date_as_yyyy_mm_dd` | text |  | — | One report date, as `2026-08-25` or the full `2026-08-25T00:00:00.000`. Reports are as of Tuesday and published Friday. For a range use `$where`. |

## Example

```bash
curl https://api.spiral.ai/v1/runs \
  -H "Authorization: Bearer $SPIRAL_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{
    "provider": "alexandria",
    "model": "cftc/legacy/futures-only",
    "input": {
      "$limit": 1000
    }
  }'
```

Try it in the Playground: https://spiral.ai/start?provider=alexandria&model=cftc%2Flegacy%2Ffutures-only

## Common questions

### CFTC · Legacy report, futures only

**How much does CFTC · Legacy report, futures only cost?**

$0.001746 per call. You pay as you go from one Spiral balance, with no subscription, and a failed run is not charged.

**How do I use CFTC · Legacy report, futures only through an API?**

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "cftc/legacy/futures-only"` and the input fields on this page, using one Spiral API key. It runs in the background: poll the run, or name a webhook to be told when it finishes.

**Do I need an account with Alexandria to use CFTC · Legacy report, futures only?**

No. Spiral runs it on its own Alexandria account and charges your Spiral balance.

**Can my AI agent use CFTC · Legacy report, futures only?**

Yes. Agents find and run it through Spiral's MCP server, CLI or agent skill, with the same API key.

