Blocks

Get Latest Block Number
Gets the number of the latest block in the chain.
Typical query time: < 1 second.
Ethereum
Polygon
SELECT max(number) AS latest_block_number
FROM eth.recent_blocks
SELECT max(number) AS latest_block_number
FROM polygon.recent_blocks
Blocks from the last 4 hours
Gets basic information for the blocks of the last 4 hours in the chain.
To get access to more than 500 results, use the Apache Arrow Flight API.
Typical query time: 2 seconds
Ethereum
Polygon
SELECT number, "timestamp", hash, transaction_count, gas_used
FROM eth.blocks
WHERE "timestamp" > UNIX_TIMESTAMP() - 4 * 60 * 60
ORDER BY number DESC
LIMIT 1000
SELECT number, "timestamp", hash, transaction_count, gas_used
FROM polygon.blocks
WHERE "timestamp" > UNIX_TIMESTAMP() - 4 * 60 * 60
ORDER BY number DESC
LIMIT 1000
Most Ethereum Burned in a Block
Returns a list of the blocks with the highest amount of Ethereum burned, sorted in descending order.
Typical query time: 2 seconds
This query only works for Ethereum
SELECT number,
 sum(gas_used * (base_fee_per_gas / 1e18)) AS eth_burned
FROM eth.blocks
WHERE base_fee_per_gas IS NOT NULL
GROUP BY eth.blocks.number
ORDER BY eth_burned DESC
LIMIT 500
Get a Random Block
Gets basic information about a random block in the chain.
Typical query time: <3 seconds
Ethereum
Polygon
WITH random_block AS (
 SELECT mod(cast(floor(random() * 1e9) AS numeric), latest_block.number) AS number
 FROM (
 SELECT max(number) AS number FROM eth.blocks
 ) AS latest_block
)
SELECT number, "timestamp", hash, transaction_count, gas_used 
FROM eth.blocks
WHERE number = (SELECT number FROM random_block)
WITH random_block AS (
 SELECT mod(cast(floor(random() * 1e9) AS numeric), latest_block.number) AS number
 FROM (
 SELECT max(number) AS number FROM polygon.blocks
 ) AS latest_block
)
SELECT number, "timestamp", hash, transaction_count, gas_used 
FROM polygon.blocks
WHERE number = (SELECT number FROM random_block)
Blocks with the Highest Number of Transactions in last 4 hours
Gets the list of blocks with the highest number of transactions that were included in that block, sorted in descending order.
Typical query time: 5~10 second
Ethereum
Polygon
SELECT number, "timestamp", transaction_count, gas_used
FROM eth.blocks 
WHERE "timestamp" > UNIX_TIMESTAMP() - 4 * 60 * 60
ORDER BY transaction_count DESC 
LIMIT 10
SELECT number, "timestamp", transaction_count, gas_used
FROM polygon.blocks 
WHERE "timestamp" > UNIX_TIMESTAMP() - 4 * 60 * 60
ORDER BY transaction_count DESC
LIMIT 10

Last modified 6mo ago