mucrypto2023-08-25 06:36 AM DeFiLlama, Categories
    Updated 2023-08-25
    with resps as
    (select defillama.get('/protocols', {}) as resp),

    liquid_staking_tvl as (
    select
    value:name::string as Name,
    value:category::string as Category,
    value:tvl::number as TVL
    from resps,
    lateral flatten (input => resp:data)
    where Category = 'Liquid Staking'
    and TVL != '0'),

    lending_tvl as (
    select
    value:name::string as Name,
    value:category::string as Category,
    value:tvl::number as TVL
    from resps,
    lateral flatten (input => resp:data)
    where Category = 'Lending'
    and TVL != '0'),

    dexes_tvl as (
    select
    value:name::string as Name,
    value:category::string as Category,
    value:tvl::number as TVL
    from resps,
    lateral flatten (input => resp:data)
    where Category = 'Dexes'
    and TVL != '0'),

    bridge_tvl as (
    select
    value:name::string as Name,
    Run a query to Download Data