# CFTC · Financial futures report, futures and options combined

Get market and financial data with CFTC · Financial futures report, futures and options combined from Alexandria through one Spiral API key. The financial split with options included, which matters most for equity index and Treasury futures, where options open interest is a large fraction of the total. 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/financial/combined`
- Page: https://spiral.ai/tools/alexandria/cftc/financial/combined

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

Try it in the Playground: https://spiral.ai/start?provider=alexandria&model=cftc%2Ffinancial%2Fcombined

## Common questions

### CFTC · Financial futures report, futures and options combined

**How much does CFTC · Financial futures report, futures and options combined 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 · Financial futures report, futures and options combined through an API?**

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "cftc/financial/combined"` 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 · Financial futures report, futures and options combined?**

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

**Can my AI agent use CFTC · Financial futures report, futures and options combined?**

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

