Q1: Volume of ALGOs swapped for goMint by day on each DEX

To address this question, we first need to filter the swaps to goMint in the swap table. Then we group the total volumes according to the day and dex and arrange them in descending order based on the day.

Q2: Number of swaps and the number of wallets by day by DEX for goMINT/algo swaps

To address this question, we must first filter out the swaps that have been swapped to goMint from date '2022-03-30' and '2022-04-05'. Then group the swap list and wallet list by dex and day. We used a distinct (swapper) to calculate the number of wallets, because we may have 7 million swaps on this date, which was unique for 200,000 wallets.

Q3- Chart the average swap price

To address this question we need to filter the swap list for goMint done on 2022-03-30. Then we divide the sum price from / to swaps by the total number of swaps to calculate the average price. Then we group based on 24 hours a day for each dex

In this chart, it is clear that the average price in algofi was almost constant until 3 pm, then decreased from 3 pm and fluctuated after that. But for the tinyman, the price was initially reduced, then between 9 and 11 o'clock there was a pump, and the price has risen significantly and fluctuated again. On pactfi, prices were balanced and mostly volatile. Also, the highest average price was on tinyman

conclusion

Based on the results and all charts of the three question : As usual, we have the largest swap volume, number of swaps and a unique wallet at the beginning of the goMint launch. Also according to these results, the largest swap volume, number of swaps and the number of unique wallets are related to tinyman dex. Interestingly, the swap volume at the beginning of the launch was higher on the pactfi dex, and over time the swap volume on the tinyman dex increased.