ErsvanTop volume sales uin NFD
    Updated 2022-06-24
    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