BLOCK_TIMESTAMP,

TX_HASH ,

SELLER_ADDRESS as seller ,

BUYER_ADDRESS as buyer ,

NFT_ADDRESS as CONTRACT_ADDRESS,

TOKENID as token_id ,

CURRENCY_SYMBOL ,

PRICE as volume

from optimism.core.ez_nft_sales

where EVENT_TYPE='sale' and PLATFORM_NAME =('quixotic') )

select

distinct CONTRACT_ADDRESS,

count(distinct TX_HASH) as txs ,

count(distinct buyer) as buyers ,

count(distinct seller) as sellers ,

count(distinct token_id) as token_id ,

token_id

from a

where CONTRACT_ADDRESS !='0x82af49447d8a07e3bd95bd0d56f35241523fbab1'

group by token_id,CONTRACT_ADDRESS

order by buyers desc limit 10