ESIOS / Tabla
esios.indicators
Series de indicadores de precios, demanda y generación eléctrica.
ESIOSIndicador, geografía, instanteSegún indicadorAl día
Detalle técnico (EN)
Time-series for every indicator the worker pulls from the ESIOS API. One row per `(indicator_id, datetime, geo_id)`. Source resolution preserved as-published — see `frequency` to know if the values are 5min/10min/15min/Hora/Día/Semana/Mes/Año.
Cobertura2013-12-31 – 2026-09-28218,905,502 filas
FuenteRed Eléctrica de EspañaFuente oficial
En tu planAcceso públicoEntra para ver tu acceso
Columnas
Esquema vivo de la tabla, leído del catálogo de Data.
ColumnasTipoDescripción
indicator_idUInt32ESIOS catalog ID (e.g. 600 = Precio mercado SPOT Diario, 682 = Demanda real). Join `esios.indicators_catalog` for human metadata.datetimeDateTime('Europe/Madrid')Period start, tz-aware Europe/Madrid. Group with toStartOfHour/toDate (DST-correct, local hours). Per-row granularity is the catalog `frequency` (5min/10min/15min/Hora/Día/…); it can change over time (e.g. 600 went hourly→15min at 2025) — COUNT/AVG across the change are not comparable, normalize first. DST days are 23h/25h. See the MCP 'Time handling' instructions.geo_idUInt32Geographic scope of the value (REE geo id). Most indicators are system-wide; some carry per-zone or per-CCAA values.valueFloat64The metric value. Units depend on the indicator's `magnitude` + `unit` columns in the catalog.indicator_nameLowCardinality(String)—geo_nameLowCardinality(String)—magnitudeLowCardinality(String)—frequencyLowCardinality(String)—unitLowCardinality(String)—inserted_atDateTime—