mucryptoNumber of protocols 2024-05-18 06:20 AM
    Updated 2024-05-20
    with resps as
    (select defillama.get('/protocols', {}) as resp)

    select
    value:category as category,
    count(value:name) as "NUMBER OF PROTOCOLS"
    from resps,
    lateral flatten (input => resp:data)
    group by 1
    having category = 'Decentralized Stablecoin'
    QueryRunArchived: QueryRun has been archived