p.block_timestamp,

p.nf_token_id,

p.liquidity_provider,

p.pool_name,

p.liquidity_adjusted,

p.tokens_owed0_usd,

p.tokens_owed1_usd,

l.action,

l.amount0_usd,

l.amount1_usd

from uniswapv3.positions p

left join uniswapv3.lp_actions l on (p.tx_id = l.tx_id)

where p.pool_name in ('USDC-WETH 3000 60')

and p.liquidity_provider in ('0xd71f271ffa7a6580e5710feb7279d795a8272a66')

and p.is_active = TRUE

order by 1