select date(block_timestamp) as day,

t1.velo_action,

count (distinct tx_hash) as no_of_lock_txns,

count (distinct origin_from_address) as no_of_users,

round(sum (velo_amount_usd),2) as total_volume_usd,

sum (usdvototal_volume_usdlume) over (partition by t1.velo_action order by day)

from optimism.velodrome.ez_velo_locks

group by day, velo_action

order by day desc