DATE | ACTION_TYPE | DAILY_ACTION_COUNT | |
|---|---|---|---|
1 | 2025-03-02 00:00:00.000 | claim | 39 |
2 | 2025-03-02 00:00:00.000 | deposit | 51 |
3 | 2025-03-02 00:00:00.000 | depositStakeAccount | 1 |
4 | 2025-03-02 00:00:00.000 | orderUnstake | 12 |
5 | 2025-03-01 00:00:00.000 | claim | 1 |
6 | 2025-03-01 00:00:00.000 | deposit | 1955 |
7 | 2025-03-01 00:00:00.000 | depositStakeAccount | 9 |
8 | 2025-03-01 00:00:00.000 | orderUnstake | 32 |
9 | 2025-02-28 00:00:00.000 | claim | 42 |
10 | 2025-02-28 00:00:00.000 | deposit | 1384 |
11 | 2025-02-28 00:00:00.000 | depositStakeAccount | 12 |
12 | 2025-02-28 00:00:00.000 | orderUnstake | 19 |
13 | 2025-02-27 00:00:00.000 | claim | 2 |
14 | 2025-02-27 00:00:00.000 | deposit | 121 |
15 | 2025-02-27 00:00:00.000 | depositStakeAccount | 30 |
16 | 2025-02-27 00:00:00.000 | orderUnstake | 25 |
17 | 2025-02-26 00:00:00.000 | claim | 77 |
18 | 2025-02-26 00:00:00.000 | deposit | 94 |
19 | 2025-02-26 00:00:00.000 | depositStakeAccount | 121 |
20 | 2025-02-26 00:00:00.000 | orderUnstake | 29 |
gigiokobaMsol Daily action type
Updated 2025-03-02
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) as date,
action_type,
COUNT(*) as daily_action_count
FROM solana.marinade.ez_liquid_staking_actions
WHERE block_timestamp >= DATEADD('day', -30, CURRENT_DATE)
GROUP BY 1, 2
ORDER BY 1 DESC, 2;
Last run: 13 days ago
...
124
5KB
1s