MONTH | NET_MSOL_FLOW | |
|---|---|---|
1 | 2021-08-01 00:00:00.000 | 669611.189125206 |
2 | 2021-09-01 00:00:00.000 | 1764538.61049038 |
3 | 2021-10-01 00:00:00.000 | 4617332.69362901 |
4 | 2021-11-01 00:00:00.000 | -471511.216227887 |
5 | 2021-12-01 00:00:00.000 | 582286.669737524 |
6 | 2022-01-01 00:00:00.000 | -772543.894084241 |
7 | 2022-02-01 00:00:00.000 | 72006.705671277 |
8 | 2022-03-01 00:00:00.000 | -152010.571463251 |
9 | 2022-04-01 00:00:00.000 | 50689.412496003 |
10 | 2022-05-01 00:00:00.000 | -417063.520525015 |
11 | 2022-06-01 00:00:00.000 | 660162.08930423 |
12 | 2022-07-01 00:00:00.000 | 425433.308393868 |
13 | 2022-08-01 00:00:00.000 | -319042.556533137 |
14 | 2022-09-01 00:00:00.000 | 229104.066479185 |
15 | 2022-10-01 00:00:00.000 | 77106.739163463 |
16 | 2022-11-01 00:00:00.000 | -2531628.85142573 |
17 | 2022-12-01 00:00:00.000 | -125067.306918171 |
18 | 2023-01-01 00:00:00.000 | -156384.263215318 |
19 | 2023-02-01 00:00:00.000 | 63719.572155439 |
20 | 2023-03-01 00:00:00.000 | -45693.703699185 |
feyikeminet flow
Updated 2025-04-21
9
1
2
3
4
5
6
7
›
⌄
SELECT
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,
SUM(CASE WHEN action_type in ('deposit', 'depositStakeAccount') THEN MSOL_MINTED ELSE 0 END) -
SUM(CASE WHEN action_type = 'orderUnstake' THEN MSOL_BURNED ELSE 0 END) AS net_msol_flow
FROM solana.marinade.ez_liquid_staking_actions
GROUP BY 1
ORDER BY 1
Last run: about 1 month ago
45
2KB
2s