SELECT tx_hash

, buyer_address

, seller_address

, project_name

, price

, price_usd

FROM ethereum.core.ez_nft_sales

WHERE platform_name = 'opensea'

AND block_timestamp >= '2022-01-01'

),

opensea_dtls as (

select project_name as nft_collection,

count(distinct buyer_address) as no_of_buyers,

count(distinct seller_address) as no_of_sellers,

count(distinct tx_hash) as no_of_txns,

round(sum(price),2) as tot_volume,

round(sum(price_usd),2) as tot_volume_usd,

round(avg(price_usd),2) as avg_volume_usd

from opensea_nfts where price_usd > 0

group by project_name

order by tot_volume_usd desc

limit 10

),

quix_nfts as (

SELECT tx_hash

, d.project_name as nft_collection

, buyer_address

, seller_address

, price

, price_usd

FROM optimism.core.ez_nft_sales e join optimism.core.dim_labels d on e.nft_address = d.address

WHERE platform_name = 'quixotic'

and event_type = 'sale'

AND block_timestamp >= '2022-01-01'