with top5_validators as (

select

address,

l.operator_address,

l.delegator_address,

l.label,

block_id,

block_timestamp,

voting_power

from terra.validator_voting_power v left join terra.validator_labels l on (v.address = l.vp_address)

where block_id = (select max(block_id) from terra.validator_voting_power)

order by voting_power desc

limit 5

),

luna_balances as (

select

date_trunc('month', date) as date,

address_label,

currency,

balance_type,

avg(balance) as staked_balance

from terra.daily_balances

where address in (select delegator_address from top5_validators)

and date > '2020-10-01'

and currency = 'LUNA'

and balance_type = 'staked'

group by 1,2,3,4

),

daily_voting_power as (

select

date_trunc('month', block_timestamp) as date,

address,

l.label,