flipside

    Number of protocols 2024-02-03 07:29 PM
    mucryptoNumber of protocols 2024-02-03 07:29 PM
    Updated 2024-02-03
    with resps as
    (select defillama.get('/protocols', {}) as resp)

    select
    value:category as category,
    count(value:name) as n_of_protocols
    from resps,
    lateral flatten (input => resp:data)
    group by 1
    having category = 'RWA'
    Last run: about 1 year ago
    CATEGORY
    N_OF_PROTOCOLS
    1
    RWA
    		40
    1
    12B
    105s