Intro:

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.

In this bounty, the shuffle of NFTs is investigated and wants to find the characteristics of users made shuffle over the past week.

Method

• Shuffle identification-→ select ASSET_ID from flipside_prod_db.algorand.asset_transfer_transaction where BLOCK_ID='22039502'
• The block id in previous step refers to the Shuffle of Genesis NFTs.
• The address of creator-→ CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM
• Shuffle sold out-→ DATEDIFF(day, first sale, last sale)
• Asset id of $COCG-→ 571576867
• $COCG balance-→ flipside_prod_db.algorand.account_asset
  • when amount< 10000 then 'a. under 10000'
  • when amount between 10000 and 1000000 then 'b. 10000-1000000'
  • when amount between 1000000 and 10000000 then 'c. 1000000-10000000'
  • when amount>10000000 then 'd. over 10000000'
• ALGO balance-→ flipside_prod_db.algorand.account
  • when balance between 0 and 10 then 'a. 0-10'
  • when balance between 11 and 100 then 'b. 11-100'
  • when balance between 101 and 500 then 'c. 101-500'
  • when balance between 501 and 2000 then 'd. 501-2000'
  • when balance> 2000 then 'e. over 2000'
• NFT hold-→ flipside_prod_db.algorand.account_asset
  • when no_nft=1 then '1 NFT'
  • when no_nft=2 then '2 NFTs'
  • when no_nft>2 then 'more than 2 NFTs'
• wallet creation time-→ flipside_prod_db.algorand.account s left outer join flipside_prod_db.algorand.block b on s.CREATED_AT=b.BLOCK_ID
  • when b.BLOCK_TIMESTAMP>='2022-05-01' then 'Recently: created after May'
  • else 'established wallets'

Outcomes:

• Based on the results, time to sold out the shuffle is about 8 days (185 hours).
• On July 6 about 930 NFTs are sold by Shuffle as specified in the bar chart.
• There is a balance between $COCG holders and NFT holders that did not hold $COCG. About 53.8% of NFT holders hold $COCG too.
• Half of the NFT holders have under 10000 $COCG token and the second largest bucket belong to the NFT holders with more than 10 million $COCG token.
• Most of the NFT holders are established wallets (about 89%) and only small group of wallets created after May. So we could say that the NFT drop bring small part of new wallets into the ecosystem.
• The ALGO balance of NFT holders shown the popularity on ALGO hold between 11-100 ALGOs. The second crowded bucket belong to 101-500 ALGOs holders.
• Most of the NFT holders hold more than 2 NFTs (about 68.8% of wallets). Also, it shown that the 18.8% of NFT holders hold only 1 NFT.