LTirrellterra_staking
    Updated 2022-01-18
    -- select
    -- trunc(block_timestamp, 'day') as date,
    -- avg(price_usd) as price_usd,
    -- currency
    -- from
    -- terra.oracle_prices
    -- where
    -- block_timestamp >= '2021-06-30'
    -- and currency like 'u%'
    -- group by
    -- date,
    -- currency
    select
    trunc(block_timestamp, 'day') as date,
    address,
    avg(voting_power) as voting_power
    from
    terra.validator_voting_power
    where
    block_timestamp >= '2021-06-30'

    group by
    date, address

    Run a query to Download Data