hessPool TVL
Updated 2023-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select block_timestamp::date as date,
avg(TOKEN0_BALANCE_USD) as USDC_Balance,
avg(TOKEN1_BALANCE_USD) as WETH_Balance,
USDC_Balance+WETH_Balance as TVL
from ethereum.uniswapv3.ez_pool_stats
where TOKEN0_SYMBOL = 'USDC'
and TOKEN1_SYMBOL = 'WETH'
and pool_address = lower('0x88e6A0c2dDD26FEEb64F039a2c41296FcB3f5640')
group by 1
order by 1 desc
limit 1
Run a query to Download Data