case when currency = 'uosmo' then 'OSMO'

else 'wAVAX' end AS currencies,

count(*) AS tx_volume,

sum(tx_volume) over ( partition by currencies ORDER BY date ) AS cumulative_txs

from osmosis.core.fact_liquidity_provider_actions

WHERE pool_id = [899]

AND action = 'pool_joined'

AND tx_succeeded = 'true'

GROUP BY 1,2

ORDER BY 1 ASC;