SELECT

SUM(AMOUNT0_USD + AMOUNT1_USD) AS amount_decrease,

POOL_ADDRESS AS pool_exit,

MIN(BLOCK_TIMESTAMP) AS date_exit,

AVG(TIMESTAMPDIFF(DAY, CURRENT_DATE - 365, BLOCK_TIMESTAMP)) AS avg_date_exit

FROM

ethereum.uniswapv3.ez_lp_actions

WHERE

AMOUNT0_USD + AMOUNT1_USD < 10e9

AND BLOCK_TIMESTAMP > CURRENT_DATE - 365

AND ACTION = 'DECREASE_LIQUIDITY'

AND AMOUNT0_USD + AMOUNT1_USD > 10000

GROUP BY POOL_ADDRESS

),

t2 AS (

SELECT

SUM(AMOUNT0_USD + AMOUNT1_USD) AS INCREASE_decrease,

POOL_ADDRESS AS pool_enter,

MIN(BLOCK_TIMESTAMP) AS date_enter,

AVG(TIMESTAMPDIFF(DAY, CURRENT_DATE - 365, BLOCK_TIMESTAMP)) AS avg_date_enter

FROM

ethereum.uniswapv3.ez_lp_actions

WHERE

AMOUNT0_USD + AMOUNT1_USD < 10e9

AND BLOCK_TIMESTAMP > CURRENT_DATE - 365

AND ACTION = 'INCREASE_LIQUIDITY'

AND AMOUNT0_USD + AMOUNT1_USD > 10000

GROUP BY POOL_ADDRESS

),

tt AS (

SELECT

AVG_DATE_EXIT - AVG_DATE_ENTER AS reclaim,

*