tx_hash,

contract_address,

CASE WHEN event_name = 'Lock' THEN

'Delegate'

ELSE

'Undelegate'

END AS action,

CASE WHEN event_name = 'Lock' THEN

event_inputs :LockAmount / POW(10, 18) :: NUMBER

ELSE

- event_inputs :wad / POW(10, 18) :: NUMBER

END AS amount,

'MKR' as token-- Delegations

FROM

ethereum.core.fact_event_logs

WHERE

contract_address = '0x84b05b0a30b6ae620f393d1037f217e607ad1b96'

AND (event_name = 'Free' OR event_name = 'Lock')