SELECT
decoded_log:delegate as delegate
,decoded_log:newBalance as new_balance
,block_timestamp
from polygon.core.ez_decoded_event_logs
where 1=1
and contract_address = '0xc2a45fe7d40bcac8369371b08419ddafd3131b4a'
and event_name in ('DelegateVotesChanged')
--group by 1, 2, 3, 4
qualify row_number () over (partition by delegate order by block_timestamp desc) = 1