date_trunc('hour', block_timestamp) as date,

count(*) as no_of_txs,

count(case when status = 'SUCCESS' then 1 end) / count(*) as pct_of_successful_txs,

count(distinct from_address) as no_of_users,

avg(tx_fee) as avg_tx_fee,

sum(tx_fee) as total_tx_fee,

count(*) / (60*60) as tps

from arbitrum.core.fact_transactions

group by 1

order by 1