*,

sum(volume) over (ORDER BY day) as total_volume

FROM (

SELECT

date_trunc('day', block_timestamp) as day,

sum(MARS_REWARDS / power(10, 6)) as volume

FROM osmosis.mars.ez_redbank_reward_claims

GROUP BY 1