flipside

    Try Quests to earn cryptoTry Quests to earn crypto
    Share

    LOOP Liquidity Analysis: number of other positions per pool

    This dashboard aims to provide insight into the liquidity on the LOOP dex. This dashboard will examine the average, median and mode of the number of other positions, a liquidity provider in each pool on LOOP provides liquidity in.

    Loading...
    Loading...
    Loading...

    Median

    The median of a list of numbers refers to the value that is in the middle of the list after the list has been sorted. This means that the median of a list with only integers (whole numbers) is also an integer, as you are picking a value from the list. This is also the case in this situation, as users can only provide liquidity to a whole number of pools. However, the median in some cases (such as with the LOOP-HALO pool) is not a whole number! How can this be? Well, it is due to the way Snowflake SQL calculates the median. When the length of a list is uneven, the list will have a value that is exactly in the middle of that list. When the length is even, it becomes a bit more tricky to calculate the median, as there is no exact middle value. Snowflake SQL chooses to calculate the average of the two middle values, which can result in a decimal number!

    Average

    To better understand the graphs, we will give an example: a user provides liquidity for the LOOP-UST pool. Besides the LOOP-UST pool, the user also provides liquidity for the BLUNA-LUNA pool and LOOP-LUNA pool. This means that this user that is providing liquidity for the LOOP-UST pool, is also providing liquidity for 2 other pools. In the graph below we can see that the average for the LOOP-UST pool is 1.85, meaning that this user provides liquidity to (slightly) more pools than the average user that is providing liquidity to the LOOP-UST pool.

    Mode

    The mode of a list is fairly straightforward. The mode of a list refers to the value in the list that occurs the most. Easy!