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

# Blocks 🌱

### Table Details

| Property          | Value                                  |
| ----------------- | -------------------------------------- |
| Table Name        | `spark.raw.blocks`                     |
| Table Status      | Beta 🌱                                |
| Unique Key        | `block_timestamp_unix`, `block_number` |
| Clustering Key(s) | `to_date("block_timestamp")`           |

### Table Columns

| Column Name            | Data Type         | Description                                                                                                                                |
| ---------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------ |
| block\_timestamp       | TIMESTAMP\_NTZ(9) | UTC timestamp of the block. Spark uses synthetic blocks minted once per second, so this advances by one second per block.                  |
| block\_number          | NUMBER(38,0)      | Sequential block height. Spark mints one synthetic block per second, so `block_number` corresponds one-to-one with `block_timestamp_unix`. |
| genesis\_epoch         | NUMBER(38,0)      | The genesis epoch identifier for the Spark network the block belongs to.                                                                   |
| transaction\_count     | NUMBER(38,0)      | Number of transactions included in this block.                                                                                             |
| block\_timestamp\_unix | NUMBER(38,0)      | Unix timestamp (seconds) of the block. Equal to `block_number` plus a fixed offset, since blocks are minted one per second.                |
| \_created\_at          | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                                                                   |
| \_updated\_at          | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                                                              |