barbodvalidators147
Updated 2022-03-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with t1 as (SELECT
TRUNC(block_timestamp, 'day') as dt1,
address as validator,
AVG(voting_power) as voting_power
FROM terra.validator_voting_power
WHERE block_timestamp >= '2021-11-01'
and validator = 'terravalcons1thzdh52s987m7xdla2c20u90gh8psdalw92djp' --Bison Trails
GROUP BY 1,2
order by 1),
t2 as (SELECT
TRUNC(block_timestamp, 'day') as dt2,
AVG(voting_power) as v_p
FROM terra.validator_voting_power
WHERE block_timestamp >= '2021-11-01'
GROUP BY 1
order by 1)
select t1.dt1 as day,
voting_power as Bison_Trails,
v_p as average_validators
from t1
inner join t2 on t1.dt1=t2.dt2
Run a query to Download Data