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

# thorchain.core_block

> THORChain block data — block height, timestamp, and chain metadata.

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 `thorchain.core_block` table contains block-level data from the THORChain blockchain including block headers, timestamps, and block statistics. This table is partitioned by block\_month.

## Column Descriptions

| **Column** | **Type** | **Description** |
| - | - | - |
| **block\_id** | bigint | Identifier |
| **block\_time** | timestamp | Timestamp of when the block was created |
| **block\_timestamp** | timestamp | Timestamp of when the block was created |
| **block\_date** | timestamp | Date of when the block was created |
| **block\_hour** | timestamp | Block Hour |
| **block\_week** | timestamp | Block Week |
| **block\_month** | timestamp | Block Month |
| **block\_quarter** | timestamp | Block Quarter |
| **block\_year** | timestamp | Block Year |
| **block\_dayofmonth** | timestamp | Block Dayofmonth |
| **block\_dayofweek** | timestamp | Block Dayofweek |
| **block\_dayofyear** | timestamp | Block Dayofyear |
| **timestamp** | timestamp | Timestamp of the record |
| **hash** | varchar | Hash |
| **agg\_state** | varchar | Agg State |
| **\_inserted\_timestamp** | timestamp | Timestamp of the record |
| **inserted\_timestamp** | timestamp | Time when the record was inserted |
| **modified\_timestamp** | timestamp | Time when the record was last modified |

## Table Sample

<TableSample tableSchema="thorchain" tableName="core_block" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.