zefwow new validators 60 days
    Updated 2021-12-13
    with vp as
    (
    select distinct
    max(date_trunc('day', block_timestamp)) as Dt_Day
    , address
    , max(voting_power) as Daily_Voting_Power
    from
    terra.validator_voting_power
    where
    date_trunc('day', block_timestamp)>=current_date-60
    group by
    2
    having max(date_trunc('day', block_timestamp))>=current_date-60
    ),
    new_validators as (
    select
    date_trunc('day', block_timestamp) as dt_day,
    main.address,
    max(voting_power)
    from
    terra.validator_voting_power main
    left join
    terra.validator_labels vl
    on
    main.address=vl.vp_address
    where main.address in (select distinct address from vp)
    group by
    1,2)
    select * from new_validators nv
    left join terra.validator_labels vl
    on nv.address=vl.vp_address
    order by dt_day

    Run a query to Download Data