Terra - 3. Terradash Part 1: Activity

    Loading...

    What is this dashboard about?

    this dashboard would walks you through Terra network for “Terra - 3. Terradash Part 1: Activity” bounty on MetricsDAO.

    here is main metrics that are analyzed in this dashboard:

    • Transactions
    • Average Transaction Fee per txn per week
    • Total Transaction Fees per week
    • Total number of transactions per week
    • Average transactions per second (TPS) per week
    • Average block time per week
    • Wallets
    • Total number of new wallets per week
    • Total number of active wallets per week
    • Only include senders who initiate transactions
    • Cumulative number of new wallets per week

    What is the Methodology?

    Flipsidecrypto Terra database is used for this dashboard.

    also all data have been filtered to start from 1st January of 2022, although after Terra crashed there is some days that data are missing or probably Terra were halted.

    main tables used are:

    • fact_transactions
    • fact_blocks


    all data has been filtered to start from 1st Jan 2022 but as mentioned, some data are missing.

    this chart shows average transaction fee per txn per week.

    transactions fees per week are almost stable in most weeks of 2022.

    at the last weeks we see a decreasing fee for transactions.


    Contact me on Twitter

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...


    here is Terra’s total transaction fee group by weeks of 2022.

    as we saw in the previous table, fees are decreasing in the last weeks on the chart.


    as fees were decreasing, in this chart we see that total number of transactions per week are growing.

    in the recent weeks, number of transactions are higher than almost most of other weeks of 2022.


    What is TPS?

    simply it’s Transaction Per Second. which is a very important metric for every network.

    here is average TPS per week for Terra from Jan 2022.

    almost TPS is stable and in a range between 1 and 2.


    this chart is filled with Terra average block time per week in 2022.

    the amounts on the chart are by seconds.

    what we have done is that we calculated time difference between two blocks and then calculated average time.

    average block time for Terra is between 6 and 6.1 in most of the weeks.


    here we have found total number of new wallets per week.

    methodology is that we have found each wallet and it’s first transaction time as a sender.

    so in a day, all wallets that their first transaction was in that day are counted as new wallets.


    this chart is as the same as previous one and it just has cumulative number of new wallets.


    every wallet that has a transaction as sender in a day is counted as active wallet.

    so this chart is number of active wallets per week in 2022.

    number of active wallets are in a stable trend.

    Some useful data from Terra network