Raw
Ledgers
Table Columns
Unique Key: ledger_index
| Column Name | Data Type | Description |
|---|---|---|
| ledger_index | BIGINT | 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 | 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 | The current status of the ledger (e.g., “closed”, “validated”, “open”). |
| total_coins | BIGINT | The total amount of XRP in existence at the time this ledger was closed, in drops. |
| parent_ledger_hash | VARCHAR | 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 | The hash of the state tree root, representing the hash of all account states in this ledger. |
| transaction_set_hash | VARCHAR | The hash of the transaction set, representing all transactions included in this ledger. |
| close_time_resolution | BIGINT | The resolution of the close time in seconds. |
| close_flags | BIGINT | Flags that indicate special conditions about how the ledger was closed. |
| transaction_count | BIGINT | 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. |