arbitrum as (

select

block_timestamp,

tx_hash,

origin_from_address as swapper,

event_index,

platform as dex,

pool_name,

token_in,

token_out,

symbol_in,

symbol_out,

amount_in,

amount_out,

amount_in_usd,

amount_out_usd,

(amount_in_usd + amount_out_usd) / 2 as amount_usd

from

arbitrum.defi.ez_dex_swaps

where

block_timestamp::date between '2024-01-01' and '2024-07-31'

),

avalanche as (

select

block_timestamp,

tx_hash,

origin_from_address as swapper,

event_index,

platform as dex,

pool_name,

token_in,

token_out,

symbol_in,