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

sum(GAS_PRICE_PAID) as total_gas , avg(GAS_PRICE_PAID) as avg_gas ,sum(TX_FEE) as total_fee , avg(TX_FEE) as avg_fee

from arbitrum.core.fact_transactions

where TX_HASH in (select TX_HASH from a)