boomer77Large address
Updated 2021-07-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT * FROM
(
select
voter, voting_power, date_trunc('day', block_timestamp) as days,
row_number() over (partition by voter ORDER by voting_power desc) as rank
FROM
terra.gov_vote
where days >= CURRENT_DATE - 30 AND
voting_power >= 5000
)RNK
where rank = 1
order by voting_power DESC
Run a query to Download Data