joltio
Sign inStart free

OMIE / Table

omie.prices

Day-ahead and intraday auction clearing prices.

OMIEHour, program, marketDailyUp to date
Coverage2025-02-28 – 2026-09-29336,678 rows
SourceOMIEOfficial source
In your planPublic accessSign in to check access

Source: OMIE. Latest data: 2026-09-29. Joltio normalizes the published values without altering them and is not affiliated with or endorsed by OMIE.

Sample

Sample from 2026-09-28 · 100 rows · 2026-09-28 – 2026-09-29

CSVParquet
datetimeDateTime('Europe/Madrid')periodLowCardinality(String)period_indexUInt16source_intervalLowCardinality(String)programLowCardinality(String)countryLowCardinality(String)priceFloat64file_dateDateinserted_atDateTime
2026-09-28T00:00:00+02:001115minPDBFES173.82026-09-282026-09-28T16:26:41
2026-09-28T00:00:00+02:001115minPDBFPT173.82026-09-282026-09-28T16:26:41
2026-09-28T00:15:00+02:002215minPDBFES170.062026-09-282026-09-28T16:26:41
2026-09-28T00:15:00+02:002215minPDBFPT170.062026-09-282026-09-28T16:26:41
2026-09-28T00:30:00+02:003315minPDBFES165.122026-09-282026-09-28T16:26:41
2026-09-28T00:30:00+02:003315minPDBFPT165.122026-09-282026-09-28T16:26:41
2026-09-28T00:45:00+02:004415minPDBFES162.512026-09-282026-09-28T16:26:41
2026-09-28T00:45:00+02:004415minPDBFPT162.512026-09-282026-09-28T16:26:41
2026-09-28T01:00:00+02:005515minPDBFES1702026-09-282026-09-28T16:26:41
2026-09-28T01:00:00+02:005515minPDBFPT1702026-09-282026-09-28T16:26:41
2026-09-28T01:15:00+02:006615minPDBFES165.392026-09-282026-09-28T16:26:41
2026-09-28T01:15:00+02:006615minPDBFPT165.392026-09-282026-09-28T16:26:41
2026-09-28T01:30:00+02:007715minPDBFES163.542026-09-282026-09-28T16:26:41
2026-09-28T01:30:00+02:007715minPDBFPT163.542026-09-282026-09-28T16:26:41
2026-09-28T01:45:00+02:008815minPDBFES1652026-09-282026-09-28T16:26:41
2026-09-28T01:45:00+02:008815minPDBFPT1652026-09-282026-09-28T16:26:41
2026-09-28T02:00:00+02:009915minPDBFES160.542026-09-282026-09-28T16:26:41
2026-09-28T02:00:00+02:009915minPDBFPT160.542026-09-282026-09-28T16:26:41
2026-09-28T02:15:00+02:00101015minPDBFES1602026-09-282026-09-28T16:26:41
2026-09-28T02:15:00+02:00101015minPDBFPT1602026-09-282026-09-28T16:26:41
2026-09-28T02:30:00+02:00111115minPDBFES157.962026-09-282026-09-28T16:26:41
2026-09-28T02:30:00+02:00111115minPDBFPT157.962026-09-282026-09-28T16:26:41
2026-09-28T02:45:00+02:00121215minPDBFES157.932026-09-282026-09-28T16:26:41
2026-09-28T02:45:00+02:00121215minPDBFPT157.932026-09-282026-09-28T16:26:41
2026-09-28T03:00:00+02:00131315minPDBFES157.222026-09-282026-09-28T16:26:41
2026-09-28T03:00:00+02:00131315minPDBFPT157.222026-09-282026-09-28T16:26:41
2026-09-28T03:15:00+02:00141415minPDBFES157.292026-09-282026-09-28T16:26:41
2026-09-28T03:15:00+02:00141415minPDBFPT157.292026-09-282026-09-28T16:26:41
2026-09-28T03:30:00+02:00151515minPDBFES157.442026-09-282026-09-28T16:26:41
2026-09-28T03:30:00+02:00151515minPDBFPT157.442026-09-282026-09-28T16:26:41
2026-09-28T03:45:00+02:00161615minPDBFES159.562026-09-282026-09-28T16:26:41
2026-09-28T03:45:00+02:00161615minPDBFPT159.562026-09-282026-09-28T16:26:41
2026-09-28T04:00:00+02:00171715minPDBFES158.582026-09-282026-09-28T16:26:41
2026-09-28T04:00:00+02:00171715minPDBFPT158.582026-09-282026-09-28T16:26:41
2026-09-28T04:15:00+02:00181815minPDBFES1602026-09-282026-09-28T16:26:41
2026-09-28T04:15:00+02:00181815minPDBFPT1602026-09-282026-09-28T16:26:41
2026-09-28T04:30:00+02:00191915minPDBFES163.542026-09-282026-09-28T16:26:41
2026-09-28T04:30:00+02:00191915minPDBFPT163.542026-09-282026-09-28T16:26:41
2026-09-28T04:45:00+02:00202015minPDBFES168.692026-09-282026-09-28T16:26:41
2026-09-28T04:45:00+02:00202015minPDBFPT168.692026-09-282026-09-28T16:26:41
2026-09-28T05:00:00+02:00212115minPDBFES169.262026-09-282026-09-28T16:26:41
2026-09-28T05:00:00+02:00212115minPDBFPT169.262026-09-282026-09-28T16:26:41
2026-09-28T05:15:00+02:00222215minPDBFES173.12026-09-282026-09-28T16:26:41
2026-09-28T05:15:00+02:00222215minPDBFPT173.12026-09-282026-09-28T16:26:41
2026-09-28T05:30:00+02:00232315minPDBFES178.082026-09-282026-09-28T16:26:41
2026-09-28T05:30:00+02:00232315minPDBFPT178.082026-09-282026-09-28T16:26:41
2026-09-28T05:45:00+02:00242415minPDBFES185.92026-09-282026-09-28T16:26:41
2026-09-28T05:45:00+02:00242415minPDBFPT185.92026-09-282026-09-28T16:26:41
2026-09-28T06:00:00+02:00252515minPDBFES193.682026-09-282026-09-28T16:26:41
2026-09-28T06:00:00+02:00252515minPDBFPT193.682026-09-282026-09-28T16:26:41
2026-09-28T06:15:00+02:00262615minPDBFES204.992026-09-282026-09-28T16:26:41
2026-09-28T06:15:00+02:00262615minPDBFPT204.992026-09-282026-09-28T16:26:41
2026-09-28T06:30:00+02:00272715minPDBFES214.842026-09-282026-09-28T16:26:41
2026-09-28T06:30:00+02:00272715minPDBFPT214.842026-09-282026-09-28T16:26:41
2026-09-28T06:45:00+02:00282815minPDBFES231.022026-09-282026-09-28T16:26:41
2026-09-28T06:45:00+02:00282815minPDBFPT231.022026-09-282026-09-28T16:26:41
2026-09-28T07:00:00+02:00292915minPDBFES229.392026-09-282026-09-28T16:26:41
2026-09-28T07:00:00+02:00292915minPDBFPT229.392026-09-282026-09-28T16:26:41
2026-09-28T07:15:00+02:00303015minPDBFES244.022026-09-282026-09-28T16:26:41
2026-09-28T07:15:00+02:00303015minPDBFPT244.022026-09-282026-09-28T16:26:41
2026-09-28T07:30:00+02:00313115minPDBFES246.32026-09-282026-09-28T16:26:41
2026-09-28T07:30:00+02:00313115minPDBFPT246.32026-09-282026-09-28T16:26:41
2026-09-28T07:45:00+02:00323215minPDBFES245.842026-09-282026-09-28T16:26:41
2026-09-28T07:45:00+02:00323215minPDBFPT245.842026-09-282026-09-28T16:26:41
2026-09-28T08:00:00+02:00333315minPDBFES275.952026-09-282026-09-28T16:26:41
2026-09-28T08:00:00+02:00333315minPDBFPT275.952026-09-282026-09-28T16:26:41
2026-09-28T08:15:00+02:00343415minPDBFES254.92026-09-282026-09-28T16:26:41
2026-09-28T08:15:00+02:00343415minPDBFPT254.92026-09-282026-09-28T16:26:41
2026-09-28T08:30:00+02:00353515minPDBFES241.632026-09-282026-09-28T16:26:41
2026-09-28T08:30:00+02:00353515minPDBFPT241.632026-09-282026-09-28T16:26:41
2026-09-28T08:45:00+02:00363615minPDBFES227.522026-09-282026-09-28T16:26:41
2026-09-28T08:45:00+02:00363615minPDBFPT227.522026-09-282026-09-28T16:26:41
2026-09-28T09:00:00+02:00373715minPDBFES255.752026-09-282026-09-28T16:26:41
2026-09-28T09:00:00+02:00373715minPDBFPT255.752026-09-282026-09-28T16:26:41
2026-09-28T09:15:00+02:00383815minPDBFES241.62026-09-282026-09-28T16:26:41
2026-09-28T09:15:00+02:00383815minPDBFPT241.62026-09-282026-09-28T16:26:41
2026-09-28T09:30:00+02:00393915minPDBFES233.162026-09-282026-09-28T16:26:41
2026-09-28T09:30:00+02:00393915minPDBFPT233.162026-09-282026-09-28T16:26:41
2026-09-28T09:45:00+02:00404015minPDBFES213.582026-09-282026-09-28T16:26:41
2026-09-28T09:45:00+02:00404015minPDBFPT213.582026-09-282026-09-28T16:26:41
2026-09-28T10:00:00+02:00414115minPDBFES233.082026-09-282026-09-28T16:26:41
2026-09-28T10:00:00+02:00414115minPDBFPT233.082026-09-282026-09-28T16:26:41
2026-09-28T10:15:00+02:00424215minPDBFES229.392026-09-282026-09-28T16:26:41
2026-09-28T10:15:00+02:00424215minPDBFPT229.392026-09-282026-09-28T16:26:41
2026-09-28T10:30:00+02:00434315minPDBFES214.382026-09-282026-09-28T16:26:41
2026-09-28T10:30:00+02:00434315minPDBFPT214.382026-09-282026-09-28T16:26:41
2026-09-28T10:45:00+02:00444415minPDBFES209.872026-09-282026-09-28T16:26:41
2026-09-28T10:45:00+02:00444415minPDBFPT209.872026-09-282026-09-28T16:26:41
2026-09-28T11:00:00+02:00454515minPDBFES209.872026-09-282026-09-28T16:26:41
2026-09-28T11:00:00+02:00454515minPDBFPT209.872026-09-282026-09-28T16:26:41
2026-09-28T11:15:00+02:00464615minPDBFES1922026-09-282026-09-28T16:26:41
2026-09-28T11:15:00+02:00464615minPDBFPT1922026-09-282026-09-28T16:26:41
2026-09-28T11:30:00+02:00474715minPDBFES1822026-09-282026-09-28T16:26:41
2026-09-28T11:30:00+02:00474715minPDBFPT1822026-09-282026-09-28T16:26:41
2026-09-28T11:45:00+02:00484815minPDBFES175.582026-09-282026-09-28T16:26:41
2026-09-28T11:45:00+02:00484815minPDBFPT175.582026-09-282026-09-28T16:26:41
2026-09-28T12:00:00+02:00494915minPDBFES175.432026-09-282026-09-28T16:26:41
2026-09-28T12:00:00+02:00494915minPDBFPT175.432026-09-282026-09-28T16:26:41
2026-09-28T12:15:00+02:00505015minPDBFES1552026-09-282026-09-28T16:26:41
2026-09-28T12:15:00+02:00505015minPDBFPT1552026-09-282026-09-28T16:26:41
SQL 
SELECT
    datetime,
    period,
    period_index,
    source_interval,
    program,
    country,
    price,
    file_date,
    inserted_at
FROM omie.prices
WHERE datetime >= '2026-09-28' AND datetime < '2026-09-29'
LIMIT 100