flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
top 10 most popular assets
glass_blossoms
top 10 most popular assets
Updated 2022-02-05
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
count
(
asset_name
)
,
asset_name
,
asset_last_removed
,
asset_id
--count (distinct address) as Wallet_address
from
algorand
.
account_asset
--where amount > 0
group
by
2
,
3
,
4
order
by
1
desc
limit
10
Results
Run a query to Download Data