nickpUniswapv3.2nd
Updated 2021-07-28
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
⌄
--select * from uniswapv3.lp_actions limit 10;
/*
--increase or decrease each day
select DATE(block_timestamp), count(action)
from uniswapv3.lp_actions
WHERE
action = 'DECREASE_LIQUIDITY' --INCREASE_LIQUIDITY
AND block_timestamp BETWEEN '2021-06-01 00:00:00' AND '2021-07-26 00:00:00'
AND (POOL_NAME LIKE '%WETH%' OR TOKEN0_SYMBOL LIKE '%WETH%' OR TOKEN1_SYMBOL LIKE '%WETH%')
group by DATE(block_timestamp)
order by DATE(block_timestamp);
*/
/*
--increase or decrease by unique individual each day
select DATE(block_timestamp), count(DISTINCT liquidity_provider)
from uniswapv3.lp_actions
WHERE
action = 'INCREASE_LIQUIDITY' --INCREASE_LIQUIDITY
AND block_timestamp BETWEEN '2021-06-01 00:00:00' AND '2021-07-26 00:00:00'
AND (POOL_NAME LIKE '%WETH%' OR TOKEN0_SYMBOL LIKE '%WETH%' OR TOKEN1_SYMBOL LIKE '%WETH%')
group by DATE(block_timestamp)
order by DATE(block_timestamp);
*/
/*
select DISTINCT a.liquidity_provider, a.block_timestamp, b.block_timestamp
from uniswapv3.lp_actions as a
left join uniswapv3.lp_actions as b
on a.liquidity_provider = b.liquidity_provider
AND a.block_timestamp <> b.block_timestamp
AND a.block_timestamp < b.block_timestamp
Run a query to Download Data