Introduction

Quixotic is the largest NFT marketplace on Optimism.

In this dashboard, we will analyze transactions on Quixotic.

🌱As of this writing, the min block time of the Optimism database used for this analysis is 2022-06-15.

Optimistic Explorer

• Most traded collection.
• Trading started on July 25th.
• 15th rank in trading volume

OptiPunk

• Highest trade volume

Apetimism

• 2nd rank in trading volume

Oliens

• 4th rank in trading volume

Bored Town

• 5th rank in trading volume

MotorHeadz

• 2nd rank in the number of trades
• 3rd rank in trading volume
• Trading started on July 29th

CryptoTesters

• 6th rank in trading volume
• Only 29 trades but with average trade of 0.21 ETH per trade

• We can see that in June, number of buyers are more than number of sellers, but in July, after the exploit, number of sellers are more than number of buyers. So in July, buyers are stronger than sellers despite increase in number of sellers.
• The increase in trades afte July 26th is mostly because of two collections:
  • Optimisim Explorer
  • MotorHeadz

In the following table, we can see top 20 NFT sales on Quixotic:

• Date: Date of trade
• Collection: The collection that traded
• Buyer/Seller: Address of buyer and seller
• Price_ETH: The ETH paid to buy the NFT
• Price_USD: The equivalent USD price of the ETH price (Calculated by average price of ETH in the day of trade)
• TX_hash: Transaction hash of the trade transaction

In the following tables, we can see the top traders on Quixotic in terms of both the highest trade volume and trade number:

• Address: The wallet address of the trader
• Trades-Buys-Sells: Total number of trades / Number of buys / Number of sells
• ETH_Vol: Total ETH volume of trading (Buy and Sell) on Quixotic
• USD_Vol: Estimated USD value of trades
• Buy_ETH_Vol: ETH value of all buys
• Sell_ETH_Vol: ETH value of all sells
• AVG_Trade_Value: Average USD value per trade

Summary

• Quixotic is the largest NFT marketplace on Optimism.
• After the exploit on the 1st of July, The sales volume increased at first but decreased till the last week of July when we observe an increase in volume and trade numbers. these increases were mostly because of the two new collections: Optimism Explorer and MotorHeadz.
• Before the exploit, the buyer-to-seller ratio was more than 1, but after that, it decreased to less than 1 which shows that stronger collectors started to collect NFTs on Optimism.

Method

• The transactions that trade NFTs via ETH were considered in this dashboard.

• 4 contracts of Quixotic were identified as:

  0x20975da6eb930d592b9d78f451a9156db5e4c77b
  0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6
  0x3f9da045b0f77d707ea4061110339c4ea8ecfa70
  0x998ef16ea4111094eb5ee72fc2c6f4e6e8647666
  

• All transaction data were extracted from optimism.core.fact_transactions table.

• The seller and NFT Address of each transaction was extracted from TX_JSON.

• Daily ETH prices were calculated by averaging hourly prices of WETH in ethereum.core.fact_hourly_token_prices table.

• Some of the NFT Collection names were added manually.