select 'ARB'as token

,case

when AMOUNT_OUT_USD>0 and AMOUNT_OUT_USD<10 then 'Below 10 $'

when AMOUNT_OUT_USD>=10 and AMOUNT_OUT_USD<=100 then '10~100 $'

when AMOUNT_OUT_USD>100 and AMOUNT_OUT_USD<=1000 then '100~1K $'

when AMOUNT_OUT_USD>1000 and AMOUNT_OUT_USD<=10000 then '1K~10K $'

when AMOUNT_OUT_USD>10000 then 'Up to 10K $' end as dis_volume

,count(distinct ORIGIN_FROM_ADDRESS) as swappers

,count(distinct TX_HASH) as swaps

from arbitrum.defi.ez_dex_swaps

where BLOCK_TIMESTAMP::date>='2023-10-01'

and PLATFORM='uniswap-v3'

and SYMBOL_OUT='ARB'

and dis_volume is not null

group by 1,2

union all

select 'OP'as token

,case

when AMOUNT_OUT_USD>0 and AMOUNT_OUT_USD<10 then 'Below 10 $'

when AMOUNT_OUT_USD>=10 and AMOUNT_OUT_USD<=100 then '10~100 $'

when AMOUNT_OUT_USD>100 and AMOUNT_OUT_USD<=1000 then '100~1K $'

when AMOUNT_OUT_USD>1000 and AMOUNT_OUT_USD<=10000 then '1K~10K $'

when AMOUNT_OUT_USD>10000 then 'Up to 10K $' end as dis_volume

,count(distinct ORIGIN_FROM_ADDRESS) as swappers

,count(distinct TX_HASH) as swaps

from optimism.defi.ez_dex_swaps

where BLOCK_TIMESTAMP::date>='2023-10-01'

and PLATFORM='uniswap-v3'

and SYMBOL_OUT='OP'

and dis_volume is not null

group by 1,2