SELECT tx_hash, block_timestamp, amount, symbol, amount_usd

FROM (

SELECT tx_hash, block_timestamp, amount, symbol, amount_usd

FROM ethereum.core.ez_token_transfers

WHERE origin_from_address = '0x5bce67b4cca69ec4ea2415d4520432a63aaa96c8'

AND origin_to_address = '0x26c2bd020bfbe8366f79ffda1a0cfac5a7b52108'

UNION ALL

SELECT tx_hash, block_timestamp, -amount, symbol, -amount_usd

FROM ethereum.core.ez_token_transfers

WHERE from_address = '0x26c2bd020bfbe8366f79ffda1a0cfac5a7b52108'

AND to_address = '0x5bce67b4cca69ec4ea2415d4520432a63aaa96c8'

UNION ALL

SELECT tx_hash, block_timestamp, -amount, 'WETH' as symbol, -amount_usd

FROM ethereum.core.ez_native_transfers

WHERE from_address = '0x26c2bd020bfbe8366f79ffda1a0cfac5a7b52108'

AND to_address = '0x5bce67b4cca69ec4ea2415d4520432a63aaa96c8'

UNION ALL

SELECT tx_hash, block_timestamp, amount, 'WETH' as symbol, amount_usd

FROM ethereum.core.ez_native_transfers

WHERE from_address = '0x5bce67b4cca69ec4ea2415d4520432a63aaa96c8'

AND to_address = '0x26c2bd020bfbe8366f79ffda1a0cfac5a7b52108'

)

ORDER BY block_timestamp