PapasotgoBTC & goETH users
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
asset_name AS ASA,
asset_id,
COUNT(DISTINCT(address)) AS wallets,
sum(amount)/100000000 AS Total_amount
FROM
algorand.account_asset
WHERE
asset_id IS NOT NULL
AND
(
asset_id = '386192725' OR
asset_id = '386195940'
)
AND
amount > 0
AND
amount < 20999850187708
GROUP BY asset_id, asset_name
Order by wallets DESC
Run a query to Download Data