ngxuan885January 2022 New Wallets Created-1
Updated 2022-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with JAN_block_id as
(SELECT MIN(block_id) as min, MAX(block_id) as max from algorand.block
WHERE block_timestamp>='2022-01-01' AND block_timestamp<'2022-02-01'),
valid_wallets as (
SELECT address from algorand.account
where created_at between (select min from JAN_block_id)
and (select max from JAN_block_id)
and address not in (select address from algorand.account_app where app_id ='552635992')
) -- Tinyman app id to exclude Tinyman pools
SELECT asset_name,COUNT(*) as number_of_wallets
from algorand.account_asset
where address in (SELECT address from valid_wallets)
and asset_name is not null
GROUP by 1 order by 2 DESC limit 5
Run a query to Download Data