*,

sum(volume) over (PARTITION BY pool ORDER BY day) as cume_vol

FROM (

SELECT

date_trunc('day', block_timestamp) as day,

SPLIT(CURRENCY, '/')[2] as pool,

sum(CASE WHEN action LIKE 'delegate' THEN AMOUNT ELSE 0 END / power(10, DECIMAL)) - sum(CASE WHEN action LIKE 'undelegate' THEN AMOUNT ELSE 0 END / power(10, DECIMAL)) as volume

FROM osmosis.core.fact_superfluid_staking

GROUP BY 1,2