KaskoazulAlgorand_Stablecoin_number_of_people
    Updated 2022-02-07
    --Algorand Stablecoin Popularity USDC vs USDT

    --Question 17: Now that xBacked(a decentralized stablecoin: https://www.xbacked.io/) is in testnet, let’s take a look at two of the biggest stable coins on Algorand: USDC and USDT.
    --What’s the number of people who currently hold USDC vs USDT (Tip: Use the Account asset table)
    --Create a time series chart counting the number of transactions a day for each stablecoin(Tip: Use the asset_transfer_transaction table)
    --Create 1 chart for each stablecoin visualizing the current distribution of holders. 3a. Does one have a better distribution than the other? If so, explain why.
    --Tip: USDC’s asset ID is 31566704 USDT’s asset ID is 312769

    SELECT
    asset_name,
    COUNT(address) as Number_of_addresses
    FROM
    algorand.account_asset
    WHERE
    amount > 0 AND asset_id = 31566704 --USDC
    OR amount > 0 AND asset_id = 312769 --USDT
    GROUP BY 1


    Run a query to Download Data