HOURLY | New Validators | |
|---|---|---|
1 | 2024-02-26 07:00:00.000 | 1 |
2 | 2024-06-28 13:00:00.000 | 1 |
3 | 2022-10-13 13:00:00.000 | 1 |
4 | 2022-10-13 00:00:00.000 | 6 |
5 | 2023-11-09 10:00:00.000 | 2 |
6 | 2023-08-10 16:00:00.000 | 1 |
7 | 2024-08-21 09:00:00.000 | 1 |
8 | 2024-07-26 02:00:00.000 | 1 |
9 | 2024-01-17 08:00:00.000 | 1 |
10 | 2023-10-02 15:00:00.000 | 3 |
11 | 2023-12-11 20:00:00.000 | 1 |
12 | 2024-04-25 02:00:00.000 | 1 |
13 | 2022-10-13 18:00:00.000 | 1 |
14 | 2023-09-08 21:00:00.000 | 1 |
15 | 2024-12-09 06:00:00.000 | 1 |
16 | 2024-01-11 16:00:00.000 | 1 |
17 | 2023-10-02 14:00:00.000 | 1 |
18 | 2024-01-09 09:00:00.000 | 1 |
19 | 2023-10-05 01:00:00.000 | 1 |
20 | 2024-09-09 17:00:00.000 | 1 |
Movement TeamNew Validators
Updated 2025-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with validators as (select PAYLOAD:"function",
payload:"arguments"[0] as validator,*
from aptos.core.fact_transactions
where PAYLOAD:"function" = '0x1::stake::join_validator_set'
)
,
new as ( select min(block_timestamp) as day,
validator
from validators
group by 2)
select trunc(day,'hour') as hourly,
count(DISTINCT validator) as "New Validators"
from new
group by 1
Last run: 2 months ago
99
3KB
99s