mariyaVoting power of terra validators
    Updated 2022-04-09
    with tab1 as(
    select address, label
    from terra.labels
    where label_subtype='validator'
    and address_name='vp_address'),
    tab2 as(select voting_power, address,block_timestamp::date as date
    from terra.validator_voting_power
    )
    select tab1.label,avg(tab2.voting_power)as avg_vot_power,tab2.date
    from tab1
    left join tab2
    on tab1.address=tab2.address
    where date=current_date
    group by 1,3
    order by 2 desc
    limit 15

    Run a query to Download Data