min(BLOCK_ID) as first_block

,max(BLOCK_ID) as last_block

, LIQUIDITY_PROVIDER_ADDRESS

,ACTION

--,case

--when ACTION='pool_joined' then AMOUNT/1e6

--when ACTION='pool_exited' then AMOUNT/1e6 end as asset_amount

from osmosis.core.fact_liquidity_provider_actions

where POOL_ID[0]='678'

and LIQUIDITY_PROVIDER_ADDRESS='osmo1jdh7eeyaar0tyask0r6w2228uh5wrd0pxtcfwr'

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

and CURRENCY='uosmo'

group by 3,4