select *, regexp_substr_all(SUBSTR(input,11),'.{64}') as segmented

, utils.udf_hex_to_int(segmented[0]) as destination_chain_selector

, concat('0x', substr(segmented[8],25,40)) as destination_address

, concat('0x', substr(segmented[11],25,40)) as token_address

, utils.udf_hex_to_int(segmented[12]) as token_amount

, case when token_address='0x3902228d6a3d2dc44731fd9d45fee6a61c722d0b' then '0x514910771af9ca656af840dff83e8264ecf986ca'

when token_address='0x9f28c9c2da4a833cbfaaacbf7eb62267334d7149' then '0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfa'

else token_address

end as price_address

from ronin.core.fact_traces

where 1=1

-- and tx_hash=lower('0x600ca84b1009c8f2b8c2d318613f3e511532dbcc000ea0e9f11e99f7ee713a8c')

and to_address='0x46527571d5d1b68ee7eb60b18a32e6c60dceaf99'

and block_timestamp >='2025-02-01'

and type='CALL'

and trace_address='ORIGIN'

and trace_succeeded='TRUE'

and tx_succeeded='TRUE'

select

br.block_number

, br.block_timestamp

, br.origin_from_address

, br.origin_to_address

, br.origin_function_signature

, br.tx_hash

, br.trace_index as event_index

, lower('0x46527571d5d1b68ee7eb60b18a32e6c60dceaf99') as bridge_address

, 'bridge' as event_name

, 'chainlink' as platform

, br.from_address as sender

, br.to_address as receiver

, br.destination_address as destination_chain_receiver

, case when br.destination_chain_selector='15971525489660198786' then 'base'