PapasotgoBTC & goETH users
    Updated 2023-01-03
    SELECT
    asset_name AS ASA,
    asset_id,
    COUNT(DISTINCT(address)) AS wallets,
    sum(amount)/100000000 AS Total_amount
    FROM
    algorand.account_asset
    WHERE
    asset_id IS NOT NULL
    AND
    (
    asset_id = '386192725' OR
    asset_id = '386195940'
    )
    AND
    amount > 0
    AND
    amount < 20999850187708
    GROUP BY asset_id, asset_name
    Order by wallets DESC


    Run a query to Download Data