with txns as (

select

iff(currency = 'uosmo', 'osmo', 'axl') as token,

amount/1e6 as token_amount,

*

from osmosis.core.fact_liquidity_provider_actions

where pool_id = '812'

and action in ('pool_joined')

date_trunc('hour',block_timestamp) as date,

token as type,

count(distinct tx_id) as n_txns,

count(distinct liquidity_provider_address) as n_wallets,

sum(token_amount) as t_amount,

avg(token_amount) as avg_amount,

sum(t_amount) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_t_amount,

avg(t_amount) over (partition by type order by date asc rows between unbounded preceding and current row) as avg_t_amount,

sum(n_txns) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_n_txns

from txns

group by 1,2

order by 1 desc