SELECT

tx_hash,

contract_address,

block_timestamp,

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,

sum(amount) OVER (ORDER BY block_timestamp ASC rows UNBOUNDED PRECEDING) as delegation_amount

FROM

ethereum.core.fact_event_logs

WHERE

contract_address = '0x84b05b0a30b6ae620f393d1037f217e607ad1b96'

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

),

dels AS (

SELECT

date_day AS date,

COALESCE(

delegation_amount,

last_value(delegation_amount ignore nulls) OVER (ORDER BY date_day ASC rows unbounded preceding)

) as last

FROM ethereum.core.dim_dates d

LEFT OUTER JOIN delegate_actions da

ON date_day = da.block_timestamp :: date

WHERE date_day >= '2022-03-24'