BlockTrackerchain TVL
Updated 2025-01-06
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
›
⌄
with base_tvl as (
select
date,
tvl_usd as base_tvl_usd
from external.defillama.fact_chain_tvl
where chain = 'Base'
)
, arbitrum_tvl as (
select
date,
tvl_usd as arbitrum_tvl_usd
from external.defillama.fact_chain_tvl
where chain = 'Arbitrum'
)
select
a.date,
base_tvl_usd,
arbitrum_tvl_usd
from base_tvl a
left join arbitrum_tvl b using(date)
where a.date >= dateadd(day, -{{past_days}}, current_date())
QueryRunArchived: QueryRun has been archived