# CFTC Commitments of Traders · Supplemental

Get market and financial data with CFTC Commitments of Traders · Supplemental from Alexandria through one Spiral API key. Positions and open interest from the CFTC Supplemental Commodity Index report for one or many markets and weeks. Use `markets` first to find contract_market_code values; use `fields` to keep the payload small. 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-gov/commitments-of-traders/supplemental`
- Page: https://spiral.ai/tools/alexandria/cftc-gov/commitments-of-traders/supplemental

## Pricing

$0.00873 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 |
| --- | --- | --- | --- | --- |
| `to` | text |  | — | Latest report date to include, YYYY-MM-DD (inclusive). Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. |
| `from` | text |  | — | Earliest report date to include, YYYY-MM-DD (inclusive). Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. |
| `sort` | one of | recent_first, oldest_first | recent_first | Order by report date then id. The upstream default order is undefined, so an order is always sent. |
| `query` | text |  | — | SODA full-text search ($q) over the text columns, e.g. `gold` or `chicago board of trade`. |
| `cursor` | text |  | — | next_cursor from the previous page of the same query (the SODA $offset). |
| `fields` | list |  | — | Projection: SODA column names to return (open_interest_all, noncomm_positions_long_all, m_money_positions_long_all, ...). The identity columns id, market_and_exchange_names, report_date_as_yyyy_mm_dd and cftc_contract_market_code are always included. An unknown column is invalid_input. Omit for every column. |
| `page_size` | number | 1 to 1000 | 100 | Rows per page (a legacy row is ~4.7 KB, a disaggregated row ~7 KB). |
| `report_date` | text |  | — | One weekly report date (a Tuesday), YYYY-MM-DD. Not combinable with from / to. Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. |
| `exchange_code` | text |  | — | cftc_market_code without its padding: CBT, CME, CMX, NYME, ICUS, ICEU, CMXE, FREX... Matches the padded value the dataset stores ('CMX '). Pattern: ^[A-Za-z0-9]{1,4}$. |
| `commodity_name` | text |  | — | Exact commodity_name, case-insensitive (GOLD, WHEAT, NATURAL GAS, BITCOIN). |
| `commodity_group_name` | text |  | — | Exact commodity_group_name, case-insensitive: AGRICULTURE, NATURAL RESOURCES, FINANCIAL INSTRUMENTS. |
| `contract_market_code` | text |  | — | Exact cftc_contract_market_code, a string with leading zeros kept (088691 = GOLD - COMMODITY EXCHANGE INC., 001602 = WHEAT-SRW - CBOT). Discover codes with `markets`. Alone, a code with no rows in this dataset is not_found; combined with date or other filters an empty page is a legitimate empty result. Pattern: ^[A-Za-z0-9]{1,12}$. |
| `commodity_subgroup_name` | text |  | — | Exact commodity_subgroup_name, case-insensitive (GRAINS, PRECIOUS METALS, PETROLEUM AND PRODUCTS, CURRENCIES, STOCK INDICES, ...). |

## 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-gov/commitments-of-traders/supplemental",
    "input": {
      "to": "<to>"
    }
  }'
```

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

## Common questions

### CFTC Commitments of Traders · Supplemental

**How much does CFTC Commitments of Traders · Supplemental cost?**

$0.00873 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 Commitments of Traders · Supplemental through an API?**

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "cftc-gov/commitments-of-traders/supplemental"` 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 Commitments of Traders · Supplemental?**

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

**Can my AI agent use CFTC Commitments of Traders · Supplemental?**

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

