date_trunc(day, mindate) as date,

count(distinct liquidity_provider_address) as New_LPers,

sum(new_Lpers) over (

order by

date

) as Total_LPers

(

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