Ramahar113. [Easy] Top 10 Validators - Last 60 Days (voting_power)
    Updated 2021-12-13
    SELECT
    date_trunc('day', block_timestamp) as dayz,
    v.label as label,
    voting_power
    FROM terra.validator_voting_power t
    LEFT OUTER JOIN terra.validator_labels v
    ON t.address = v.vp_address
    WHERE dayz >= CURRENT_DATE - 60
    group by 1, 2, 3
    ORDER BY voting_power DESC





    Run a query to Download Data