mo115# transactions + Fees *
Updated 2024-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from # transactions @ https://flipsidecrypto.xyz/edit/queries/d7daa758-cc9a-4064-986c-4603dbacc4dd
select
date_trunc('day',BLOCK_TIMESTAMP_HOUR) as date
, sum (TRANSACTION_COUNT ) as Transactions
, sum (TRANSACTION_COUNT_SUCCESS ) as "Successful Transactions"
, sum (TRANSACTION_COUNT_FAILED ) as "Failed Transactions"
, sum (TOTAL_FEES_NATIVE/1e9 ) as "Fees (SOL)"
---, sum (TOTAL_FEES_USD ) as "Fees (USD)"
, sum(Transactions) over (order by date) as "Cumulative Transactions"
, sum("Fees (SOL)") over (order by date) as "Cumulative Fee (SOL)"
---, sum("Fees (USD)") over (order by date) as "Cumulative Fee (USD)"
from solana.stats.ez_core_metrics_hourly
where date >= current_date - 30
group by 1
QueryRunArchived: QueryRun has been archived