date_trunc('day',block_timestamp) as day ,

count(distinct buyer_address) as Buyers ,

count(distinct seller_address) as Sellers ,

sum(price) as sum_price_eth

FROM ethereum.core.ez_nft_sales

where project_name = 'cryptopunks'

AND block_timestamp >= '2023-01-01'

and price is not null

and price <> 0

group by 1

order by 1