LTirrell1. Most Popular ASAs
Updated 2022-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- - What are the most popular ASAs on Algorand?
-- - How many wallets are holding each ASA?
-- - How many transactions happen with these ASAs?
-- - How have these stats changed over time?
SELECT
asset_name,
COUNT(asset_name) AS addresses_with_asset,
COUNT(case when amount > 0 then asset_name end) as addresses_with_value
FROM
algorand.account_asset
GROUP BY
asset_name
ORDER BY
addresses_with_asset DESC
LIMIT 10000;
Run a query to Download Data