Introduction & Methodology

In this dashboard, we will show the distribution of $RUNE holdings by address. We will not only include the $RUNE currently held in the wallet, but considered $RUNE added to liquidity pools as well. This was calculated in the following way:

1. Calculate wallet balance In order to calculate the wallet balance, the thorchain.transfers table was used. Using this table we are able to track all the $RUNE that was transferred into and out of each wallet. We calculate the current balance using total_received-total_sent.
2. Calculate liquidity balance To calculate the amount of $RUNE in liquidity pools for each address, the table thorchain.liquidity_actions. Using this table, we calculate the total amount of $RUNE added and withdrawn from liquidity pools using the lp_action column. We can then calculate the liquidity pool balance using total_rune_added - total_rune_withdrawn.
3. We have to keep in mind that Thorchain auto compounds the liquidity balance. Therefore, it is possible to withdraw more RUNE than you have added. If we use the formula total_rune_added - total_rune_withdrawn to calculate the liquidity balance, the balance can be negative. We solve this issue by truncating negative balances to 0 because a negative liquidity pool balance means that all $RUNE was withdrawn from liquidity pools.
4. Finally, we add the wallet balance and the liquidity balance together to get the total $RUNE balance and we calculate the distribution

Results

Unfortunately, the Flipside graph does not order the barchart logically. Therefore a new graph was created using Plotly to reflect the right order of the bins:

We can see that most users hold between 0 and 10 $RUNE. We can also see that quite a similar number of users hold up to 1K $RUNE. Only after 5K $RUNE, we can see the number of users drop.