PLATFORM | TOTAL_POOLS | TOTAL_LP_TOKEN_ADDRESSES | TOTAL_ACTIONS | ADDED_LIQUIDITY_ACTIONS | REMOVED_LIQUIDITY_ACTIONS | |
---|---|---|---|---|---|---|
1 | seaswap | 61 | 61 | 3229 | 2590 | 639 |
2 | fuzio | 6 | 6 | 1424 | 1058 | 366 |
3 | astroport | 1 | 3101 | 40766 | 27545 | 13509 |
4 | levana | 5 | 0 | 10681 | 6796 | 3885 |
datavortexLp actions per dex
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
PLATFORM,
COUNT(DISTINCT pool_name) AS total_pools,
COUNT(DISTINCT LP_TOKEN_ADDRESS) AS total_lp_token_addresses,
COUNT(DISTINCT TX_ID) AS total_actions,
COUNT(
DISTINCT CASE
WHEN LP_ACTION = 'add_liquidity' THEN TX_ID
END
) AS added_liquidity_actions,
COUNT(
DISTINCT CASE
WHEN LP_ACTION = 'remove_liquidity' THEN TX_ID
END
) AS removed_liquidity_actions
FROM
sei.defi.fact_lp_actions
GROUP BY
PLATFORM;
Last run: 5 days ago
4
131B
3s