select

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

count(distinct tx_sender) as "Active wallet"

from terra.core.fact_transactions

group by 1

),

avg_info as (

select avg("Active wallet") as "AVG active wallet"

from info

select *

from info, avg_info