cast(getdate() as date) as date,

tx_hash,

event_name,

event_inputs,

event_inputs:delegate::string as delegate,

event_inputs:newBalance/power(10,18) as current_bal,

event_inputs:newBalance/power(10,18) - event_inputs:previousBalance/power(10,18) as net_change

from optimism.core.fact_event_logs

where contract_address = '0x4200000000000000000000000000000000000042'

and event_name = 'DelegateVotesChanged'

and delegate = '0x5e349eca2dc61abcd9dd99ce94d04136151a09ee'

order by date