date_trunc('day',block_timestamp) as date,

count(distinct tx_hash) as tx_count,

count(distinct seller_address) as sellers,

count(distinct buyer_address) as buyers,

sum(price_usd) as volume_usd,

sum(tx_fee) as fees,

sum(tx_fee_usd) as fees_usd

from ethereum.core.ez_nft_sales

where platform_name like 'looksrare'

and block_timestamp >= '2022-12-15'

group by date

order by date asc)

select

avg(tx_count) as avg_tx_count,

avg(sellers) as avg_sellers,

avg(buyers) as avg_buyers,

avg(volume_usd) as avg_volume,

avg(fees_usd) as avg_fees_usd

from main_tab