SELECT

vote_timestamp,

CASE WHEN space_id = 'opcollective.eth' THEN

'Optimism'

END AS protocol,

CASE WHEN space_id = 'opcollective.eth' THEN voting_power END AS voting_power

FROM "ETHEREUM"."CORE"."EZ_SNAPSHOT"

WHERE voter = '0x62a43123FE71f9764f26554b3F5017627996816a'

AND space_id = 'opcollective.eth'

SELECT

date_day AS date,

COALESCE(

voting_power,

last_value(voting_power ignore nulls) OVER (ORDER BY date_day ASC rows unbounded preceding)

) as voting_power

FROM ethereum.core.dim_dates d

LEFT OUTER JOIN votes da

ON date_day = da.vote_timestamp :: date

WHERE date_day >= CURRENT_DATE - {{days}}

qualify(ROW_NUMBER() over (PARTITION BY date_day

ORDER BY

vote_timestamp DESC)) = 1

ORDER BY date_day DESC