Query editor
WITH daily_stats AS (SELECTDATE_TRUNC('day', block_time) AS day,COUNT(DISTINCT "from") AS active_users,COUNT(*) AS transaction_count,SUM(gas_used * gas_price) / 1e18 AS total_gas_ethFROM ethereum.transactionsWHERE block_time >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY DATE_TRUNC('day', block_time))SELECTday,active_users,transaction_count,ROUND(total_gas_eth, 2) AS total_gas_eth,ROUND(transaction_count * 1.0 / active_users, 2) AS avg_txs_per_userFROM daily_statsORDER BY day DESC