shreexActive Wallets
Updated 2022-12-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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