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

platform_name as "marketplace",

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 = 'potatoz' and

price_usd is not null

group by 1