with all_delegation as(

select date_trunc('day', block_timestamp) as evt_date,

block_number,

tx_hash,

status,

delegator,

to_delegate,

from_delegate,

delegation_type

from optimism.core.fact_delegations

),

self_del as (

select

block_timestamp,

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' -- OP governance token

and event_name = 'DelegateVotesChanged'

),

ff0420 as (

select

ad.evt_date,

ad.block_number,

ad.tx_hash,

ad.status,