Question:

Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year. 

• What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace or ecosystem of NFTs?
• Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume.
• Is the turnover rate (number of transactions) for collections on Quix noticeably higher than on OpenSea and Magic Eden? Provide some insights on these findings.

About Quix (formerly Quixotic)

Optimism is an Ethereum-based layer 2 scaling solution. Optimism's essential feature is that it makes Ethereum application transactions relatively cheap.

Quixotic is the largest NFT marketplace operating on Optimism. Soon after announcing the optimistic airdrop, Quixotic announced its official launch to the masses. Since it runs on Optimism, its transactions and operations are fast and cheap compared to other markets.

> Thanks to Optimism, Quixotic is a better choice for you to sell, discover and collect NFTs with lower fees. > > Quixotic launched on Optimism in December 2021. Only one year later, it has facilitated +100 ETH in total volume already, making it hard to ignore the development of the NFT platform. > > by Medium

Part 1: Comparison of Marketplaces

Findings:

The NFT sale on Quix has been done by two various tokens (OP and WETH). By considering it the outcomes related to the NFT sale activity on Quix are sum of the results related to these tokens.

• The domination of sale volume from July, 2022 belong to the OpenSea as a biggest NFT marketplace of crypto universe.
• The unique purchasers of Magic Eden is larger than other two.
• The average sale price is higher than other marketplaces with over 230$ and the average sale price or Quix is over 15$.
• The highest sale count and unique purchasers on Quix were high on July 27, 2022.
• The greatest average sale price on Quix happened on September 14, 2022 with near 104 USD.

Part 2: Grow rate of various marketplaces

Findings:

The grow rate of NFT sale analysis since start of 2022 has been drawn in this part:

• The last week of the April, 2022 was the breakpoint for the NFT sale on Quix and as can be seen the slope of cumulative charts shown this high grown.
• The final sale volume of Quix in 2022 is over 2.29 million USD and the NFT sales have been done by over 33.8k unique purchasers.

Part 3: Top NFT collections

Findings:

The TOP NFT collections on each marketplaces have been determined as below:

• The ==Optipunk== is the leading NFT collection on Quix of Optimism with over 1.1 million USD volume by 1866 unique purchasers.
• The ==Boredapeyachtclub== collection as a one of the most famous NFT collection is the leading collection on OpenSea with over 62.5 million USD sale volume.
• The ==ABC== and ==DeGods== are the two of the top NFT collections on Magic Eden.

Part 4: User distribution an retention

Findings:

• Due to the price of NFT collections on various marketplaces and the popularity of it, the purchasers distribution on different marketplaces changed accordingly.
• Most of the purchasers on ==Quix== marketplace bought NFTs with ==below 100$== and only 1 unique purchaser bought NFT over 2000$ on Quix.
• The purchasers retention on ==Magic Eden== is higher than other two marketplaces and the retention for Quix is about ==41%== which means only 41% of unique purchasers bought NFT on Quix ==more than one time==.

References and useful links:

• Quix on Optimism
• Magic Eden on Solana
• OpenSea on Ethereum

Author:

Credited by MZG

Discord handle: m.zamani#0361

Twitter handle: @GargariZamani

Methodology

• The tables for NFT sale

  • Quix: from optimism.core.ez_nft_sales where PLATFORM_NAME='quixotic'
  • Magic Eden: from solana.fact_nft_sales where marketplace ilike '%magic eden%'
  • OpenSea: from ethereum_core.ez_nft_sales where PLATFORM_NAME='opensea'

• Buyer distribution:

  a.below 100 , b.100-500 , c.500-2000 , d.above 2000

• User retention:

  case when no_transaction=1 then 'One time users' when no_transaction>1 then 'More than 1 transaction'

• Time period:

  Where BLOCK_TIMESTAMP>='2022-07-01' since July, 2022

  \