• image Source
  This Link

Overview

In this dashboard, I will answer this question from Flipside Crypto:

• Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May?

• How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets?

• What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap?

• Finally, note anything else interesting about these wallets! Why are these wallets being created and what are they doing on Algorand?"

Introduction

What Is Algorand?

• Algorand (ALGO) is both a digital currency and blockchain platform. -The Algorand platform is designed to process many transactions quickly, similar to a major payments processor like Mastercard or Visa.
• Algorand can host other cryptocurrencies and blockchain-based projects, making it a direct competitor to Ethereum. ALGO, the platform's native currency, is used to secure the Algorand blockchain and pay processing fees for Algorand-based transactions.
• Algorand is an open-source blockchain, meaning that anyone can view and contribute to the platform's code. Algorand uses an operating protocol called pure proof-of-stake (PPoS), which recruits network operators from the entire pool of ALGO coin holders.
• for more information read Here

Method

-> >To get this data, I first created a CTE and made the list I wanted from the wallet addresses.
To do this, I used the flipside_prod_db.algorand.account and flipside_prod_db.algorand.blocktables.

> I used the second table to give time information to wallets.

> For the second question, I categorized the assets of my wallets using the case command.

> For question 3, I used the flipside_prod_db.algorand.account_asset table, but gave the list I made from the wallets to the Join table.

> Finally, I used flipside_prod_db.algorand.swaps to get swaps.

Chart & Analyze;

• Chart above the distribution of ALGO holdings for these new wallets.
• 7.1% have 1 AlGO
• 37.5% have less than 10 ALGO
• 20.8% have less then 100 ALGO
• 25.1% have between 100- 1000 ALGO
• 15.5% have between 1k-50k ALGO
• 0.286% have between 50k-500k ALGO
• 0.0566% have more than 500k

• 234Wallet have 1 AlGO
• 11.246k Wallet have less than 10 ALGO
• 6253 Wallet have less then 100 ALGO
• 7525 Wallet have between 100- 1000 ALGO
• 4659 Wallet have between 1k-50k ALGO
• 86 Wallet have between 50k-500k ALGO
• 17 Wallet have more than 500k

• The chart above shows what token they kept most in their wallets.
• Most wallets have USDC and USDT in their wallet.

additional

• The chart above shows the addresses added per day and the number of addresses cumulative address per day.
• On May 12, a large number of addresses (2306 addresses) were added.

Conclusions

1. 30.1k addresses have 1 ALGO in their wallet.
2. 12.6k addresses were sent or received in May.
3. 1.7 million wallets were added in May.
4. 7.1% have 1 AlGO in their wallet .
5. The average algo in each wallet is 5690 algo.
6. Most wallets have USDC and USDT in their wallet.
7. 2431 new wallets had a swap in May

Thank you for reading!