jonomeuniswap tvl
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
date_trunc('day', block_timestamp) AS _date,
SUM(VIRTUAL_RESERVES_TOKEN0_USD) as fdf,
SUM(VIRTUAL_RESERVES_TOKEN1_USD) AS TVL
FROM ethereum.uniswapv3.ez_pool_stats
WHERE block_timestamp::date between '2023-06-20' and '2023-06-23'
GROUP BY 1
ORDER BY 1
;
Run a query to Download Data