Spiral gives your agent every tool with one account. Browse the tools →

AlexandriaFinanceAvailable now

CFTC · Disaggregated report, futures and options combined

cftc/disaggregated/combined

Get market and financial data with CFTC · Disaggregated report, futures and options combined from Alexandria through one Spiral API key. The disaggregated split with options included. Prefer it for crude, natural gas and gold, where a large share of managed-money exposure is held through options and the futures-only figure understates it. It runs in the background and returns structured JSON. Pay as you go, with no subscription.

Pricing

$0.001746 per call.

Limits

Runs
In the background
Returns
json
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

FieldKindDefaultDescription
$limitnumber1000

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.

$ordertext—

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.

$wheretext—

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.

$offsetnumber—

Rows to skip, for paging past $limit.

$selecttext—

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_nametext—

Commodity name, GOLD or CRUDE OIL. Exact match, upper case. One commodity can span several markets.

cftc_market_codetext—

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_wwtext—

Report week label, 2026 Report Week 34. Exact match.

commodity_group_nametext—

Top-level commodity group: AGRICULTURE, FINANCIAL INSTRUMENTS or NATURAL RESOURCES.

cftc_contract_market_codetext—

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_namestext—

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_ddtext—

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.

Same request in code

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

Frequently asked questions

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

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "cftc/disaggregated/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 · Disaggregated 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 · Disaggregated 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.