'AVAX' as SYMBOL_OR_CONTRACT,

AMOUNT,

AMOUNT_USD,

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS,

ORIGIN_FUNCTION_SIGNATURE,

avax_FROM_ADDRESS as FROM_ADDRESS,

avax_TO_ADDRESS as TO_ADDRESS

from avalanche.core.ez_avax_transfers

where ORIGIN_TO_ADDRESS = '0xe0c38b2a8d09aad53f1c67734b9a95e43d5981c0'

and AMOUNT > 0)

union all

(select

coalesce(SYMBOL,CONTRACT_ADDRESS) as SYMBOL_OR_CONTRACT,

AMOUNT,

AMOUNT_USD,

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS,

ORIGIN_FUNCTION_SIGNATURE,

FROM_ADDRESS as FROM_ADDRESS,

TO_ADDRESS as TO_ADDRESS

from avalanche.core.ez_token_transfers

where ORIGIN_TO_ADDRESS = '0xe0c38b2a8d09aad53f1c67734b9a95e43d5981c0'

and AMOUNT > 0)),

Swap_from as (select

'Swap From' as action,

*

from txs

where ORIGIN_FROM_ADDRESS = FROM_ADDRESS),

Swap_for as

(select