block_timestamp :: date as date,

voter,

voting_power / POW(10, 18) AS voting_power

FROM ethereum.aave.ez_votes

WHERE voter = lower('{{voter_address}}')

AND block_timestamp :: date >= '2022-10-01'

qualify(ROW_NUMBER() over(PARTITION BY voter, block_timestamp :: date

ORDER BY

block_timestamp DESC)) = 1

ORDER BY block_timestamp :: date ASC