flyingfishAlgorand New wallets profiler
Updated 2022-05-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH new_accounts AS (
SELECT DISTINCT address
FROM flipside_prod_db.algorand.account account
LEFT JOIN flipside_prod_db.algorand.block ON account.created_at = block.block_id
WHERE block.block_timestamp::date >= '2022-01-01'
)
SELECT
asset_name,
count(*) as count_of_wallets
FROM flipside_prod_db.algorand.account_asset assets
WHERE
assets.address IN (SELECT address FROM new_accounts as adr)
AND amount > 0
GROUP BY asset_name
ORDER BY count_of_wallets DESC
LIMIT 10
Run a query to Download Data