amirkhannoriiSolana Paid Fee Hourly
Updated 2024-03-20
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT AVG(fee/pow(10,9)) as "Average Paid Fees",
count (distinct TX_ID) as "Total number of transactions",
count ( distinct case when SUCCEEDED= 'false' then TX_ID end) as "Number of Failed Transactions",
count ( distinct case when SUCCEEDED= 'true' then TX_ID end) as "Number of Successful Transactions",
("Number of Failed Transactions"/"Total number of transactions")*100 as "ratio of failed transactions",
DATE_trunc('hour',block_timestamp) as hour
FROM solana.core.fact_transactions
where BLOCK_TIMESTAMP>=current_date - 7
group by hour
QueryRunArchived: QueryRun has been archived