TOTAL_STAKERS | TOTAL_UNSTAKERS | TOTAL_STAKE_TX_IDS | TOTAL_UNSTAKE_TX_IDS | TOTAL_STAKE_USD | TOTAL_UNSTAKE_USD | |
|---|---|---|---|---|---|---|
1 | 215930 | 11605 | 11761143 | 27085 | 37656575.891803 | 30250281.1257403 |
datavortexattractive-salmon
Updated 2025-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
SELECT
COUNT(DISTINCT CASE
WHEN action_type IN ('deposit') THEN provider_address
END) AS total_stakers,
COUNT(DISTINCT CASE
WHEN action_type IN ('claim') THEN provider_address
END) AS total_unstakers,
COUNT(DISTINCT CASE
WHEN action_type IN ('deposit') THEN tx_id
END) AS total_stake_tx_ids,
COUNT(DISTINCT CASE
WHEN action_type IN ('claim') THEN tx_id
END) AS total_unstake_tx_ids,
SUM(CASE
WHEN action_type IN ('deposit') THEN deposit_amount
ELSE 0
END) AS total_stake_usd,
SUM(CASE
WHEN action_type IN ('claim') THEN claim_amount
ELSE 0
END) AS total_unstake_usd
FROM
solana.marinade.ez_liquid_staking_actions
WHERE
action_type IN ('deposit', 'claim');
Last run: 2 months ago
1
64B
3s