(select address, max(voting_power) as Voting_power,date_trunc('day', block_timestamp) as days

from terra.validator_voting_power

where days = CURRENT_DATE and address != 'terravalcons1yaqex3zuksjkneug595zl5jv62t07r5cjyswpg'

group by 1,3

order by voting_power desc

limit 9),

label as

(select delegator_address, label, operator_address, vp_address

terra.validator_labels),

balance as

(select date, address_label, address, balance

from terra.daily_balances

where balance_type = 'staked')

select A.address, A.voting_power, A.days, B.label, C.date, C.balance, (C.balance/A.voting_power)*100 as Percentage

from vp A

join label B on A.address = B.vp_address

join balance C on C.address = B.delegator_address and C.date = A.days