solving method:

This review has one important point and that is the lack of attention to dual swaps As discussed on the FlipSide Discord server:

> Basically Thorchain pools are only RUNE-xxx. For example, if you want to swap BTC for ETH their will be two swaps BTC-RUNE and RUNE-ETH. So, any transaction with two swaps are not a swap of RUNE for something, RUNE is only used as an intermediary. The sample query just tell > you what transaction to filter.

Now to draw the trends, you need to filter the data properly Draw the desired diagrams and examine them

day_based charts

In these charts, the general trend of users can be seen Also in the second diagram, the total amount of fee is categorized by day

There are several points about the first diagram :

• First, the chart does not have data on dates, and this has led to the loss of chart continuity

• Secondly, there is not necessarily a direct relationship between unique users and the total number of users in one day. For example, on November 27, 2021, there were a large number of users, but there were few unique users, but on the other hand, on April 8, the number of unique users was large and the total number of users was relatively small.

• Third, the general trend is bullish, and especially in recent months, this bullish trend has accelerated

Regarding the second diagram, it can be said that because the general shape of the diagram is very similar to the first diagram, then it can be concluded that the total amount per swap is very dependent on the number of users who use the network.

In this last table, we can see the sum of the three values : users , unique users and fee_usd