Eman-RazTVL Changes: 30d
Updated 2024-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with tab1 as (select tvl_usd as current_tvl
from external.defillama.fact_chain_tvl
where chain in ('zkSync Era')
order by date desc
limit 1),
tab2 as (select tvl_usd as month_tvl
from external.defillama.fact_chain_tvl
where date=current_date-29
and chain in ('zkSync Era'))
select ((current_tvl-month_tvl)/month_tvl)*100 as tvl_change
from tab1 , tab2
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived