Our main goal in this analyse is answering below questions:

Plot the average transaction fee grouped by hour. Use data from the last seven days (or more).

Show the total number of transactions per hour during the last seven days (or more).

Similarly, show the total number of failed transactions per hour. Show data from the last week (or more).

Plot the ratio of failed transactions per hour during the last seven days (or more).

Methodology

To figure out the answer of above questions I made this dashboard using Flipsidecrypto database and tools.
Main database that help me out to extract data was solana.core.fact_transactions table.
In order to find failed transactions on it I used SUCCEEDED = 'false'.
I limited all my results by block_timestamp >= '2023-04-01' to show them since the first day of April until today which is basically the last 10 days.

Takeaways

Since the beginning of April 2023 until day 10th more than 324M transactions created on Solana.

Average fee of these transactions are 7.4K lamport.

More than 63M of these transactions became failed.

Average transactions made on Solana chain per hour was 1.4M

Also Average failed transactions per hour was almost 264K

Average ratio of failed transactions was %19.5

Total transactions made on Solana network since April is 324M number.

Average transaction fee from this date is 7.4K lamport. According to Solana docs A lamport has a value of 0.000000001 SOL. This unit named in honor of Solana's biggest technical influence, Leslie Lamport.

Average fee on hourly visual doesn't show that transactions fee are going up or down but we can see that there are some hours people spent more fee than others.

Lowest number of transactions on Solana since the beginning of April is 1.13M transactions and highest number of them is 1.81M transactions that happened on the April 3th right after it's saw the bottom.

In this section I've showed some visuals that tells us more about transactions on Solana.
Results indicates that since the beginning of April average failed transactions on Solana per hour is 263.9K .
Total number of failed transactions since April is 63.3M and average transactions per hour is 1.4M .
So far, Ratio of failed transactions per hour is %19.5 .
Hourly visual of total transactions and failed ones shows highest ratio of failed transactions is %28 and lowest amount is %13.5