The asset volume (in Algos) and the number of transactions was queried in order to find the asset_id of the best performing ASAs. Then, those asset_ids were mapped in a second table to obtain their names and the holding wallets. Assuming that the top ASAs are a combination of those 3 dimensions, two tables of the same 10 ASAs are provided.

YLDY TVL

To do that, we will carry out different analysis. In the following task, we will analyze the following metrics over time:

• Daily liquidity incomes and outcomes
• Distribution area of liquidity addings and removals
• Cumulative liquidity addings and withdrawals
• YLDY TVL over time

Note: I have selected the transactions with a volume less than 10B of YLDY because of it seems like there are some transactions with wrong volume (too high) if we compared with the current TVL.

There are a total of approximately 3.4B YLDY tokens locked. At the current price of around 0.012 it is equivalent to a total of more than 20M USD locked in Yieldly. We can see how the major liquidity was added in June 11th 2021, few days after the launch of the pool, which is normal due to the hype of the project. From the start to the end, the liquidity adding volume has been higher than removals. However, we can see how from now, the addings started to lose dominance against removals and the difference decreases over time.

YLDY Timings

Now, we will analyze how long users stay in the YLDY pool and if it depends on the amount of tokens locked. To do that, firstly I extracted the information of tokens locked in liquidity, the first date day deposited some tokens, and the last date of they removed some token, if it happened. Finally, I compute the difference in days to get the time in pool.

Note: From this second analysis, we will take only those users who have aggregated liquidity at least one time. For the counting days, I have taken into account the first deposit and final withdrawal transactions independently of the amount transferred if it happened.

The table below shows the results obtained for each wallet. But, in order to get moree interesting data, I computed the average of each metric: tokens locked and timing. I divided the analysis as follows:

• Global averages
• Top 100 liquidity providers averages
• Low 100 liquidity providers averages

As we can see, a total of 32500 users have contributed on the pool, with an average contribution of 4.63M. They stayed in the pool an average of 15 days. However, taking a look at the top 100 results, the metrics are so different. They contributed an average of more than 272.5M and stayed in the pool for more than 160 days. Instead, the low 100 addresses contributed a total of 0.935 tokens and stayed in the pool for 10 days.

Then, we can conclude that this change based on the amount the user staked. When more tokens are staked, more days the user stays in the pool.

YLDY pool rewards

Finally, in this last step, we will see the following pool rewards metrics:

• Total claimers
• Total YLDY claimed
• Total ALGO claimed
• Total number of claims
• Average claims per user

We can see how almost 15k users have claimed rewards at least one time. These users claimed a total of 305k times with an average of 19.4 claims. A total of 3.72B YLDY and 112M ALGO have been claimed so far.