PapasotUniswapv3 LPs
Updated 2022-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- The price of UNI has been trending downwards since the start of 2022.
-- How is UNI price correlated with trading volume? Does this have an effect on the number of liquidity providers?
SELECT
date_trunc('day',creation_time) as block_day,
COUNT(creation_tx)
FROM ethereum.dex_liquidity_pools
WHERE
platform = 'uniswap-v3' AND
block_day > '2021-11-01'
GROUP BY block_day
ORDER BY block_day
Run a query to Download Data