count(distinct tx_hash) as total_num_txs,

count(distinct seller_address) as total_nft_sellers,

count(distinct buyer_address) as total_nft_buyers,

count(distinct tokenid) as total_num_nfts,

sum(price) as total_nft_sales_eth,

sum(price_usd) as total_nft_sales_usd,

sum(price)/total_nft_buyers as avg_nft_sales_eth,

sum(price_usd)/total_nft_buyers as avg_nft_sales_usd,

total_num_nfts/total_nft_buyers as avg_nfts_per_buyer,

avg(price_usd) as avg_nft_sales_usd,

max(price_usd) as max_nft_sales_usd,

min(price_usd) as floor_price,

total_nft_sales_usd/180 as usd_per_day,

total_num_txs/180 as tx_per_day,

total_nft_buyers/180 as buyers_per_day

from ethereum.core.ez_nft_sales

where currency_symbol in ('WETH', 'ETH')

and

event_type = 'sale'

and

buyer_address not in ('0x0000000000000000000000000000000000000000')

and

block_timestamp >= '2023-01-01'