select 'ARB'as token

,sum(AMOUNT_IN_USD) as sell_volume

,count(distinct ORIGIN_FROM_ADDRESS) as sellers

,count(distinct TX_HASH) as sell_swaps

from arbitrum.defi.ez_dex_swaps

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

and PLATFORM='uniswap-v3'

and SYMBOL_IN='ARB'

group by 1

union all

select 'OP'as token

,sum(AMOUNT_IN_USD) as sell_volume

,count(distinct ORIGIN_FROM_ADDRESS) as sellers

,count(distinct TX_HASH) as sell_swaps

from optimism.defi.ez_dex_swaps

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

and PLATFORM='uniswap-v3'

and SYMBOL_IN='OP'

group by 1