flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Copy of Most Popular ASAs (wallets and asset name)
Papasot
Copy of Most Popular ASAs (wallets and asset name)
Updated 2023-01-03
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
asset_name
AS
ASA
,
asset_id
,
COUNT
(
DISTINCT
(
address
)
)
AS
wallets
,
SUM
(
amount
)
FROM
algorand
.
account_asset
GROUP
BY
asset_id
,
asset_name
Order
by
wallets
DESC
Limit
10
Results
Run a query to Download Data