boomer77Angel Protocol
    Updated 2021-08-15
    select
    date_trunc('day',block_timestamp) as block_day, action, validator_address, sum(event_amount) as LUNA_staked,
    case when action = 'undelegate' then concat('-',LUNA_staked)
    else LUNA_staked
    end as Amount
    from terra.staking
    where tx_status = 'SUCCEEDED' and validator_address = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
    group by 1,2,3
    order by 1 desc
    Run a query to Download Data