ESIOS / Table

esios.indicator_vintages_gates

Forecast snapshots preserved at each market gate.

ESIOSPer recordBy sourceUp to date
Coverage2026-08-31 – 2026-11-161,672,735 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.

indicator_idUInt32geo_idUInt32datetimeDateTime('Europe/Madrid')vintageLowCardinality(String)capture_dateDatecaptured_atDateTime('Europe/Madrid')valueFloat64
474422026-11-02 00:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 00:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 01:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 01:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 02:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 02:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 03:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 03:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 04:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 04:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 05:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 05:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 06:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 06:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 07:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 07:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 08:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 08:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 09:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 09:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 10:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 10:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 11:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 11:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 12:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 12:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 13:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 13:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 14:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 14:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 15:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 15:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 16:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 16:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 17:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 17:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 18:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 18:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 19:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 19:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 20:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 20:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 21:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 21:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 22:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 22:00:00PHF12026-11-012026-11-01 16:00:162041.1
474422026-11-02 23:00:00PDBF2026-11-012026-11-01 13:00:132041.1
474422026-11-02 23:00:00PHF12026-11-012026-11-01 16:00:162041.1
474602026-11-02 00:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 00:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 01:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 01:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 02:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 02:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 03:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 03:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 04:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 04:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 05:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 05:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 06:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 06:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 07:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 07:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 08:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 08:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 09:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 09:00:00PHF12026-11-012026-11-01 16:00:161003.4
474602026-11-02 10:00:00PDBF2026-11-012026-11-01 13:00:131003.4
474602026-11-02 10:00:00PHF12026-11-012026-11-01 16:00:161003.4
46087412026-11-02 00:00:00PDBF2026-11-012026-11-01 13:00:1321838
46087412026-11-02 00:00:00PHF12026-11-012026-11-01 16:00:1621857
46087412026-11-02 00:15:00PDBF2026-11-012026-11-01 13:00:1321545
46087412026-11-02 00:15:00PHF12026-11-012026-11-01 16:00:1621542
46087412026-11-02 00:30:00PDBF2026-11-012026-11-01 13:00:1321271
46087412026-11-02 00:30:00PHF12026-11-012026-11-01 16:00:1621239
46087412026-11-02 00:45:00PDBF2026-11-012026-11-01 13:00:1321014
46087412026-11-02 00:45:00PHF12026-11-012026-11-01 16:00:1620949
46087412026-11-02 01:00:00PDBF2026-11-012026-11-01 13:00:1320753
46087412026-11-02 01:00:00PHF12026-11-012026-11-01 16:00:1620642
46087412026-11-02 01:15:00PDBF2026-11-012026-11-01 13:00:1320521
46087412026-11-02 01:15:00PHF12026-11-012026-11-01 16:00:1620384
46087412026-11-02 01:30:00PDBF2026-11-012026-11-01 13:00:1320300
46087412026-11-02 01:30:00PHF12026-11-012026-11-01 16:00:1620148
46087412026-11-02 01:45:00PDBF2026-11-012026-11-01 13:00:1320096
46087412026-11-02 01:45:00PHF12026-11-012026-11-01 16:00:1619938
46087412026-11-02 02:00:00PDBF2026-11-012026-11-01 13:00:1319854
46087412026-11-02 02:00:00PHF12026-11-012026-11-01 16:00:1619686
46087412026-11-02 02:15:00PDBF2026-11-012026-11-01 13:00:1319705
46087412026-11-02 02:15:00PHF12026-11-012026-11-01 16:00:1619549
46087412026-11-02 02:30:00PDBF2026-11-012026-11-01 13:00:1319593
46087412026-11-02 02:30:00PHF12026-11-012026-11-01 16:00:1619456
46087412026-11-02 02:45:00PDBF2026-11-012026-11-01 13:00:1319512
46087412026-11-02 02:45:00PHF12026-11-012026-11-01 16:00:1619398
46087412026-11-02 03:00:00PDBF2026-11-012026-11-01 13:00:1319426
46087412026-11-02 03:00:00PHF12026-11-012026-11-01 16:00:1619344
46087412026-11-02 03:15:00PDBF2026-11-012026-11-01 13:00:1319383
46087412026-11-02 03:15:00PHF12026-11-012026-11-01 16:00:1619318
46087412026-11-02 03:30:00PDBF2026-11-012026-11-01 13:00:1319350
46087412026-11-02 03:30:00PHF12026-11-012026-11-01 16:00:1619295
SQL
SELECT
    indicator_id,
    geo_id,
    datetime,
    vintage,
    capture_date,
    captured_at,
    value
FROM esios.indicator_vintages_gates
WHERE datetime >= '2026-11-02' AND datetime < '2026-11-03'
LIMIT 100