piperSolana - Network Performance Dashboard: Users vs. Bots
Updated 2022-07-13
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
29
30
31
32
33
34
35
›
⌄
⌄
/*
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?
*/
WITH all_transactions AS (
SELECT
block_timestamp::date AS date,
COUNT(DISTINCT(tx_id)) AS number_of_transactions,
instruction:parsed:info:source as wallet_address,
FROM
solana.core.fact_events
WHERE
block_timestamp BETWEEN '2022-01-01' AND '2022-01-30'
GROUP BY date, wallet_address
ORDER BY date ASC
)
SELECT
wallet_address,
MAX(number_of_transactions) as number_of_transactions
FROM
all_transactions
GROUP BY wallet_address
/* The End! */
Run a query to Download Data