Introduction

In this dashboard, we'll look at the LP size distribution per pool on Thorchain. This means that we'll look at what percent of the liquidity providers of a pool fall in each category of users. Examples:

• Shrimp, a user that provided between 0 and 10 RUNE to a pool

• Crab, a user that provided between 10 and 100 RUNE to a pool

This distribution can give insight into what pool attract

Methodology

1. Find the total amount of RUNE each user has added to each pool. This was done using the table thorchain.liquidity_actions and lp_action = 'add_liquidity'.
2. Find the total amount of RUNE each user has withdrawn from each pool. This was done using the same table and the condition lp_action = 'remove_liquidity'
3. Find the current balance of each user for each pool. If the balance is positive, the user is actively providing liquidity.
4. Calculate a histogram by counting the number of users that fall into each bin per pool.
5. Divide by the total number of liquidity providers per pool to get the distribution per pool in percentage terms.

Results

In the chart above, we can see the number of types of users per pool. We can see that no pool have a Humpback whale, with over 1 million RUNE tokens in the pool. However, a number of pools have a whale. A whale hold between 100k and 1 million RUNE tokens in the pool. The ETH.ETH pool has the most amount of whales: 3.

Key findings

• In most pools, the majority of the providers are shrimps, which provide between 0 and 10 RUNE.
• There are no pools with a Humpback Whale, which provide over 1M RUNE.
• The ETH.ETH pool has the most amount of whales (100k-1m RUNE): 3

Next, we have the same distribution but now in percentage terms to better visualize distribution per pool. We can clearly see that in most pools the majority of the providers are shrimps. We can also see that in some pools 100% of the providers belong to a certain group. This is the case when there is only one liquidity provider for that pool.