SELECT delegate_address, delegated_votes FROM

(

SELECT

TRIM(LOWER(event_inputs:delegate::string)) as delegate_address,

ROUND(event_inputs:newBalance / pow(10, 18), 0) as delegated_votes,

ROW_NUMBER() over (partition by delegate_address order by block_timestamp desc) as row_number

FROM ethereum.events_emitted

WHERE event_name ='DelegateVotesChanged'

and contract_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'

and block_timestamp > DATEADD(DAY, -180, getDate())

)

WHERE row_number = 1 ORDER BY delegated_votes DESC LIMIT 5

SELECT

event_inputs:proposalId as prop_id,

CASE WHEN event_inputs[ 'support' ] = true THEN 'For' ELSE 'Against' END AS support,

top5del.delegate_address,

top5del.delegated_votes,

DATE_TRUNC(DAY, evdet.block_timestamp) as date

FROM ethereum.events_emitted as evdet

INNER JOIN top5_delegate_addresses as top5del

ON top5del.delegate_address = TRIM(LOWER(event_inputs['voter']))

WHERE contract_address = '0x5e4be8bc9637f0eaa1a755019e06a68ce081d58f'

AND event_name ='VoteCast'

AND block_timestamp > DATEADD(DAY, -180, getDate())