TOTAL_POOLS | TOTAL_LP_TOKEN_ADDRESSES | TOTAL_ACTIONS | TOTAL_POOLS2 | ADDED_LIQUIDITY_ACTIONS | REMOVED_LIQUIDITY_ACTIONS | |
|---|---|---|---|---|---|---|
1 | 3174 | 3168 | 56100 | 73 | 37989 | 18399 |
datavortexTotals
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
COUNT(DISTINCT POOL_ADDRESS) AS total_pools,
COUNT(DISTINCT LP_TOKEN_ADDRESS) AS total_lp_token_addresses,
COUNT(DISTINCT TX_ID) AS total_actions,
COUNT(DISTINCT pool_name) AS total_pools2,
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;
Last run: 4 days ago
1
34B
4s