select sum(amount_usd) as ETH_volume, date_trunc('week', block_timestamp::date) as TIME, 'ETH' as asset

from ethereum.core.ez_eth_transfers

where origin_to_address = lower('0xb8901acB165ed027E32754E0FFe830802919727f')

and block_timestamp > CURRENT_DATE - 180

group by TIME, asset),

matic as (select sum(amount_usd) as Matic_volume, date_trunc('week', block_timestamp::date) as TIME, 'Matic' as asset

from ethereum.core.ez_token_transfers

where origin_to_address = lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2')

and block_timestamp > CURRENT_DATE - 180

group by TIME, asset)

select sum(ETH_volume) as eth_volume, sum(Matic_volume) as matic_volume, e.TIME,

case when e.asset = 'ETH' then 'ETH'

when m.asset = 'Matic' then 'Matic'

end as token

from eth e inner join matic m on m.TIME = e.TIME

group by e.TIME, token