Yet Another Acme Question
Q184. Refer to submissions for #175 - your own, or those of others. Pick your favourite Terra metric or visualization and recreate your own version. Your SQL can be similar or even identical to the original, but you should put your own narrative and explanation. Why is this metric/visualization your favourite? If you improved it, what changes did you make?
Introduction
In the previous Bounty (Q175), I have analysed a dashboard that included a metric that analysed data from the Mars protocol. This Bounty will recreate what I have discussed in the previous Bounty. The query that I have written includes more data analysis compared to what I liked on the dashboard, as I have divided the analysis into daily and weekly time frames - I also wanted to include the monthly overview, however, it doesn't really make sense in this specific case, as Mars has launched only over a month ago so the visualisation wouldn't be very insightful.
The data mentioned in Q175 only consisted of a simple price chart of the Mars token and how it changed over time. I thought it would be more insightful to show how much has been deposited and withdrawn from the Mars protocol, as it allows us to see how much interest there has been since the launch of the platform. We can see here the two biggest spikes - the first initial one on March 29th 2022 being the day with the biggest amount of USD deposited, and April 11th 2022 being the day with the biggest amount of USD withdrawn.
This chart presents how much Mars has been used to borrow USD and how much of it has already been repaid by users. We can see that the amount borrowed on a daily basis stays pretty much within 10M $ per day, with the exception of a few spikes, for example on March 19th 2021, when 26.8M $ has been borrowed. On the other hand, we can also see that the amount of USD repaid has been slow in the beginning, but users have been repaying their debts, with the biggest spike of the amount repaid being on April 11th 2022 with the amount of 36.5M $!
This section of this dashboard shows the weekly behaviour of inflows and outflows for Mars. As mentioned before, the data in the dashboard in Q175 wasn't very insightful as it was simple. Here we can see more in-depth patterns, as we can see what weeks were better or worse for the protocol. In other words, we can see when Mars was popular for depositing USD and when people were withdrawing their money from it.
Similarly here, we can see how much has been borrowed and repaired on a weekly basis. What we can analyse from this chart is the huge amount of money that has been repaid very recently, in the second week of April 2022. I believe that those metrics are more insightful than just showing the price of Mars over time, as we can see the popularity and the usefulness of the protocol itself as well.
Conclusion
Firstly, I would like to say that I really enjoyed this Bounty! It seems like a great idea to be able to refer to your own previous work and see how it can be improved. I think that the SQL query and the visualisations that I have provided in this Bounty show what kind of data is useful and insightful. Personally, Mars is one of my favourite Terra protocols, and therefore I thought I will focus on writing more metrics for this one protocol in particular. If I had more time to write the queries, I would probably include more data analysis, such as the comparison of how Mars price behaved when money was deposited/withdrawn from Mars, or maybe even do a comparison of two different protocols over time. For example, I think it would be interesting to see if there is any correlation between Mars and Anchor - if people are withdrawing from one and depositing to the other one, or borrowing from one and depositing it to the other.