angealCurrent Positions
Updated 2021-05-25Copy Reference Fork
99
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
›
⌄
WITH positions AS (
SELECT * FROM uniswapv3.positions
),
max_blocks AS (
SELECT
max(block_id) AS block_id,
pool_address,
liquidity_provider,
nf_token_id
FROM positions
GROUP BY
pool_address,
liquidity_provider,
nf_token_id
)
SELECT
blockchain,
p.block_id,
block_timestamp,
tx_id,
fee_percent,
liquidity_adjusted,
p.liquidity_provider,
nf_position_manager_address,
p.nf_token_id,
p.pool_address,
p.pool_name,
p.tick_lower,
p.tick_upper,
p.price_lower_0_1,
Run a query to Download Data