binhachon142. Quis Custodiet Ipsos Custodies? - Top 10
    Updated 2022-02-16
    with this_month as (
    select
    address,
    l.label,
    block_id,
    block_timestamp,
    voting_power,
    (select sum(voting_power) from terra.validator_voting_power where block_id = (select max(block_id) from terra.validator_voting_power)) as total_voting_power,
    voting_power/total_voting_power * 100 as percent_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 10
    ),
    last_month as (
    select
    address,
    l.label,
    block_id,
    block_timestamp,
    voting_power,
    (select sum(voting_power) from terra.validator_voting_power where block_id = (select max(block_id) - 389189 from terra.validator_voting_power)) as total_voting_power,
    voting_power/total_voting_power * 100 as percent_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) - 389189 from terra.validator_voting_power) -- assume 1 block = 6.66 seconds, 1 month = 30 days
    order by voting_power desc
    limit 10
    ),
    last_3_months as (
    select
    address,
    l.label,
    block_id,
    block_timestamp,
    voting_power,
    (select sum(voting_power) from terra.validator_voting_power where block_id = (select max(block_id) - 389189*3 from terra.validator_voting_power)) as total_voting_power,
    Run a query to Download Data