osmosis.core Table: fact_blocks Type: View
Records of all blocks that have occurred on Osmosis, dating back to the genesis block.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| CHAIN_ID | TEXT | The name and version of the blockchain. This column will deprecate in all tables except core.fact_blocks soon. Please modify your queries to join to the blocks table to use this field. |
| TX_COUNT | NUMBER | The number of transactions that occurred during a block. |
| PROPOSER_ADDRESS | TEXT | The address of the validator that proposed the block. |
| VALIDATOR_HASH | TEXT | The root hash of the new validator set. |
| FACT_BLOCKS_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |