Sbhn_NPArbitrum
    Updated 2024-08-21
    select date_trunc('month',BLOCK_TIMESTAMP_HOUR) as date,
    sum(TRANSACTION_COUNT) as transactions,
    sum(TRANSACTION_COUNT_SUCCESS) as success_txs,
    sum(TRANSACTION_COUNT_FAILED) as failed_txs,
    sum(UNIQUE_FROM_COUNT) as users,
    sum(TOTAL_FEES_NATIVE) as fees_arb,
    sum(TOTAL_FEES_USD) as fees_usd
    from arbitrum.stats.ez_core_metrics_hourly
    group by 1
    QueryRunArchived: QueryRun has been archived