select *

from ethereum.core.ez_nft_sales

where block_timestamp::date >= '2022-02-15' and platform_name in('opensea', 'rarible', 'looksrare', 'x2y2')

select

project_name,

platform_name,

sum(creator_fee_usd) as total_royalty,

count(distinct tx_hash) as total_sales,

sum(price_usd) as total_volume,

count(distinct buyer_address) as total_buyer,

count(distinct seller_address) as total_seller

from ethereum.core.ez_nft_sales

where creator_fee_usd > 0 and project_name is not null and project_name != 'opensea'

group by 1, 2