BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS as buyer ,

EVENT_INPUTS:from as seller ,

EVENT_INPUTS:tokenId as token_id,

CONTRACT_ADDRESS,ORIGIN_FUNCTION_SIGNATURE

from

arbitrum.core.fact_event_logs

where EVENT_NAME ='Transfer'

and TX_STATUS='SUCCESS'

and BUYER !=SELLER and ORIGIN_TO_ADDRESS=lower('0x7bc8b1b5aba4df3be9f9a32dae501214dc0e4f3f')

order by 1 desc )

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 ,

ORIGIN_FUNCTION_SIGNATURE

from a

where CONTRACT_ADDRESS !='0x82af49447d8a07e3bd95bd0d56f35241523fbab1'

group by CONTRACT_ADDRESS,ORIGIN_FUNCTION_SIGNATURE

order by sellers desc limit 10