mucryptoTVL market share of top 10 RWA protocols 2024-02-08 02:59 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),

    final_list as (
    select
    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.05%
    7
    Hashnote USYC1.13%
    8
    BackedFi0.99%
    9
    tangible0.97%
    10
    maple-finance0.85%
    10
    230B
    5s