date_trunc('day',block_timestamp) as "Day",

coalesce(POOL_NAME,pool_address) as "Pool",

coalesce(sum(case when vote_action = 'unvote' then vote_amount end),0) as "Voted",

-1*coalesce(sum(case when vote_action = 'vote' then vote_amount end),0) as "Unvoted"

from

optimism.velodrome.ez_votes

where origin_from_address = lower('{{Address}}')

group by 1,2

order by 1 desc, 2