Conclusion

In conclusion, the transfer ratio holds truest to the total overall transaction ratio, however, it doesn't have much correlation to the number of events. It does have a strong association with the amount of gas used.

Specific Events and Fees

Looking at the following three graphs, we can see that the value of staking fees to staking volume and swap fees to swap volume is much lower than the transfer fees to transfer volume by a magnitude of x10^5. In addition, the swap and staking ratios have almost no correlation to the gas used. On the other hand, the ratio of transfer fees to transfer volume has the most correlation to the total number of events.

Transactions and Transaction Fee Ratios

ratio calculations: fees_USD/volume_USD

The next two graphs show the ratios of transaction fees to the transaction volume and number of transactions. See that the ratio does not correlate to the number of transaction events! For example, June 18 and 19 had a decreased number of transaction events, but the ratios are some of the highest seen in the last 60 days. With regards to the next graph which looks at the ratio of transaction fees to the number of transactions, we can see that the ratio follows the same trend as the gass_difference which is equal to gas_wanted - gas_used.

Introduction

This dashboard utilizes the terra.transactions table as well as the staking, swap, transfer and oracle_prices tables. terra.transactions.fee was given in a currency, therefore to compute a USD value, a CASE statement was used to multiply the fee value by the hourly average oracle price. All values for volume were converted to USD before any other calculation was done.

Transaction events were broken down into 3 types of events: staking, swaps, and transfers.

Sanity note - there are some missing transactions in the tables which may render some of the data somewhat inaccurate.

Transactions

The graph below shows the breakdown of transaction events into the 3 aforementioned categories: staking, swap, and transfer. From the graph, we can see that >80% of the events spawn from transfers, with swaps and staking events holding at the low thousands (1000-2000 on average). Notice that the gas_used doesn't really correlate to the number of transactions per day.