ethereum.blocks

​

Table Description

The ethereum.blocks table contains information about blocks in the Ethereum blockchain. A block is a collection of transactions that are hashed and added to the blockchain. Each block contains a reference to the previous block, known as the parent hash, and a timestamp. The table contains information about each block, such as the block number, the block hash, the block size, the number of transactions, and the gas used.

​

Column Descriptions

​

Table Sample

​

Examples

​

Show the most recent blocks

SELECT
  number,
  hash,
  size,
  gas_used
FROM
  ethereum.blocks
ORDER BY
  number DESC
LIMIT 10

​

Show the number of blocks mined each day

SELECT
  date_trunc('day', time) AS day,
  count(distinct number)
FROM
  ethereum.blocks
GROUP BY
  day
ORDER BY
  day DESC

​

Show the number of transactions in each block

SELECT
  number,
  count(*)
FROM
  ethereum.blocks
group by 1 

LIMIT 10