block_timestamp::date as date,

'Ethereum' as blockchain,

count(DISTINCT tx_hash) as sales_count,

sum(sales_count) over (order by date asc) as cum_sales_count,

count(DISTINCT BUYER_ADDRESS) as unique_buy ,

sum(unique_buy) over (order by date asc) as cum_user,

sum(PRICE_USD) as volume,

sum(volume) over (order by date) as cum_volume

from ethereum.core.ez_nft_sales

where block_timestamp::date >= '2022-08-01'

group by 1

order by 1 desc