DATE(block_timestamp) as dayz,

liquidity_provider_address as addusers,

sum(amount) / 1e18 as addamt

from osmosis.core.fact_liquidity_provider_actions

where currency = 'ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5'

AND tx_status = 'SUCCEEDED' AND action = 'pool_joined'

group by 1, 2),

removeETH as (select

DATE(block_timestamp) as dt,

liquidity_provider_address as removeusers,

sum(amount) / 1e18 as removeamt

from osmosis.core.fact_liquidity_provider_actions

where currency = 'ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5'

AND tx_status = 'SUCCEEDED' AND action = 'pool_exited'

group by 1, 2),

wETHpos as (select

dayz,

addusers,

(addamt - coalesce(removeamt, 0)) as Netamt,

sum(Netamt) over (partition by addusers order by dayz asc rows between unbounded preceding and current row) as balance

from addETH a

left join removeETH ON dayz=dt AND addusers = removeusers

order by dayz ASC ),

min as (SELECT f.date_added

, f.balance as initialbalance

, f.addusers

FROM ( SELECT addusers, balance, dayz AS date_added, RANK() OVER( PARTITION BY addusers ORDER BY dayz ASC ) AS rnk_first FROM wETHpos ) AS f

WHERE f.rnk_first = 1),

max as (SELECT f.date_added

, f.balance as lastbalance

, f.addusers