Blocks

Several columns may only be applicable for specific EVM-compatible blockchains. The list of columns present in the table is not exhaustive.

Column Name	Data Type	Description
timestamp	TIMESTAMP_NTZ(9)	The unix timestamp for when the block was collated.
number	BIGINT	The length of the chain, in blocks.
hash	VARCHAR	Unique identifier of a block.
parent_hash	VARCHAR	Unique identifier of the block preceding this block, also known as the parent block.
nonce	VARCHAR	The hash of the generated proof-of-work. null if pending
sha3_uncles	VARCHAR	An array of uncle hashes.
logs_bloom	VARCHAR	The bloom filter for the logs of the block.
transactions_root	VARCHAR	The root of the transaction trie of the block.
state_root	VARCHAR	The root of the final state trie of the block.
receipts_root	VARCHAR	The root of the receipts trie of the block.
miner	VARCHAR	The address of the beneficiary to whom the mining rewards were given.
difficulty	BIGINT	The integer of the difficulty for this block.
total_difficulty	VARCHAR	The integer of the total difficulty of the chain until this block.
size	BIGINT	The size of the block, in bytes, as determined by the gas_limit.
extra_data	VARCHAR	The “extra data” field of this block.
gas_limit	BIGINT	Gas limit of the current block.
gas_used	BIGINT	Total gas used in the block.
transaction_count	BIGINT	Number of transactions included in this block.
base_fee_per_gas	BIGINT	Post London Upgrade (EIP1559), this represents the minimum gas_used required for a transaction to be included in a block. Represented in wei.
send_root	VARCHAR	The root hash of send operations.
created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was created.
updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated.

Column Name

Data Type

Description

timestamp

TIMESTAMP_NTZ(9)

The unix timestamp for when the block was collated.

number

BIGINT

The length of the chain, in blocks.

hash

VARCHAR

Unique identifier of a block.

parent_hash

VARCHAR

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

nonce

VARCHAR

The hash of the generated proof-of-work. null if pending

sha3_uncles

VARCHAR

An array of uncle hashes.

logs_bloom

VARCHAR

The bloom filter for the logs of the block.

transactions_root

VARCHAR

The root of the transaction trie of the block.

state_root

VARCHAR

The root of the final state trie of the block.

receipts_root

VARCHAR

The root of the receipts trie of the block.

miner

VARCHAR

The address of the beneficiary to whom the mining rewards were given.

difficulty

BIGINT

The integer of the difficulty for this block.

total_difficulty

VARCHAR

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

size

BIGINT

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

extra_data

VARCHAR

The “extra data” field of this block.

gas_limit

BIGINT

Gas limit of the current block.

gas_used

BIGINT

Total gas used in the block.

transaction_count

BIGINT

Number of transactions included in this block.

base_fee_per_gas

BIGINT

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

send_root

VARCHAR

The root hash of send operations.

created_at

TIMESTAMP_NTZ(9)

Timestamp when the record was created.

updated_at

TIMESTAMP_NTZ(9)

Timestamp when the record was last updated.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns