-- date(block_timestamp) as date,

project_name,

count(tx_hash) as sales,

sum(price_usd) as usd_vol,

sum(total_fees_usd) as fees_usd

-- distinct event_type

from ethereum.core.ez_nft_sales

where platform_name = 'nftx'

and block_timestamp > current_date - interval '60 days'

group by 1

order by usd_vol desc

limit 3