select BLOCK_TIMESTAMP::date as date

,sum(PRICE) as volume

,avg(PRICE) as avg_volume

,count(distinct BUYER_ADDRESS) as buyers

,count(distinct SELLER_ADDRESS) as sellers

,count(distinct TOKENID) as nft_sold

,count(distinct TX_HASH) as sale_count

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

from base.nft.ez_nft_sales

group by 1)

select

avg(volume) as avg

from tab1