hessDaily TVL Per Platform
    Updated 2024-09-30
    with tops as ( select protocol,
    CHAIN_TVL
    from external.defillama.fact_protocol_tvl
    where chain = 'Klaytn'
    and date = current_date - 1
    order by 2 desc
    limit 10)

    select date,
    case when protocol ilike '%neopin%' then 'Neopin'
    when protocol ilike '%klayswap%' then 'Klayswap'
    when protocol ilike '%swapscanner%' then 'Swapscanner' else protocol end as platform,
    sum(chain_tvl) as tvl
    from external.defillama.fact_protocol_tvl
    where chain in ('Klaytn-staking','Klaytn')
    and date >= current_date - 90
    and protocol in (select protocol from tops)
    group by 1,2
    Last run: 3 months ago
    No Data to Display
    0
    2B
    14s