WEEK | TVL | |
|---|---|---|
1 | 2025-05-18 00:00:00.000 | 80120918 |
2 | 2025-05-17 00:00:00.000 | 79683302 |
3 | 2025-05-16 00:00:00.000 | 81907583 |
4 | 2025-05-15 00:00:00.000 | 80545739.5 |
5 | 2025-05-14 00:00:00.000 | 82795680 |
6 | 2025-05-13 00:00:00.000 | 80524061 |
7 | 2025-05-12 00:00:00.000 | 81617602 |
8 | 2025-05-11 00:00:00.000 | 81242335 |
9 | 2025-05-10 00:00:00.000 | 75325535 |
10 | 2025-05-09 00:00:00.000 | 69198731 |
11 | 2025-05-08 00:00:00.000 | 65954176 |
12 | 2025-05-07 00:00:00.000 | 65424938.5 |
13 | 2025-05-06 00:00:00.000 | 65781323 |
14 | 2025-05-05 00:00:00.000 | 65548748.5 |
15 | 2025-05-04 00:00:00.000 | 61973531 |
16 | 2025-05-03 00:00:00.000 | 67361333.5 |
17 | 2025-05-02 00:00:00.000 | 65398650.5 |
18 | 2025-05-01 00:00:00.000 | 63636033 |
19 | 2025-04-30 00:00:00.000 | 63694528.5 |
20 | 2025-04-29 00:00:00.000 | 60643217 |
adriaparcerisasflow defi tvl by protocol number
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with
tvl as (
select
trunc(x.date,'day') as week,
x.protocol,
avg(chain_tvl) 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
)
select week, sum(tvl) as tvl from tvl group by 1 order by 1 desc
Last run: 6 days ago
...
1036
38KB
5s