monarettagoBTC and goETH has been minted by users
    Updated 2022-06-30
    select
    case when tx.asset_id = '386192725' then 'goBTC'else 'goETH' end as "Asset Name",
    COUNT(DISTINCT asset_receiver) as "Number of Wallets",sum(ASSET_AMOUNT/ power(10,algoasset.decimals)) as "Total Amount"
    from algorand.asset_transfer_transaction as tx ,algorand.asset as algoasset

    WHERE sender = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4' and tx.asset_id in (386195940,386192725)
    and algoasset.asset_id=tx.asset_id
    GROUP BY tx.asset_id
    Run a query to Download Data