mucrypto2023-08-25 06:36 AM DeFiLlama, Categories
Updated 2023-08-25
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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