count(distinct TX_HASH ) as txs , count(distinct SELLER_ADDRESS ) as SELLER_ADDRESSs ,count(distinct BUYER_ADDRESS ) as BUYER_ADDRESSs

,NFT_ADDRESS ,sum(PRICE) as volume ,avg (PRICE) as prices ,BLOCK_TIMESTAMP::date as date

FROM optimism.core.ez_nft_sales

WHERE platform_name = 'quixotic' and EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and NFT_ADDRESS='0x9c7305eb78a432ced5c4d14cac27e8ed569a2e26'

group by NFT_ADDRESS,date