PapasotAlgorand new wallets
Updated 2023-01-02
9
1
2
3
4
5
6
7
8
9
›
⌄
select
date_trunc('day',b.block_timestamp) as date,
count(distinct a.address) as n_wallets,
sum(n_wallets) over (order by date asc rows between unbounded preceding and current row) as cum_n_wallets
from algorand.account a
left join algorand.block b on b.block_id = a.created_at
where b.block_timestamp >= '2021-10-28'
group by date
order by date desc
Run a query to Download Data