CryptoIcicleSolana-95.Network Performance Dashboard - Failed ProgramId
Updated 2022-07-10
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
›
⌄
-- Q95. Create a dashboard displaying Solana network performance over time.
-- Payout 1.385 SOL
-- Grand Prize 4.16 SOL
-- Level Beginner
-- 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?
-- NOTE: This bounty will be paid on the Solana network. Please give your Solana address when submitting
with txns as (
select
instructions[0]:programId as program_id,
signers[0] as wallet,
fee/1e6 as fee_sol
from solana.core.fact_transactions
where succeeded = 'FALSE'
and block_timestamp::date >= '2022-01-01'
)
select
program_id,
sum(fee_sol) as fee_sol_total
from txns
group by program_id
order by fee_sol_total desc
limit 100
Run a query to Download Data