joltio
Sign inStart free

ESIOS / Table

esios.indicator_vintages_gates

Forecast snapshots preserved at each market gate.

ESIOSPer recordBy sourceUp to date
Coverage2026-08-29 – 2026-09-29776,103 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-09-29. 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-09-28 · 100 rows · 2026-09-28 – 2026-09-29

CSVParquet
indicator_idUInt32geo_idUInt32datetimeDateTime('Europe/Madrid')vintageLowCardinality(String)capture_dateDatecaptured_atDateTime('Europe/Madrid')valueFloat64
54387412026-09-28T00:00:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:00105
54387412026-09-28T00:00:00+02:00PHF12026-09-272026-09-27T16:03:56+02:00105
54387412026-09-28T00:00:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00115
54387412026-09-28T00:00:00+02:00PHF32026-09-282026-09-28T11:03:43+02:00119
54387412026-09-28T00:15:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:00100
54387412026-09-28T00:15:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0099
54387412026-09-28T00:15:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00109
54387412026-09-28T00:15:00+02:00PHF32026-09-282026-09-28T11:03:43+02:00114
54387412026-09-28T00:30:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0097
54387412026-09-28T00:30:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0095
54387412026-09-28T00:30:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00106
54387412026-09-28T00:30:00+02:00PHF32026-09-282026-09-28T11:03:43+02:00110
54387412026-09-28T00:45:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0094
54387412026-09-28T00:45:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0093
54387412026-09-28T00:45:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00105
54387412026-09-28T00:45:00+02:00PHF32026-09-282026-09-28T11:03:43+02:00106
54387412026-09-28T01:00:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0093
54387412026-09-28T01:00:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0091
54387412026-09-28T01:00:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00105
54387412026-09-28T01:00:00+02:00PHF32026-09-282026-09-28T11:03:43+02:00104
54387412026-09-28T01:15:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0091
54387412026-09-28T01:15:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0090
54387412026-09-28T01:15:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00105
54387412026-09-28T01:15:00+02:00PHF32026-09-282026-09-28T11:03:43+02:00100
54387412026-09-28T01:30:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0088
54387412026-09-28T01:30:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0089
54387412026-09-28T01:30:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00105
54387412026-09-28T01:30:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0098
54387412026-09-28T01:45:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0084
54387412026-09-28T01:45:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0088
54387412026-09-28T01:45:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00105
54387412026-09-28T01:45:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0095
54387412026-09-28T02:00:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0081
54387412026-09-28T02:00:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0087
54387412026-09-28T02:00:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00105
54387412026-09-28T02:00:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0062
54387412026-09-28T02:15:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0077
54387412026-09-28T02:15:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0085
54387412026-09-28T02:15:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00104
54387412026-09-28T02:15:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0060
54387412026-09-28T02:30:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0075
54387412026-09-28T02:30:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0082
54387412026-09-28T02:30:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00102
54387412026-09-28T02:30:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0059
54387412026-09-28T02:45:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0073
54387412026-09-28T02:45:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0080
54387412026-09-28T02:45:00+02:00PHF22026-09-272026-09-27T23:00:32+02:00100
54387412026-09-28T02:45:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0058
54387412026-09-28T03:00:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0071
54387412026-09-28T03:00:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0077
54387412026-09-28T03:00:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0098
54387412026-09-28T03:00:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0071
54387412026-09-28T03:15:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0069
54387412026-09-28T03:15:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0074
54387412026-09-28T03:15:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0095
54387412026-09-28T03:15:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0070
54387412026-09-28T03:30:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0066
54387412026-09-28T03:30:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0071
54387412026-09-28T03:30:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0091
54387412026-09-28T03:30:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0068
54387412026-09-28T03:45:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0062
54387412026-09-28T03:45:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0068
54387412026-09-28T03:45:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0087
54387412026-09-28T03:45:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0066
54387412026-09-28T04:00:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0059
54387412026-09-28T04:00:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0067
54387412026-09-28T04:00:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0083
54387412026-09-28T04:00:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0062
54387412026-09-28T04:15:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0055
54387412026-09-28T04:15:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0063
54387412026-09-28T04:15:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0078
54387412026-09-28T04:15:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0056
54387412026-09-28T04:30:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0052
54387412026-09-28T04:30:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0060
54387412026-09-28T04:30:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0073
54387412026-09-28T04:30:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0049
54387412026-09-28T04:45:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0048
54387412026-09-28T04:45:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0055
54387412026-09-28T04:45:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0068
54387412026-09-28T04:45:00+02:00PHF32026-09-282026-09-28T11:03:43+02:0042
54387412026-09-28T05:00:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0046
54387412026-09-28T05:00:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0052
54387412026-09-28T05:00:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0066
54387412026-09-28T05:00:00+02:00PHF32026-09-282026-09-28T11:03:43+02:002
54387412026-09-28T05:15:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0042
54387412026-09-28T05:15:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0046
54387412026-09-28T05:15:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0057
54387412026-09-28T05:15:00+02:00PHF32026-09-282026-09-28T11:03:43+02:002
54387412026-09-28T05:30:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0037
54387412026-09-28T05:30:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0041
54387412026-09-28T05:30:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0041
54387412026-09-28T05:30:00+02:00PHF32026-09-282026-09-28T11:03:43+02:001
54387412026-09-28T05:45:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0032
54387412026-09-28T05:45:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0035
54387412026-09-28T05:45:00+02:00PHF22026-09-272026-09-27T23:00:32+02:0025
54387412026-09-28T05:45:00+02:00PHF32026-09-282026-09-28T11:03:43+02:001
54387412026-09-28T06:00:00+02:00PDBF2026-09-272026-09-27T14:00:25+02:0026
54387412026-09-28T06:00:00+02:00PHF12026-09-272026-09-27T16:03:56+02:0030
54387412026-09-28T06:00:00+02:00PHF22026-09-272026-09-27T23:00:32+02:008
54387412026-09-28T06:00:00+02:00PHF32026-09-282026-09-28T11:03:43+02:004
SQL 
SELECT
    indicator_id,
    geo_id,
    datetime,
    vintage,
    capture_date,
    captured_at,
    value
FROM esios.indicator_vintages_gates
WHERE datetime >= '2026-09-28' AND datetime < '2026-09-29'
LIMIT 100