STAKE_TYPE | ROW_NUM | SHARE | CURRENT_VALUE | CHANGE_24H | CHANGE_24H_PCT | CHANGE_7D | CHANGE_7D_PCT | CHANGE_30D | CHANGE_30D_PCT | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | Total Stake | 1 | 100 | 384639440 | 770907 | 0.2 | 2623976 | 0.69 | 198184 | 0.05 |
2 | 2 | |||||||||
3 | Native Stake | 3 | 88.61 | 340818922 | 654487 | 0.19 | 1777591 | 0.52 | -2451036 | -0.71 |
4 | LST Supply | 4 | 11.39 | 43820518 | 116420 | 0.2663821726 | 846385 | 1.96952106 | 2649220 | 6.434628307 |
0xallyzachnative stake vs lst
Updated 2025-03-24
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
›
⌄
WITH total_stake AS (
-- Compute total stake per epoch (this is the combined value)
SELECT
epoch,
ROUND(SUM(active_stake) * POW(10,-9), 0) AS total_stake
FROM solana.gov.fact_validators
WHERE active_stake > 0
GROUP BY 1
),
latest_epoch AS (
-- Get the most recent epoch
SELECT MAX(epoch) AS latest_epoch FROM total_stake
),
historical_epochs AS (
-- Determine the epochs closest to 1d, 7d, and 30d ago (assuming ~1 epoch = 2 days)
SELECT
le.latest_epoch AS current_epoch,
le.latest_epoch - 1 AS epoch_1d_ago, -- 1 epoch ~ 2 days
le.latest_epoch - 4 AS epoch_7d_ago, -- 7 days ≈ 4 epochs
le.latest_epoch - 15 AS epoch_30d_ago -- 30 days ≈ 15 epochs
FROM latest_epoch le
),
staked_changes AS (
-- Get stake amounts for the latest and historical epochs
SELECT
ns.epoch,
ns.total_stake,
he.current_epoch,
he.epoch_1d_ago,
he.epoch_7d_ago,
he.epoch_30d_ago
FROM total_stake ns
JOIN historical_epochs he
Last run: about 1 month ago
4
290B
2s