count(distinct tx_hash) as tx_count,

count(distinct from_address) as user_count,

sum(value) as volume,

sum(tx_fee) as tx_fees,

count(distinct case when TX_SUCCEEDED = 'TRUE' then tx_hash end ) as succeed_txns,

(succeed_txns / tx_count ) * 100 as success_rate,

avg(tx_fee) as avg_fee_per_tx

from boba.core.fact_transactions