LIQUIDITY_PROVIDER | Net add/remove Liq | |
|---|---|---|
1 | BXoCWWijZiVQFXNRqcZAiHQroYkaUnjkRznnZrt9gj42 | -28658123.4247412 |
2 | 8NScYncjpY1mKrbxVJFFdVqNPEocyXTnQqy9GW1hg4j3 | -25954235.9054965 |
3 | jwudCiJ5QUUmfxPXN41jaqYKnSc3UmKo5RoRGkZzomN | -13483595.9188231 |
4 | 5fnahDWBtUB8QBTXWHm2QzfAoAVHToxvMf38i3a7okGe | -8540885.82465347 |
5 | EFrg9SXbnCfuVqJPJf2hKKY3CtTPLHvipEpgrHjBkb4L | -7078661.58156988 |
6 | 5Wsjee6FgZQtxjUBedfNq9ZbV6RN7wgb4N422LyV3ZEr | -1829257.29846584 |
ArioLIBRA Remove Liq
Updated 2025-02-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
33
34
35
36
›
⌄
with removing_liq as (
select
*
from solana.defi.fact_liquidity_pool_actions
where mint = 'Bo9jh3wsmcC2AjakLWzNmKJ3SgtZmXEcSaW7L2FAvUsU'
and block_timestamp >= '2025-02-13'
-- and block_timestamp >= '2025-01-23'
and action in (
'removeBalanceLiquidity',
'removeLiquidityByRange'
)
and LIQUIDITY_PROVIDER in (
'42rex5yRsP1mdAKHzB5avDzagT6mqB5uYPergUFZ2Tgn',
'DtkvLXkfJ7gT3UKrYcLHb6MoXJSXvyVr4qy8ZLtzyvBE',
'61yKS9bjxWdqNgAHt439DfoNfwK3uKPAJGWAsFkC5M4C',
'2zuVoUKekiz5J43448TFtXFW4bKgwBsZUwBX6ouUq612',
'8DgzQsLHdh2gGqjqyi8pAPshhkXcRjL9J2Prvqw7GUbq',
'5Wsjee6FgZQtxjUBedfNq9ZbV6RN7wgb4N422LyV3ZEr',
'5fnahDWBtUB8QBTXWHm2QzfAoAVHToxvMf38i3a7okGe',
'8NScYncjpY1mKrbxVJFFdVqNPEocyXTnQqy9GW1hg4j3',
'EFrg9SXbnCfuVqJPJf2hKKY3CtTPLHvipEpgrHjBkb4L',
'BXoCWWijZiVQFXNRqcZAiHQroYkaUnjkRznnZrt9gj42',
'jwudCiJ5QUUmfxPXN41jaqYKnSc3UmKo5RoRGkZzomN',
'FTjLYkNARZHnqekpKj5mHzbJx7EqW1fSr15Ec4oijBUQ',
'B9KTwxhc9e6qrjw5nfmhgcN38oKFTBtnef8AwaTPVQ6q',
'DefcyKc4yAjRsCLZjdxWuSUzVohXtLna9g22y3pBCm2z',
'FdWhTThthSN7mbcmBgh18dzogi1dXqQqBb6BnnzZEJJn',
'FKeS1FTXGbq5P3Ze8nkLd5nqgZF4Z426CjXLiztSEsi'
)
and SUCCEEDED
order by block_timestamp asc
)
select
LIQUIDITY_PROVIDER,
sum(case when action ilike '%remove%' then - amount * price else amount * price end) as "Net add/remove Liq"
from solana.defi.fact_liquidity_pool_actions a join solana.price.ez_prices_hourly b on date_trunc(hour, block_timestamp) = b.hour
Last run: about 1 month ago
6
402B
1s