SELECT

trunc(block_timestamp,'day') as date,

platform_name,

count(distinct buyer_address) as active_users,

count(distinct tx_hash) as sales,

sum(sales) over (partition by platform_name order by date) as total_sales,

sum(price_usd) as volume,

sum(volume) over (partition by platform_name order by date) as total_volume

from near.nft.ez_nft_sales

where date>=current_date-interval '1 MONTH' and date<current_date --and label_type='nft'

group by 1,2

order by 1 desc