Query editor
SELECTDATE_TRUNC ('month', block_date) time,AVG(gas_price / 1e9) as average_gas_price,APPROX_PERCENTILE(gas_price/1e9, 0.5) AS median_gas_priceFROM ethereum.transactionsWHERE block_time >= CAST('2015-10-01' AS TIMESTAMP)GROUP BY 1ORDER BY time ASC