# Commodity Price Aggregator — EIA Energy & USDA Crop Prices (`jungle_synthesizer/commodity-price-aggregator`) Actor Energy and commodity price data from US government APIs. Fetches crude oil (Brent/WTI), petroleum products, and natural gas from the EIA API, plus agricultural prices (corn, soybeans, wheat, cotton) from USDA NASS. Includes spot prices, settlement dates, units, and region. - **URL**: https://apify.com/jungle\_synthesizer/commodity-price-aggregator.md - **Developed by:** [BowTiedRaccoon](https://apify.com/jungle_synthesizer) (community) - **Categories:** Business, Education, Other - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, NaN bookmarks - **User rating**: No ratings yet ## Pricing Pay per event This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## Commodity Price Aggregator — EIA Energy & USDA Crop Prices Aggregate commodity price data from US government APIs. Fetches energy prices (crude oil Brent/WTI, petroleum products, natural gas) from the EIA API and agricultural prices (corn, soybeans, wheat, cotton) from the USDA NASS Quick Stats API. ### What it does The actor queries two US federal government data APIs and returns structured commodity price records: - **EIA (Energy Information Administration):** Daily petroleum spot prices (Brent, WTI, diesel, propane, heating oil), weekly retail gasoline/diesel prices, and monthly natural gas prices. - **USDA NASS Quick Stats:** Monthly farm-level prices received for corn, soybeans, wheat, and cotton (requires a free API key). No browser automation needed — both sources are clean REST APIs with JSON responses. ### Output fields | Field | Description | |-------|-------------| | `source` | Data source: `EIA` or `USDA-NASS` | | `commodity` | Commodity name (e.g. UK Brent Crude Oil, Natural Gas, Corn) | | `market` | Market identifier (EIA-Spot or NASS-Received) | | `series_id` | Source series code (e.g. `RBRTE` for Brent crude) | | `series_description` | Full series description from the source API | | `settlement_date` | Date of the price record (YYYY-MM-DD or YYYY-MM) | | `price` | Price as a decimal number | | `unit` | Price unit (e.g. `$/BBL`, `$/MCF`, `$/GAL`, `$/BU`) | | `currency` | Currency code (always USD) | | `frequency` | Data frequency: `daily`, `weekly`, or `monthly` | | `region` | Geographic area (e.g. U.S., Los Angeles, Europe) | | `grade` | Commodity grade (Brent, WTI, Gasoline, Diesel, Natural Gas, etc.) | | `process` | Price type (e.g. Spot Price FOB, Price Delivered to Residential) | | `product_code` | Raw product code from the source API | ### Input parameters | Parameter | Required | Default | Description | |-----------|----------|---------|-------------| | `commodityCategory` | No | `energy` | Which category: `energy`, `natural_gas`, `agriculture`, or `all` | | `eiaApiKey` | No | — | Free EIA API key for higher rate limits. Register at eia.gov/opendata | | `nassApiKey` | Required for agriculture | — | Free USDA NASS key. Register at quickstats.nass.usda.gov/api | | `startDate` | No | 90 days ago | Start date (YYYY-MM-DD for energy; YYYY-MM for gas/agriculture) | | `endDate` | No | Today | End date | | `maxItems` | No | 100 | Maximum records to return | ### Example output ```json { "source": "EIA", "commodity": "UK Brent Crude Oil", "market": "EIA-Spot", "series_id": "RBRTE", "series_description": "Europe Brent Spot Price FOB (Dollars per Barrel)", "settlement_date": "2024-01-02", "price": 76.24, "unit": "$/BBL", "currency": "USD", "frequency": "daily", "region": "NA", "grade": "Brent", "process": "Spot Price FOB", "product_code": "EPCBRENT" } ```` ### API keys - **EIA API key** is optional but recommended. The built-in key covers standard usage. For high-volume runs, register your own free key at [eia.gov/opendata/register.php](https://www.eia.gov/opendata/register.php). - **USDA NASS API key** is required for the agriculture category. Free registration at [quickstats.nass.usda.gov/api](https://quickstats.nass.usda.gov/api). ### Use cases - Track Brent and WTI crude oil spot prices for trading dashboards - Monitor US retail gasoline and diesel price trends - Analyze natural gas price movements by region - Build commodity price datasets for algorithmic trading (CTA strategies) - Feed agricultural commodity prices into agri-fintech applications - Research energy market correlations and seasonality ### Data coverage | Source | Commodity | Frequency | Coverage | |--------|-----------|-----------|---------| | EIA | Petroleum spot prices (Brent, WTI, diesel, propane) | Daily | 1986–present | | EIA | Retail gasoline and diesel | Weekly | 1995–present | | EIA | Natural gas (residential, commercial, industrial) | Monthly | 1989–present | | USDA NASS | Corn, soybeans, wheat, cotton | Monthly | ~1900s–present | ### Notes - The EIA API returns up to 5,000 records per request; the actor paginates automatically. - USDA NASS data reflects prices received by farmers, not futures or exchange prices. - LME metals (copper, aluminum, zinc) and CME futures are not included in this version. # Actor input Schema ## `sp_intended_usage` (type: `string`): Please describe how you plan to use the data extracted by this crawler. ## `sp_improvement_suggestions` (type: `string`): Provide any feedback or suggestions for improvements. ## `sp_contact` (type: `string`): Provide your email address so we can get in touch with you. ## `commodityCategory` (type: `string`): Which commodity category to fetch. 'energy' pulls EIA crude oil and petroleum spot prices. 'natural\_gas' pulls EIA natural gas prices. 'agriculture' pulls USDA NASS crop prices (requires nassApiKey). 'all' fetches energy + natural gas (agriculture requires nassApiKey). ## `eiaApiKey` (type: `string`): Free EIA API key for higher rate limits (100 req/sec vs 5 req/sec with demo key). Register at https://www.eia.gov/opendata/register.php. Leave blank to use the demo key. ## `nassApiKey` (type: `string`): Free USDA NASS Quick Stats API key required for agricultural commodity prices. Register at https://quickstats.nass.usda.gov/api. Only needed when commodityCategory is 'agriculture' or 'all'. ## `startDate` (type: `string`): Earliest settlement date to include (YYYY-MM-DD for daily/weekly; YYYY-MM for monthly). Defaults to 30 days ago for energy, current year for agriculture. ## `endDate` (type: `string`): Latest settlement date to include (YYYY-MM-DD for daily/weekly; YYYY-MM for monthly). Defaults to today. ## `maxItems` (type: `integer`): Maximum number of price records to return. Set to 0 for all available records. ## Actor input object example ```json { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "commodityCategory": "energy", "maxItems": 15 } ``` # Actor output Schema ## `results` (type: `string`): No description # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "commodityCategory": "energy", "eiaApiKey": "", "nassApiKey": "", "startDate": "", "endDate": "", "maxItems": 15 }; // Run the Actor and wait for it to finish const run = await client.actor("jungle_synthesizer/commodity-price-aggregator").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "commodityCategory": "energy", "eiaApiKey": "", "nassApiKey": "", "startDate": "", "endDate": "", "maxItems": 15, } # Run the Actor and wait for it to finish run = client.actor("jungle_synthesizer/commodity-price-aggregator").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "commodityCategory": "energy", "eiaApiKey": "", "nassApiKey": "", "startDate": "", "endDate": "", "maxItems": 15 }' | apify call jungle_synthesizer/commodity-price-aggregator --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=jungle_synthesizer/commodity-price-aggregator", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Commodity Price Aggregator — EIA Energy & USDA Crop Prices", "description": "Energy and commodity price data from US government APIs. Fetches crude oil (Brent/WTI), petroleum products, and natural gas from the EIA API, plus agricultural prices (corn, soybeans, wheat, cotton) from USDA NASS. Includes spot prices, settlement dates, units, and region.", "version": "0.1", "x-build-id": "xyYcUliQhPuo6jeD3" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/jungle_synthesizer~commodity-price-aggregator/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-jungle_synthesizer-commodity-price-aggregator", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/jungle_synthesizer~commodity-price-aggregator/runs": { "post": { "operationId": "runs-sync-jungle_synthesizer-commodity-price-aggregator", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/jungle_synthesizer~commodity-price-aggregator/run-sync": { "post": { "operationId": "run-sync-jungle_synthesizer-commodity-price-aggregator", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "properties": { "sp_intended_usage": { "title": "What is the intended usage of this data?", "minLength": 1, "type": "string", "description": "Please describe how you plan to use the data extracted by this crawler." }, "sp_improvement_suggestions": { "title": "How can we improve this crawler for you?", "minLength": 1, "type": "string", "description": "Provide any feedback or suggestions for improvements." }, "sp_contact": { "title": "Contact Email", "minLength": 1, "type": "string", "description": "Provide your email address so we can get in touch with you." }, "commodityCategory": { "title": "Commodity Category", "enum": [ "all", "energy", "natural_gas", "agriculture" ], "type": "string", "description": "Which commodity category to fetch. 'energy' pulls EIA crude oil and petroleum spot prices. 'natural_gas' pulls EIA natural gas prices. 'agriculture' pulls USDA NASS crop prices (requires nassApiKey). 'all' fetches energy + natural gas (agriculture requires nassApiKey).", "default": "energy" }, "eiaApiKey": { "title": "EIA API Key (Optional)", "type": "string", "description": "Free EIA API key for higher rate limits (100 req/sec vs 5 req/sec with demo key). Register at https://www.eia.gov/opendata/register.php. Leave blank to use the demo key." }, "nassApiKey": { "title": "USDA NASS API Key (Required for agriculture)", "type": "string", "description": "Free USDA NASS Quick Stats API key required for agricultural commodity prices. Register at https://quickstats.nass.usda.gov/api. Only needed when commodityCategory is 'agriculture' or 'all'." }, "startDate": { "title": "Start Date", "type": "string", "description": "Earliest settlement date to include (YYYY-MM-DD for daily/weekly; YYYY-MM for monthly). Defaults to 30 days ago for energy, current year for agriculture." }, "endDate": { "title": "End Date", "type": "string", "description": "Latest settlement date to include (YYYY-MM-DD for daily/weekly; YYYY-MM for monthly). Defaults to today." }, "maxItems": { "title": "Max Items", "type": "integer", "description": "Maximum number of price records to return. Set to 0 for all available records.", "default": 100 } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```