SELECT tx_hash

, block_timestamp

, buyer_address

, project_name

, price

, price_usd

FROM ethereum.core.ez_nft_sales

WHERE platform_name = 'opensea'

AND block_timestamp >= '2022-01-01'

)

select date(block_timestamp) as day,

count(distinct buyer_address) as no_of_users,

count(distinct tx_hash) as no_of_txns,

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

round(sum(price_usd),2) as tot_volume_usd

from opensea_nfts

group by day

order by day desc