Fetch PVPC Prices
fetch_pricesFetch Spanish PVPC electricity prices for a specified date range and geographical area, with configurable time and geographical aggregation.
Instructions
Fetches the Voluntary Price for the Small Consumer (PVPC) prices for a given date range and geographical area.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| locale | No | Get translations for sources. Accepted values: `es`, `en`. Defaults to `es`. | es |
| startDate | No | Beginning of the date range to filter indicator values in iso8601 format. E.g. 2025-06-29T00:00:00.000+02:00. Defaults to the start of today. | 2026-04-29T00:00:00.000Z |
| endDate | No | End of the date range to filter indicator values in iso8601 format. E.g. 2025-06-29T23:59:59.999+02:00. Defaults to the end of today. | 2026-04-29T23:59:59.999Z |
| timeAggregation | No | How to aggregate indicator values when grouping them by time. Accepted values: `sum`, `average`. Defaults to `sum`. | sum |
| timeTruncation | No | Tells how to truncate data time series. Accepted values: `hour`, `day`, `month`, `year`. | |
| geographicalAggregation | No | How to aggregate indicator values when grouping them by geographical ID. Accepted values: `sum`, `average`. Defaults to `sum`. | sum |
| geographicalIds | No | Tells the geographical IDs to filter indicator values. Accepted values: `3` (España), `8741` (Península), `8742` (Canarias), `8743` (Baleares), `8744` (Ceuta), `8745` (Melilla). Defaults to `8741`, `8742`, `8743`, `8744`, `8745`. | |
| geographicalTruncation | No | Tells how to group data at geographical level when the geographical aggregation is informed. Accepted values: `country`, `electric_system`. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| prices | Yes |