par_rnNEAR 1
Updated 2024-11-17
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_FROM_COUNT) AS users,
SUM (TOTAL_FEES_USD) AS fees,
FROM near.stats.ez_core_metrics_hourly
WHERE date >= '2024-01-01'
GROUP BY 1