ErsvanTop volume sales uin NFD
Updated 2022-06-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT ASSET_NAME AS NFD_NAME, SUM(AMOUNT) AS Volume_of_sales FROM(
SELECT
P.TX_ID,
P.TX_GROUP_ID,
A.ASSET_ID,
A.ASSET_NAME,
AMOUNT
FROM flipside_prod_db.algorand.PAYMENT_TRANSACTION AS P
JOIN flipside_prod_db.algorand.asset AS A ON A.CREATOR_ADDRESS = P.SENDER
WHERE
A.ASSET_NAME LIKE '%.algo'
AND TX_GROUP_ID IS NOT NULL
AND AMOUNT IS NOT NULL
AND ASSET_NAME NOT LIKE '%nearlymad%'
AND ASSET_NAME NOT LIKE 'infinit%'
)
GROUP BY ASSET_NAME, ASSET_ID
ORDER BY Volume_of_sales DESC
LIMIT 10
Run a query to Download Data