HOUR | HOURLY_STAKED | HOURLY_UNSTAKED | HOURLY_RESTAKED | NET_STAKE | TOTAL_CLOUD_STAKED | |
|---|---|---|---|---|---|---|
1 | 2025-03-06 10:00:00.000 | 19896.537133535 | 0 | 0 | 19896.537133535 | 39991840.4323133 |
2 | 2025-03-06 09:00:00.000 | 12464.168840609 | 0 | 0 | 12464.168840609 | 39971943.8951798 |
3 | 2025-03-06 08:00:00.000 | 1897.124730295 | 0 | 0 | 1897.124730295 | 39959479.7263392 |
4 | 2025-03-06 07:00:00.000 | 17269.883092115 | 0 | 0 | 17269.883092115 | 39957582.6016089 |
5 | 2025-03-06 06:00:00.000 | 309755.331114195 | 0 | 0 | 309755.331114195 | 39940312.7185168 |
6 | 2025-03-06 05:00:00.000 | 33982.53760677 | 0 | 0 | 33982.53760677 | 39630557.3874026 |
7 | 2025-03-06 04:00:00.000 | 228.785506215 | 0 | 0 | 228.785506215 | 39596574.8497958 |
8 | 2025-03-06 03:00:00.000 | 7108.645808669 | 0 | 0 | 7108.645808669 | 39596346.0642896 |
9 | 2025-03-06 02:00:00.000 | 23406.266494309 | -14818.640046297 | 14818.640046297 | 23406.266494309 | 39589237.4184809 |
10 | 2025-03-06 01:00:00.000 | 521084.097588685 | 0 | 0 | 521084.097588685 | 39565831.1519866 |
11 | 2025-03-06 00:00:00.000 | 715.881693415 | -3043.162977843 | 1851.150462963 | -476.130821465 | 39044747.0543979 |
12 | 2025-03-05 23:00:00.000 | 638190.196032742 | 0 | 0 | 638190.196032742 | 39045223.1852194 |
13 | 2025-03-05 22:00:00.000 | 26732.924756476 | 0 | 0 | 26732.924756476 | 38407032.9891866 |
14 | 2025-03-05 21:00:00.000 | 11074.661345798 | 0 | 0 | 11074.661345798 | 38380300.0644302 |
15 | 2025-03-05 20:00:00.000 | 902.471271381 | 0 | 0 | 902.471271381 | 38369225.4030844 |
16 | 2025-03-05 19:00:00.000 | 26070.592895994 | 0 | 0 | 26070.592895994 | 38368322.931813 |
17 | 2025-03-05 18:00:00.000 | 11864.676430405 | -3400.517995366 | 0 | 8464.158435039 | 38342252.338917 |
18 | 2025-03-05 17:00:00.000 | 1095.451620381 | -15000 | 0 | -13904.548379619 | 38333788.180482 |
19 | 2025-03-05 16:00:00.000 | 9818.140093012 | 0 | 0 | 9818.140093012 | 38347692.7288616 |
20 | 2025-03-05 15:00:00.000 | 13002.667099269 | 0 | 0 | 13002.667099269 | 38337874.5887686 |
dannyamahHourly Cloud Staking
Updated 2025-03-06
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 stake AS (
SELECT
date_trunc('hour', t.block_timestamp) as hour,
'stake' as type,
amount as stake_amount
FROM solana.core.fact_transfers t
join solana.core.fact_events e
On t.tx_id = e.tx_id
WHERE 1 = 1
AND program_id = 'bon4Kh3x1uQK16w9b9DKgz3Aw4AP1pZxBJk55Q6Sosb'
AND mint = 'CLoUDKc4Ane7HeQcPpE3YHnznRxhMimJ4MyaUqyHFzAu'
-- AND t.tx_id = '2rz4azpEkTzkcmuN2j3eyut32yWd2cWSgm2bKhf9uUBYdcKurxDFB4J5jgKmoN1WgoMBiNaZVDFevh25RK26VA5A'
AND succeeded
AND t.block_timestamp >= '2025-02-20'
),
unstake AS (
SELECT
date_trunc('hour', t.block_timestamp) as hour,
'unstake' as type,
- amount as unstake_amount
FROM solana.core.fact_transfers t
join solana.core.fact_events e
On t.tx_id = e.tx_id
WHERE 1 = 1
AND program_id = 'bon4Kh3x1uQK16w9b9DKgz3Aw4AP1pZxBJk55Q6Sosb'
AND mint = 'sc1dNAxRBj5CNWaGC26AR7PEW75R36Umzt1V8vuP8kZ'
-- AND t.tx_id = '4NJzcukr2kbVy8LT17cNJmCz5MXCSA8p69cCSCtsbFpCbDQkaLg3rQtT11mT7DJn99qj6JpktrBJPhGHZjL1bMix'
AND succeeded
AND t.block_timestamp >= '2025-02-20'
),
-- Unstaking takes 30 days. sCLOUD gradually converts to CLOUD over this period.
-- You can cancel the unstaking anytime to instantly claim your available CLOUD and remaining sCLOUD.
cancel_unstake AS (
select
Last run: 3 months ago
...
292
23KB
52s