Query: Iberian Blackout (April 2025) - Power Demand by jsoares

SELECT 
  strftime('%H:%M', "time" - INTERVAL '4 hour') AS "time",
  "actual",
  "forecast",
  "scheduled"
FROM @jsoares.iberian_blackout_april_2025.demand
WHERE @jsoares.iberian_blackout_april_2025.demand.time >= TIMESTAMP '2025-04-28 03:00:00'

time	actual	forecast	scheduled
23:00	19828	19629	19650
23:05	19716	19645	19650
23:10	19767	19644	19650
23:15	19734	19627	19707
23:20	19658	19607	19707
23:25	19623	19597	19707
23:30	19744	19598	19568
23:35	19625	19598	19568
23:40	19645	19585	19568
23:45	19478	19561	19497
23:50	19465	19555	19497
23:55	19533	19599	19497
00:00	19571	19693	19396
00:05	19420	19790	19396
00:10	19489	19843	19396
00:15	19798	19851	19392
00:20	19853	19840	19392
00:25	19683	19836	19392
00:30	19700	19838	19398
00:35	19740	19859	19398
00:40	19624	19911	19398
00:45	19569	19994	19793
00:50	19514	20045	19793
00:55	19644	20001	19793
01:00	19826	19862	19962
01:05	20070	19739	19962
01:10	20177	19740	19962
01:15	20144	19866	20244
01:20	20212	20050	20244
01:25	20352	20223	20244
01:30	20617	20385	20597
01:35	20418	20560	20597
01:40	20437	20771	20597
01:45	20747	21017	21237
01:50	20754	21263	21237
01:55	21224	21471	21237
02:00	21350	21642	22067
02:05	21907	21817	22067
02:10	22309	22037	22067
02:15	22628	22303	22726
02:20	22829	22591	22726
02:25	22962	22876	22726
02:30	23105	23158	23701
02:35	23452	23432	23701
02:40	23752	23692	23701
02:45	23823	23938	24384
02:50	24102	24205	24384
02:55	24250	24528	24384
03:00	24730	24906	25413
03:05	25184	25278	25413
03:10	25482	25581	25413
03:15	25770	25816	26133
03:20	25824	26020	26133
03:25	26053	26229	26133
03:30	26192	26442	26456
03:35	26287	26643	26456
03:40	26310	26812	26456
03:45	26558	26950	26785
03:50	26700	27086	26785
03:55	26909	27252	26785
04:00	26917	27447	27294
04:05	27066	27627	27294
04:10	27443	27748	27294
04:15	27470	27810	27805
04:20	27453	27838	27805
04:25	27606	27857	27805
04:30	27532	27868	27796
04:35	27339	27870	27796
04:40	27268	27863	27796
04:45	27163	27847	27799
04:50	27221	27812	27799
04:55	27141	27745	27799
05:00	27154	27647	26994
05:05	26988	27548	26994
05:10	26973	27478	26994
05:15	27055	27437	26795
05:20	27077	27402	26795
05:25	26677	27352	26795
05:30	26808	27288	26891
05:35	26763	27228	26891
05:40	26649	27190	26891
05:45	26772	27175	26497
05:50	26485	27131	26497
05:55	26661	27005	26497
06:00	26329	26797	26023
06:05	26295	26590	26023
06:10	26360	26464	26023
06:15	26108	26421	26263
06:20	25933	26403	26263
06:25	25922	26352	26263
06:30	25800	26270	26013
06:35	26000	26184	26013
06:40	26080	26123	26013
06:45	25872	26085	26048
06:50	25748	26023	26048
06:55	25344	25890	26048
07:00	25157	25684	25345
07:05	25731	25482	25345
07:10	26334	25359	25345
07:15	25808	25315	25166
07:20	25340	25301	25166
07:25	25257	25270	25166
07:30	25325	25223	25095
07:35	25090	25174	25095
07:40	25191	25138	25095
07:45	25173	25115	25131
07:50	25005	25093	25131
07:55	24658	25060	25131
08:00	24708	25015	24873
08:05	24616	24974	24873
08:10	25367	24950	24873
08:15	25110	24943	24974
08:20	25124	24945	24974
08:25	25283	24946	24974
08:30	25184	24948	25140
08:35	14185	24949	25140
08:40	12732	24951	25140
08:45	12425	24954	24918
08:50	11838	24960	24918
08:55	11803	24972	24918
09:00	11654	24990	24932
09:05	11562	25005	24932
09:10	10902	25009	24932
09:15	10702	25003	25060
09:20	10648	24988	25060
09:25	10552	24966	25060
09:30	10556	24939	24281
09:35	10480	24906	24281
09:40	10503	24866	24281
09:45	10624	24821	24846
09:50	10627	24771	24846
09:55	10665	24718	24846
10:00	10667	24662	24574
10:05	10788	24605	24574
10:10	10815	24548	24574
10:15	10876	24490	24396
10:20	10941	24432	24396
10:25	10995	24375	24396
10:30	11009	24318	24234
10:35	10982	24264	24234
10:40	10985	24216	24234
10:45	11069	24173	24160
10:50	11140	24128	24160
10:55	11258	24074	24160
11:00	11445	24009	20879
11:05	11295	23946	20879
11:10	11417	23899	20879
11:15	11482	23867	25167
11:20	11540	23842	25167
11:25	11718	23816	25167
11:30	11922	23788	24893
11:35	12025	23763	24893
11:40	11946	23747	24893
11:45	11834	23741	25063
11:50	11855	23731	25063
11:55	11797	23707	25063
12:00	11885	23669	25078
12:05	11915	23634	25078
12:10	11737	23622	25078
12:15	11947	23631	24927
12:20	12025	23651	24927
12:25	12033	23669	24927
12:30	12034	23685	25271
12:35	12082	23705	25271
12:40	12157	23735	25271
12:45	12208	23775	25529
12:50	12062	23814	25529
12:55	12117	23840	25529
13:00	12156	23853	25398
13:05	12318	23870	25398
13:10	12380	23907	25398
13:15	12448	23964	25474
13:20	12395	24030	25474
13:25	12536	24094	25474
13:30	12658	24156	27443
13:35	12705	24222	27443
13:40	12916	24298	27443
13:45	13209	24383	25640
13:50	13485	24466	25640
13:55	13612	24536	25640
14:00	13755	24593	28719
14:05	14150	24654	28719
14:10	14048	24736	28719
14:15	14245	24840	28633
14:20	14425	24954	28633
14:25	14526	25069	28633
14:30	14570	25184	28715
14:35	14600	25301	28715
14:40	14655	25422	28715
14:45	14725	25546	28720
14:50	14779	25673	28720
14:55	14923	25805	28720
15:00	15058	25942	30002
15:05	15429	26079	30002
15:10	15436	26213	30002
15:15	15603	26344	30001
15:20	15814	26473	30001
15:25	15846	26599	30001
15:30	15824	26723	30467
15:35	15904	26849	30467
15:40	15891	26980	30467
15:45	15915	27115	31512
15:50	15900	27246	31512
15:55	16041	27365	31512
16:00	15983	27472	33261
16:05	16637	27582	33261
16:10	16771	27713	33261
16:15	16997	27863	33612
16:20	17034	28030	33612
16:25	15884	28212	33612
16:30	16892	28407	34332
16:35	17184	28591	34332
16:40	17315	28736	34332
16:45	17835	28842	34246
16:50	18219	28989	34246
16:55	18356	29253	34246
17:00	18287	29636	33233
17:05	18220	29997	33233
17:10	18260	30195	33233
17:15	17976	30232	33284
17:20	17985	30186	33284
17:25	17943	30137	33284
17:30	17889	30084	33138
17:35	17926	30006	33138
17:40	17941	29879	33138
17:45	18010	29703	32570
17:50	18181	29511	32570
17:55	18330	29334	32570
18:00	18419	29173	25133
18:05	18600	28998	25133
18:10	18673	28779	25133
18:15	18792	28517	27746
18:20	19024	28237	27746
18:25	19095	27964	27746
18:30	19096	27698	27603
18:35	18882	27443	27603
18:40	18737	27200	27603
18:45	18750	26970	29127
18:50	18633	26730	29127
18:55	18688	26456	29127
19:00	18776	26148	24186
19:05	18696	25849	24186
19:10	18725	25605	24186
19:15	18922	25414	27221
19:20	19038	25251	27221
19:25	18987	25091	27221
19:30	20909	24933	27216
19:35	21224	24783	27216
19:40	21275	24648	27216
19:45	21266	24528	27209
19:50	21190	24416	27209
19:55	21360	24305	27209
20:00	21199	24194	20865
20:05	20694	24088	20865
20:10	20655	23989	20865
20:15	20300	23898	20860
20:20	20332	23809	20860
20:25	20298	23716	20860
20:30	19998	23620	23516
20:35	19892	23524	23516
20:40	19613	23427	23516
20:45	19586	23331	23516
20:50	19714	23234	23516
20:55	19433	23134	23516
21:00	19559	23031	21833
21:05	19657	22929	21833
21:10	19711	22830	21833
21:15	19675	22735	21833
21:20	20057	22642	21833
21:25	20103	22548	21833
21:30	20057	22452	18387
21:35	20085	22361	18387
21:40	20193	22277	18387
21:45	20258	22200	21806
21:50	20229	22119	21806
21:55	20251	22023	21806
22:00	20287	21912	20423
22:05	20422	21805	20423
22:10	20220	21721	20423
22:15	19697	21660	20423
22:20	19617	21610	20423
22:25	19412	21559	20423
22:30	20211	21509	21336
22:35	20035	21462	21336
22:40	19865	21424	21336
22:45	19733	21395	20307
22:50	19898	21367	20307
22:55	19987	21330	20307
23:00	20030	21286	19615