99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
date_trunc('hour', block_timestamp) as hour,
pool_name,
pool_address,
TOKEN0_BALANCE_USD + TOKEN1_BALANCE_USD as TVL
FROM
ethereum.uniswapv3.ez_pool_stats
WHERE
TOKEN0_BALANCE_USD IS NOT NULL
and TOKEN1_BALANCE_USD IS NOT NULL
--and POOL_ADDRESS = '0xb4e16d0168e52d35cacd2c6185b44281ec28c9dc'
Run a query to Download Data