> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.                                                  |