mucryptoDeFi protocols ranked by combined TVL
    Updated 2023-10-09
    with resps as
    (select defillama.get('/protocols', {}) as resp),

    ttvl as (
    select
    value:category::string as category,
    value:tvl::number as tvl
    from resps,
    lateral flatten (input => resp:data))

    select
    Category,
    sum(tvl) as combined_tvl
    from ttvl
    where category != 'CEX'
    and category != 'Chain'
    group by 1
    order by 2 desc
    Run a query to Download Data