A as(

select block_timestamp as time, event_name as event, tx_hash,

case when event_name like '%Increased%' then 1 else -1 end * decoded_log['shares']/1e18 as amount,

decoded_log['operator'] as operator,

decoded_log['staker'] as staker,

decoded_log

from ethereum.core.fact_decoded_event_logs

where decoded_log['strategy'] = '0xacb55c530acdb2849e6d4f36992cd8c9d50ed8f7'

and decoded_log['shares'] > 0 ),

B as(

select operator, sum(amount) as amount

from A

group by 1)

select operator, 'Σ:' || to_varchar(amount ,'999,999,999,999') as "(Σ) AMOUNT RESTAKED"

from B

order by amount desc