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,

rank() over(partition by delegate order by block_timestamp desc) as rank

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

lower('0x6cea573473348367a5f66e0f261bfa25799e6a60'), --Mike

lower('0x94db037207f6fb697dbd33524aadffd108819dc8'), --Joxes

lower('0x13838884271ec954cb036d0b29d404afab5eae2a'), --Cryptotesters

lower('0xd23199f1222c418ffc74c385171330b21b16e452'), --Doug

lower('0x46abfe1c972fca43766d6ad70e1c1df72f4bb4d1'), --Synthetics Ambassador Council

lower('0xed11e5eA95a5A3440fbAadc4CC404C56D0a5bb04'), --she256

lower('0x7ae109a63ff4dc852e063a673b40bed85d22e585'), --Blockchain at Berkley

lower('0xdab0d648a2a771e6952916a822dddf738b535f5a'), --Wildfire Infra Prod

lower('0xb7abf554aefd4686639afcf2a653adfda3d9b038'), --pseudotheos

lower('0x8f73be66ca8c79382f72139be03746343bf5faa0'), --David Mihal