with polygon_usdt as (

SELECT 'polygon [USDT]' as type,

sum(value) as tvl

FROM (

SELECT

sum(amount_usd) as value

FROM polygon.core.ez_token_transfers

WHERE

to_address = '0x7043e4e1c4045424858ecbced80989feafc11b36'

AND block_timestamp::date >= '2023-04-16'

AND block_number >= 41594860

UNION

SELECT

-1 * sum(amount_usd) as value

FROM polygon.core.ez_token_transfers

WHERE

from_address = '0x7043e4e1c4045424858ecbced80989feafc11b36'

AND block_timestamp::date >= '2023-04-16'

AND block_number >= 41594860

,

polygon_usdc as (

SELECT 'polygon [USDC]' as type,

sum(value) as tvl

FROM (

SELECT

sum(amount) as value

FROM polygon.core.ez_token_transfers

WHERE

to_address = lower('0x2a838AB9b037db117576db8D0DcC3B686748EF7c')

AND block_timestamp::date >= '2023-01-31'

AND block_number >= 38749424

AND symbol = 'USDC'

UNION