with txs as (

(select

'ETH' as SYMBOL_OR_CONTRACT,

AMOUNT,

AMOUNT_USD,

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS,

ORIGIN_TO_ADDRESS,

ORIGIN_FUNCTION_SIGNATURE,

ETH_FROM_ADDRESS as FROM_ADDRESS,

ETH_TO_ADDRESS as TO_ADDRESS

from ethereum.core.ez_ETH_transfers

where AMOUNT > 0)

union all

(select

coalesce(SYMBOL,CONTRACT_ADDRESS) as SYMBOL_OR_CONTRACT,

AMOUNT,

AMOUNT_USD,

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS,

ORIGIN_TO_ADDRESS,

ORIGIN_FUNCTION_SIGNATURE,

FROM_ADDRESS as FROM_ADDRESS,

TO_ADDRESS as TO_ADDRESS

from ethereum.core.ez_token_transfers

where AMOUNT > 0)

(select

'Polygon zkEVM' as "Network",

*