from ethereum.core.ez_nft_sales

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

select datediff(day, '2022-09-02', current_date) as days,

sum(price_usd) as total_volume,

sum(creator_fee_usd) as total_royalties,

sum(platform_fee_usd) as platform_fees,

count(distinct seller_address) as seller_wallet,

count(distinct buyer_address) as buyer_wallet,

count(distinct tx_hash) as sales_tx

from allsale