SELECT

SPLIT_PART('{{token_pair}}', '<->', 1) AS token1,

SPLIT_PART('{{token_pair}}', '<->', 2) AS token2

FROM

(VALUES(1,2))

, arb_0 AS (

SELECT

tx_hash,

MAX(symbol_in) as symbol_in,

MAX(symbol_out) as symbol_out,

MAX(COALESCE(amount_in_usd, 0)) AS amount,

MAX(ORIGIN_FROM_ADDRESS) as wallet

FROM

arbitrum.defi.ez_dex_swaps

WHERE

platform LIKE '%uniswap%'

GROUP BY 1

, arb as (

SELECT

symbol_in,

symbol_out,

'arb' as chain,

MAX(LEAST(symbol_in, symbol_out)) AS token1,

MAX(GREATEST(symbol_in, symbol_out)) AS token2,

COUNT(DISTINCT tx_hash) AS swap_count,

SUM(amount) AS swap_volume,

MAX(amount) AS max_swap_volume,

COUNT(DISTINCT wallet) AS wallet

FROM

arb_0

where