WITH max_pos_blocks AS (

SELECT

max(block_id) AS block_id,

pool_address,

liquidity_provider,

nf_token_id

FROM

uniswapv3.positions

GROUP BY

pool_address,

liquidity_provider,

nf_token_id

),

max_stats_blocks AS (

SELECT

max(block_id) AS block_id,

pool_address

FROM

uniswapv3.pool_stats

GROUP BY

pool_address

),

current_prices AS (

SELECT

price_0_1 AS current_price_0_1,

token0_balance_usd / nullifzero(token0_balance_adjusted) AS price0_usd,

price_1_0 AS current_price_1_0,

token1_balance_usd / nullifzero(token1_balance_adjusted) AS price1_usd,

p.pool_address