TX_COUNT | USER | SOL_AMOUNT | ACTION_TYPE | |
---|---|---|---|---|
1 | 2674 | 746 | 3815473.36567035 | unstake |
2 | 465 | 2 | 144615.463734286 | stake |
3 | 2522 | 752 | 4874253.64187328 | withdraw |
4 | 6266 | 2634 | 78205.655436518 | deposit |
saber-jltotal marinade
Updated 2025-05-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
count(distinct TX_ID) as tx_count,
count(distinct ADDRESS) as user,
sum(AMOUNT/1e9) as sol_amount,
CASE
WHEN action IN ('deposit') THEN 'deposit'
when action IN ('deposit_stake') THEN 'stake'
WHEN action IN ('claim') THEN 'withdraw'
when action IN ('order_unstake') THEN 'unstake'
END AS action_type
FROM solana.defi.fact_stake_pool_actions s
WHERE stake_pool_name = 'marinade'
AND s.block_timestamp >= '2025-01-01'
group by action_type
Last run: 21 days ago
4
149B
2s