Typical query time: ~60 seconds
SELECT DATE_TRUNC('day', TO_TIMESTAMP("timestamp")) AS day, SUM(gas_used) AS total_gas FROM eth.blocks GROUP BY day ORDER BY total_gas DESC LIMIT 10;
Last updated 6 months ago