LTirrellterra_staking
Updated 2022-01-18
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
›
⌄
-- select
-- trunc(block_timestamp, 'day') as date,
-- avg(price_usd) as price_usd,
-- currency
-- from
-- terra.oracle_prices
-- where
-- block_timestamp >= '2021-06-30'
-- and currency like 'u%'
-- group by
-- date,
-- currency
select
trunc(block_timestamp, 'day') as date,
address,
avg(voting_power) as voting_power
from
terra.validator_voting_power
where
block_timestamp >= '2021-06-30'
group by
date, address
Run a query to Download Data