sum(price_usd) as sales_volume_usd,

count(distinct tx_hash) as sales_count,

count(distinct buyer_address) as unique_buyer,

count(distinct seller_address) as unique_seller,

avg(price_usd) as avg_sales_price_usd

from optimism.core.ez_nft_sales

where block_timestamp::date >= '2022-07-01' and platform_name ilike '%quixotic%' and event_type = 'sale'