Query editor
WITH txs AS (SELECT DISTINCT evt_tx_hash AS tx_hashFROM mantle_ethereum.meth_evt_transferWHERE evt_block_time >= TIMESTAMP '2025-01-01')SELECTdate_trunc('day', t.block_time) AS date,count(*) AS tx_count,avg(t.gas_used) AS avg_gas_used,approx_percentile(t.gas_used, 0.95) AS p95_gas_usedFROM txs xJOIN ethereum.transactions tON t.hash = x.tx_hashGROUP BY 1ORDER BY 1;