mucryptoLiquid Staking, Combined TVL 2023-08-29 03:23 AM
    Updated 2023-11-08
    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 = 'Liquid Staking'
    group by 1
    order by 2 desc
    Run a query to Download Data