Quix vs Magic Eden vs OpenSea - July

CryptoIcicleQuix vs Magic Eden vs OpenSea - July

Updated 2022-09-28

-- Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year.

-- Pay by Quality Your score determines your final payout.

-- Grand Prize 112.5 USDC (A score of 11 or 12 earns you a Grand Prize title)

-- Payout 75 USDC

-- Score Multiplier0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%

-- Payout Network Ethereum

-- Level Intermediate

-- Difficulty Hard

-- Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption

-- between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year.

-- What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace

-- or ecosystem of NFTs?

-- Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume.

-- Is the turnover rate (number of transactions) for collections on Quix noticeably higher than on OpenSea and Magic Eden?

-- Provide some insights on these findings.

with sol_price as (

select

block_timestamp::date as date,

avg(swap_to_amount/swap_from_amount) as price

from flipside_prod_db.solana.fact_swaps

where swap_from_mint = 'So11111111111111111111111111111111111111112' -- SOL

and swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC

and succeeded = 'TRUE'

and block_timestamp >= '{{start_date}}'

group by date

sol_sales as (

select

seller,

purchaser as buyer,

sales_amount * p.price as sale_usd,

tx_id,

block_timestamp,

Run a query to Download Data