flipside

    TVL market share of top 10 RWA protocols 2024-02-08 02:03 PM
    mucryptoTVL market share of top 10 RWA protocols 2024-02-08 02:03 PM
    Updated 2024-02-08
    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 = 'RWA'
    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
    		maker49.37
    2
    		stUSDT31.61
    3
    		Ondo Finance4.23
    4
    		Mountain Protocol3.54
    5
    		realt2.28
    6
    		MatrixDock2.06
    7
    		Hashnote USYC1.13
    8
    		BackedFi0.99
    9
    		tangible0.97
    10
    		maple-finance0.85
    10
    200B
    4s