agg_load_min_by_h.sql

copy(
with 
base_data as
(
select 
	alm.*
	, dd.day
	, dd.hour
	, dd.minute
  from 
        agg_load_min_by_h_hh_p alm
     inner join
        dim_date dd
        on 
        alm.ts = dd.ts
)
select 
 row_number() over() as id
,   min(bd.ts) as ts
, sum(bd.value) as value  --sum of avg(...)
, max(bd.property) as property
, bd.house_id  
, min(bd.household_id) as household_id
, min(bd.plug_id) as plug_id

from base_data bd
group by 
  bd.house_id
 ,bd.day
 ,bd.hour
 ,bd.minute
)
to 'D:\\development\\projects\\xd-keynote\\load_test\\agg_load_min_by_h.csv' CSV

Query returned successfully: 40120 rows affected, 5989 ms execution time.