andreafiandroSEI Pool deposit
Updated 2024-04-19
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
›
⌄
WITH wallet_transactions AS (
SELECT
platform,
block_timestamp,
liquidity_provider_address,
lp_action,
pool_address,
token1_currency,
CASE WHEN lp_action = 'add_liquidity' THEN
token1_amount * pow(10,(-1) * 6)
WHEN lp_action = 'remove_liquidity' THEN
-token1_amount * pow(10,(-1) * 6)
ELSE 0 END as token1_amount,
CASE WHEN token2_currency = 'factory/sei1e3gttzq5e5k49f9f5gzvrl0rltlav65xu6p9xc0aj7e84lantdjqp7cncc/isei' THEN 'isei'
ELSE token2_currency END as token2_currency,
CASE WHEN lp_action = 'add_liquidity' THEN
token2_amount * pow(10,(-1) * 6)
WHEN lp_action = 'remove_liquidity' THEN
-token2_amount * pow(10,(-1) * 6)
ELSE 0 END as token2_amount
FROM
sei.defi.fact_lp_actions
WHERE
liquidity_provider_address in ('sei16ze646gks4798hwrd47xhwjkpf5t5ugykmnp8f', 'sei10ktevkzhsegnnsn956qc0trat035x2awjn56vh')
and tx_succeeded = TRUE
)
SELECT
liquidity_provider_address, token1_currency, token2_currency, sum(token1_amount) as token1_balance, sum(token2_amount) as token2_balance
FROM
wallet_transactions
GROUP BY liquidity_provider_address, token1_currency, token2_currency
QueryRunArchived: QueryRun has been archived