hessDaily Yei Finance TVL [USD] II
    Updated 2024-10-26
    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

    QueryRunArchived: QueryRun has been archived