Quixotic NFT Dashboard

Question:

Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism!

Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.

Overview of essay:

Quixotic is the largest NFT marketplace on the Ethereum layer-2 platform Optimism. This essay presents the Quixotic NFT Dashboard on Optimism and seeks to explore the data related to NFT secondary marketplace based on Flipside data.

This essay contains two parts:

The first one explore the secondary NFT marketplace named Quixotic on Optimism
The second part has been compared the performance of Quixotic on Optimism with OpenSea on Ethereum.

Approach:

NFT sale

select * from optimism.core.ez_nft_sales where PLATFORM_NAME='quixotic' and EVENT_TYPE='sale'

As can be seen in the tables, the sales related to the OP token has USD price but sales related to ETH did not contains USD price so we should add the price of ETH and USD price of sale on Table

select * from ethereum.core.fact_hourly_token_prices where SYMBOL = 'WETH'
Purchaser Distribution:

CASE WHEN sale_vol <= 100 THEN 'a.below 100' WHEN sale_vol > 100 and sale_vol <=500 THEN 'b.100-500' WHEN sale_vol > 500 and sale_vol <=2000 THEN 'c.500-2000' WHEN sale_vol > 2000 THEN 'd.above 2000'

Comparison:

As mentioned in the Overview, the Quixotic on Optimism has been compared with OpenSea on Ethereum.

OpenSea sales:

SELECT * FROM ethereum.core.ez_nft_sales where PLATFORM_NAME='opensea'
Compared criteria:
- Sale activity
- Distinct buyers
- Average price of sale

The appearance of Optimism data on Flipside was from June 15, 2022.

Analysis on Quixotic NFT Marketplace:

Key findings 1:

The sale count has been risen in the last week on Quixotic marketplace.
The number of distinct sellers has been enhanced too on the last week but count of distinct buyers did not enhanced so much. We can conclude that some special users grab the NFTs on Quixotic in the past week.
The average price of sale by ETH token was 118 USD and by OP token was 172.7 USD on July 1, 2022.
The distribution of purchasers reveals the large of the sales on Quixotic was taken below 100 USD and about 88% of buyers bought in this group.
The NFT collection with highest sale is OptiPunk with near 50% of sale volume on Quixotic.
The sale activity on Quixotic by ETH has consistent movement but by Quixotic spiked on July 1, 2022.

Compare with Opensea on Ethereum:

Key findings 2:

In this section, the performance of Quixotic has been compared to the OpenSea as a leading sale marketplace on Ethereum and crypto universe.