Algorand - New Wallets In May

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

    db_img

    Description of work:

    In this Bounties we want to examine the May wallets. To do this we want to do the following:

    • How many wallets have a balance greater than 1 ALGO?
    • 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?
    • Show the distribution of ALGO holdings for 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?

    1 ---> How many wallets have a balance greater than 1 ALGO?

    To do this in the [algorand.account] table we count the total number of wallets and the number of those with more than one ALGO balance.

    Loading...
    Loading...

    2 ---> How many of those wallets sent or received a transaction in May?

    To do this in the [algorand.account] table we find the total number of wallets having more than one ALGO balance. Then in the [payment_transaction] table we find the list and the number of those who had a sender or receiver in May

    Loading...
    Loading...
    Loading...

    According to the results, it is clear that

    • Wallets with more than one ALGO balance received more transactions in May than they send
    • The number of transactions received for these wallets in May was more than the number of transactions sent each day
    • The maximum number of transactions for these wallets (sending and receiving) was on the 30th and 31th (late May)

    3 ---> How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this?

    Loading...
    Loading...
    Loading...
    Loading...

    According to the results obtained, it is clear that:

    • The total number of wallets created in May is 1640237, of which 29636 have a balance of more than 1 ALGO, ie about 1.8%
    • The maximum number of wallets created is related to days 5, 6, 7 and 8 May

    4 ---> Show the distribution of ALGO holdings for new wallets

    According to the results, it is clear that:

    • About 98.9% of wallets created in May have a balance of less than 10 ALGOs
    Loading...
    Loading...

    5 ---> What is the average ALGO holding of these new wallets?

    Loading...

    6 ---> What other ASAs do these new wallets from May hold?

    Loading...
    Loading...

    The charts above show the top 10 ASAs holds by new wallets. According to the results, it is clear that:

    • Xfinite Entertainment Token with 92.2%, it has the largest number of holders among new wallets, followed by Smile Coin and PLANET.

    7 ---> How many of these wallets have performed a swap?

    Loading...