Query editor
1SELECT block_time, hash, (gas_price/1e18) AS gas_price_eth 2FROM ethereum.transactions 3WHERE block_time > NOW() - INTERVAL '1' DAY 4ORDER BY gas_price DESC 5LIMIT 10;
SELECT block_time, hash, (gas_price/1e18) AS gas_price_eth
FROM ethereum.transactions
WHERE block_time > NOW() - INTERVAL '1' DAY
ORDER BY gas_price DESC
LIMIT 10;