select date_trunc('second',BLOCK_TIMESTAMP)as join_time,LIQUIDITY_PROVIDER_ADDRESS

from osmosis.core.fact_liquidity_provider_actions

where POOL_ID[0]='678'

and LIQUIDITY_PROVIDER_ADDRESS='osmo1hq8tlgq0kqz9e56532zghdhz7g8gtjymdltqer'

and (BLOCK_ID>='4712771' and BLOCK_ID<='4713064')

and CURRENCY='uosmo'

and ACTION in ('pool_joined')),

tab2 as (

select date_trunc('second',BLOCK_TIMESTAMP)as exit_time,LIQUIDITY_PROVIDER_ADDRESS

from osmosis.core.fact_liquidity_provider_actions

where POOL_ID[0]='678'

and LIQUIDITY_PROVIDER_ADDRESS='osmo1hq8tlgq0kqz9e56532zghdhz7g8gtjymdltqer'

and (BLOCK_ID>='4712771' and BLOCK_ID<='4713064')

and CURRENCY='uosmo'

and ACTION in ('pool_exited')

),

tab3 as (

select date_trunc('second',BLOCK_TIMESTAMP)as join_time,LIQUIDITY_PROVIDER_ADDRESS

from osmosis.core.fact_liquidity_provider_actions

where POOL_ID[0]='678'

and LIQUIDITY_PROVIDER_ADDRESS='osmo1v44mqmhvtn8cw373xv0hw6npddccnr70lqsk9s'

and (BLOCK_ID>='4712961' and BLOCK_ID<='4713064')

and CURRENCY='uosmo'

and ACTION in ('pool_joined')),

tab4 as (

select date_trunc('second',BLOCK_TIMESTAMP)as exit_time,LIQUIDITY_PROVIDER_ADDRESS

from osmosis.core.fact_liquidity_provider_actions

where POOL_ID[0]='678'

and LIQUIDITY_PROVIDER_ADDRESS='osmo1v44mqmhvtn8cw373xv0hw6npddccnr70lqsk9s'

and (BLOCK_ID>='4712961' and BLOCK_ID<='4713064')

and CURRENCY='uosmo'

and ACTION in ('pool_exited')),

tab5 as (

select date_trunc('second',BLOCK_TIMESTAMP)as join_time,LIQUIDITY_PROVIDER_ADDRESS

from osmosis.core.fact_liquidity_provider_actions