LIQUIDITY_PROVIDER | TOT_LIQUIDITY | |
|---|---|---|
1 | 0x97184552473b3ecf9bb3e7363bb1372d26b2fa01 | |
2 | 0x50dcb3f5766527319ca2f3be8dae5fd24b72c807 | |
3 | 0xecaa8f3636270ee917c5b08d6324722c2c4951c7 | 58195842.790622 |
4 | 0xff82bf5238637b7e5e345888bab9cd99f5ebe331 | 38190307.0937784 |
5 | 0xd985c35f566c9de55df16ade36852b0c40f4bf59 | 37349884.8710237 |
6 | 0x3c21f1a9daed29d769e81e3e6148b09a336e8b87 | 30504118.4122895 |
7 | 0x9b0297ce4ebcf554a2000ebd60987298a9bc314b | 15311321.7808668 |
8 | 0x741aa7cfb2c7bf2a1e7d4da2e3df6a56ca4131f3 | 15251497.12142 |
9 | 0xb25c98cd23274178c5f6950e7f3eef8154d26bd5 | 13401560.0774454 |
10 | 0x30c35950f2a8b8b76338bcd0b4d6fe67c98d2439 | 13151310.1929972 |
11 | 0x4b296808f414ab3775889fa2863e1d73f958a58e | 10912328.3007874 |
12 | 0x1eab3b222a5b57474e0c237e7e1c4312c1066855 | 10310281.3428646 |
13 | 0xdb2c3282cb499644de2157dac72a09c6a066e8a5 | 9510861.997846 |
14 | 0x1111567e0954e74f6ba7c4732d534e75b81dc42e | 8233784.2942267 |
15 | 0x7d543ba5314f0a46de2c2d2cb52c61bc2f9f3619 | 8116644.54476263 |
16 | 0x21d3aa7e4e1a9734d65ff2c85317e078583a3d7d | 7404560.04787785 |
17 | 0x31dc6d8afd5a379ea168c21da87f376d67c4ebf5 | 7144516.20374621 |
18 | 0x66a12885f5df191e2b177e18bec643fe056d0d4d | 6901156.74289221 |
19 | 0xb1e664ab31aecf357ad04121aa3048fbb54b392a | 6477956.39102609 |
20 | 0x7267dd1d2de61f484f10082e0446d221310b66f8 | 6166806.96327671 |
KeyrockTop Provider per Pool
Updated 2024-01-26
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
›
⌄
SELECT
LIQUIDITY_PROVIDER,
SUM(LIQUIDITY) AS TOT_LIQUIDITY
FROM
(
SELECT
block_timestamp,
action,
liquidity_provider,
CASE
WHEN (ACTION = 'DECREASE_LIQUIDITY') THEN - (amount0_usd + amount1_usd)
ELSE (amount0_usd + amount1_usd)
END AS "LIQUIDITY"
FROM
ethereum.uniswapv3.ez_lp_actions
WHERE
(
ACTION = 'DECREASE_LIQUIDITY'
OR ACTION = 'INCREASE_LIQUIDITY'
)
AND POOL_ADDRESS = '{{pool_address}}'
)
GROUP BY
LIQUIDITY_PROVIDER
ORDER BY
TOT_LIQUIDITY DESC
Last run: over 1 year ago
...
12227
731KB
4s