QUERY IT / Finance And Securities
What can you query with CFTC Commitments of Traders?
Futures positions by trader category and market
THE DECISION
Source route
# CFTC Commitments of Traders ## What It Contains The CFTC publishes Commitments of Traders reports through its public reporting portal. The reports summarize reportable futures and options positions by trader classification and market, supporting position-trend research, regulatory analysis, and commodity dashboards. The portal exposes dataset resources through a documented Socrata-style JSON endpoint as well as its web interface. Use its field definitions and report schedules when comparing observations: report formats, classifications, and historical coverage differ. The data provides aggregate regulatory reporting information and does not identify individual traders or establish a trading recommendation. ## Search With Codex ```text Use CFTC Commitments of Traders only through https://publicreporting.cftc.gov/stories/s/Commitments-of-Traders/6dca-aqww/. Inspect the official documentation before writing a small Python query for a bounded research question. Respect pagination, rate limits, and error responses; return the documented fields in JSON with the source URL and retrieval timestamp. Do not scrape an unofficial site or invent an endpoint. ``` ## Python Starter Script ```python import json from urllib.request import Request, urlopen url = "https://publicreporting.cftc.gov/resource/6dca-aqww.json?$limit=1" # Replace with an authorised, documented query. request = Request(url, headers={"User-Agent": "byebuy.ai research (contact: you@example.com)", "Accept": "application/json"}) with urlopen(request, timeout=20) as response: if response.status != 200: raise RuntimeError(f"Unexpected HTTP status: {response.status}") payload = json.load(response) print(json.dumps(payload, indent=2)[:2000]) ``` ## Example Searches - What is the most recent official record for a bounded query? - Which available fields support a reproducible dashboard? - What metadata and retrieval date should accompany an export? ## What You Could Build - A provenance-aware research dashboard using permitted results. - A scheduled alert that records source updates rather than redistributing raw data. - A data-enrichment workflow that preserves the publisher's terms. ## Access and Rights Connect: API + REST. Rights code: O. No API key is required for the documented public route. Follow the official terms and source-specific notices. ## Geography Details Primary coverage is US; use the publisher's metadata for detailed scope. ## Related Databases - SEC EDGAR ## Sources - [https://publicreporting.cftc.gov/stories/s/Commitments-of-Traders/6dca-aqww/](https://publicreporting.cftc.gov/stories/s/Commitments-of-Traders/6dca-aqww/) ## FAQ - **Is this an official route?** Yes; use the linked publisher documentation. - **Can I redistribute results?** Check the linked rights evidence and source-specific terms. - **Does it need credentials?** See Access and Rights. - **Should I scrape the website?** No; use the documented route. - **How current is it?** Check source metadata and the verification date.
COPYABLE IMPLEMENTATION PROMPT
Design a source-aware query workflow for CFTC Commitments of Traders. Source context: Futures positions by trader category and market Use the documented access route, record the exact source and retrieval time for every result, respect rate limits and rights, and distinguish source facts from analysis. Do not invent missing data.
Opening an AI app also copies this prompt as a fallback.
THE USEFUL CORE
What you can query
- CFTC Commitments of Traders What It Contains The CFTC publishes Commitments of Traders reports through its public reporting portal.
- The reports summarize reportable futures and options positions by trader classification and market, supporting position-trend research, regulatory analysis, and commodity dashboards.
- The portal exposes dataset resources through a documented Socrata-style JSON endpoint as well as its web interface.
- Use its field definitions and report schedules when comparing observations: report formats, classifications, and historical coverage differ.
- The data provides aggregate regulatory reporting information and does not identify individual traders or establish a trading recommendation.
WHAT TO VERIFY BEFORE USE
What to verify before use
Confirm the source licence, access rules, update cadence, documentation, and whether the data is complete enough for the decision you need to make.
QUESTIONS
What should I verify first?
Start with the official source, current terms or licence, practical setup requirements, and the limits of the recorded catalogue data.
Is this information current?
Last recorded check: 2026-08-17. Verify time-sensitive details with the linked official source.
Can I save this route?
Yes. Create an account or log in, then use the Save button to keep it in your collection.
