SELECT
BALANCE_DATE,
sum(AMOUNT_USD) as tvl
FROM flipside_prod_db.ethereum.erc20_balances
where USER_ADDRESS in (
'0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1', -- Hop Protocol: DAI Bridge
'0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2', -- Hop Protocol: MATIC Bridge
'0x3666f603cc164936c1b87e207f36beba4ac5f18a', -- Hop Protocol: USDC Bridge
'0x3e4a3a4796d16c0cd582c382691998f7c06420b6', -- Hop Protocol: USDT Bridge
'0xb8901acb165ed027e32754e0ffe830802919727f'
)
GROUP BY BALANCE_DATE