Table Details
| Property | Value |
|---|---|
| Table Name | xrp_ledger.raw.ledgers |
| Table Status | Production-Ready |
| Unique Key | close_time, ledger_index |
| Clustering Key(s) | to_date("close_time") |
| Search Optimization | ledger_index |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| ledger_index | NUMBER(38,0) | The sequence number of this ledger. Each ledger has a unique, monotonically increasing sequence number. |
| close_time | TIMESTAMP_NTZ(9) | The timestamp when this ledger was closed, indicating when the consensus process completed. |
| ledger_hash | VARCHAR(16777216) | The hash of the ledger header, serving as a unique identifier for this specific ledger state. |
| closed | BOOLEAN | Whether this ledger has been closed by consensus process. |
| validated | BOOLEAN | Whether this ledger has been validated by the network consensus. Only validated ledgers are considered final. |
| status | VARCHAR(16777216) | The current status of the ledger (e.g., “closed”, “validated”, “open”). |
| total_coins | NUMBER(38,0) | The total amount of XRP in existence at the time this ledger was closed, in drops. |
| parent_ledger_hash | VARCHAR(16777216) | The hash of the parent ledger that this ledger builds upon, creating the chain of ledgers. |
| parent_ledger_close_time | TIMESTAMP_NTZ(9) | The timestamp when the parent ledger was closed. |
| state_data_hash | VARCHAR(16777216) | The hash of the state tree root, representing the hash of all account states in this ledger. |
| transaction_set_hash | VARCHAR(16777216) | The hash of the transaction set, representing all transactions included in this ledger. |
| close_time_resolution | NUMBER(38,0) | The resolution of the close time in seconds. |
| close_flags | NUMBER(38,0) | Flags that indicate special conditions about how the ledger was closed. |
| transaction_count | NUMBER(38,0) | The number of transactions included in this ledger. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated in the database. |