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='0x51e5426ede4e2d4c2586371372313b5782387222'

group by NFT_ADDRESS,date