with raw as (select *
from ethereum.core.ez_nft_sales
where date(block_timestamp) >= current_date - 31
and price_usd > 0)
select
platform_name,
count(distinct tx_hash) as sales_tx,
sum(price_usd) as sales_volume,
sum(platform_fee_usd) as platform_fees_usd,
count(distinct buyer_address) as buyers
from raw
group by 1
order by 2 desc