Question:

Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.

Overview of essay:

This essay presents a live dashboard (refresh once a day) to establish a specific work on one of the NFT projects on Solana. The Primates NFT project has been investigated from various prospects. The main purpose of this essay is to study the Health of this NFT project over time.

The introduced metrics and way to estimate them have been assigned in the Approach section.

Approach:

• Primates NFT project:

  from solana.core.dim_nft_metadata where PROJECT_NAME ilike '%Primates'

• NFT Mint study:

  count(TX_ID) as count_mint, sum(MINT_PRICE) as vol_mint, count(distinct PURCHASER) as count_minter, sum(vol_mint) over (order by day) as grow_mint from solana.core.fact_nft_mints

• NFT sale study:

  count(TX_ID) as count_sale, sum(SALES_AMOUNT) as vol_sale, count(distinct PURCHASER) as count_purchaser, vol_sale*0.07 as royalty_fee, sum(vol_sale) over (order by day) as grow_sale from solana.core.fact_nft_sales

• Marketplace:

  MARKETPLACE from solana.core.fact_nft_sales

• Analyze based on wallets record NFTs

  when first_use<'2022-01-01' then 'Established wallets- before 2022' when first_use between '2022-01-01' and '2022-06-01' then 'Wallets on 2022 until June' when first_use>='2022-06-01' then 'New wallets- after June, 2022'

• Analyze based on wallet type

  ==Select top 200 purchasers of all time based on Sale amount==

  distinct PURCHASER as users,sum(SALES_AMOUNT) as vol1

  from solana.core.fact_nft_sales where tx_id is not NULL group by 1 order by 2 desc limit 200

Key findings:

The start point of Primates NFTs sale on Solana is from 14th of June, 2022 after its minting on the same day.

1. For Primates NFT project on Solana, total count of mints is 10k NFTs and these NFTs minted by 9.07k unique minters. The total purchased SOL for minting Primates is 39.6k SOL.
2. The sales pressure was high in the early days, but it gradually decreased over time. The highest count of sales occurred on the first day with near 4000 sales of Primates.
3. The sale volume and consequently the price of Primates NFTs increased in the first days and experienced its highest level on June 19th with 40.21k SOL.
4. The Royalty fee is considered as 7% of sale volume and shown in the same graph of Primates NFTs sale volume.
5. The count of unique purchasers on Primates NFTs displayed in the scatter plot and has a decreasing slope. As expected its highest count occurred in the first day of listing with 2280 unique accounts.
6. The grow rate of sale for Primates NFTs is a very useful tool to study the sale performance of it over time. According to this graph, the previous statements have been validated by considering the gradient of chart.
7. The dominated marketplace for Primates NFT sale is Magic Eden V2 with near 96% of sales.
8. The major part of purchasers on Primates NFTs are wallets participate of NFT projects of Solana in 2022 and until June with 52.2% of purchasers.
9. The more remarkable result came from new wallets made after June, 2022 and has 28.2% of purchasers.
10. Another vision related to analyze the type of purchasers is categorizing them by whales or Other wallets. From this point of view, most of the purchasers on Primates NFTs are other wallets and only 6.44% of them belongs to introduced Whales.