boomer77Redel daily to top 10
Updated 2021-08-29
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc('day', block_timestamp) as block_day, validator_address_label, sum(event_amount) as Redelegations
from terra.staking
where tx_status = 'SUCCEEDED' and action = 'redelegate'
and validator_address_label in ('Orion.Money', 'Terran One', 'Mosaic', 'Smart Stake', 'Staky.io', 'B-Harvest', 'NOD Games', 'CAPAPULT Commission Change 5%', 'Mr.K', 'stake.systems')
group by 1,2
order by 1 desc
Run a query to Download Data