Query editor
SELECTDATE_TRUNC('hour', block_time AT TIME ZONE 'UTC' AT TIME ZONE 'GMT+8') AS time,AVG(gas_price / 1e9) AS average_gas_price,APPROX_PERCENTILE(gas_price / 1e9, 0.5) AS median_gas_priceFROM ethereum.transactionsWHERE block_time > NOW() - INTERVAL '7' dayGROUP BY 1ORDER BY time ASC;