DAY | TOTAL_DAILY_TVL | PROTOCOL_NAME | DAILY_TVL | |
|---|---|---|---|---|
1 | 2025-02-24 00:00:00.000 | 3047393 | HyperSwap V3 | 470828 |
2 | 2025-02-24 00:00:00.000 | 3047393 | HyperSwap V2 | 631702 |
3 | 2025-02-24 00:00:00.000 | 3047393 | HypurrFi | 1944863 |
4 | 2025-02-25 00:00:00.000 | 3798231 | HyperSwap V2 | 441414 |
5 | 2025-02-25 00:00:00.000 | 3798231 | HyperSwap V3 | 1025400 |
6 | 2025-02-25 00:00:00.000 | 3798231 | HypurrFi | 2331417 |
7 | 2025-02-26 00:00:00.000 | 4687404 | HyperSwap V2 | 853049 |
8 | 2025-02-26 00:00:00.000 | 4687404 | HyperSwap V3 | 1104493 |
9 | 2025-02-26 00:00:00.000 | 4687404 | HypurrFi | 2729862 |
10 | 2025-02-27 00:00:00.000 | 5012235 | HyperSwap V2 | 902487 |
11 | 2025-02-27 00:00:00.000 | 5012235 | HyperSwap V3 | 1248510 |
12 | 2025-02-27 00:00:00.000 | 5012235 | HypurrFi | 2861238 |
13 | 2025-02-28 00:00:00.000 | 4874578 | HyperSwap V2 | 903471 |
14 | 2025-02-28 00:00:00.000 | 4874578 | HyperSwap V3 | 1145004 |
15 | 2025-02-28 00:00:00.000 | 4874578 | HypurrFi | 2826103 |
16 | 2025-03-01 00:00:00.000 | 5834056 | HyperSwap V2 | 930854 |
17 | 2025-03-01 00:00:00.000 | 5834056 | HyperSwap V3 | 1270166 |
18 | 2025-03-01 00:00:00.000 | 5834056 | HypurrFi | 3633036 |
19 | 2025-03-02 00:00:00.000 | 6084970 | HyperSwap V2 | 922839 |
20 | 2025-03-02 00:00:00.000 | 6084970 | HyperSwap V3 | 1330827 |
elenahoohyper-evm-tvl
Updated 2025-03-17
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
33
34
›
⌄
WITH daily_protocol_tvl AS (
SELECT
date,
protocol as protocol_name,
SUM(COALESCE(chain_tvl, 0)) as daily_tvl
FROM external.defillama.fact_protocol_tvl
WHERE protocol IN (
'HypurrFi',
'HyperYield',
'Looped Hype',
'KittenSwap',
'HyperSwap V2',
'HyperSwap V3'
)
AND date >= DATEADD(day, -30, CURRENT_DATE())
GROUP BY date, protocol
),
daily_total_tvl AS (
SELECT
date,
SUM(COALESCE(daily_tvl, 0)) AS total_daily_tvl
FROM daily_protocol_tvl
GROUP BY date
)
SELECT
d.date as day,
ROUND(d.total_daily_tvl, 2) as total_daily_tvl,
p.protocol_name,
ROUND(p.daily_tvl, 2) as daily_tvl
FROM daily_total_tvl d
JOIN daily_protocol_tvl p ON d.date = p.date
ORDER BY d.date ASC, p.daily_tvl ASC;
Last run: 15 days ago
89
5KB
2s