SENDER as ADDRESS,

AMOUNT_OUT AS volume_ETH,

AMOUNT_IN AS volume_USDC,

sum(AMOUNT_OUT)/sum(AMOUNT_IN) as ETH_USDC_TWAP

from ethereum.sushi.ez_swaps

where BLOCK_NUMBER between 15180000-100 and 15180000

and SYMBOL_IN = 'WETH'

and SYMBOL_OUT = 'USDC'

),main2 as (

SELECT

ADDRESS as Lp,

volume_ETH as Amount_ETH,

volume_USDC as Amount_USDC,

ETH_USDC_TWAP as TWAP_secondry,

Amount_USDC/Amount_ETH as TWAP_primary,

(2*sqrt(TWAP_primary / TWAP_secondry)/(1+(TWAP_primary / TWAP_secondry)) - 1)*100 as percent_Impermanent_Loss,

(AMOUNT_ETH*TWAP_PRIMARY+AMOUNT_USDC)*percent_Impermanent_Loss/100 as Impermanent_Loss_in_USDC

from table3

SELECT

Lp,

avg(Impermanent_Loss_in_USDC) as volume , avg(percent_Impermanent_Loss) as "percent of Impermanent Loss"

from main2

GROUP BY 1