maybeyonastera_new_valid_growth
    Updated 2021-12-15
    with new_valids as (
    select * from (
    select
    address,
    min(block_timestamp) as start_date
    from terra.validator_voting_power
    group by 1
    )
    where start_date > current_date - interval '60 days'
    ),
    daily_topblock as (
    select
    date(block_timestamp) as date,
    max(block_id) as max_block
    from terra.validator_voting_power
    group by 1
    ),
    latestBlock as (
    select
    date(block_timestamp) as date,
    address , voting_power
    from terra.validator_voting_power
    where block_id in (
    select max_block from daily_topblock --terra.validator_voting_power
    )
    and address in (select address from new_valids)
    ),
    totalDelegation as(
    select
    -- date(block_timestamp) as date,
    date,
    sum(voting_power) as total
    from (
    select
    date(block_timestamp) as date,
    address , voting_power
    Run a query to Download Data