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

pool_name as "Pool",

sum(coalesce(sum(case when vote_action = 'vote' then vote_amount end),0)-coalesce(sum(case when vote_action = 'vote' then vote_amount end),0)) over (order by 1 asc rows between unbounded preceding and current row) as "New Votes"

from

optimism.velodrome.ez_votes

where block_timestamp::date > '2022-06-30'::date

group by 1,2

order by 1,2