HOURLY | STAKE_TX | UNSTAKE_TX | STAKERS | UNSTAKERS | STAKED_NFTS | UNSTAKED_NFTS | CURRENT_NET | NET | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2024-12-07 23:00:00.000 | 10 | 2 | 10 | -2 | 48 | -2 | 46 | 3018 |
2 | 2024-07-01 11:00:00.000 | 1 | 1 | 1 | -1 | 1 | -1 | 0 | 2647 |
3 | 2024-12-17 07:00:00.000 | 1 | 1 | 1 | -1 | 3 | -1 | 2 | 3049 |
4 | 2024-12-06 14:00:00.000 | 2 | 1 | 2 | -1 | 2 | -1 | 1 | 2969 |
5 | 2024-06-03 16:00:00.000 | 1 | 1 | 1 | -1 | 1 | -1 | 0 | 2466 |
6 | 2024-05-29 03:00:00.000 | 7 | 1 | 7 | -1 | 7 | -1 | 6 | 2206 |
7 | 2024-07-04 20:00:00.000 | 1 | 0 | 1 | 0 | 2 | 0 | 2 | 2652 |
8 | 2024-05-04 11:00:00.000 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1827 |
9 | 2024-10-11 17:00:00.000 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 2878 |
10 | 2024-12-08 13:00:00.000 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 3020 |
11 | 2024-06-06 13:00:00.000 | 2 | 0 | 1 | 0 | 2 | 0 | 2 | 2508 |
12 | 2024-05-07 16:00:00.000 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1918 |
13 | 2024-05-18 02:00:00.000 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 2088 |
14 | 2024-06-28 13:00:00.000 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 2637 |
15 | 2024-07-12 12:00:00.000 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 2680 |
16 | 2024-12-07 14:00:00.000 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 2970 |
17 | 2025-01-21 04:00:00.000 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 3158 |
18 | 2025-02-08 19:00:00.000 | 2 | 0 | 1 | 0 | 2 | 0 | 2 | 3179 |
19 | 2024-07-10 14:00:00.000 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 2666 |
20 | 2024-04-24 07:00:00.000 | 1 | 1 | 1 | -1 | 3 | -3 | 0 | 18 |
hessTotal New
Updated 2025-04-05
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_tx as ( select DISTINCT tx_id
from sei.core.fact_msg_attributes
where msg_type in ('wasm-staked','wasm-unstaked')
and attribute_value = 'sei1cujl8ujhc36lp7sr98x30u0aeqtjlj68kll5rqqr9dke5xvn2ltquzhysl'
and attribute_key = 'token_address'
and block_timestamp::date >= '2024-04-15'
and tx_id in (select tx_id from sei.core.fact_msg_attributes
where block_timestamp::date >= '2024-04-15'
and attribute_value = 'sei1k20knz5qc0twatcs3t0tap32klaxprnwtc0f0npj8wd8x2a55vrs269a6f'
and attribute_key = '_contract_address'))
,
owner as ( select block_timestamp,
a.tx_id,
attribute_value as owner,
msg_group
from sei.core.fact_msg_attributes a join stake_tx b on a.tx_id = b.tx_id
where msg_type in ('wasm-staked','wasm-unstaked')
and block_timestamp::date >= '2024-04-15'
and ATTRIBUTE_KEY = 'owner'
and tx_succeeded = 'TRUE')
,
token_id_staked as ( select a.block_timestamp,
a.tx_id,
owner,
a.msg_group,
attribute_value as token_id
from sei.core.fact_msg_attributes a join owner b on a.tx_id = b.tx_id and a.msg_group = b.msg_group
where msg_type = 'wasm-staked'
and a.block_timestamp::date >= '2024-04-15'
and ATTRIBUTE_KEY = 'token_id')
,
token_id_unstaked as ( select a.block_timestamp,
a.tx_id,
owner,
a.msg_group,
attribute_value as token_id
Last run: 11 days ago
...
739
34KB
145s