Question:

Create a dashboard on the secondary market for NFT sales on Optimism! Include at least these metrics, along with any others you find notable or interesting:

• Sales volume (daily/weekly/monthly)
• Total Sales Volume
• Daily Average Sales Price and 7-day moving average
• Total Unique Buyers
• Average Buyers/Day

Additional Analysis:

• Top NFT collections
• NFT purchaser behavior

NFT marketplace on Optimism

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.

In this dashboard, the secondary NFT market dominated by Quix has been investigated in detail.

This mega dashboard has been presented to follow the detail info about the NFT sale on Optimism.

Part 1: Sale by various currencies

Methodology

The Flipside date has been utilized to execute this analysis.

Some of the metrics are introduced and simple but other methods used in this dashboard are:

• The moving average for 7-days

  avg(average_volume) OVER (ORDER BY day ROWS BETWEEN 7 PRECEDING AND CURRENT ROW)

• Sale of days of week

  dayname(to_date(block_timestamp::date)) as week_day

• Bucket purchasers by NFT sale price

• NFT hold time

  Difference of bought and sold NFTs on Optimism

• Top NFT traders with highest profit in USD

Findings:

First of all, the sale activity of NFTs on Optimism has been divided into the two major currencies named OP and ETH.

• As can be seen, over 99% of NFT sales on Optimism secondary market executed by ETH.
• The domination of ETH token for NFT sale on Sale volume and unique buyers is obviously observable.

Part 2: Sale stats (Overall and over time)

Findings:

The stats related to NFT sale on secondary market on Optimism have been summarized as below:

• The September 2022 was the most busiest month from the sale volume of NFTs on Optimism.
• From September 19 to 26 and specially September 21 were the most sold week and day on Optimism NFT secondary market.
• The outcomes related to the sale count and number of unique buyers have been followed the pattern of sale volume on secondary marketplace.
• From the days of week prospect, the Wednesday is the most popular day for NFT purchase with over 1.546 million USD value.
• The 7 day moving average reached its highest value on February 13 with over 470 USD.
• Important break points on cumulative graph can be seen and the last one happened on September 10.

Part 3: NFT collections

Findings:

The NFT collections detailed analysis has been summarized in this part as below:

• The OptiPunk is the most popular and sold NFT collection on secondary marketplace of NFT sale on Optimism with over 1.167 million USD volume.
• The Mirror collection has the highest count of sale and unique buyers among Top NFT collections.
• The most expensive collection on the secondary market for NFT sales on Optimism belongs to OptiPunk collections with average sale price more than 288 USD.
• The cumulative and weekly sale volume of Top NFT collections on the secondary market for NFT sales on Optimism validate the domination of ==OptiPunk== and ==Optimism== collections.

Part 4: Purchaser behavior

Findings:

Finally lets talk about the behavior of NFT purchasers on the secondary market for NFT sales on Optimism.

• Most of the buyers== have been purchased under ==50 USD== for NFTs on Optimism secondary NFT market.
• Large group of purchasers hold NFTs ==under 1 day== and the second largest group belong to hold over 1 month.
• About ==18346 unique purchasers hold 1 NFT== and its the largest group of purchasers.
• The 0x13ddeae97a8c157a68a7272cd665897f884739fc is the most successful trader on Optimism secondary sale market with over ==27.7k USD== net profit.

Useful links:

• Buy NFT on Optimism
• About Quix
• Optimism scanner
• Reference on graph

Author:

Credited by MZG

Discord handle: m.zamani#0361

Twitter handle: @GargariZamani