from ethereum.core.ez_nft_sales

where nft_address = '0x9674739124d69d555712a30e0a44de648f494219' and price_usd > 0)

select date_trunc('day', block_timestamp) as dt, platform_name,

count(distinct tx_hash) as sales_tx,

count(distinct seller_address) as seller_wallet,

count(distinct buyer_address) as buyer_wallet,

sum(price_usd) as volume_usd,

sum(total_fees_usd) as total_fees,

sum(platform_fee_usd) as platform_fees,

sum(creator_fee_usd) as creator_fee,

sum(tx_fee) as tx_fee

from allsale

group by 1,2