block_timestamp::date as date

,count(DISTINCT block_timestamp::date) as activity_days

,count(DISTINCT tx_hash) as sales

,count(DISTINCT buyer_address) as buyers

,count(DISTINCT project_name) as projects

,sum(price_usd) as volume_usd

,avg(price_usd) as avg_volume_usd

,sum(sales) over(order by date) as cum_sales

,sum(volume_usd) over(order by date) as cum_volume_usd

,sum(projects) over(order by date) as cum_projects

from base.nft.ez_nft_sales

where EVENT_TYPE='sale'

and CURRENCY_SYMBOL='ETH'

group by 1

order by 1