select

date_trunc('week', block_timestamp) as date_week,

date_trunc('min', block_timestamp),

count(*) as count1

from terra.core.fact_transactions

group by 1,2 )

select

date_week as date1,

avg(count1/60) as Avg,

max(count1/60) as Max,

min(count1/60) as Min

from tab1

group by 1

order by 1