princefarzamThe top ten assets by the number of transfers since Feb 2022
    Updated 2022-04-07
    SELECT
    b.ASSET_NAME,
    COUNT(DISTINCT a.TX_ID) AS number_of_transfers
    FROM algorand.asset_transfer_transaction a INNER JOIN algorand.asset b ON a.ASSET_ID=b.ASSET_ID
    WHERE a.BLOCK_TIMESTAMP>= '2022-02-01'
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10
    Run a query to Download Data