ethereum.blocks

Description of the ethereum.blocks table on Dune

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

Datatypes on Snowflake datashare are different in some cases, read more here.

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