select

date_trunc('week', block_timestamp) as "Day",

sum(fee) as "fee",

avg("fee") over (order by "Day", "Day" rows between 6 preceding and current row) as "MA7 fee",

sum("fee") over (order by "Day") as "Cum fee",

avg(fee) as "AVG tx fee"

from terra.core.fact_transactions

where fee_denom = 'uluna'

group by 1

),

avg_info as (

select

avg("fee") as "AVG fee", avg("AVG tx fee") as "AVG tx fee per week"

from info

select *

from info, avg_info