Nige7777positions
Updated 2021-05-20
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
›
⌄
-- select *
-- from uniswapv3.positions where
-- liquidity_provider = '0xf7a8f04c7fe7c8a6ed692bdf5ee1658559cbe7dc'
-- and token0_symbol = 'USDC' and token1_symbol = 'USDT'
-- order by block_timestamp
-- limit 100
-- --select * from uniswapv3.lp_actions where liquidity_provider = '0xf7a8f04c7fe7c8a6ed692bdf5ee1658559cbe7dc'
-- --and pool_name like 'USDC_USDT%'
with cte_1 as (
select
sum (case when liquidity_adjusted) over (partition by liquidity_provider order by block_id rows unbounded preceding) liquid
,liquidity_provider
,block_id
from uniswapv3.lp_actions
)
select
max(liquid)
,liquidity_provider
from cte_1 c1
group by liquidity_provider
order by max(liquid) desc
limit 10
-- cross apply (
-- select top 1 block_id , liquidity_provider
-- order by block_id desc) d
-- where c1.block_id = d.block_id and c1.liquidity_provider = d.liquidity_provider
Run a query to Download Data