(SELECT

DISTINCT address as address,

date_trunc('day',block_timestamp) as block_day,

AVG(voting_power) as avg_voting_power

FROM terra.validator_voting_power

GROUP BY 1,2

ORDER BY 3 DESC),

total as (

SELECT

date,

SUM(balance) as total_staked

FROM terra.daily_balances

WHERE

balance_type='staked'

AND

lower(currency)='luna'

GROUP BY 1

ORDER BY 1 DESC)

block_day,

address,

avg_voting_power,

total_staked,

avg_voting_power/total_staked as perc_voting

FROM by_validator

JOIN total ON by_validator.block_day=total.date

WHERE

address = 'terravalcons1ljuhg54jh4fu83g7uq9g76fms0nrzhfmrvdr8d'

-- AND

-- block_day <= '2021-06-17'

ORDER BY 1