SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY,

AVG(TOKEN0_PRICE) AS TOKEN_0_PRICE,

AVG(TOKEN1_PRICE) AS TOKEN_1_PRICE,

TOKEN_1_PRICE/TOKEN_0_PRICE AS PRICE_0_1,

FIRST_VALUE(PRICE_0_1) OVER (ORDER BY DAY) AS FIRST_TOKEN0_IN_TOKEN1_PRICE,

PRICE_0_1/FIRST_TOKEN0_IN_TOKEN1_PRICE AS p,

(2*(SQRT(p)/(p+1))-1) AS IMPERMANENT_LOSS,

ABS(IMPERMANENT_LOSS*100) AS IMPERMANENT_LOSS_PERC

FROM ethereum.uniswapv3.ez_lp_actions

WHERE POOL_NAME LIKE ('{{POOL_NAME}}%3000%') AND DAY >= '2023-01-01'

GROUP BY DAY