with transfer as ( select block_timestamp,

tx_hash,

origin_from_address,

TX_POSITION as EVENT_INDEX,

'WSEI' as contract_address,

from_address,

to_address,

'WSEI' as symbol,

AMOUNT_PRECISE as amount

from sei.core_evm.ez_native_transfers

UNION all

select block_timestamp,

tx_hash,

origin_from_address,

EVENT_INDEX,

contract_address,

from_address,

to_address,

symbol,

amount

from sei.core_evm.ez_token_transfers)

,

base as ( select block_timestamp,

tx_hash,

origin_from_address::string as swapper,

contract_address,

symbol,

amount,

to_address,

event_index,

from_address

from transfer

where tx_hash in (select tx_hash

from sei.core_evm.fact_event_logs