external.avalanche Table: fact_x_blocks Type: View
What
Avalanche X-Chain Blocks. Please visit https://discord.gg/avax for any questions.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_HASH | TEXT | Unique identifier (hash) for the block |
| BLOCK_INDEX | NUMBER | Sequential index of the block within the chain |
| TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the block was produced |
| TYPE | TEXT | Type of block (e.g., proposal, decision, etc.) |
| TX_COUNT | NUMBER | Number of transactions included in the block |
| BLOCK_SIZE | NUMBER | BLOCK_SIZE column |
| PARENT_HASH | TEXT | Hash of the parent block in the chain |
| PROPOSER_ID | TEXT | Identifier for the entity that proposed the block |
| PROPOSER_PARENT_ID | TEXT | PROPOSER_PARENT_ID column |
| PROPOSER_NODE_ID | TEXT | Unique node ID of the block proposer |
| PROPOSER_P_CHAIN_HEIGHT | NUMBER | PROPOSER_P_CHAIN_HEIGHT column |
| PROPOSER_TIMESTAMP | TIMESTAMP_NTZ | Timestamp recorded by the proposer when creating the block |
| LAST_UPDATED | TIMESTAMP_NTZ | Timestamp of the last update to this record |
| LOAD_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the block data was loaded into Snowflake |
| BLOCK_HEIGHT | NUMBER | Block height on the chain indicating its position in the ledger |