Tokenflow Trailblazers

    Q1. Dive into the Tokenflow data and tell us what you find. Conduct a brief analysis on a topic of your choice, with at least 1 data visualization and a succinct paragraph describing your findings. Additionally, share your experience with the data: was anything missing that you expected to find, were there difficulties you encountered, was there documentation you desired, etc? How does this data change the way you think about and analyze Ethereum data? Helpful Resource: https://ath.mirror.xyz/lcZzeBcfpmfQlIHqUBmNAmv5EeVfNBGmr-S7mkWcuyo

    Tokenflow brings another dimension in crypto data analysis. Thanks to the data provided by Tokenflow, Ethereum data can be fully analyzed with more detail and new metrics can be found and investigated.

    In this dashboard, I have investigated about the Ethereum trasnactions failure rate. In concrete, we are gonna see:

    • The Ethereum failure rate over time
    • The Ethereum volume over the same time versus the average gas price in a daily basis
    • Failure rate compared against gas price
    • Failure rate depending on transactions done when gas price high or low
    Loading...

    As we can see the Ethereum transactions remained constant over time. The failure rate increased a little bit during January, however, since Feburary, the dynamic is downside.

    Loading...

    About the Ethereum voluem and the average gas price, it can be seen how both increased during the first days of January and then started to go down. It is clear that there is a positive and string correlation between both metrics and then, for the rest of the analysis we will only use one of them. In this case, we will compare the failure rate against average gas price.

    Loading...

    In this above chart, we can see how there is also a positive correlation between both metrics. When average gas price is high, more transactions tend to fail. Then, the transactions use to fail more times when the gas price is higher.

    Loading...

    To finally corroborate the previous assumption, thanks to Tokenflow data we can also analyze the failure rate when the gas price is high or low and compare it. As well, we can see how when the average is low, the users tend to do more transactions but the failure rate is lower.

    Conclusions

    In this dashboard, we have analyzed several metrics taking into account Ethereum transactions that have been able to solve thanks to Tokenflow data. Instead of Ethereum tables, Tokenflow data have aggregated some other info about transactions like the amount transacted as well as gas price.