amirkhannoriiavg paid fee
Updated 2024-03-20
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT AVG(fee/pow(10,9)) as "Average Paid Fees",
sum (fee/pow(10,9)) as "total paid fee",
count (distinct TX_ID) as "Total number of transactions",
count(distinct SIGNERS) as "users",
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"
FROM solana.core.fact_transactions
where BLOCK_TIMESTAMP>=current_date - 7
QueryRunArchived: QueryRun has been archived