Try Quests to earn cryptoAB2 Gallery Wallets (Algorand Week: NFTs)
Q78. Let’s look at wallets that buy from AB2 Gallery!
In the current dashboard I raying to address this issues:
-
How many wallets are buying NFTs on AB2 gallery.
-
What is the total number of unique wallets that have purchased from AB2?
-
Create a distribution plot of how many NFTs each wallet has purchased from AB2.
-
Are we seeing new wallets purchasing on AB2 or is it only wallets that have purchased from AB2 before? Chart the first purchase on AB2 by wallet over time.
-
Create a table of the top 10 wallets that are purchasing from AB2 by ALGOs and number of NFTs
Method
To Address the goals of dashboard I used following filter on algorand.payment_transaction and algorand.asset_transfer_transaction tables :
tx_group_id is not null
where try_base64_decode_string(tx_message:txn:note::string) = 'ab2.gallery'
date_trunc('day',block_timestamp) as day
min(day) as first_purchase_stamp
date_trunc('day', first_purchase_stamp) as first_purchase_date
So let's look at the findings.
- According to the above chart, the maximum amount of ALGO and USD was paid on November 9th, 2021, and after that it was into a downtrend.
- In the above PIE chart, I divided NFT holders into 5 categories. As of the chart shown, 40.2% of the NFTs belong to those addresses that have a number of between 10 to 100 NFTs, and 38.5% of NFTs belong to those that have a number of between 100 to 1000 NFTs, and the rest to others.
New wallet over time
- As we see in the last chart, new wallets purchased on AB2 Gallery are significantly ascending over time to reach an all-time high on October 10th 2021 with 997 addresses per day, and after that drop to 274 and continue on a previous increasing trend to November 17th 2021, the last uptrend day, and after that going on a downtrend to less than 50 addresses per day to date.