> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# polkadot.blocks

> Description of Substrate blocks table on Dune.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## 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        |

## Table Sample

<TableSample tableSchema="polkadot" tableName="blocks" />