Blocks

Blocks are the building blocks of blockchains and rollups.

A block contains transactions which will alter the state of an EVM system incrementally. Transaction within a block can only be executed one after the other, not in parallel.

Learn more in the official Ethereum documentation here.

Sample Query

Querying the latest blocks produced.

select *
  from ethereum.raw.blocks
order by timestamp desc 
limit 100

Table Columns

Column Name
Description
Example

timestamp

The unix timestamp for when the block was collated.

2023-02-03 00:22:47

number

The length of the chain, in blocks.

16,544,661

hash

Unique identifier for that block.

0xf20ff90876535215fbde9560b00dd6d77764d29bdbbee095c1c1b6c217bf522a

parent_hash

Unique identifier of the block preceding this block, also known as the parent block.

0xfc540fac4c549a6bdfde197a765cf5d68add9977bf6750768fc2995550ffbd47

nonce

Proof of Stake: Unused post Merge. The value will always be 0x0000000000000000

Proof of Work: Used to demonstrate proof of work during mining

0x0000000000000000

sha3_uncles

An array of uncle hashes.

0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347

logs_bloom

The bloom filter for the logs of the block.

0x1de564d6d4e217110e204155832ae2b01b081c000a04124702b152025c9626639f50e08697ae01a55358d1504399dd86e7231e298ae835884368014540afa3a00e47590011024ddcb849488a5a203060760d29503045094314003a62cb50184076912942f202306a08601dd36a0a9cb1d51b5f660a166e0c96aec7f0f2a867860e238be752670606354fc48a8347e94738833d0d4308e67b3c44836e817872258f199195099062b6612191dc9028cec8afac0247cf455ebb5cf1ae7ea040195eed10151228000cf225243c2e4e4f3a89c66226f716fe93d902a76942901ae0272f9af0b9a679859e2095edc4a2669bfc50f8427d40fab068a0cb3ad0c9130630

transactions_root

The root of the transaction trie of the block.

0xb43e9b2212372bd1feb6dc60c131881510640b586b3b5ef7b8aee6774234b3cd

state_root

The root of the final state trie of the block.

0xb5a7292fde6a9d72a1d9fec001bf047dab432624c1a3a22823969f5f8b5c3ea3

receipts_root

The root of the receipts trie of the block.

0x6881e7138efb56dd174af14f250d168e003507ca627b850b5ea05384559712af

miner

Proof of Stake Address receiving fees from transactions in this block Proof of Work Address of the miner that mined this block.

0x95222290dd7278aa3ddd389cc1e1d165cc4bafe5

difficulty

The integer of the difficulty for this block.

0

total_difficulty

The integer of the total difficulty of the chain until this block.

5.88E+22

size

The size of the block, in bytes, as determined by the gas_limit.

71,052

extra_data

The “extra data” field of this block.

0x6265617665726275696c642e6f7267

gas_limit

Gas limit of the current block.

30,000,000

gas_used

Total gas used in the block.

13,800,371

transaction_count

Number of transactions included in this block.

162

base_fee_per_gas

Post London Upgrade (EIP1559), this represents the minimum gas_used required for a transaction to be included in a block. Represented in wei.

25,733,653,331

Other Advanced Fields

  • sha3_uncles

  • logs_bloom

  • transactions_root

  • state_root

  • receipts_root

  • extra_data

Last updated