THORChain Active Wallet Addresses

In this dashboard, we show the number of Thorchain active wallets and examine them over time.

Q105. We are interested in knowing how many users are currently in the ecosystem.
In this case, how many are holding $RUNE in their wallet or have an open LP position.
What is this number currently, and how has it trended over time?

What is Thorchain ?

Thorchain aims to decentralize cross-chain cryptocurrency liquidity via a network of public THORNodes and ecosystem products. Thorchain is a decentralized liquidity network by design, which enables much more than just swaps -- synthetics, composites and self-paying loans. Access to its native and cross-chain liquidity is open to any person, product or institution.

What is $RUNE Token ?

RUNE is the asset which powers the THORChain ecosystem and provides the economic incentives for THORNodes validators in order to secure the network economically. THORNodes validators are rewarded with RUNE tokens for validating transactions that are happening on THORChain.
THORNodes validators have to bond their own $RUNE capital to make is safe for Liquidity Providers to pool their assets in the THORChain network. For the network to operate in the optimal state of security, for each unit of pooled capital there are two units of bonded capital. For instance, if RUNE-BTC liquidity providers provided $1M worth of $RUNE and another $1M worth of $BTC onto the THORChain network, THORNodes validators would have to bond $2M worth of $RUNE by design.
If THORNodes validators steal from their own vault, the mechanism is designed to slash 1.5X the amount stolen from their bonded tokens. They would end up losing more than they gained, which makes zero economic sense for them to steal.
You can read here for more information

> To answer this question, I used the tables thorchain.liquidity_actions and thorchain.transfers according to the question guide.
> For the first part, which was the total number of wallets, I considered the wallet to which the transfer was made and put the condition TO_ADDRESS! = FROM_ADDRESS for more impact.
> For the second part, which was the amount of open liquidity, I used the following condition to separate and filter the wallets that still have liquidity:
- > FROM_ADDRESS not in (select FROM_ADDRESS from flipside_prod_db.thorchain.liquidity_actions where LP_ACTION = 'remove_liquidity'

The chart above shows the number of active wallets per day.
The number of wallets seems to have been on an upward trend since February 25, 2022, but with the recent decline, the market has returned to its original position.
The highest number of active wallets was registered on May 25, 2022.
From July 23, 2021 to August 9, 2021, no active wallet will be observed

If we set the above chart based on the sum of the RUNE values of each active wallet per day, this chart is obtained.
In this chart, on January 3, 2022, a large amount of RUNE was active in one or more wallets, which shows us this leap. On this day, the number of active wallets was 230

This diagram shows the number of users who have opened the LP position but have not yet removed_liquidity over time.
A large number of LP positions have been removed since early 2021.
As of November 3, 371 users have add LP position and have not yet remove it

This chart shows the amount of open LP position in $ RUNE over time.
In March and April 2022, most LP volumes were opened by users and have not been removed yet.

Conclusion

46.3k users are currently in the ecosystem.
Each user has an average of 14.55 $RUNE in their wallet and the total $RUNE in the wallet is 2.018B
total users have open LP position and they have not remove it is 5170 user and amount of this liquidity pool is 7.11M in $RUNE
The trend from May 2022 can be said to have had an upward slope, but due to the general market conditions could not increase.
The highest RUNE in the liquidity pool is BTC-BTC