with raw as (select date_trunc('day', block_timestamp) as dt, address, max(voting_power) as vp, ROW_NUMBER() OVER (PARTITION BY dt ORDER BY vp desc) as rank
from terra.validator_voting_power
where dt >= CURRENT_DATE - 60
group by 1,2),
labels as (select address, label
from terra.labels)
select a.dt, b.label, a.vp, a.rank
from raw a
left outer join labels b on a.address = b.address
where a.rank < 11