date_trunc('week',BLOCK_TIMESTAMP) as week,

count(distinct tx_hash) as sale_no,

count(distinct BUYER_ADDRESS) as buyer_no,

count(distinct SELLER_ADDRESS) as seller_no,

sum(PRICE) as volume,

sum(PRICE_USD) as volume_usd,

avg(PRICE) as average_volume

from optimism.core.ez_nft_sales

where PLATFORM_NAME='quixotic'

and EVENT_TYPE='sale'

and CURRENCY_SYMBOL='OP'

group by 1