L as(select token,chain,contract,price from $query('a431c1fc-9ce0-4a5d-b100-e3af8a26b5d8') ),

X as(

select 'Base' as chain, block_timestamp, 0+amount as balance, from_address as user, to_address as pool, contract_address from base.core.ez_token_transfers union all

select 'Base' as chain, block_timestamp, 0-amount as balance, to_address as user, from_address as pool, contract_address from base.core.ez_token_transfers ),

A as(

select token, a.chain,

sum(case when balance is null then 0 else balance end) as BAL,

sum(case when balance is null then 0 else balance*price end) as TVL

from X as a

join L as b on a.chain = b.chain and a.contract_address = lower(b.contract)

where user = '0x0000000000000000000000000000000000000000'

group by 1,2)

select

token, chain,

to_varchar(BAL,'999,999,999,999') as SUPPLY,

to_varchar(TVL,'$999,999,999,999') as TVLs,

'-' "I",

TVL, BAL, sum(TVL) over() as TVL_ALL -- oasis tvl

from A

order by TVL desc