What is this analysis about?

> Q117. Algorand-based NFT Game, Cosmic Champs, dropped their collection of 1,000 Genesis NFTs this past week. Let’s look at how the shuffle went! > >
> -How quickly did it sell out? Show shuffle sales over time! > > -What percent of Genesis NFT holders also hold COSG tokens, show the distribution of COSG balances for the NFT holders > > -Show the distribution of ALGO balances for the NFT holders and when their wallets were created over time. -Did this NFT drop bring in new wallets into the ecosystem? > > -Look at how many Genesis NFTs does each wallet holds. > > -How much in ALGO sales were generated from the shuffle? > > -Note any other interesting findings about the collection such as secondary ALGO sales generated.

\n

As mentioned in the documentation

> Cosmic Champs, the first 3D real-time play-to-earn game on Algorand blockchain, is launching its governance token Cosmic Gold ($COSG) on Tinyman DEX and Yieldly Finance's yLaunch. yLaunch is the world's first vertically integrated staking, NFTs and listing platform for Algorand Standard Assets (ASAs).

challenges of this analysis

Find collection IDNFTs

One of the challenges of this analysis was finding IDs, for this we needed to access the account of the creator of the collection.

Then I have run the following code as one of my tests which gave me wrong output (1270 NFT)

And for this reason, with the help of table flipside_prod_db.algorand.asset_transfer_transaction and the manufacturer's account I was able to remember the correct code that correctly displayed the number of thousands of NFTs raised in the question.

SELECT * FROM flipside_prod_db.algorand.asset \n WHERE CREATOR_ADDRESS = 'CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'

AND ASSET_DELETED = 'FALSE' AND ASSET_NAME not in ('SINGULARITY ERA COMMEMORATIVE','Cosmic Champs Whitelist TOKEN')

shuffle sales over time!

To answer this part of the analysis, we need two categories of answers Answers that

• the source of the transaction was the account of the manufacturer of NFTs

• And the answers that have been bought and sold among other network users without considering the creator's account

  
  that I have obtained both answers in the graphs below

percent of Genesis NFT holders also hold COSG tokens

For this part, first we need to get the number of accounts that hold the asset and also the number of accounts that hold the NFT. According to the data, they have 135 NFT accounts and 76 asset accounts

So the percentage is equal to:

0.56 %

the distribution of COSG balances for the NFT holders

how many Genesis NFTs does each wallet holds.

This graph shows a very high non-normal distribution The first account, which is 74%, is the account of the manufacturer of NFTs

But the second account is ready in the link below link

the distribution of ALGO balances for the NFT holders and when their wallets were created over time

How much in ALGO sales were generated from the shuffle

Considering all the things that have been said, it can be concluded that about 21,000 ALGO have been transferred in the network in the purchase and sale of NFTs, although the number of new users who have entered the network just because of this event is high. is not Considering the distribution of blocks and knowing that all NFTs in Block 22,039,502 have been supplied by the manufacturer, these results are obtained