flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
The Road So Far, Mvmt. I: Validators - Number of validators
binhachon
The Road So Far, Mvmt. I: Validators - Number of validators
Updated 2022-03-15
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
date_trunc
(
'week'
,
block_timestamp
)
as
time
,
count
(
distinct
address
)
as
number_of_validators
from
terra
.
validator_voting_power
where
time
>
getdate
(
)
-
interval
'1 year'
group
by
time
Results
Run a query to Download Data