block_timestamp,

block_id,

event_id,

case

when origin_function_name = 'enter' then 'enter'

when origin_function_name = 'transfer' then 'transfer'

when to_address = '0x0000000000000000000000000000000000000000' then 'leave'

else 'other'

end as contract_function_call,

case

when contract_function_call = 'enter' then amount

when contract_function_call = 'leave' then -amount

else 0

end as qty,

sum(qty) over (order by block_id, event_id rows between unbounded preceding and current row) as issuance

from ethereum.udm_events

where contract_address = '0x9ae236653325b29d5ab4a2c8cb285e8059c2c204' --xCVP contract

order by block_id, event_id