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.

Data Sources:

• optimism.core.ez_nft_sales

• ethereum.core.fact_hourly_token_prices

Key Findings:

• There have been around

  • ~7.3K unique buyers
  • ~5.7K unique seller
  • 19.9K sales transactions
  • nearly ~$411K USD sales volume.
  • 238 ETH sales volume.
  • 223K OP sales volume.

• The most expensive NFT traded had a price of $6190.

• Since July 27, the number of transactions has increased significantly, but the USD volume of these transactions has not been large.

• ETH is much more popular than OP for sale on Quixotic

• 0xbe81eabdbd437cba43e4c1c330c63022772c2520 address is top NFT project with max sales volume(~143K).

• optipunk, apetimism, Oliens are top 3 NFT projects by total USD sales volume.

What is Quixotic?

Quixotic is an NFT Marketplace project focusing on Digital Cards Collectibles, bringing these conventional items from the traditional world into the crypto space. The project runs on the Ethereum layer-2 platform Optimism.

Part 1: General Statistic

Part 2: Daily Sales Volume

Part 3: Top NFT Projects

Some Possible Errors In The Data:

• PRICE_USD field for a large part of the table ( from July 2 to July 26) is not available.
• After July 1st no more trading with OP token.
• Buyers and sellers have not made a transaction with each other, in other words, the query below did not return any rows.

select * from optimism.core.ez_nft_sales as t1 join optimism.core.ez_nft_sales as t2 on t1.BUYER_ADDRESS=t2.SELLER_ADDRESS