Query editor
selectdate_trunc('day', block_time) as Day,count(*) as NumberOfTransactions,count(distinct from) as DailyUsers,avg(gas_used) as AverageGasUsedfrom arbitrum.transactionsgroup by Day
Query editor
1select2date_trunc('day', block_time) as Day,3count(*) as NumberOfTransactions,4count(distinct from) as DailyUsers,5avg(gas_used) as AverageGasUsed6from arbitrum.transactions7group by Day