count(tx_hash) as transactions,

count(distinct from_address) as unique_users,

sum(gas_used) as gas_used,

sum(gas_price) as gas_price,

sum(eth_value) as value,

sum(l1_fee) as posting_fees,

sum(l1_gas_used) as l1_gas

FROM base.core.fact_transactions

GROUP BY 1