piperSolana - Network Performance Dashboard: Users & Transactions
Updated 2022-07-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
⌄
/*
Twitter: @der_piper
Discrod: piper#6707
Solana - Network Performance Dashboard
Q95. Create a dashboard displaying Solana network performance over time.
How has the network performed over the past month compared to the rest of the year?
Has transaction per second and success rates of transactions gone up recently? Is
this because of less botting or fewer users, or new improvements from the Solana
engineers? What wallets and programs have paid the most in fees for failed transactions?
*/
SELECT
block_timestamp::date AS date,
COUNT(DISTINCT(signers)) AS number_of_users,
COUNT(DISTINCT(tx_id)) AS number_of_transactions,
number_of_transactions/number_of_users AS average_transactions_per_user
FROM
solana.core.fact_transactions
WHERE
block_timestamp::date BETWEEN '2022-01-01' AND '2022-07-10'
AND
succeeded = 'True'
GROUP BY date
/* The End! */
Run a query to Download Data