SELECT

date_trunc('day', block_timestamp) as day,

count(DISTINCT tx_hash) as transactions,

count(DISTINCT from_address) as users,

sum(l1_gas_price) as total_l1_gas_price,

sum(tx_fee) as total_tx_fee,

avg(tx_fee) as avg_tx_fee

from base.goerli.fact_transactions

GROUP BY 1