block_timestamp,

block_id,

event_id,

event_name,

event_type,

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,

from_address,

origin_address,

origin_function_name,

to_address,

symbol,

amount,

amount_usd,

tx_id

from ethereum.udm_events

where contract_address = '0x9ae236653325b29d5ab4a2c8cb285e8059c2c204' --xCVP contract

order by block_timestamp