-- select * from base.nft.ez_nft_sales

select

count(tx_hash) as sale_count,

count(distinct seller_address) as sellers,

count(distinct buyer_address) as buyers,

tokenid as nft_ID,

sum(price) as volume,

sum(platform_fee) as Opensea_Fee,

sum(creator_fee) as Basepaint_Fee

from base.nft.ez_nft_sales

where nft_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'

and event_type = 'sale'

group by nft_ID