flipside

    TVL market share of top 10 farm protocols 2024-02-19 11:29 PM
    mucryptoTVL market share of top 10 farm protocols 2024-02-19 11:29 PM
    Updated 2024-02-19
    with resps as
    (select defillama.get('/protocols', {}) as resp),

    list as (
    select
    value:category as category,
    value:parentProtocol as protocol,
    value:name as name,
    value:tvl as tvl
    from resps,
    lateral flatten (input => resp:data)
    where category = 'Farm'
    and tvl != 0),

    m_protocols as (
    select
    substr(protocol, 8) as protocol,
    sum(tvl) as tvl
    from list
    group by 1),

    protocols as (
    select
    name,
    sum(tvl) as tvl
    from list
    where protocol is null
    group by 1),

    tvl_combined as (
    select
    sum(tvl) as total_combined_tvl
    from list)

    select
    protocol,
    Last run: about 1 year ago
    PROTOCOL
    TVL_MARKET_SHARE
    1
    		Blast53.27
    2
    		Merlins Seal33.92
    3
    		B2 Buzz12.16
    4
    		vyfinance0.19
    5
    		swell0.17
    6
    		ZoomSwap0.06
    7
    		bao-finance0.06
    8
    		GroveCoin0.04
    9
    		sperax0.04
    10
    		zkDX0.02
    10
    180B
    34s