piperPLANET main wallets
Updated 2022-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
⌄
/*
Algorand - 1. Most Popular ASAs
- 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
sender,
count(tx_id) AS txs
FROM
algorand.transactions
WHERE
asset_id = '27165954'
GROUP BY sender
ORDER BY txs DESC
LIMIT 10;
Run a query to Download Data