with tvl as (select *
from external.defillama.fact_protocol_tvl
where chain = 'Sei'
and protocol ilike '%yei finance%')
,
borrow as (select *
from external.defillama.fact_protocol_tvl
where chain = 'Sei-borrowed'
and protocol ilike '%yei finance%')
select a.date,
a.chain_tvl as "Yei Finance TVL",
b.chain_tvl as "Borrow TVL"
from tvl a join borrow b on a.date = b.date
order by 1 desc
limit 1