block_timestamp,

block_id,

address,

voting_power,

row_number() OVER(PARTITION BY block_timestamp ORDER BY voting_power DESC) as rn

FROM terra.validator_voting_power

ORDER by 1 desc)

select * from validator