adambalaWhat validators have gained the most traction
Updated 2021-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with validators as ( select validator_address , min(block_timestamp) as minimum_time , max(validator_address_label) as validator_label from terra.staking
GROUP BY validator_address ORDER BY minimum_time DESC
),
new_validators as (select minimum_time , validator_address , validator_label from validators
where minimum_time >= CURRENT_DATE - 60
ORDER BY minimum_time DESC
),
amount_per_new_validators as (
select new_validators.validator_address , sum(event_amount_usd) from new_validators INNER JOIN terra.staking
on(terra.staking.validator_address= new_validators.validator_address )
GROUP BY new_validators.validator_address ORDER BY sum(event_amount_usd) DESC
)
select * from amount_per_new_validators
Run a query to Download Data