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