Papasotstablecoin data on Algorand
    Updated 2022-05-30
    SELECT
    asset_name AS ASA,
    asset_id,
    COUNT(DISTINCT(address)) AS wallets,
    sum(amount)/1000000 AS Total_amount
    FROM
    algorand.account_asset
    WHERE
    asset_id IS NOT NULL
    AND
    (asset_id = '465865291' or asset_id = '31566704' or asset_id = '312769')
    AND
    amount > 0
    AND
    amount < 20999850187708
    GROUP BY asset_id, asset_name
    Order by wallets DESC
    Run a query to Download Data