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

count(distinct TX_HASH) as txs ,

count(distinct buyer) as buyers ,

count(distinct seller) as sellers ,

count(distinct token_id) as token_id ,

sum(volume) as volumes ,

token_id ,

CONTRACT_ADDRESS

from a

group by token_id ,CONTRACT_ADDRESS

order by volumes desc limit 10