DATE | SECTOR | CATEGORY | TVL_RANK | TVL | |
|---|---|---|---|---|---|
1 | 2024-05-01 00:00:00.000 | Defi | Lending | 1 | 251173105 |
2 | 2024-05-01 00:00:00.000 | Defi | Leveraged Farming | 2 | 119346359.5 |
3 | 2024-05-01 00:00:00.000 | Defi | Yield Aggregator | 3 | 92425806 |
4 | 2024-05-01 00:00:00.000 | Defi | CDP | 4 | 71942856 |
5 | 2024-05-01 00:00:00.000 | Defi | Derivatives | 5 | 48920758.5 |
6 | 2024-05-01 00:00:00.000 | Defi | Yield | 6 | 15230957.5 |
7 | 2024-05-01 00:00:00.000 | Defi | Liquid Restaking | 7 | 5157945.5 |
8 | 2024-05-01 00:00:00.000 | Defi | Options | 8 | 833437 |
9 | 2024-05-01 00:00:00.000 | Defi | Farm | 9 | 5016 |
10 | 2024-05-01 00:00:00.000 | Defi | Options Vault | 10 | 365.5 |
11 | 2024-06-01 00:00:00.000 | Defi | Lending | 1 | 253837476.19855 |
12 | 2024-06-01 00:00:00.000 | Defi | Leveraged Farming | 2 | 114901772.666667 |
13 | 2024-06-01 00:00:00.000 | Defi | Yield Aggregator | 3 | 93756206.319298 |
14 | 2024-06-01 00:00:00.000 | Defi | CDP | 4 | 72091500.1 |
15 | 2024-06-01 00:00:00.000 | Defi | Derivatives | 5 | 53634559.016667 |
16 | 2024-06-01 00:00:00.000 | Defi | Yield | 6 | 15367835.7 |
17 | 2024-06-01 00:00:00.000 | Defi | Liquid Restaking | 7 | 5139678.333333 |
18 | 2024-06-01 00:00:00.000 | Defi | Options | 8 | 2599368.433333 |
19 | 2024-06-01 00:00:00.000 | Defi | Farm | 9 | 4984.366667 |
20 | 2024-06-01 00:00:00.000 | Defi | Options Vault | 10 | 365.133333 |
cybergenlab[DeFi Overview] DeFi TVL Historical
Updated 2025-05-16
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
›
⌄
with defi as (
select
date_trunc('month', date) as date,
'Defi' as sector,
protocol,
category,
avg(chain_tvl) as tvl
from external.defillama.fact_protocol_tvl
where chain = 'Base'
and category in ('Farm', 'Liquid Restaking', 'Options Vault', 'Staking Pool', 'Yield', 'Yield Aggregator', 'Leveraged Farming', 'RWA Lending',
'Options', 'CDP', 'Synthetics', 'Lending', 'Liquid Staking', 'Basis Trading', 'Derivatives', 'Uncollateralized Lending', 'Restaking')
and date >= dateadd(year, -1, date_trunc('month',current_date()))
and date < date_trunc('month',current_date())
and chain_tvl >0
group by 1, 2, 3, 4
order by 1 desc
)
, defi_tvl as (
select
date,
sector,
category,
rank() over (partition by date order by sum(tvl) desc) as tvl_rank,
sum(tvl) as tvl
from defi
group by 1,2,3
)
select * from defi_tvl
order by date, tvl desc
Last run: 3 months ago
...
127
8KB
2s