WEEK | PROTOCOL | TVL | |
|---|---|---|---|
1 | 2025-06-08 00:00:00.000 | Ankr | 12359228 |
2 | 2025-06-08 00:00:00.000 | Fixes Launchpad | 1096 |
3 | 2025-06-08 00:00:00.000 | Fixes frc20 | 24160 |
4 | 2025-06-08 00:00:00.000 | Fixes frc20 Staking | 23642 |
5 | 2025-06-08 00:00:00.000 | Increment Lending | 1290644 |
6 | 2025-06-08 00:00:00.000 | Increment Liquid Staking | 2987893 |
7 | 2025-06-08 00:00:00.000 | Increment Swap | 12615415 |
8 | 2025-06-08 00:00:00.000 | KittyPunch PunchSwap | 9740611 |
9 | 2025-06-08 00:00:00.000 | KittyPunch PunchSwap V3 | 7320356 |
10 | 2025-06-08 00:00:00.000 | KittyPunch StableKitty | 22205019 |
11 | 2025-06-08 00:00:00.000 | MORE Markets | 30067931 |
12 | 2025-06-08 00:00:00.000 | Sturdy V2 | 1068288.5 |
13 | 2025-06-08 00:00:00.000 | Trado Perpetual | 304343 |
14 | 2025-06-08 00:00:00.000 | Trado Spot | 733133 |
15 | 2025-06-07 00:00:00.000 | Ankr | 12345457 |
16 | 2025-06-07 00:00:00.000 | Fixes Launchpad | 1086 |
17 | 2025-06-07 00:00:00.000 | Fixes frc20 | 23916 |
18 | 2025-06-07 00:00:00.000 | Fixes frc20 Staking | 23408 |
19 | 2025-06-07 00:00:00.000 | Increment Lending | 1301445.5 |
20 | 2025-06-07 00:00:00.000 | Increment Liquid Staking | 3114597 |
adriaparcerisasflow defi tvl by protocol all
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
trunc(x.date,'day') as week,
x.protocol,
case when x.protocol ilike '%more markets%' then avg(chain_tvl)+15000000 else avg(chain_tvl) end as tvl
--sum(volume) as dex_volume,
--sum(dex_volume) over (order by week) as total_dex_volume
from external.defillama.fact_protocol_tvl x
--join external.defillama.fact_dex_volume y on lower(x.chain)=y.chain and x.date=y.date
where x.chain ilike '%Flow%' and week<trunc(current_date,'day')
group by 1,2 order by 1 desc,2
Last run: 3 days ago
...
5831
311KB
3s