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 BLOCK_TIMESTAMP_HOUR::date >= '2024-01-01'