Nige7777Top 10 Uniswap V3 Liquidity Providers
Updated 2021-07-10
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
›
⌄
-- with cte_1 as (
-- select distinct
-- last_value(ifnull(amount1_USD,0) + ifnull(amount0_usd,0) ) OVER (partition by liquidity_provider , pool_name, nf_token_id order by block_id) AS Current_Total_USD_Value_Of_LP
-- ,nf_token_id
-- ,pool_name
-- ,pool_address
-- ,liquidity_provider
-- from uniswapv3.lp_actions
-- --where liquidity_provider ='0xb82f45b3553f81acfe2b2dfc50ed2c7a37fa70ce'
-- )
WITH max_pos_blocks AS (
SELECT
max(block_id) AS block_id,
pool_address,
liquidity_provider,
nf_token_id
FROM
uniswapv3.positions
GROUP BY
pool_address,
liquidity_provider,
nf_token_id
),
max_stats_blocks AS (
SELECT
max(block_id) AS block_id,
pool_address
FROM j
uniswapv3.pool_stats
Run a query to Download Data