shreexActive Wallets
    Updated 2022-12-30
    with active_wallets as (
    select
    date_trunc('week',block_timestamp::date) as date1,
    tx_sender as wallet,
    count(*) as txs
    from terra.core.fact_transactions
    GROUP BY 1,2
    HAVING count(*) >= 4
    )
    select
    date_trunc('week',date1) as date,
    count(distinct wallet) as active_wallets,
    avg(active_wallets) over (order by date) as avg_active_wallets
    from active_wallets
    GROUP BY DATE
    ORDER BY DATE
    Run a query to Download Data