Overview of question:

Q77. Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior.

How many wallets are buying NFTs on rand gallery. What is the total number of unique wallets that have purchased from rand gallery? Create a distribution plot of how many NFTs each wallet has purchased from Rand Gallery Are we seeing new wallets purchasing on Rand Gallery or is it only wallets that have purchased from Rand Gallery before? Chart the first purchase on Rand Gallery by wallet over time. Create a table of the top 10 wallets that are purchasing from rand gallery by ALGOs and number of NFTs Tips: Check out these analyses for some inspiration on how to write your queries: https://app.flipsidecrypto.com/dashboard/algo-rand-gallery-nft-sales-Fdtzb6 and https://app.flipsidecrypto.com/dashboard/rand-gallery-nft-sales-SYCxCf NFT Sale Example: https://algoexplorer.io/tx/group/m5Xmjvw60T%2B%2F9%2Bxo15Oi5GjffoRHNRtBkSYDDZBeLgc%3D Fees are sent to: RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE NFT Statistics and Explorer: https://www.nftexplorer.app/stats

Approach:

The methodology of this essay contains the following metrics and used the respected tables as below:

• To capture unique wallets

     from algorand.payment_transaction 
     where RECEIVER='RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE' 
     for specifying transactions related to rand gallery 
  

• To capture new users

     min(BLOCK_TIMESTAMP)
  

• To find the distribution of wallets based on NFTs, these buckets introduced:

     'Beginner: under 5 NFTs'
     'Intermediate: 5-30 NFTs'
     'Pro: 30-80  NFTs'
     'Elit: over 80 NFTs'
  

Results:

The daily count of wallets that purchased on rand gallery has shown in the graph. According to the graph, the count of unique wallets on rand gallery has been increased since start of 2022.

In general, 29.35k unique wallets have been participated on rand gallery and total volume of sale is 10.91 million ALGO.

Based on the bucket definition in the approach section, most of the wallets purchased for under 5 NFTs and belonged to the beginner level.

The Elite level with more than 80 NFTs only contains the 4.07% of wallets.

The count of unique wallets that purchased for the first time has been displayed by date in this graphic. According to this graph, the count of new wallets on rand gallery has been spiked since May 13th.

The scatter plot has been utilized to demonstrate the top 10 wallets on rand gallery by count of NFT purchased and ALGO volume.

Based on these plots, the wallets in the first rank of NFT count has been used rand gallery for 2267 times. Also, the wallet with most ALGO volume has 225.71k ALGO transfer on rand gallery for purchasing NFTs.