select

date_trunc('day', block_timestamp) as "day",

sum(price_usd) as "sales volume",

avg(price_usd) as "avg nft price",

count(distinct buyer_address) as "unique buyers",

count(distinct seller_address) as "unique sellers",

count(distinct tx_hash) as "sales count"

from ethereum.core.ez_nft_sales

where

project_name = 'cryptopunks' and

price_usd is not null

group by 1

),

avg_info as (

select

avg("sales volume") as "daily sales volume (in usd)",

avg("avg nft price") as "daily nft price (in usd)",

avg("sales count") as "daily sales count",

avg("unique buyers") as "daily unique buyers",

avg("unique sellers") as "daily unique sellers"

from info

select *

from avg_info