from ethereum.core.ez_nft_sales

where date(block_timestamp) >= current_date - 31

and price_usd > 0)

select date_trunc('week', block_timestamp) as dt,

count(distinct tx_hash) as sales_tx,

platform_name,

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

group by 1,3