from ethereum.core.ez_nft_sales

where date(block_timestamp) >= current_date - 31

and price_usd > 0)

count(distinct tx_hash) as sales_tx,

count(distinct seller_address) as sellers,

count(distinct buyer_address) as buyers,

sum(price_usd) as volume_usd,

sum(total_fees_usd) as total_fees_usd,

sum(platform_fee_usd) as platform_fees_usd

from raw