select liquidity_provider_address,

min (block_timestamp) as mindate

from osmosis.core.fact_liquidity_provider_actions

where currency = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A'

and tx_status = 'SUCCEEDED'

and action in ('pool_joined')

group by 1)

select mindate::date as date,

count (distinct liquidity_provider_address) as New_LPers,

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

from table1

group by 1

order by 1