where PLATFORM='sushiswap')---address contract

SELECT BLOCK_TIMESTAMP::date as days, count(distinct ORIGIN_FROM_ADDRESS) as LP1, lag(LP1) ignore nulls over(ORDER BY days ASC) as lag_LP,

(LP1-lag_LP)/LP1*100 as LP_change_percentage from ethereum.core.ez_token_transfers

where TO_ADDRESS in (select POOL_ADDRESS from tible) and BLOCK_TIMESTAMP>=CURRENT_DATE-365---to years

and ORIGIN_TO_ADDRESS='0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f'--addres contract

and origin_function_signature in ('0xe8e33700', '0xded9382a', '0xf305d719') group by days