with arbitrum as (

with tab1 as (

with seri1 as (

select

date_trunc('day', block_timestamp) as "Date",

sum(amount_in_usd) as selling_volume_usd

from

arbitrum.defi.ez_dex_swaps

where

token_in = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8'

group by

1

)

select

"Date",

case

when selling_volume_usd is null then 0

else selling_volume_usd

end as selling_volume_usd

from

seri1

),

tab2 as (

with seri2 as (

select

date_trunc('day', block_timestamp) as "Date",

sum(amount_out_usd) as buying_volume_usd

from

arbitrum.defi.ez_dex_swaps

where

token_out = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8'

group by

1

)

select