amasucciStaying Put Count
Updated 2021-08-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT count (distinct liquidity_provider)
FROM uniswapv3.lp_actions
WHERE liquidity_provider NOT IN (
SELECT DISTINCT liquidity_provider
FROM uniswapv3.positions
WHERE liquidity_provider IN
(SELECT DISTINCT liquidity_provider
FROM uniswapv3.lp_actions
WHERE action='DECREASE_LIQUIDITY'
AND date_trunc('day',block_timestamp) BETWEEN '2021-06-15' AND '2021-06-30'
AND uniswapv3.lp_actions.pool_name LIKE '%WETH%'
))
AND action='DECREASE_LIQUIDITY'
AND date_trunc('day',block_timestamp) BETWEEN '2021-06-15' AND '2021-06-30'
AND uniswapv3.lp_actions.pool_name LIKE '%WETH%'
Run a query to Download Data