block_timestamp,

label,

rank()over(partition BY actor ORDER BY block_timestamp) as rank

SELECT 'unstake' as label,

block_timestamp,

delegator_address as actor

FROM osmosis.core.fact_staking

WHERE action = 'undelegate'

AND tx_status = 'SUCCEEDED'

SELECT 'stake' as label,

block_timestamp,

delegator_address as actor

FROM osmosis.core.fact_staking

WHERE action = 'delegate'

AND tx_status = 'SUCCEEDED'

SELECT 'redelegate' as label,

block_timestamp,

delegator_address as actor

FROM osmosis.core.fact_staking

WHERE action = 'redelegate'

AND tx_status = 'SUCCEEDED'

SELECT 'swap' as label,

block_timestamp,

trader as actor

FROM osmosis.core.fact_swaps

WHERE from_currency = 'uosmo'

AND tx_status = 'SUCCEEDED'

SELECT 'transfer' as label,

block_timestamp,