select date_trunc('week',BLOCK_TIMESTAMP) as week

,count(distinct BUYER_ADDRESS) as buyers

,count(distinct TOKENID) as nft_sold

,count(distinct TX_HASH) as sale_count

,count(distinct SELLER_ADDRESS) as sellers

,sum(PRICE_USD) as sale_volume

,sum(TX_FEE_USD) as fee_amount

from ethereum.core.ez_nft_sales

where BLOCK_TIMESTAMP>=current_date-30

and EVENT_TYPE='sale'

and PRICE_USD>0

group by 1)

select 'ETH Chain' as chain

,avg(buyers) as "Avg Buyers"

,avg(nft_sold) as "Avg NFT Sold"

,avg(sellers) as "Avg Sellers"

,avg(sale_volume) as "Avg Volume"

,avg(sale_count) as "Avg sale Count"

,avg(fee_amount) as "Avg Fee Amount"

from tab1

group by 1