tkvresearchTotal value locked I L2
Updated 2024-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with
A as( select date, sum(tvl_usd) as tvl
from external.defillama.fact_chain_tvl
where chain in ('Arbitrum','Optimism','Base','Manta','Kroma','Scroll','zkSync Era','Polygon zkEVM','Linea',
'Starknet','Aurora','Mantle')
and tvl_usd > 0
and date >= '2022-12-18'
group by 1)
select *,
(tvl / (select tvl from A order by date limit 1) - 1)*100 as tvl_change
from A
where day(date) = '01'
order by date desc
QueryRunArchived: QueryRun has been archived