Bounty Question:

Create a dashboard that shows the crossover between the top Solana NFT projects by market cap (you can reference https://howrare.is/ for a list of the top collections). Which of the strongest projects tend to have the most crossover, and which projects have a wider mix of other communities?

Which communities tend to provide the most signal that another NFT project will do well? As in, is there any alpha if you were to see a certain PFP buying another collection? Which communities tend to be most active in minting new collections? Which communities have are the most diamond handed on other projects?"

Methodology

The following methods are used in this dashboard:

• First, the top 5 collections were determined through howrare. These top 5 collections are found in the solana.core.dim_nft_metadata table via the following code:

  select 
    contract_name as "NFT Colection",
    count(distinct token_id) as "Number of Items"
  from solana.core.dim_nft_metadata
  where CONTRACT_NAME in ('DeGods', 'Solana Monkey Business','Okay Bears', 'ABC', 'Degen Apes')
  group by 1
  order by 1
  

• Then the status of these top 5 collections was obtained with the help of solana.core.fact_nft_sales table:

  with tab1 as (select *
  from solana.core.dim_nft_metadata
    where CONTRACT_NAME in ('DeGods', 'Solana Monkey Business','Okay Bears', 'ABC', 'Degen Apes'))
  
  select 
    distinct CONTRACT_NAME as "Collection", 
    sum(SALES_AMOUNT) as "Sales Volume",
    count(*) as "Sales Count",
    count(distinct PURCHASER) as "Number of Unique Buyers",
    count(distinct seller) as "Number of Unique Sellers",
    ("Sales Count"/"Number of Unique Sellers") as "Average Sale per Seller",
    ("Sales Count"/"Number of Unique Buyers") as "Average Buy per Buyer",
    ("Sales Volume"/"Number of Unique Sellers") as "Average Recieved Amount per Seller",
    ("Sales Volume"/"Number of Unique Buyers") as "Average Paid Amount per Buyer",
    ("Sales Volume"/"Sales Count") as "Average Amount per Sale",
    count(distinct token_id) as "Number of Items Sold"
    
  	from solana.core.fact_nft_sales
  	inner join tab1 on tab1.mint=fact_nft_sales.mint
  		where SUCCEEDED = TRUE
  			group by 1
  			order by 1
  

• In the following, it was found that among the buyers and sellers, each of them was connected with several collections from these 5 collections.

  \

• Then the crossover between these 5 collections was obtained two by two.

  \

• In the following, the percentage of buyer and seller users who participated in crossovers was obtained for each collection of each crossover.

  \

• At the end, the collections that were minted by the communities of these top collections (buyers community and sellers community) were also obtained.

What is DeGods?

DeGods is an NFT project fully built on Solana. DeGods offers a range of deflationary collections, including degenerates, punks, and misfits. They consider themselves Gods of the metaverse and masters of their own universe. There are less than 10,000 DeGods NFTs available on the market. 

DeGods have integrated with Dust Protocol in order to use DUST tokens across its entire ecosystem.

What is Solana Monkey Business?

Solana Monkey Business is one of the top-selling and most well-known NFT projects on the Solana blockchain. Although Gen2 SMBs were only launched in August 2021, the Solana Monkey Business community has grown substantially, even creating its own community-established DAO — MonkeDAO.

The main 5,000 NFT profile picture collection is made up of smiley, distinctive pixelated 24×24 monkeys. The SMBs have over 99 traits and six generative layers, with some of the rarest commanding substantial price premiums on the secondary market.

What is Okay Bears?

Okay Bears is a culture shift. A clean collection of 10,000 diverse bears building a virtuous community that will transcend the internet into the real world. Okay Bears is a culture shift. A clean collection of 10,000 diverse bears building a virtuous community that will transcend the internet into the real world.

What is Degen Apes?

Degenerate Ape Academy is a Solana-based NFT collection containing 10,000 unique apes that serve as an interface that allows users to exchange their digital assets. Users can “enroll” in the Ape Academy by minting a Degenerate Ape, which allows them to have a valuable asset and enjoy their utility. 

Buyers can rest assured that they will acquire full intellectual property rights of both the art and the Degen Ape itself after purchasing the asset, thanks to the power of smart contracts. After the purchase, the Degenerate Ape Academy cannot modify, seize, or freeze ownership of Ape NFTs from new owners. 

What is ABC?

ABC or Abracadabra is a collection of 10K immutable NFTs, 0% royalties. Made to remind you of how fun things were when we were kids, before growing up - let’s never stop having fun! *This project has no official Twitter or Discord*

DeGods

Number of Items: 10,000

Floor Price: 393.33 SOL

Floror Price Market Cap: 130.98 million USD

SolanaMonkeyBusiness

Number of Items: 5,000

Floor Price: 192 SOL

Floror Price Market Cap: 31.97 million USD

Okay Bears

Number of Items: 10,000

Floor Price: 75.5 SOL

Floror Price Market Cap: 25.14 million USD

Degen Ape Academy

Number of Items: 10,000

Floor Price: 64.69 SOL

Floror Price Market Cap: 21.54 million USD

ABC

Number of Items: 10,000

Floor Price: 62.7 SOL

Floror Price Market Cap: 20.88 million USD

Top NFT Collection in Solana Blockchain (SOL Price: $33.3)

• Below, the top 5 collections were compared in 10 parameters:

  1. Sales volume
  2. Sales Count
  3. Sellers Count
  4. Buyers Count
  5. Average Amount per Sale
  6. Average Sale per Seller
  7. Average Buy per Buyer
  8. Average Received Amount per Seller
  9. Average Paid Amount per Buyer
  10. Number of Items Sold

• Although the ABC collection constitutes about 50% of the total sales of these top collections, it ranks last in terms of sales volume because it has the lowest average cost paid per sale. This shows the importance of the floor price of each collection. In comparison, we can mention DeGods, which, although it ranks fourth in the number of sales, but due to the high floor price, it has the second place in the volume of sales after Okay Bears. The Okay Bears is a collection that has almost the balance between the number and the floor price. This collection has the second rank in the number of sales, in terms of the average cost paid per each sale, this collection ranks third, and these two have led to the fact that this collection had the largest sales volume. (More than 40% of the total sales of these top 5 collections).

• These 5 collections have a total of 26.6k sellers and 23k buyers. Among the 5 collections, the most buyers and sellers were for the Okay Bears collection. (more than 37 percent in both cases). In both cases, the second to fifth ranks are the same and are as follows:

  • ABC ---> DeGods ---> Degen Aps ---> Solana Monkey Busines

• Buyers of each of these 5 collections have made more buys on average than the number of sales of sellers of each of these 5 collections. It is normal that the amount paid by buyers is on average higher than the amount received by sellers.

• Of the total number of items in each collection, the highest number of items sold is related to the ABC collection, which has sold more than 98.7% of its items. The lowest selling items are related to the SMB collection. (29%)

\

• In terms of crossover between collections, in the first 4 ranks, Okay Bears collection three times, DeGods twice, Degen twice and ==ABC== once (both in buyers and sellers). This indicates that the Okay Bears community collection has one of the most crossovers among these 5 collections.

  \

• The most crossover between Okay Bears and ABC community collections and the least crossover between Solana Monkey Business and ABC community collections. (In both cases, the communities of sellers and buyers, these ranks are the same)

• More than 15% of the DeGods seller community is part of the Okay Bears seller community. While these sellers make up only 6% of the community of Okay Bears sellers.

  \

• On the other hand, 11% of the Okay Bears seller community is also a member of the Degen Apes seller community. While these sellers make up only 3% of the community of Okay Bears sellers.

  \

• About the community of buyers; More than 22% of the Solana Monkey Business community of sellers are part of the Okay Bears community of sellers. While these sellers make up only 3.7% of the community of Okay Bears sellers.

  \

• Other crossovers between the communities of buyers and sellers of these top collections can be seen and checked in the two charts above.

• The community of sellers of these top 5 collections have participated in minting of 39 other collections:

1. 7== Collections are only minted by the ==SMB== seller community.
2. 7== Collections are minted only by the ==ABC== seller community.
3. 6== Collections are only minted by the ==DeGods== seller community.
4. 6== Collections are minted only by the ==Okay Bears sellers== seller community.
5. 5== Collections are only minted by the ==Degen Apes== community of sellers.
6. 6== collections have been minted by ==2 of the sellers community==.
7. 1== collection has been minted by ==3 of the sellers community==.
8. 1== collection has been minted by ==4 of the sellers community==.

• The community of buyers of these top 5 collections have participated in minting 35 other collections:

1. 6== Collections are minted only by the ==ABC== seller community.
2. 5== Collections are only minted by the ==DeGods== seller community.
3. 5== Collections are only minted by the ==SMB== seller community.
4. 4== Collections are only minted by the ==Degen Apes== community of sellers.
5. 4== Collections are minted only by the ==Okay Bears sellers== seller community.
6. 8== collections have been minted by ==2 of the sellers community==.
7. 1== collection has been minted by ==3 of the sellers community==.
8. 2== collection has been minted by ==4 of the sellers community==.

• About 92% of all sellers were the sellers of item/items from only one of the collections. This amount in the case of buyers is around 87%.

  \

• About 7% of all sellers were selling items from two of the collections. This amount is about 9.9% for buyers.

  \

• Only 0.026% of users were sellers of items/items from all 5 collections (7 wallets) and only 0.061% of users were buyers of items/items from all 5 collections. (14 wallets)