SELECT tx_hash

, block_timestamp

, 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 date(block_timestamp) as day,

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

group by day

order by day desc

),

quix_nfts as (

SELECT tx_hash

, block_timestamp

, buyer_address

, seller_address

, price

, price_usd

FROM optimism.core.ez_nft_sales

WHERE platform_name = 'quixotic'

AND block_timestamp >= '2022-01-01'

),