SELECT date_trunc('week', balance_date) as weekly , sum(balance) as TVL

from ethereum.erc20_balances B

where balance_date >= '2021-12-27'

and balance_date < '2022-04-18'

and user_address <> '0x82ccea8020dde8df2932f6920c39e1259ff5eea1'

and user_address <> '0xad492e78ea607f1ccf1cefaa7ee37871932b1d02'

and user_address <> '0x8c654ea010cfb5312fc711f05cde3d91a7a8ddbe'

and symbol like '%/USDC-LINK'

group by 1)

,

DAI_daily as (

SELECT date_trunc('week', balance_date) as weekly , sum(balance) as TVL

from ethereum.erc20_balances B

where balance_date >= '2021-12-27'

and balance_date < '2022-04-18'

and user_address <> '0x82ccea8020dde8df2932f6920c39e1259ff5eea1'

and user_address <> '0xad492e78ea607f1ccf1cefaa7ee37871932b1d02'

and user_address <> '0x8c654ea010cfb5312fc711f05cde3d91a7a8ddbe'

and symbol like '%/DAI-LINK'

group by 1)

,

USDT_daily as (

SELECT date_trunc('week', balance_date) as weekly , sum(balance) as TVL

from ethereum.erc20_balances B

where balance_date >= '2021-12-27'

and balance_date < '2022-04-18'

and user_address <> '0x82ccea8020dde8df2932f6920c39e1259ff5eea1'

and user_address <> '0xad492e78ea607f1ccf1cefaa7ee37871932b1d02'

and user_address <> '0x8c654ea010cfb5312fc711f05cde3d91a7a8ddbe'

and symbol like '%/USDT-LINK'

group by 1)