KaskoazulAlgorand Stablecoing Number of transactions all time
    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
    date_trunc('DAY', block_timestamp) as DATE,
    asset_id,
    count(tx_id) as number_transactions
    FROM
    algorand.asset_transfer_transaction
    WHERE
    asset_amount > 0 AND asset_id = 31566704 --USDC
    OR asset_amount > 0 AND asset_id = 312769 --USDT
    GROUP BY 1, 2
    ORDER BY 1 DESC
    Run a query to Download Data