date_trunc('week', block_timestamp) as week,

count(DISTINCT tx_hash) as nft_sales ,

avg(PRICE_USD) as avg_price ,

sum(price_usd) as sum_price_usd ,

sum(price) as sum_price_eth

FROM ethereum.core.ez_nft_sales

WHERE project_name LIKE 'cryptopunks'

AND NOT PRICE_USD is NULL

GROUP BY 1

ORDER BY 1