Table description

Tracks ledgers info (equivalent of blocks on other blockchain), including metadata such as sequence numbers, transactions included, and fees.

Column Descriptions

ColumnDescriptionType
closed_at_dateThe date when the ledger was closed.date
sequenceThe sequence number of the ledger.bigint
ledger_hashThe hash of the current ledger, in binary format.varbinary
previous_ledger_hashThe hash of the previous ledger, in binary format.varbinary
transaction_countThe number of transactions included in the ledger.bigint
operation_countThe number of operations executed within the transactions in the ledger.bigint
closed_atThe timestamp when the ledger was closed.timestamp(3) with time zone
idThe unique identifier for the ledger entry.bigint
total_coinsThe total number of lumens (XLM) in circulation at the time the ledger was closed.bigint
fee_poolThe sum of all transaction fees accumulated in the ledger.bigint
base_feeThe minimum fee, in lumens (XLM), charged per operation included in the ledger.bigint
base_reserveThe minimum XLM balance required to maintain an account, as defined in the ledger.bigint
max_tx_set_sizeThe maximum number of transactions that can be included in a ledger.bigint
protocol_versionThe protocol version used by the ledger.bigint
ledger_headerThe raw binary (XDR) representation of the ledger header.varbinary
successful_transaction_countThe number of successful transactions in the ledger.bigint
failed_transaction_countThe number of failed transactions in the ledger.bigint
tx_set_operation_countThe total number of operations in the transaction set of the ledger.bigint
soroban_fee_write_1kbThe fee in lumens (XLM) for writing 1KB of data related to Soroban smart contracts.bigint
node_idThe identifier of the node that signed and validated the ledger.varchar
signatureThe digital signature applied to the ledger by the validating node.varchar
total_byte_size_of_bucket_listThe total byte size of the ledger’s bucket list, which tracks state changes.bigint
updated_atThe time when the ledger record was last updated.timestamp(3) with time zone
ingested_atThe time when the ledger data was ingested into the system.timestamp(3) with time zone

Table Sample

Table description

Tracks ledgers info (equivalent of blocks on other blockchain), including metadata such as sequence numbers, transactions included, and fees.

Column Descriptions

ColumnDescriptionType
closed_at_dateThe date when the ledger was closed.date
sequenceThe sequence number of the ledger.bigint
ledger_hashThe hash of the current ledger, in binary format.varbinary
previous_ledger_hashThe hash of the previous ledger, in binary format.varbinary
transaction_countThe number of transactions included in the ledger.bigint
operation_countThe number of operations executed within the transactions in the ledger.bigint
closed_atThe timestamp when the ledger was closed.timestamp(3) with time zone
idThe unique identifier for the ledger entry.bigint
total_coinsThe total number of lumens (XLM) in circulation at the time the ledger was closed.bigint
fee_poolThe sum of all transaction fees accumulated in the ledger.bigint
base_feeThe minimum fee, in lumens (XLM), charged per operation included in the ledger.bigint
base_reserveThe minimum XLM balance required to maintain an account, as defined in the ledger.bigint
max_tx_set_sizeThe maximum number of transactions that can be included in a ledger.bigint
protocol_versionThe protocol version used by the ledger.bigint
ledger_headerThe raw binary (XDR) representation of the ledger header.varbinary
successful_transaction_countThe number of successful transactions in the ledger.bigint
failed_transaction_countThe number of failed transactions in the ledger.bigint
tx_set_operation_countThe total number of operations in the transaction set of the ledger.bigint
soroban_fee_write_1kbThe fee in lumens (XLM) for writing 1KB of data related to Soroban smart contracts.bigint
node_idThe identifier of the node that signed and validated the ledger.varchar
signatureThe digital signature applied to the ledger by the validating node.varchar
total_byte_size_of_bucket_listThe total byte size of the ledger’s bucket list, which tracks state changes.bigint
updated_atThe time when the ledger record was last updated.timestamp(3) with time zone
ingested_atThe time when the ledger data was ingested into the system.timestamp(3) with time zone

Table Sample