count (distinct liquidity_provider_address) as New_LPers,

sum (new_Lpers) over (order by date) as Total_LPers

from (

select liquidity_provider_address,

min (block_timestamp) as mindate

from osmosis.core.fact_liquidity_provider_actions

where pool_id [0] = '773'

and action in ('pool_joined')

and TX_SUCCEEDED = 'true'

group by 1)

group by 1

order by 1