hessWeekly TVL Per Chain
Updated 2023-08-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with avax_price as ( select hour::date as date,
avg(price) as avg_price
from avalanche.core.fact_hourly_token_prices
where hour::date >= '2022-01-01'
group by 1)
select trunc(date,'week') as weekly, chain, avg(tvl_usd) as tvl
from external.defillama.fact_chain_tvl
where chain in ('Avalanche','Polygon','Optimism','Arbitrum','Fantom','BSC')
and date >= '2022-01-01'
group by 1,2
Run a query to Download Data