kasadeghAlgo_New_Address
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with new_wallets as (
select date(b.BLOCK_TIMESTAMP) as date, count(distinct a.ADDRESS) as total_number_of_new_wallets from flipside_prod_db.algorand.account as a
join flipside_prod_db.algorand.block as b
on b.BLOCK_ID=a.CREATED_AT
where a.ACCOUNT_CLOSED=0
group by date
)
select * from new_wallets
order by date
Run a query to Download Data