date as "Date",

sum(volume) as "Daily volume" ,

sum ("Daily volume") over (order by date) as "cumulative volume"

from external.defillama.fact_dex_volume

where chain = 'aptos'

and date > '2024-04-01 00:00:00.000 '

group by 1

order by 1 desc