mucrypto2023-08-31 12:17 AM
    Updated 2023-10-04
    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 = 'Lending'
    group by 1
    order by 2 desc
    Run a query to Download Data