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

block_number,

tx_hash,

status,

delegator,

to_delegate,

from_delegate,

delegation_type

from optimism.core.fact_delegations

),

delegations 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'

and event_inputs:delegate::string in (

lower('0x5e349eca2dc61aBCd9dD99Ce94d04136151a09Ee'), --Linda Xie

lower('0xB1EA5a3E5EA7fA1834d48058EcDa26d8c59e8251'), --Quixotic

lower('0x45a10F35BeFa4aB841c77860204b133118B7CcAE'), --Ethernaut

lower('0xdb5781a835b60110298fF7205D8ef9678Ff1f800'), --Yoav Weiss

lower('0x75536cf4f01c2bfa528f5c74ddc1232db3af3ee5'), --Katie

lower('0xa6e8772af29b29b9202a073f8e36f447689beef6'), --GFX Labs

lower('0x48a63097e1ac123b1f5a8bbffafa4afa8192fab0'), --Scott Moore

lower('0x01e6b50557ef1a2ca58a621998ace3f278e808b8'), --Nick Tong (Perpetual Team)

lower('0x1b686ee8e31c5959d9f5bbd8122a58682788eead'), --Kris Kaczor (L2BEAT)

lower('0x512fce9b07ce64590849115ee6b32fd40ec0f5f3'), --Solarcurve

lower('0x9b7df3a2df61e72df5c4d565a0e017d7c5c6e532'), --Jen Senhaji

lower('0x9cbe5b896d0c24acf41860b9e3df6750c2040a40'), --Devon Zuegel

lower('0x839395e20bbb182fa440d08f850e6c7a8f6f0780'), --Griff Green