select

'Ethereum' as chain,

block_timestamp,

tx_hash,

origin_from_address,

amount_in_usd,

amount_out_usd,

platform,

symbol_in,

symbol_out,

pool_name

from ethereum.defi.ez_dex_swaps

where token_in = '0xa469b7ee9ee773642b3e93e842e5d9b5baa10067'or

token_out = '0xa469b7ee9ee773642b3e93e842e5d9b5baa10067'

union all

select

'Base' as chain,

block_timestamp,

tx_hash,

origin_from_address,

amount_in_usd,

amount_out_usd,

platform,

symbol_in,

symbol_out,

pool_name

from base.defi.ez_dex_swaps

where token_in = '0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938'or

token_out = '0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938'

union all

select

'Arbitrum One' as chain,

block_timestamp,

tx_hash,

origin_from_address,