WEEK | CHAIN_SUMMARY | SUM_TVL_USD | |
|---|---|---|---|
1 | 2024-05-01 00:00:00.000 | Other | 291512482926 |
2 | 2024-05-01 00:00:00.000 | aavev2 | 7539941364 |
3 | 2024-05-01 00:00:00.000 | aavev3 | 48665835248 |
4 | 2024-05-01 00:00:00.000 | binancestakedeth | 20330135181 |
5 | 2024-05-01 00:00:00.000 | coinbasewrappedstakedeth | 3985454622 |
6 | 2024-05-01 00:00:00.000 | compoundv3 | 5807584730 |
7 | 2024-05-01 00:00:00.000 | convexfinance | 9442483700 |
8 | 2024-05-01 00:00:00.000 | curvedex | 5729880597 |
9 | 2024-05-01 00:00:00.000 | eigenlayer | 37277444276 |
10 | 2024-05-01 00:00:00.000 | eigenpie | 5970652221 |
11 | 2024-05-01 00:00:00.000 | ethena | 5949085326 |
12 | 2024-05-01 00:00:00.000 | ether.filiquid | 7313601458 |
13 | 2024-05-01 00:00:00.000 | ether.fistake | 35751021423 |
14 | 2024-05-01 00:00:00.000 | jito | 10701030405 |
15 | 2024-05-01 00:00:00.000 | justcryptos | 15523050278 |
16 | 2024-05-01 00:00:00.000 | justlend | 13558125171 |
17 | 2024-05-01 00:00:00.000 | kaminolend | 2307035718 |
18 | 2024-05-01 00:00:00.000 | lido | 503609370305 |
19 | 2024-05-01 00:00:00.000 | makerdao | 13131857212 |
20 | 2024-05-01 00:00:00.000 | makerrwa | 4688638730 |
rockawayxfilthy-indigo
Updated 2025-03-27
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
27
28
29
30
31
32
›
⌄
WITH chain_tvl AS (
SELECT
date_trunc('month', date) AS week,
lower(trim(replace(protocol,' ',''))) AS protocol,
SUM(chain_tvl) AS sum_tvl_usd
FROM external.defillama.fact_protocol_tvl
WHERE date >= '2021-01-01'
GROUP BY 1, 2
),
chain_rankings AS (
SELECT
protocol,
RANK() OVER (ORDER BY SUM(sum_tvl_usd) DESC) AS rank
FROM chain_tvl
GROUP BY 1
)
SELECT
ct.week,
CASE
WHEN cr.rank <= 50 THEN ct.protocol
ELSE 'Other'
END AS chain_summary,
SUM(ct.sum_tvl_usd) AS sum_tvl_usd
FROM chain_tvl ct
JOIN chain_rankings cr
ON ct.protocol = cr.protocol
GROUP BY 1, 2
ORDER BY 1, 2;
-- morpho, resolv, kamino
Last run: about 1 month ago
...
507
27KB
3s