KaskoazulTop 10 ASA by new addresses number
Updated 2022-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH New_wallets AS (
SELECT
address
FROM
algorand.account
WHERE
created_at>= 18363444 AND created_at<=18974008 -- 18363444 January first block 18974008 January last block
),
TOP_10 AS (
SELECT
count(address) as Number_of_addresses,
asset_id
FROM
algorand.account_asset
WHERE
address IN ( SELECT * from New_wallets )
GROUP BY 2
ORDER BY 1 DESC
LIMIT 10
)
SELECT
Number_of_addresses,
CASE asset_id
WHEN '287867876' THEN 'Opulous'
WHEN '312769' THEN 'Tether USDt'
WHEN '31566704' THEN 'USDC'
WHEN '27165954' THEN 'PLANET'
WHEN '137020565' THEN 'Buy Token'
WHEN '300208676' THEN 'Smile Coin'
WHEN '226701642' THEN 'Yieldly'
WHEN '283820866' THEN 'Xfinite Entertainment Token'
WHEN '230946361' THEN 'AlgoGems'
WHEN '548981315' THEN 'Drape Coin (deleted)'
END AS ASA
Run a query to Download Data