day,

'locked_velo' as token_type,

amt1 as volume

FROM (

SELECT

date_trunc('day', block_timestamp) as day,

sum(velo_amount) as amt1

FROM optimism.velodrome.ez_velo_locks

GROUP BY 1

SELECT sum(volume)

from tab1

WHERE day BETWEEN '2023-01-01' AND '2023-03-31'