BlockTrackerchain TVL [Dominance]
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
›
⌄
with base_tvl as (
select
'Base' as chain,
date,
tvl_usd as tvl_usd
from external.defillama.fact_chain_tvl
where date >= dateadd(day, -{{past_days}}, current_date())
and chain = 'Base'
)
, avalanche_tvl as (
select
'Avalanche' as chain,
date,
tvl_usd as tvl_usd
from external.defillama.fact_chain_tvl
where date >= dateadd(day, -{{past_days}}, current_date())
and chain = 'Avalanche'
)
select
*
from base_tvl
union all
select *
from avalanche_tvl
QueryRunArchived: QueryRun has been archived