polkadot.blocks

Table description

The polkadot.blocks table stores basic information about Substrate blocks, with one record per block, including the block hash and statistics on the number of extrinsics, events, and transfers contained in each block.

Table Schema

Column	Type	Description
`year`	`INTEGER`	Calendar year of the block (partition column)
`month`	`INTEGER`	Calendar month of the block (partition column)
`day`	`INTEGER`	Calendar day of the block (partition column)
`block_time`	`TIMESTAMP`	The timestamp when the block was produced
`number`	`BIGINT`	The sequential block number
`spec_version`	`BIGINT`	Runtime specification version active at this block
`relay_block_number`	`BIGINT`	Corresponding relay chain block number (for parachains)
`hash`	`VARBINARY`	Unique hash identifying this block
`parent_hash`	`VARBINARY`	Hash of the preceding block
`state_root`	`VARBINARY`	Root hash of the state trie after this block
`extrinsics_root`	`VARBINARY`	Root hash of the extrinsics trie for this block
`author_ss58`	`VARCHAR`	SS58-encoded address of the block author/validator
`author_pub_key`	`VARBINARY`	Public key of the block author/validator
`relay_state_root`	`VARBINARY`	State root of the relay chain at this block (for parachains)
`extrinsic_count`	`BIGINT`	Number of extrinsics included in this block
`event_count`	`BIGINT`	Number of events emitted in this block
`transfer_count`	`BIGINT`	Number of token transfers in this block
`trace_count`	`BIGINT`	Number of traces recorded for this block
`updated_at`	`TIMESTAMP`	When this record was last updated in the database
`ingested_at`	`TIMESTAMP`	When this record was first ingested into the database

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

Table description

Table Schema

Table Sample

​Table description

​Table Schema

​Table Sample

Table description

Table Schema

Table Sample