select *

from $query('d46b92dc-794b-4a63-a681-cf84888b0274')),

transfers as (

(select distinct tx_hash, block_timestamp, ORIGIN_FROM_ADDRESS, FROM_ADDRESS,TO_ADDRESS,SYMBOL,AMOUNT,AMOUNT_USD,CONTRACT_ADDRESS as token_address,RAW_AMOUNT,EVENT_INDEX AS INDEX

from base.core.ez_token_transfers

where ORIGIN_FROM_ADDRESS = FROM_ADDRESS)

--and BLOCK_TIMESTAMP >= '2025-02-21')

union all

(select distinct tx_hash, block_timestamp, ORIGIN_FROM_ADDRESS, FROM_ADDRESS,TO_ADDRESS,'ETH' as SYMBOL,AMOUNT,AMOUNT_USD,'0x0000000000000000000000000000000000000000' as token_address,AMOUNT_PRECISE_RAW ,TRACE_INDEX

from base.core.ez_native_transfers

where ORIGIN_FROM_ADDRESS = FROM_ADDRESS)

--and BLOCK_TIMESTAMP >= '2025-02-21')

),

base as (

select

a.BLOCK_TIMESTAMP,

'Base' || ' ---> ' || Chain_Name as bridge_route,

'0x' || substr(TOPICS[1], 27, 42) as sender_address,

length(A.DATA) as length,

b.SYMBOL,

b.AMOUNT,

b.AMOUNT_USD,

a.TX_HASH,

B.INDEX,

a.ORIGIN_FROM_ADDRESS,

b.ORIGIN_FROM_ADDRESS as freom_Addrs,

B.FROM_ADDRESS,

B.TO_ADDRESS,

a.ORIGIN_TO_ADDRESS,

A.ORIGIN_FUNCTION_SIGNATURE,

A.DATA,

ethereum.public.udf_hex_to_int(substr(A.data, (3 + (64*0)), 64)) as sequence,

ethereum.public.udf_hex_to_int(substr(A.data, (3 + (64*1)), 64)) as nonce,