The aims of this dashboard are showing:

• 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

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

Reciever = 'RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'

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.

Analysis

Observation

• In the above PIE chart, I divided NFT holders into 5 categories. As of the chart shown, 76.5% of the NFTs are belongs to one address as whales, and the rest have been held in other wallets.

New wallet over time

• As we see in the last chart, new wallets purchasing on Rand Gallery are significantly ascending over time.

Discord: 0xHaM☰d#8391