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

count(distinct TX_HASH) as txs ,

count(distinct buyer) as buyers ,

count(distinct seller) as sellers ,

count(distinct token_id) as token_id ,

count(distinct CONTRACT_ADDRESS) as collections

from a