Liquicomun / Table

archives_liquicomun.timeseries

Electricity settlement timeseries.

LiquicomunPer recordBy sourceUp to date
Coverage2011-12-31 – 2026-11-16139,102,389 rows
SourceRed Eléctrica de EspañaOfficial source
In your planPublic accessSign in to check access

Source: Red Eléctrica de España. Latest data: 2026-11-16. Joltio normalizes the published values without altering them and is not affiliated with or endorsed by Red Eléctrica de España.

Sample

Sample from 2026-11-02 · 100 rows · 2026-11-02 – 2026-11-03

This sample is more than two days old.

liq_versionLowCardinality(String)file_typeLowCardinality(String)geo_regionLowCardinality(String)atr_codeLowCardinality(String)datetimeDateTime('Europe/Madrid')source_intervalLowCardinality(String)valueFloat64source_fileStringpublished_atDateTimeingested_atDateTimeversionUInt64
A1coperBALEARES2.0TD2026-11-02 00:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 01:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 02:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 03:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 04:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 05:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 06:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 07:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 08:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 09:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 10:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 11:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 12:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 13:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 14:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 15:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 16:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 17:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 18:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 19:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 20:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 21:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 22:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES2.0TD2026-11-02 23:00:001h18A1_Scoper20TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 00:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 01:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 02:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 03:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 04:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 05:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 06:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 07:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 08:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 09:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 10:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 11:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 12:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 13:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 14:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 15:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 16:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 17:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 18:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 19:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 20:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 21:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 22:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES3.0TD2026-11-02 23:00:001h18A1_Scoper30TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 00:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 01:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 02:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 03:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 04:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 05:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 06:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 07:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 08:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 09:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 10:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 11:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 12:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 13:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 14:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 15:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 16:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 17:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 18:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 19:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 20:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 21:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 22:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.1TD2026-11-02 23:00:001h7.7A1_Scoper61TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 00:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 01:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 02:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 03:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 04:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 05:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 06:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 07:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 08:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 09:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 10:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 11:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 12:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 13:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 14:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 15:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 16:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 17:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 18:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 19:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 20:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 21:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 22:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.2TD2026-11-02 23:00:001h5.4A1_Scoper62TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.3TD2026-11-02 00:00:001h4.4A1_Scoper63TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.3TD2026-11-02 01:00:001h4.4A1_Scoper63TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.3TD2026-11-02 02:00:001h4.4A1_Scoper63TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
A1coperBALEARES6.3TD2026-11-02 03:00:001h4.4A1_Scoper63TD_BALEARES_20261101_202611302026-06-16 23:08:182026-11-02 04:03:241781651298
SQL
SELECT
    liq_version,
    file_type,
    geo_region,
    atr_code,
    datetime,
    source_interval,
    value,
    source_file,
    published_at,
    ingested_at,
    version
FROM archives_liquicomun.timeseries
WHERE datetime >= '2026-11-02' AND datetime < '2026-11-03'
LIMIT 100