Using the near.core.fact_transactions table and adding up the value of gas_used and converting them to the real value, we calculated the total fee value and then grouped them based on the contract using group_by.

As we can see, aurora has the highest gas_used value by a large margin, followed by app.nearcrowd.near and v2.nearapps.near. In this chart, we obtained 20 contracts that used the most gas

When we grouped the amount of gas according to the day, the above graph was obtained, which shows the last 7 days, which has always decreased during these days. compared to the first day, i.e. the last 7 days, it has decreased by about 75%

Conclusion

According to the results we see from the monthly chart, we understand that the increase shown on the last day of the 7-day chart is temporary and the average value is closer to other days.

The last chart shows the amount of gas used in over time

Introduction

What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?

\n

Hint: The gas units in the table are in raw (not decimal adjusted) format. To adjust accordingly, divide by 10^12.