Goal:

show the swap volume and the liquidity after its first week going live.

Solution:

In this dashboard, we are asked to find the swaps volume and liquidity in all the pools, regardless of the first week they were launched.

To skip the first week, I got the first transaction date for each pool, then 7 days later.

I also used the swaps table to get the swap volume and the liquidity_actions table to get liquidity.

Swaps volume:

Now let's see the swaps volume per pool on Thorchain network.

According to the above chart, you can see the swaps volume of each pool on Thorchain. As you can see BNB.BUSD has the most swap volume among other pools with more than 3B $ and after that is BTC.BTC with more than 1B $ on it.

I show the 10 most swaps volume pools in the next chart.

Liquidity:

To answer this question I consider two following conditions:

1. if lp_action = 'add_liquidity' then sum the rune_amount_usd and asset_amount_usd
2. if lp_action = 'remove_liquidity' then sum the -rune_amount_usd and -asset_amount_usd

Now let's see the liquidity per pool on Thorchain network.

According to the above chart, you can see the liquidity of each pool on Thorchain. As you can see BTC.BTC has the most liquidity among other pools with more than 100M $ and after that is ETH.ETH with more than 70M $ on it.

I show the 10 most liquidity pools in the next chart.

Conclusion:

BNB.BUSD is the pool with the most swaps volume pool and BTC.BTC is the pool with the most liquidity pool.