flipside

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

    tvl as (
    select
    value:category as category,
    value:tvl as tvl
    from resps,
    lateral flatten (input => resp:data)),

    combined as (select
    category,
    sum(tvl) as combined_tvl
    from tvl
    where category not in ('CEX', 'Chain')
    group by 1
    order by 2 desc),

    total_combined as (
    select
    sum(combined_tvl) as total_combined_tvl
    from combined)

    select
    category,
    cast(combined_tvl / total_combined_tvl * 100 as decimal(38,2)) as tvl_market_share
    from combined
    inner join total_combined
    order by 2 desc
    Last run: about 1 year agoAuto-refreshes every 12 hours
    CATEGORY
    TVL_MARKET_SHARE
    1
    Liquid Staking
    		27.97
    2
    Lending
    		17.81
    3
    Bridge
    		11.18
    4
    Dexes
    		10.65
    5
    CDP
    		6.68
    6
    Restaking
    		4.6
    7
    Services
    		3.99
    8
    Yield
    		3.51
    9
    RWA
    		2.94
    10
    Liquid Restaking
    		2.23
    11
    Farm
    		1.78
    12
    Derivatives
    		1.48
    13
    Yield Aggregator
    		0.8
    14
    Synthetics
    		0.6
    15
    Launchpad
    		0.59
    16
    Staking Pool
    		0.51
    17
    Cross Chain
    		0.47
    18
    Indexes
    		0.34
    19
    Privacy
    		0.3
    20
    Liquidity manager
    		0.29
    38
    773B
    12s