tab1 as (

SELECT

trunc(block_timestamp,'day') as days,

substring(memo, CHARINDEX('UNBOND:', memo) + 7, CHARINDEX('UNBOND:', memo) + 42) as operator,

count(distinct tx_id) as participations,

--cum(bonds) over (partition by operator order by days) as cum_bonds,

sum(e8/pow(10,8)) as rune_to_unbond

--sum(bonded) over (partition by operator order by days) as cum_rune_to_unbond

FROM thorchain.bond_events

WHERE bond_type = 'bond_returned' and memo like '%UNBOND:%' and CHARINDEX('UNBOND:', memo) > 0

group by 1,2

ORDER BY 1

)

days,

operator,

participations, sum(participations) over (partition by operator order by days) as cum_participations,

rune_to_unbond, sum(rune_to_unbond) over (partition by operator order by days) as cum_rune_to_unbond

from tab1

order by 1 asc