mucryptoDeFiLlama, top 10 categories, CEX, Chain included
    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
    group by 1
    order by 2 desc
    limit 10