par_rnsolana 1
Updated 2024-11-14
9
1
2
3
4
5
6
7
8
9
›
⌄
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 (UNIQUE_SIGNERS_COUNT) AS users,
SUM (TOTAL_FEES_USD) AS fees
FROM solana.stats.ez_core_metrics_hourly
WHERE date >= current_date-30
GROUP BY 1
QueryRunArchived: QueryRun has been archived