movement.core Table: fact_blocks Type: Base Table
What
This table contains “block” level data for the Movement blockchain. This table can be used to analyze trends at a block level, for example total transactions over time. “The Movement blockchain doesn’t have an explicit notion of a block — it only uses blocks for batching and executing transactions. A transaction at height 0 is the first transaction (genesis transaction), and a transaction at height 100 is the 101st transaction in the transaction store.”Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_NUMBER | NUMBER | BLOCK_NUMBER column |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced. |
| BLOCK_HASH | TEXT | The hash of the block header for a given block. |
| FIRST_VERSION | NUMBER | The version number of the first transaction in the block. |
| LAST_VERSION | NUMBER | The version number of the last transaction in the block. |
| TX_COUNT | NUMBER | The count of transactions in this block. |
| FACT_BLOCKS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |