Updated 2022-09-04
    with a as (select
    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


    Run a query to Download Data