OWNER | TOTAL_STAKING_POWER | TOTAL_AMOUNT_STAKED | MAX_LOCKUP_DAYS | |
---|---|---|---|---|
1 | 2S5JDnseFzM3r5ZQ9LyGYZGuduQXQ4SkXXtvRbuD9qyC | 2106400 | 105320 | 1460 |
2 | GcXFgTPypQPqTBGTgZdZHHweZAaDJ3Suwugj52kyAcov | 1789949.53028641 | 93771.496951 | 1390 |
3 | 7RVsvF7K2R2s1jQ4T4TMFWhjtfCKxGbySenKVTKfSqKP | 1003469.6372 | 50173.48186 | 1460 |
4 | Hn2iU87MPL67Thp49dyC6G3ommDXW3kQHHrJSBH7Rv2A | 934251.906577867 | 790182.645855 | 15 |
5 | HUGoBCUqK5eFAybExfcjQTnC7At7EhysXjkzv3TQUXi2 | 768745.76 | 40000 | 1400 |
6 | Bt3VgJo5ES99DqD9vyJYq9ErrCEi7qmY7qYh3Ewx4KBA | 763453.11534 | 38172.655767 | 1460 |
7 | 4y2qgNTH6bmJYqKJnFDemicFQLUS3gb5xTET4ZJYDKQo | 678087.307316106 | 628948.795798 | 7 |
8 | 6ryG4EHMB8SpQi5SkeFqCWNpSHv3NhPaZAtd4LgC7Kdb | 677411.67698 | 33870.583849 | 1460 |
9 | GTJw31XHrxrYhnzhbW9XUPcXEs3fi9T77YvPd9nqWFPo | 629299.76824 | 31464.988412 | 1460 |
10 | HLmv58ujf9Sy4b5cKFipEufT5t8FCgnDe3BWSupw9eXs | 614592.6318 | 30729.63159 | 1460 |
11 | 3kQQqL5YFG29AxXriexHjuKepDovL45hqWFQRmA4ATV5 | 602092.82354 | 30104.641177 | 1460 |
12 | 8KgimJXmqNRXpYaocP7VFGufAmh2gFcA7he3kmFJqY6C | 600000 | 30000 | 1460 |
13 | Ec4zx6uyxWyNvRvukMWMSfPgWPw2q2HbmToLzTUXEXQK | 571940 | 28597 | 1460 |
14 | DggDVRataeiZPDuwaoRQ9MkLBYi2jixst386yJDGPxDa | 546892 | 27344.6 | 1460 |
15 | 9ceKtYkz1AMd7mdJeCsdcmooqrGmvESQ2D3yCacqStrC | 508150.03854 | 25407.501927 | 1460 |
16 | 29yGs5JJ1CPj4TF6HHiwVo5Vw2Hvk2Lq3NNZpnVcmFqR | 500030.43124 | 25001.521562 | 1460 |
17 | 9U4eV9LUpjA7u7hXuhpRRfjUG8tfWvKHZxJj7W6Hzb2k | 500008 | 25000.4 | 1460 |
18 | Gsojys5tZvsCLTWX3JfAySubeg3KpTFAiqR7Gn679ciH | 499958.855270487 | 25277.752315 | 1443 |
19 | 6j2nY5VJyswY4g3svqjEj5oZihB3j3bi3LosuEtaMkuJ | 497014.837815209 | 25704.311385 | 1409 |
20 | 2LQWVC9nP14pc9V331M3zffmZQeDoupZdv7UJYNHptvw | 490868.20234 | 24543.410117 | 1460 |
jsbmuditmagic L by amount power copy
Updated 2025-02-01
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
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH staking_p AS (
SELECT
signers[0] AS owner,
SUM(utils.udf_hex_to_int(
TO_CHAR(REVERSE(TO_BINARY(SUBSTR(utils.udf_base58_to_hex(instruction:data), 19, 16))))
) / POW(10, 6)) AS total_amount_staked, -- Total amount staked per owner
MAX(DATEDIFF(
'day',
block_timestamp,
TO_TIMESTAMP(
utils.udf_hex_to_int(
TO_CHAR(REVERSE(TO_BINARY(SUBSTR(utils.udf_base58_to_hex(instruction:data), 35, 8))))
)
)
)) AS max_lockup_days -- Maximum lockup period among stakes
FROM
solana.core.fact_events
WHERE
succeeded
AND fact_events.program_id = 'veTbq5fF2HWYpgmkwjGKTYLVpY6miWYYmakML7R7LRf'
AND SUBSTR(utils.udf_base58_to_hex(fact_events.instruction:data), 3, 16) = 'ceb0ca12c8d1b36c' -- staking
AND block_timestamp >= '2024-12-10 14:05:13.000'
GROUP BY
owner
),
staking_calculated AS (
SELECT
owner,
total_amount_staked,
max_lockup_days,
-- Compute staking power using precomputed max_lockup_days
total_amount_staked * (
1 + ((max_lockup_days - 1) / (1460 - 1)) * (20 - 1)
) AS total_staking_power
FROM staking_p
)
Last run: 2 months ago
...
1000
73KB
28s