Analysis Vis 5 and Vis 6:

We can see that the volume of sales with ETH was much higher and several times before the OP stopped selling.

On the day of the attack, we see that about five times the ETH , OP was transferred, and it can be assumed that the security problem was in the OP token.

We can see the sales volume percentage of each currency, 70% of which was with ETH.

If we want to skip July 1st, this percentage can reach more than 95%

Analysis Vis 2 to Vis 4:

In these graphs, the percent of the number of sales per currency Percent of buyers with each currency And we see the graph of the number of sales with ETH and OP currencies.

• 91% of buyers have bought and sold with ==ETH== and only about 9% of users have bought with ==OP==.

• Also, 96% of the purchases were paid with ==ETH== and only 4% were done with ==OP==.

• After July 1, no sales have been made with ==OP== and it seems they have stopped selling with ==OP==.

Analysis Vis 1:

In the chart below, we see the number of sales, sales volume, unique number of buyers, and average price.

The first thing that can be seen in the chart is the high volume of sales on July 1.

It can be said that anyone who sees this chart will realize that something special happened on that day On July 1, 2022, the largest Optimism network marketplace was hacked and more than $140,000 was stolen. Quixotic's official Twitter account confirmed the news and changed the sales contract, and according to them, compensated the users' losses.

In the last week, the number of sales has increased significantly, but the volume of sales has not changed relatively, which indicates the drop in the price of NFTs.

And the sharp drop in the average price confirms this

Source

Analysis Vis 7 to Vis 9:

In these three charts, we check the number of buyers and the number of sales of collections in Quixotic Marketplace. Collection ==Mirror== has the most users and number of sales. With 1921 sales, this collection has accounted for 21% of the total sales in Quixotic.

==genesisKami== has less number of buyers, but it ranks second in the number of sales, which shows that each user has more than one NFT of this collection.

There are more than 10 collections that have not sold more than one

Analysis Vis 10:

This chart shows the top 10 collections per day. We can see that the ==mirror== collection was the best seller on most days.

After that, we have ==GenesisKami==, which was minted on July 3rd and has been bought and sold.

The sale of NFTs is in a downward trend

Conclusion

• The Quixotic Marketplace can grow and this market will grow with the growth of the Optimism network.
• After the hacker attack on this platform, it does not seem that there has been any change in the number of its users.
• The sales of collections are decreasing, which can be due to the extreme fear that exists in the market

overview

Q. 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 in the secondary NFT market.

A. In this dashboard, we will examine the Quixotic Marketplace and examine it in terms of the number of sales, volume of sales, and the number of buyers.

What is Optimism?

Optimism is an Ethereum-based layer 2 scaling solution. The fundamental characteristic of Optimism is that it makes Ethereum application transactions relatively inexpensive. Optimism causes transactions to flow from one blockchain to another. Gas prices are dramatically lowered as a result, and throughput rises. Optimism allows Ethereum developers to utilize all of the existing tools on Ethereum without having to make any changes. Traders will pay a 10x lower gas charge, according to the Optimism development team. Optimistic rollups are used to combat fraud and incorrect state transitions.

What is Quixotic Crypto?

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

Since its launch, Quixotic managed to save more than USD 1.7 million in fees for its users. This figure is very impressive, seeing that the launch happened only around 1 month ago. Additionally, the platform boasts a total of more than 14,500 addresses that traded NFTs, with a total volume traded of more than 700 ETH. Pretty impressive!

source

Method

In this marketplace, buy and sell NFT has been done with ETH and OP currencies So, for a better comparison, I converted them to USD to have a better view

• For this purpose, Table ethereum.core.fact_hourly_token_prices was used to convert the ETH price, and Table optimism.core.fact_hourly_token_prices was used to convert the OP price.
• Optimism.core.ez_nft_sales the table has been used to obtain the number of sales and volume of sales and buyers.
• To check NFT ==collections==, I used Table optimism.core.fact_event_logs and join it with Table optimism.core.dim_labels