OMIE / Tabla

omie.prices

Precios de casación de las subastas diaria e intradiarias.

OMIE1 hora, programa, mercadoDiariaAl día
Detalle técnico (EN)

OMIE auction CLEARING (marginal) prices — one row per (datetime, program, country), from marginalpdbc (day-ahead PDBF) and marginalpibc (intraday PHF). Since the June 2024 IDA reform, the intraday auction programs are PHF1..PHF3; earlier history can contain PHF4..PHF7. Continuous-intraday MIC/XBID weighted prices are stored exclusively in omie.continuous_prices, not in this table. Daily refresh replays yesterday as well as today because the delivery day's intraday marginal files may not yet be published.

Cobertura2025-02-28 – 2026-09-28336,870 filas
FuenteOMIEFuente 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
datetimeDateTime('Europe/Madrid')Delivery period wall-clock start, Europe/Madrid.
periodLowCardinality(String)Raw OMIE period label for the delivery period (verbatim).
period_indexUInt16Period ordinal within the delivery day (1–96 for 15-min post-MTU, 1–24 hourly before).
source_intervalLowCardinality(String)'15min' or '1h' — publication granularity for this row.
programLowCardinality(String)Market gate: PDBF (day-ahead) or PHF1..PHF3 (intraday auctions since June 2024); historical PHF4..PHF7 before the IDA reform. No MIC rows — see omie.continuous_prices.
countryLowCardinality(String)Delivery area (ES / PT).
priceFloat64Marginal auction clearing price for the period.
file_dateDate—
inserted_atDateTime—