date_trunc('day', block_timestamp) as day,

count(

distinct(tx_hash)

) as transactions_count ,

sum(transactions_count) over (order by day

)as cum_tx

from

optimism.velodrome.ez_swaps

where

platform like 'velodrome'

group by

day