CHAIN | TVL | |
|---|---|---|
1 | Core | 77834895 |
2 | Rootstock | 3418888 |
3 | Bitlayer | 37290 |
4 | Bsquared | 25200 |
tkvresearchempty-aquamarine
Updated 2025-02-10
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
35
36
›
⌄
select chain,
sum(tvl_usd) as tvl
from
(select *
from external.defillama.fact_pool_yields
where chain = 'Core'
and
date = current_date() - 1
and
symbol like '%BTC%'
and
symbol not like '%-%'
union all
select *
from external.defillama.fact_pool_yields
where chain = 'Bitlayer'
and
date = current_date() - 1
and
symbol like '%BTC%'
and
symbol not like '%-%'
union all
select *
from external.defillama.fact_pool_yields
where chain = 'Rootstock'
and
date = current_date() - 1
and
symbol like '%BTC%'
and
symbol not like '%-%'
union all
select *
from external.defillama.fact_pool_yields
where chain = 'Bsquared'
Last run: 3 months ago
4
79B
1s