Q7.

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

\n

Info

Quixotic, the largest NFT marketplace on Optimism. Discover, collect, and sell digital items on the largest NFT marketplace on Optimism.

Method

Table: from optimism.core.fact_hourly_token_prices , optimism.core.ez_nft_sales

where symbol in ('WETH','OP') and hour >= CURRENT_DATE - 30

count(DISTINCT buyer_address) as total_buyer
count(DISTINCT seller_address) as total_seller 

nft_address = '0xb8df6cc3050cc02f967db1ee48330ba23276a492' then 'OptiPunk'
when nft_address  = '0x51e5426ede4e2d4c2586371372313b5782387222' then 'Apetimism'
when nft_address  = '0x69a68eb548a37ee475d9f89646945588558796d1' then 'Oliens'
when nft_address  = '0x18a1bc18cefdc952121f319039502fdd5f48b6ff' then 'CryptoTesters '
when nft_address  = '0x824bb1f0438a38ea424e19171ef6665a4bcce3a5' then ' NerdApeDAONFT'
when nft_address  = '0x81b30ff521d1feb67ede32db726d95714eb00637' then 'Optimistic Explorer'
when nft_address  = '0xf25cba0ae45496e71117442378f820b2cf09e9f1' then ' Rockets '
when nft_address  = '0x8e56343adafa62dac9c9a8ac8c742851b0fb8b03' then ' Bored Town'
when nft_address  = '0x40426c367f44c37e10f0a452574c2f84dcba3038' then ' Galaxy Gans'
when nft_address  = '0x4d40396b4eb19be0c1ce1b9544608068bdf6b0fc' then ' Optimistic Apes'

\n \n

Buyer and seller

Sales Volume

The highest volume of NFT that had been sold was on July 4th. On this day, the volume of sold nft was 12.4k.

The lowest volume was on July 13th with 2264.

The volume of sales grew moderately.

It started at 12.5k on July 4th and ended at 155.42 on August 3rd.

Sales number

Top 10

Volume

Sales number

The highest number of buyers was on July 27th. On this day, the number of buyers was 539.

The highest number of sellers was also on July 27th. On this day, the number of sellers was 1397.

There was a spike in the growth of the seller’s number on July 27th. On this day the cumulative as sellers was 5418 which was 4021 on July 26th.

The cumulative of buyers also had a growth on July 27th from 3067 on July 26th to 3606 on July 27th.

• The highest number of sales was on July 27th. On this day, 2100 NFTs had been sold on Quixotic.
• The lowest number of sales was on July 8th with 130 NFTs.
• The cumulative sales number spiked on July 27th. On this day, the cumulative number of sales on Quixotic was 8864.
• On July 26th, the cumulative a number of sales was 6548.

• The collection that had the most volume of sales was Optipunk. This collection had around 45k volume of selling.

Optipunk took 36.4% of the top 10 collections that were filtered by the sell volume.

• The second collection of the top 10 wallets based on the volume was Apetimism which had 38.47k volume and had 31.3% part.
• The third collection was Oliens. This collection had a 12k volume and 9.8% of the top 10 collections.

• The collection that had the most sales number is Optimistic Explorer. This collection’s NFTs had been sold 6607 over the past 30 days.

  This collection took 72% of the top 10 collections based on the number of sales.

• The second collection was Oliens which had sold 1054 over the past 30 days.

• The third collection of the top 10 was Galaxy Gans which had sold 369.

There is a massive gap between the first collection and the others.