| SEQUENCE | NUMBER | The sequence number that corresponds to the individual ledgers. As ledgers are written to the network, the sequence is incremented by 1 |
| LEDGER_HASH | TEXT | The hex-encoded SHA-256 hash that represents the ledger’s XDR-encoded form. |
| PREVIOUS_LEDGER_HASH | TEXT | The hex-encoded SHA-256 hash of the ledger that immediately precedes this ledger. |
| TRANSACTION_COUNT | NUMBER | The number of successful transactions submitted and completed by the network in this ledger. |
| OPERATION_COUNT | NUMBER | The total number of successful operations applied to this ledger. |
| CLOSED_AT | TIMESTAMP_NTZ | Timestamp when the ledger was closed and committed to the network. Ledgers are expected to close ~every 5 seconds. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | A clone of closed_at for join convenience. |
| ID | NUMBER | Unique identifier for the ledger |
| TOTAL_COINS | NUMBER | Total number of lumens in circulation |
| FEE_POOL | NUMBER | The sum of all transaction fees |
| BASE_FEE | NUMBER | The fee (in stroops) the network charges per operation in a transaction for the given ledger. The minimum base fee is 100, with the ability to increase if transaction demand exceeds ledger capacity. When this occurs, the ledger enters surge pricing. |
| BASE_RESERVE | NUMBER | The reserve (in stroops) the network requires an account to retain as a minimum balance in order to be a valid account on the network. The current minimum reserve is 10 XLM. |
| MAX_TX_SET_SIZE | NUMBER | The maximum number of operations that Stellar validator nodes have agreed to process in a given ledger. Since Protocol 11, ledger capacity has been measured in operations rather than transactions. |
| PROTOCOL_VERSION | NUMBER | The protocol verstion that the Stellar network was running when this ledger was committed. Protocol versions are released ~every 6 months. |
| SUCCESSFUL_TRANSACTION_COUNT | NUMBER | The number of successful transactions submitted and completed by the network in this ledger |
| FAILED_TRANSACTION_COUNT | NUMBER | The number of failed transactions submitted to the network in this ledger. The transaction was still paid for but contained an error that prevented it from executing |
| TX_SET_OPERATION_COUNT | NUMBER | The total number of operations in the transaction set for this ledger, including failed transactions. |
| BATCH_ID | TEXT | String representation of the run id for a given DAG in Airflow. Takes the form of “scheduled__<batch_end_date>-<dag_alias>”. Batch ids are unique to the batch and help with monitoring and rerun capabilities. |
| BATCH_RUN_DATE | TIMESTAMP_NTZ | The start date for the batch interval. When taken with the date in the batch_id, the date represents the interval of ledgers processed. The batch run date can be seen as a proxy of closed_at for a ledger. |
| BATCH_INSERT_TS | TIMESTAMP_NTZ | The timestamp in UTC when a batch of records was inserted into the database. This field can help identify if a batch executed in real time or as part of a backfill. The timestamp should not be used during ad hoc analysis and is useful for data engineering purposes. |
| SOROBAN_FEE_WRITE_1KB | NUMBER | The fee associated with writing 1KB of data to the Soroban ledger.The write fee is dynamic fee that grows linearly with the size of the ledger. The write fee for a given ledger is recorded in the ledger header and has a direct relationship to the bucketlist size of the ledger db. |
| NODE_ID | TEXT | The id of winning validator node which is allowed to write transaction set to the network. The winning validator is decided by the network. |
| SIGNATURE | TEXT | The signing hash of the validator node which writes the transaction set to the network.This signature ensures the integrity and authenticity of the ledger, confirming that it has not been tampered with. |
| TOTAL_BYTE_SIZE_OF_BUCKET_LIST | NUMBER | Total size in bytes of the bucket list |
| FACT_LEDGERS_ID | TEXT | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |
