ACTION_TAKEN | NUM_TRANSACTIONS | UNIQUE_USERS | TOTAL_SOL_AMOUNT | |
|---|---|---|---|---|
1 | withdraw_stake | 387836 | 5657 | 5121693720997390 |
2 | deposit_stake | 355220 | 52370 | 1369275801810610 |
3 | deposit | 204806 | 105155 | 3921884050144110 |
4 | withdraw | 99415 | 30489 | 3461453152886730 |
bobby_daniel5-1 Stake Actions
Updated 2025-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with stake_actions as (
SELECT
block_timestamp,
action,
address as user_address,
amount as sol_amount,
stake_pool
FROM solana.defi.fact_stake_pool_actions
WHERE block_timestamp >= CURRENT_DATE - {{lookback_days}}
AND stake_pool_name LIKE '%blazestake%'
)
-- Stake Pool Activity Summary
SELECT
action as action_taken,
COUNT(*) as num_transactions,
COUNT(DISTINCT user_address) as unique_users,
SUM(sol_amount) as total_sol_amount
FROM stake_actions
GROUP BY 1
ORDER BY 2 DESC, 1
Last run: 21 days ago
4
182B
4s