select contract_address, symbol from ethereum.erc20_balances WHERE

balance_date::date = CURRENT_DATE - 2

and symbol like 'km%'

and ( symbol like '%USDC%' or symbol like '%DAI%' or symbol like '%UST%' or symbol like '%USDT%' ) group by 1, 2

), perdate as (

select balance_date::date as date, symbol, sum(balance) as total from ethereum.erc20_balances where

YEAR(balance_date) = 2022 and

contract_address in (select contract_address from data_kashi) group by 1, 2

select date_trunc('week', date) as week, symbol, avg(total) as tvl from perdate group by 1, 2