barbodvalidators147
    Updated 2022-03-17
    with t1 as (SELECT
    TRUNC(block_timestamp, 'day') as dt1,
    address as validator,
    AVG(voting_power) as voting_power
    FROM terra.validator_voting_power
    WHERE block_timestamp >= '2021-11-01'
    and validator = 'terravalcons1thzdh52s987m7xdla2c20u90gh8psdalw92djp' --Bison Trails
    GROUP BY 1,2
    order by 1),

    t2 as (SELECT
    TRUNC(block_timestamp, 'day') as dt2,
    AVG(voting_power) as v_p
    FROM terra.validator_voting_power
    WHERE block_timestamp >= '2021-11-01'
    GROUP BY 1
    order by 1)

    select t1.dt1 as day,
    voting_power as Bison_Trails,
    v_p as average_validators
    from t1
    inner join t2 on t1.dt1=t2.dt2
    Run a query to Download Data