par_rnEclipse 01
Updated 2025-02-19Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP_HOUR) AS date,
SUM(TRANSACTION_COUNT) AS total_transactions,
SUM(TRANSACTION_COUNT_SUCCESS) AS successful_transactions,
SUM(TRANSACTION_COUNT_FAILED) AS failed_transactions,
SUM(UNIQUE_SIGNERS_COUNT) AS unique_users,
SUM(TOTAL_FEES_USD) AS total_fees
FROM
eclipse.stats.ez_core_metrics_hourly
GROUP BY
1
ORDER BY
date
QueryRunArchived: QueryRun has been archived