Method :

I used flipside_prod_db.thorchain.swaps for extracing Thor swaps data . I consider from_asset = 'THOR.RUNE' and to_asset = 'THOR.RUNE' in two different subquery.

• About 30% of wallets have swapped_from between $10 and $100 RUNE.
• About 22% of wallets have swapped_from less than $10 RUNE.
• About 27% of wallets have swapped_to between $10 and $100 RUNE.
• About 24% of wallets have swapped_to less than $10 RUNE.

• The volume of swaps has increased sharply since March 2022, peaked in April 2022, and then decreased. The cumulative graph of the volume of swaps has also taken a steep slope since February 2022.

• we can see a total increasing trend in number of swaps on Thorchain over time. Also We can see the share of swaps with $1K to $2.5K and also $500 to $1K volume is increasing over time.
• we can see an almost close compete between growth rate of swaps with different volume sizes.

• The BNB.BNB pool swap size for less than 10 $RUNE is most popular swap size. After that ETH.ETH and BTC.BTC pools have been more popular than others.

• based on swap size in USD BNB.BNB is most popular pool. After that ETH.ETH and BTC.BTC pools have been more popular than others.

Concolusion :

From the above analysis, we get the following results:

1. About 30% of wallets have swapped_from between $10 and $100 RUNE.
2. About 22% of wallets have swapped_from less than $10 RUNE.
3. About 27% of wallets have swapped_to between $10 and $100 RUNE.
4. About 24% of wallets have swapped_to less than $10 RUNE.
5. The volume of swaps has increased sharply since March 2022, peaked in April 2022, and then decreased. The cumulative graph of the volume of swaps has also taken a steep slope since February 2022.
6. The total increasing trend in number of swaps on Thorchain over time. Also We can see the share of swaps with $1K to $2.5K and also $500 to $1K volume is increasing over time.
7. almost close compete between growth rate of swaps with different volume sizes.
8. The BNB.BNB pool swap size for less than 10 $RUNE is most popular swap size. After that ETH.ETH and BTC.BTC pools have been more popular than others.
9. based on swap size in USD BNB.BNB is most popular pool. After that ETH.ETH and BTC.BTC pools have been more popular than others.