SNAPSHOT_DATE | Total Amount Being Unstaked | Total Unique Signers from newEscrow | |
|---|---|---|---|
1 | 2025-04-21 00:00:00.000 | 82081330.423566 | 693040 |
2 | 2025-04-20 00:00:00.000 | 81604951.365641 | 692959 |
3 | 2025-04-19 00:00:00.000 | 81153650.865961 | 692835 |
4 | 2025-04-18 00:00:00.000 | 80816685.263926 | 692524 |
5 | 2025-04-17 00:00:00.000 | 80707549.835777 | 692420 |
6 | 2025-04-16 00:00:00.000 | 81304954.237003 | 692305 |
7 | 2025-04-15 00:00:00.000 | 81795742.319206 | 692157 |
8 | 2025-04-14 00:00:00.000 | 85443472.321728 | 692081 |
9 | 2025-04-13 00:00:00.000 | 85429239.569116 | 691942 |
10 | 2025-04-12 00:00:00.000 | 84822436.781424 | 691838 |
11 | 2025-04-11 00:00:00.000 | 83769469.043754 | 691687 |
12 | 2025-04-10 00:00:00.000 | 83487448.693293 | 691462 |
13 | 2025-04-09 00:00:00.000 | 82926294.679169 | 691235 |
14 | 2025-04-08 00:00:00.000 | 81691120.876251 | 691076 |
15 | 2025-04-07 00:00:00.000 | 82562229.579697 | 690095 |
16 | 2025-04-06 00:00:00.000 | 82755429.293547 | 689628 |
17 | 2025-04-05 00:00:00.000 | 83876906.750863 | 689530 |
18 | 2025-04-04 00:00:00.000 | 87733823.097749 | 689439 |
19 | 2025-04-03 00:00:00.000 | 86610354.540779 | 689353 |
20 | 2025-04-02 00:00:00.000 | 81326901.535662 | 689217 |
CyberaResearchJUP Staking - v2 sw total v4
Updated 1 day ago
999
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
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Enable recursive CTEs
WITH RECURSIVE
-- 1. Filter relevant transactions for all signers in the staking program
filtered_signers AS (
SELECT DISTINCT
di.block_timestamp,
di.block_id,
di.tx_id,
LOWER(di.signers[0]::STRING) AS signer, -- Use the first signer as the user's wallet
di.program_id,
di.event_type,
di.decoded_instruction
FROM
solana.core.fact_decoded_instructions di
WHERE
di.program_id = 'voTpe3tHQ7AjQHMapgSue2HJFAh2cGsdokqN3XqmVSj'
AND di.event_type IN (
'mergePartialUnstaking',
'openPartialUnstaking',
'increaseLockedAmount',
'toggleMaxLock',
'newEscrow',
'withdraw',
'withdrawPartialUnstaking'
)
),
-- 2. Extract and sum withdrawal amounts per transaction and signer
withdrawals AS (
SELECT
fe.tx_id,
LOWER(fe.signers[0]::STRING) AS signer,
SUM(
CASE
WHEN ed.event_type IN ('withdraw', 'withdrawPartialUnstaking') THEN
Last run: about 15 hours ago
...
423
21KB
63s