par_rnbase
Updated 2024-10-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT DATE_TRUNC ('day', BLOCK_TIMESTAMP_HOUR ) as date,
SUM (TRANSACTION_COUNT) AS transations,
SUM (TRANSACTION_COUNT_SUCCESS) AS successful_transactions,
SUM (TRANSACTION_COUNT_FAILED) AS failed_transactions,
SUM (UNIQUE_FROM_COUNT) AS users,
SUM (TOTAL_FEES_USD) AS fees
FROM base.stats.ez_core_metrics_hourly
WHERE date >= current_date-30
GROUP BY 1
QueryRunArchived: QueryRun has been archived