theericstoneInverted ETH/DAI Positions
Updated 2021-11-11
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
›
⌄
with pools as (
select * from uniswapv3.pools
where pool_address = '0xc2e9f25be6257c210d7adf0d4cd6e3e881ba25f8'
)
select * from (
select
distinct
liquidity_provider,
nf_token_id,
pool_address,
pool_name,
last_value(tx_id) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as tx_id,
last_value(liquidity_adjusted) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as liquidity_adj,
last_value(tick_upper) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as tick_upper,
last_value(tick_lower) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as tick_lower,
last_value(price_lower_0_1_usd) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_lower_0_1_usd,
last_value(price_upper_0_1_usd) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_upper_0_1_usd,
last_value(price_lower_1_0_usd) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_lower_1_0_usd,
last_value(price_upper_1_0_usd) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_upper_1_0_usd,
last_value(price_lower_0_1) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_lower_0_1,
last_value(price_upper_0_1) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_upper_0_1,
last_value(price_lower_1_0) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_lower_1_0,
last_value(price_upper_1_0) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_upper_1_0
from uniswapv3.positions pos
where pos.pool_address in (select pool_address from pools)
and pos.tick_lower > 0
and pos.block_timestamp > '2021-05-05 01:00:00'
)
where liquidity_adj > 0
order by liquidity_adj desc;
Run a query to Download Data