block_timestamp::date as date,

count(distinct tx_hash) as txs,

count(distinct seller_address) as sellers,

count(distinct buyer_address) as buyers,

count(distinct tokenid) as tokens,

sum(price) as volume,

sum(price_usd) as volume_usd,

sum(txs) over(order by date) as total_txs,

sum(sellers) over(order by date) as total_sellers,

sum(buyers) over(order by date) as total_buyers,

sum(tokens) over(order by date) as total_tokens,

sum(volume) over(order by date) as total_volume,

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

avg(volume) over(order by date rows between 6 preceding and current row) as ma_7days_eth,

avg(volume_usd) over(order by date rows between 6 preceding and current row) as ma_7days_usd

from ethereum.core.ez_nft_sales

where project_name ilike '%Cryptopunk%'

and event_type = 'sale'

and buyer_address not like '0x000000000000000000000000%'

and date >= '2022-01-01'

group by 1