# CFTC · Supplemental report, commodity index traders

Get market and financial data with CFTC · Supplemental report, commodity index traders from Alexandria through one Spiral API key. Thirteen agricultural markets - corn, wheat, soybeans, sugar, coffee, cocoa, cotton, cattle, hogs - when the question is how much of the length is passive index money rather than a directional view. Nowhere else in the COT is index-trader positioning stated on its own. 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/supplemental/index-traders`
- Page: https://spiral.ai/tools/alexandria/cftc/supplemental/index-traders

## 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/supplemental/index-traders",
    "input": {
      "$limit": 1000
    }
  }'
```

Try it in the Playground: https://spiral.ai/start?provider=alexandria&model=cftc%2Fsupplemental%2Findex-traders

## Common questions

### CFTC · Supplemental report, commodity index traders

**How much does CFTC · Supplemental report, commodity index traders 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 · Supplemental report, commodity index traders through an API?**

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "cftc/supplemental/index-traders"` 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 · Supplemental report, commodity index traders?**

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

**Can my AI agent use CFTC · Supplemental report, commodity index traders?**

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

