mucryptoTop 10 DeFi categories ranked by combined TVL
    Updated 2024-02-15
    with resps as
    (select defillama.get('/protocols', {}) as resp)

    select
    value:category as "Category",
    sum(value:tvl) as "Combined TVL"
    from resps,
    lateral flatten (input => resp:data)
    where "Category" not in ('CEX', 'Chain')
    group by 1
    order by 2 desc
    limit 10
    Last run: about 1 year agoAuto-refreshes every 12 hours
    Category
    Combined TVL
    1
    Liquid Staking
    42498048706.4501
    2
    Lending
    27089678865.476
    3
    Bridge
    17010483211.2015
    4
    Dexes
    16223729618.7287
    5
    CDP
    10163736738.9527
    6
    Restaking
    6992218016.11734
    7
    Services
    6061402623.22293
    8
    Yield
    5346739654.54234
    9
    RWA
    4500620312.38715
    10
    Liquid Restaking
    3383651742.29924
    10
    296B
    116s