main as (

select

tx_hash,

origin_from_address as user,

block_timestamp,

amount_usd,

symbol,

decoded_log:bridgeData:bridge as platform,

case decoded_log:bridgeData:destinationChainId

when 8453 then 'Base'

when 59144 then 'Linea'

when 324 then 'zkSync'

when 34443 then 'Mode'

when 1151111081099710 then 'Solana'

when 1 then 'Ethereum'

when 1329 then 'Sei'

when 137 then 'Polygon'

when 43114 then 'Avalanche'

when 10 then 'Optimism'

when 534352 then 'Scroll'

when 56 then 'BNB'

when 250 then 'Fantom'

when 1101 then 'Polygon zkEVM'

when 1088 then 'Metis'

end as destination_chain

from

arbitrum.core.ez_decoded_event_logs

join

arbitrum.core.ez_token_transfers

using (tx_hash, block_timestamp, origin_to_address)

where

tx_status = 'SUCCESS'

and event_name = 'LiFiTransferStarted'

and origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'