(

select

block_timestamp,

TX_ID,

currency,

decimal,

DELEGATOR_ADDRESS,

VALIDATOR_ADDRESS as dest,

REDELEGATE_SOURCE_VALIDATOR_ADDRESS as source,

'normal_unstake' as "stake"

from osmosis.core.fact_staking

where action='redelegate'

and TX_STATUS='SUCCEEDED'

)

select

block_timestamp::date as "date",

count(tx_id) as redelgates

from restakes

group by "date"