Assuming each address holding a Stablecoin amount bigger than 0 corresponds to a different person, one can query the account asset table to obtain the current number of addresses with a count function.

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)

Assuming every unique transaction can be obtained by counting the tx_id parameter on the asset_transfer_transaction table, I created 2 charts to visualize the trend in transactions per day for USDC (in orange, asset_id 31566704) and Tether USDT (in blue, asset_id 312769).

The first one shows the transactions per day since March 2020 and the second one shows the transactions per day since October 1st 2021 to "zoom in" the latest period due to the increase in number of transactions.

On October 7th 2021,the USDC transactions went over 2000, an all time high at the time. Since then, total transactions for both Stablecoins increased significantly. USDC has more activity compared to USDT overall except for a short period of time between January 10th and 19th. The ATH for the most transactions per day was achieved on October 19th for USDC for a total 47.9k.

For better visualization, the distribution of holders as the number of wallets holding a concrete amount for USDT and USDC is shown on two separate bar graphs on the chart below. The wallet denomination has been chosen like this:

• MOUSE 0 - 1000

• CAT 1000 - 10000

• DOG 100000 - 1000000

• ELEPHANT 1000000 - 10000000

• DINOSAUR >10000000

One can say that USDC has a "better" distribution than USDT because the ELEPHANTS in USDT add to almost 40% of the total number of wallets implying more inequality.

Interestingly, both coins have over 1.4 million wallet with 0 balance.

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.