*,

sum(net_volume) over (order by day) as cume_volume

from (

SELECT

date_trunc('day', block_timestamp) as day,

sum(CASE WHEN TRANSFER_TYPE LIKE 'IBC_TRANSFER_OUT' THEN amount / power(10, 6) END) as volume_out,

sum(CASE WHEN TRANSFER_TYPE LIKE 'IBC_TRANSFER_IN' THEN amount / power(10, 6) END) as volume_in,

sum(CASE WHEN TRANSFER_TYPE LIKE 'IBC_TRANSFER_OUT' THEN amount / power(10, 6) ELSE 0 END) - sum(CASE WHEN TRANSFER_TYPE LIKE 'IBC_TRANSFER_IN' THEN amount / power(10, 6) ELSE 0 END) as net_volume

FROM cosmos.core.fact_transfers

WHERE currency LIKE 'uatom'

GROUP BY 1

WHERE day > CURRENT_DATE - {{age_days}}