Analyse LP performance on Ekubo ETH/USDC pool by user address

[akiraonstarknet]

Analyse all the users who did LP on ETH/USDC in the most liquid fee tier pool to provide the following outcomes:

1. Capital dollar value vs time (from pool launch block to now). One unique line for each user. Normalize the investment of all users to $1000. Also plot a black thick line with $1000 as original investment in terms of HODL.
2. Take 10 most profitable users (they should atleast be invested for 60 days in the pool). The profit is compared wrt to HODL. Plot number of rebalances done by each of these users
3. Plot Profit % (Annualized) vs these 10 users as bar chart.

The intent of this analysis is to study the profitability of LP-ers on Ekubo

[NueloSE]

Hi, kindly assign me this task.
I am experience in using python for Data analysis and result interpretation.
And I have handle similar project to this. check it here

[Kingsuite]

Can I handle this task?

[abdegenius]

Could I try solving this?

[jedstroke]

I’d like to help with this.

[Joe-joe25]

May I take this issue on?

[Supa-mega]

I'd like to handle this task.

[mimisavage]

May I try my hand at this?

[0xdevcollins]

Can I be assigned this issue?

My Background
I am a Full Stack Blockchain Developer with proficiency in Solidity/Rust, Next.js, TypeScript, React, and Node.js. I've demonstrated my ability to adjust to a variety of requirements, perform well under pressure, and reliably produce user-centric blockchain solutions with 58 significant contributions spread over 17 OnlyDust projects.

[Michaelkingsdev]

Hello @LazarusAA
I am a frontend developer with 4 years of experience. I would really love to work on this task. Can it be assigned to me?

[Benjtalkshow]

I am a Full Stack Developer with a strong background in blockchain and extensive experience in Next.js/React, TypeScript, and Rust. I’ve made over 49 contributions to over 17 projects in the OnlyDust ecosystem, solving complex issues and delivering efficient, scalable solutions.

I can handle this task.
ETA is 3days.

[Bosun-Josh121]

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged:

software engineering background, backend & smart contract dev with contribution to tasks on od(https://app.onlydust.com/u/Bosun-Josh121) looking to make first contribution on this project

How I plan on tackling this issue
I will analyze on-chain data to track capital dollar value over time for each user, normalizing investments to $1000 and plotting these trends since the pool launch block. A reference line representing $1000 HODL will be included for comparison. For the 10 most profitable users (invested for at least 60 days), I will calculate profits relative to HODL and plot the number of rebalances each user performed.
work on feedback & recommendation ensuring contact. Can deliver within 48hrs upon assignment

[BrunoAmbricca]

I would like to work on this issue

[ShantelPeters]

I’d love to work on this task.

[Jagadeeshftw]

Hello, I’d love to work on this issue as I have strong experience in developing secure and efficient smart contracts using Cairo and deploying them on StarkNet. Please assign this to me, and I’ll ensure to deliver a robust and high-quality PR within 12-24 hours.

[Judah04]

Hi @akiraonstarknet I'd like to work on this.
I am a data scientist with python.

[NueloSE]

@akiraonstarknet

my proposed approach to solving this task:

• I'll start by querying and analyzing ETH/USDC pool data to track LP positions for each user since the pool's launch.
• Then proceed to normalize each user's investment to $1000 and create a time series plot, adding a HODL comparison line in black to show relative performance.
• Calculate profitability compared to HODL for users who maintained positions for at least 60 days, identifying the top 10 performers.
• I'll creating a visualization to show the relationship between rebalances and profitability.
• I'll calculate annualized profit percentages for the top 10 users and create a bar chart to visualize their relative performance.
• I'll use data visualization libraries to create clear, informative charts
• Document my methodology and include data interpretation for the analysis.

ETA <= 3days

[caxtonacollins]

I am a Full Stack Developer with two years of professional experience, specializing in web3. I have strong background in blockchain and extensive experience in Next.js/React, TypeScript, Cairo and Rust.

I will like to take care of this.

[olisaagbafor]

Could I try solving this?

[Dorcas18]

May I take this issue on?

[akiraonstarknet]

@NueloSE the task is assigned to you. Can you share your plan for implementation and timeline?

[NueloSE]

@akiraonstarknet

similar to what i mentioned earlier my approach, when given access to the data I will:

• Load the pool data into a Pandas DataFrame, to include usefull columns like user transactions, token reserves, prices, and timestamps.
• Then calculate each user's initial capital and normalize it to $1000.
• Track capital value over time by grouping data by user and timestamp.
• Plot each user's performance over time, including a reference HODL line for comparison.
• Identify the top 10 most profitable users who were active for at least 60 days.
• and compute the number of rebalances (e.g., Mint and Burn events) for these top users.
  finally I will return a report containing my analysis.

I can achieve this in 48 hours of receiving the data source.

kindly guide me on the how to access the dataset so i can begin immediately

Thanks for assigning me

[akiraonstarknet]

@NueloSE u will have the collect the data as well. check src/data/ekubo_data.py