count(distinct tx_hash) as transactions,

count(distinct from_address) as users,

sum(tx_fee) as total_tx_fee,

avg(tx_fee) as average_tx_fee,

transactions / count(distinct date_trunc('second', block_timestamp)) as tps

avalanche.dexalot.fact_transactions

year(block_timestamp) >= 2025