select LIQUIDITY_PROVIDER_ADDRESS as pool_joined_address ,Date(BLOCK_TIMESTAMP ) pool_joined_Date, COUNT(1) Count_joined from osmosis.core.fact_liquidity_provider_actions

where action = 'pool_joined'

and tx_status = 'SUCCEEDED'

and BLOCK_ID BETWEEN 4707300 and 4713064

group by Date(BLOCK_TIMESTAMP ),LIQUIDITY_PROVIDER_ADDRESS

),pool_exited as (

select LIQUIDITY_PROVIDER_ADDRESS as pool_exited_address ,Date(BLOCK_TIMESTAMP ) pool_exited_Date, COUNT(1) Count_exited from osmosis.core.fact_liquidity_provider_actions

where action = 'pool_exited'

and tx_status = 'SUCCEEDED'

and BLOCK_ID BETWEEN 4707300 and 4713064

group by Date(BLOCK_TIMESTAMP ),LIQUIDITY_PROVIDER_ADDRESS

select (case when pool_exited_Date is null then pool_joined_Date else pool_exited_Date end ) Date ,pool_joined_address , pool_exited_address,Count_joined , Count_exited from pool_joined

join pool_exited on pool_joined_address = pool_exited_address and pool_joined_Date = pool_exited_Date