flipside

    Combined TVL 2024-02-22 10:17 PM
    mucryptoCombined TVL 2024-02-22 10:17 PM
    Updated 2024-02-22
    with resps as
    (select defillama.get('/protocols', {}) as resp)

    select
    value:category as category,
    sum(value:tvl) as combined_tvl
    from resps,
    lateral flatten (input => resp:data)
    where category = 'Indexes'
    group by 1