OMIE / Table

omie.continuous_volume

Continuous intraday market continuous volume.

OMIEPer recordBy sourceUp to date
Coverage2022-11-30 – 2026-09-285,508,814 rows
In your planPublic accessSign in to check access

Source: OMIE. Latest data: 2026-09-28. 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-27 – 2026-09-28

datetimeDateTime('Europe/Madrid')period_indexUInt16roundUInt16countryLowCardinality(String)sideLowCardinality(String)unit_typeLowCardinality(String)energyFloat64file_dateDateinserted_atDateTime
2026-09-27T16:00:00+02:00651ESVentaall13.72026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:00651ESVentaproduccion13.72026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:00652ESVentaall1.62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:00652ESVentaproduccion1.62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:00655ESCompraall12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:00655ESCompraproduccion12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:00658ESVentaall8.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:00658ESVentaproduccion8.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:00659ESVentaall0.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:00659ESVentaproduccion0.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006510ESCompraall62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006510ESCompraproduccion62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006510ESVentaall7.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006510ESVentaproduccion7.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006511ESCompraall32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006511ESCompraproduccion32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006511ESVentaall3.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006511ESVentaproduccion3.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006513ESCompraall22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006513ESCompraproduccion22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006513ESVentaall62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006513ESVentaproduccion62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006514ESVentaall22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006514ESVentaproduccion22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006516ESCompraall41.42026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006516ESCompraproduccion41.42026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006516PTVentaall93.92026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006516PTVentaproduccion93.92026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006517ESCompraall49.32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006517ESCompraproduccion49.32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006517ESVentaall6.32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006517ESVentaproduccion6.32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006517PTVentaall6.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006517PTVentaproduccion6.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006518ESCompraall22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006518ESCompraproduccion22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006518ESVentaall52026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006518ESVentaproduccion52026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006519ESCompraall32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006519ESCompraproduccion32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006522ESCompraall10.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006522ESCompraproduccion10.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006522ESVentaall32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006522ESVentaproduccion32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006523ESCompraadquisicion0.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006523ESCompraall2.82026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006523ESCompraproduccion2.72026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006526ESVentaall12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006526ESVentaproduccion12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006530ESCompraadquisicion0.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006530ESCompraall1.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006530ESCompraproduccion12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006531ESCompraadquisicion1.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006531ESCompraall1.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006534ESCompraall12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006534ESCompraproduccion12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006534ESVentaall12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006534ESVentaproduccion12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006535ESCompraall12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006535ESCompraproduccion12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006535ESVentaall12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006535ESVentaproduccion12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006536ESVentaall38.92026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006536ESVentaproduccion38.92026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006537ESCompraall22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006537ESCompraproduccion22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006537ESVentaall27.42026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006537ESVentaproduccion27.42026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006538ESCompraall32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006538ESCompraproduccion32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006538ESVentaall31.32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006538ESVentaproduccion31.32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006539ESVentaall3.72026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006539ESVentaproduccion3.72026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006540ESVentaall245.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006540ESVentaproduccion245.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006542ESVentaall3.82026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006542ESVentaproduccion3.82026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006548ESCompraall18.72026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006548ESCompraproduccion18.72026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006548ESVentaadquisicion6.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006548ESVentaall7.92026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006548ESVentaproduccion1.72026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006549ESCompraall50.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006549ESCompraproduccion50.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006549ESVentaall10.62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006549ESVentaproduccion10.62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006550ESCompraall23.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006550ESCompraproduccion23.22026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006551ESCompraadquisicion0.62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006551ESCompraall0.62026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006553ESCompraadquisicion52026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006553ESCompraall8.32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006553ESCompraproduccion3.32026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006553ESVentaadquisicion0.12026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006553ESVentaall72026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006553ESVentaproduccion6.92026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006554ESCompraadquisicion28.82026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006554ESCompraall29.42026-09-272026-09-28T16:35:48
2026-09-27T16:00:00+02:006554ESCompraproduccion0.62026-09-272026-09-28T16:35:48
SQL
SELECT
    datetime,
    period_index,
    round,
    country,
    side,
    unit_type,
    energy,
    file_date,
    inserted_at
FROM omie.continuous_volume
WHERE datetime >= '2026-09-27' AND datetime < '2026-09-28'
LIMIT 100