date_trunc('day', block_timestamp) as date,

tx_hash,

event_inputs:delegate::string as delegate,

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

event_inputs:newBalance/pow(10,18) - event_inputs:previousBalance/pow(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 desc, current_bal desc