CartanGroupTVL Comparison - APTOS vs. Others
Updated 2024-10-14
99
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
›
⌄
WITH
json as (
SELECT
livequery.live.udf_api (
'https://api.llama.fi/v2/chains'
) AS response
)
SELECT CASE when ranking = '1' then '🥇'
when ranking = '2' then '🥈'
when ranking = '3' then '🥉'
else to_char(ranking) end as rank,
network,
tvl_usd
FROM (
SELECT
value:name::string as network,
value:tvl::double as tvl_usd,
rank()over(ORDER BY tvl_usd DESC) as ranking
FROM
json,
LATERAL FLATTEN(input => response:data)
WHERE network IN ('Sui', 'Polygon', 'Avalanche', 'Solana', 'Aptos')
ORDER BY tvl_usd DESC)
QueryRunArchived: QueryRun has been archived