Calculate the total Solana JITO tips and priority fees for each hour of the previous day. The result should include 48 values (24 hours × 2 metrics) and the query code used to obtain them.

Solana data:

You can get the data from one of the open free analytical sources Dune CryptoHouse FlipsideCrypto (If you know another open data source, please comment!)

Data can also be obtained directly from the archival RPC node, but access to RPC could cost a significant sum of money. This is not a simple engineering task.

Correctness criteria:

No value should deviate by more than 1% from the correct values.

FAQ:

Q: Should we include the regular fees of 5000 lamports in our calculations as part of the priority fees for this task?

A: I will consider the answer correct if the minimum fee is excluded and if it’s included because the initial question phrasing wasn’t clear.

Q: Should we include priority fees for failed transactions?

A: Yes

Q: What time should be used?

A: UTC

Q: What is JITO?

A: What is JITO

Q: What are priority fees?