SELECT * FROM uniswapv3.positions

),

-- first get current positions:

max_blocks AS (

SELECT

min(block_id) AS min_block_id,

max(block_id) AS max_block_id,

pool_address,

liquidity_provider,

nf_token_id,

date_trunc('day', block_timestamp) AS blk_date

FROM positions

GROUP BY

pool_address,

liquidity_provider,

nf_token_id,

blk_date

),

max_blocks_prices AS (

SELECT

max(block_id) AS max_block_id,

min(block_id) AS min_block_id,

pool_address,

date_trunc('day', block_timestamp) AS blk_date

FROM uniswapv3.pool_stats

GROUP BY

pool_address,

blk_date

),

current_positions_by_day AS (

SELECT