date_trunc('day',block_timestamp) as block_day, count(distinct tx_id) as Redelegations_Count

from terra.staking

where tx_status = 'SUCCEEDED' and action = 'redelegate'

group by 1

order by 1 desc