PLATFORM | WEEK_START_DATE | ADDED_LIQUIDITY_ACTIONS | REMOVED_LIQUIDITY_ACTIONS | |
|---|---|---|---|---|
1 | astroport | 2025-05-12 00:00:00.000 | 0 | 11 |
2 | levana | 2025-05-12 00:00:00.000 | 0 | 10 |
3 | astroport | 2025-05-05 00:00:00.000 | 0 | 3 |
4 | levana | 2025-05-05 00:00:00.000 | 0 | 1 |
5 | astroport | 2025-04-28 00:00:00.000 | 0 | 13 |
6 | astroport | 2025-04-21 00:00:00.000 | 0 | 11 |
7 | astroport | 2025-04-14 00:00:00.000 | 1 | 19 |
8 | levana | 2025-04-14 00:00:00.000 | 0 | 2 |
9 | astroport | 2025-04-07 00:00:00.000 | 3 | 3 |
10 | astroport | 2025-03-31 00:00:00.000 | 2 | 5 |
11 | astroport | 2025-03-24 00:00:00.000 | 1 | 2 |
12 | levana | 2025-03-24 00:00:00.000 | 0 | 1 |
13 | astroport | 2025-03-17 00:00:00.000 | 6 | 3 |
14 | astroport | 2025-03-10 00:00:00.000 | 2 | 10 |
15 | levana | 2025-03-10 00:00:00.000 | 0 | 23 |
16 | astroport | 2025-03-03 00:00:00.000 | 6 | 8 |
17 | levana | 2025-03-03 00:00:00.000 | 0 | 2 |
18 | astroport | 2025-02-24 00:00:00.000 | 5 | 4 |
19 | astroport | 2025-02-17 00:00:00.000 | 5 | 5 |
20 | astroport | 2025-02-10 00:00:00.000 | 8 | 9 |
datavortexWeekly added and removed lp
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
PLATFORM,
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week_start_date,
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,
week_start_date
ORDER BY
week_start_date DESC,
PLATFORM;
Last run: 3 days ago
...
228
10KB
3s