select

date_trunc('week', block_timestamp) as weekly,

count(distinct tx_sender) as active_count,

avg(active_count) over (order by weekly, weekly rows between 6 preceding and current row) as ma7_active_count,

(select count(distinct tx_sender) from terra.core.fact_transactions) as total_active_wallet

from terra.core.fact_transactions

group by 1

),

avg_info as (

select avg(active_count) as avg_active_count

from info

select *

from info, avg_info