date_trunc('week', block_timestamp)::date as week,

count(distinct tx_hash) as txn_count,

count(distinct nft_address) as nfts_count,

count(distinct buyer_address) as buyers_count,

count(distinct seller_address) as sellers_count,

sum(total_fees) as total_fee,

avg(total_fees) as average_fee,

median(total_fees) as median_fee,

sum(txn_count) over (order by week asc) as cumulative_txn_count,

sum(nfts_count) over (order by week asc) as cumulative_nfts_count,

sum(total_fee) over (order by week asc) as cumulative_total_fee

from optimism.core.ez_nft_sales

where currency_address = 'ETH'

and block_timestamp::date > '2022-01-01'

group by week

order by week asc