boomer77Angel Protocol
Updated 2021-08-15
9
1
2
3
4
5
6
7
8
9
›
⌄
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