select

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS AS User,

'Avalanche' AS Source,

case

when DECODED_LOG:_dstChainId = '110' then 'Arbitrum'

else 'BSC'

end AS Destination,

DECODED_LOG:_amount/1e18::Int AS Amount

from

avalanche.core.ez_decoded_event_logs

where

Event_name = 'SendToChain'

and CONTRACT_ADDRESS = '0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07'

and ORIGIN_FROM_ADDRESS not in (

'0x5d3e4c0fe11e0ae4c32f0ff74b4544c49538ac61',

'0x86355f02119bdbc28ed6a4d5e0ca327ca7730fff',

'0x2ef002aa0ab6761b6aea8d639dcdaa20d79b768c'

)

union ALL

select

BLOCK_TIMESTAMP,

TX_HASH,

from_address AS User,

'Arbitrum' as Source,

'Avalanche' AS Destination,

CAST(amount AS INT) AS Amount

from

arbitrum.core.ez_token_transfers

where

to_address = '0x0000000000000000000000000000000000000000'

and contract_address = '0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07'

and from_address not in (

'0x5d3e4c0fe11e0ae4c32f0ff74b4544c49538ac61',