with trades_decodes_table as (

with optimism_trades as (

select

,block_timestamp

,concat('0x',substr(topics[3],-40)) as user

,'10' as from_chainID

,regexp_substr_all(SUBSTR(data, 3), '.{64}') AS segmented

,utils.udf_hex_to_int(substr(topics[1],-40)) as to_chainID

,concat('0x', substr(segmented [0], -40)) as from_token

,concat('0x', substr(segmented [3], -40)) as from_token_value

,utils.udf_hex_to_int(from_token_value) as from_token_value_int

,concat('0x', substr(segmented [1], -40)) as to_token

,concat('0x', substr(segmented [4], -40)) as to_token_value

,utils.udf_hex_to_int(to_token_value) as to_token_value_int

from optimism.core.fact_event_logs

where 1=1

and block_number >= '121593991' -- june 19 2024

and TX_STATUS = 'SUCCESS'

and contract_address='0x6cca65f0bc3140019a81a1619aa75a6925c2601e'

and origin_to_address='0x6cca65f0bc3140019a81a1619aa75a6925c2601e'

and topics[0]='0x43784f390addfc00eee6e683e2c14a18da294f5fb331b76fd37c6537106ff9cd'

),

ethereum_trades as (

select

,block_timestamp

,concat('0x',substr(topics[3],-40)) as user

,'1' as from_chainID

,regexp_substr_all(SUBSTR(data, 3), '.{64}') AS segmented

,utils.udf_hex_to_int(substr(topics[1],-40)) as to_chainID

,concat('0x', substr(segmented [0], -40)) as from_token