KaskoazulAlgorand Stablecoing Number of transactions all time
Updated 2022-02-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
--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