SELECT

'arbitrum' AS platform,

origin_from_address,

tx_hash,

CASE

WHEN amount_in_usd IS NULL THEN amount_out_usd

ELSE amount_in_usd

END AS usd_volume,

CASE

WHEN usd_volume > 1000000 THEN 'Whale'

WHEN usd_volume <= 1000000 THEN 'Retail User'

END AS User_Category

FROM

arbitrum.defi.ez_dex_swaps

WHERE

(

AMOUNT_IN_USD BETWEEN AMOUNT_OUT_USD - 5000

AND AMOUNT_OUT_USD + 5000

)

AND platform = 'uniswap-v3'

GROUP BY

4,

1,

2,

3

),

BaseSwapData AS (

SELECT

'base' AS platform,

origin_from_address,

tx_hash,

CASE

WHEN amount_in_usd IS NULL THEN amount_out_usd

ELSE amount_in_usd

END AS usd_volume,