sum(transaction_count) as txs,

sum(unique_from_count) as users,

sum(TRANSACTION_COUNT_SUCCESS) as success,

sum(TRANSACTION_COUNT_FAILED) as failed,

(txs/success)*100 as percent,

sum(total_fees_native) as fees_flow

from flow.stats.ez_core_metrics_hourly

where BLOCK_TIMESTAMP_HOUR::date >= '2024-01-01'