datavortexpersistent-purple
Updated 2025-02-03
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
›
⌄
⌄
--SELECT DISTINCT event_name FROM kaia.core.ez_decoded_event_logs
--where event_name ilike '%stake%'
SELECT
SUM((DECODED_LOG:value::int) / 1e18) AS "staked_amount",
COUNT(DISTINCT tx_hash) AS "Total Stakes",
COUNT(DISTINCT origin_from_address) AS "stakers"
from
kaia.core.ez_decoded_event_logs
WHERE
event_name = 'lockedUnStakeAll'
--AND block_timestamp >= '2024-08-29'
/*
UnlockAllStakes
2
RefreshStake
3
lockedStake
4
StakeKlay
5
Unstaked
6
normalStake
7
Staked
8
Stake
9
StakeLocked
10
lockedUnStakeAll
*/
QueryRunArchived: QueryRun has been archived