date_trunc('month', block_timestamp) as month,

count(tx_hash) as volume,

sum(tx_fee) as total_transaction_fee,

avg(tx_fee) as avg_transaction_fee,

count(distinct from_address) as active_users,

sum(value) -- total value transacted in eth

from berachain.testnet.fact_transactions

where block_timestamp::date >= '2024-06-09' -- Berachain officially launched version 2 of its testnet called bArtio

group by 1