One of the main advantages for a user of Algorand is the extremely low fees relative to other blockchains.

In this dashboard, we are gonna explore the Algorand blockchain to find:

• The cost of transaction fees per day accumulated since the beginning of January 2022
• What wallets have conducted the most transactions and spent the most on fees?
• How much have users on Algorand spent on transactions in total? 

First Query and its Main table (flipside_prod_db.algorand.transactions).

The mentioned table has been used to querying in all segments.

SELECT
  SUM(FEE) AS paid_fees
FROM flipside_prod_db.algorand.transactions
WHERE BLOCK_TIMESTAMP::date >= '2022-01-01'
AND FEE IS NOT NULL

It’s obvious that there is a Peak-day (Jan 7, 2022) in our data. Hourly Data has been extracted, so we can get focused on this day.

By the way, the base fee for the Algorand ecosystem is 0.001 ALGO. In order to have a better insight, I decided to declare a new variable, mCount, which represents count/1000. The new variable helps us to find some outliers.

Transaction fees, Jan 7, 2022

Top n Wallets

Regarding this assumption that 0.001 $ALGO is a base fee for Algorand transactions, we expect a linear correlation between the total count of transactions and the total paid fees, but there are two accounts that have paid an abnormal total fee since Jan 01, 2022.

First account: EKJQZGJOYCGCOALPS6VDDF5QU5PDMNZWHEAKDJ5AR3HHKPWWJDECHKDRB4

Second account: J4BJWP67LHXT7LQTWZYWJGNSB25VZMO6SFZPKBSY7HJUCXJIFVE2PEOTVA

It seems one of these accounts (The first one) is connected to an automated script that has been configured to broadcast transactions with 0.247 $ALGO as the base fee.

P.S.: Maybe it belongs to a Crypto-currency exchange.