with t1 as
(select
sum(AMOUNT_IN_USD) as buy_volume,
SYMBOL_IN
from
((select
'arbitrum' as blockchain ,
*
from
arbitrum.defi.ez_dex_swaps
where
PLATFORM like '%uniswap%'
and
BLOCK_TIMESTAMP>current_date-365)
union all
(select
'Base' as blockchain ,
*
from
Base.defi.ez_dex_swaps
where
PLATFORM like '%uniswap%'
and
BLOCK_TIMESTAMP>current_date-365)
union all
(select
'Optimism' as blockchain ,