Skip to main content

Table Details

PropertyValue
Table Namestellar.raw.ledgers_v2
Table StatusProduction-Ready
Unique Keysequence
Clustering Key(s)to_date("close_time")
Search Optimizationsequence

Table Columns

Column NameData TypeDescription
sequenceNUMBER(38,0)Stellar ledger sequence number (ledger height).
close_timeTIMESTAMP_NTZ(9)Time when this ledger was closed and finalized by the network.
hashVARCHAR(16777216)Hash of this ledger.
base_feeNUMBER(38,0)Base fee per operation in stroops at this ledger.
base_reserveNUMBER(38,0)Minimum XLM balance required per ledger entry, in stroops, at this ledger.
id_poolNUMBER(38,0)Last used generalized ledger entry ID in this ledger header.
inflation_seqNUMBER(38,0)Sequence number tracking the inflation process for this ledger.
fee_poolNUMBER(38,0)Accumulated fee pool balance in the network at this ledger close, in stroops.
total_coinsNUMBER(38,0)Total XLM supply in the network at this ledger close, in stroops.
previous_ledger_hashVARCHAR(16777216)Hash of the previous ledger.
extensionVARCHAR(16777216)XDR extension data on this ledger header, used for forward-compatible ledger changes.
node_idVARCHAR(16777216)Identifier of the validator node that proposed this ledger.
signatureVARCHAR(16777216)Signature over this ledger header.
skip_listVARIANTArray of ledger hashes at exponentially-spaced offsets, used for efficient historical lookups.
bucket_list_hashVARCHAR(16777216)Hash of the bucket list (Stellar’s persistent state storage) after applying this ledger.
max_tx_set_sizeNUMBER(38,0)Maximum number of transactions allowed in this ledger’s transaction set.
tx_set_hashVARCHAR(16777216)Hash of the transaction set included in this ledger.
tx_set_result_hashVARCHAR(16777216)Hash of the execution results for the transaction set in this ledger.
upgradesVARCHAR(16777216)Array of protocol upgrade votes included in this ledger close.
total_byte_size_of_bucket_listNUMBER(38,0)Total size in bytes of the bucket list (Stellar’s persistent state) at this ledger.
protocol_versionNUMBER(38,0)Stellar protocol version in effect at this ledger.
transaction_countNUMBER(38,0)Number of transactions included in this ledger.
successful_transaction_countNUMBER(38,0)Number of transactions in this ledger that executed successfully.
failed_transaction_countNUMBER(38,0)Number of transactions in this ledger that failed execution.
operation_countNUMBER(38,0)Number of operations across all transactions in this ledger.
effect_countNUMBER(38,0)Number of effects (state change records) produced in this ledger.
contract_event_countNUMBER(38,0)Number of contract events emitted in this ledger.
diagnostic_event_countNUMBER(38,0)Number of diagnostic events emitted during Soroban execution in this ledger.
metadataVARIANTLedger metadata.
_extra_fieldsVARIANTCatch-all of additional source fields not mapped to a dedicated column.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.
token_transfer_countNUMBER(38,0)Number of token transfer events emitted in this ledger.
balance_snapshot_countNUMBER(38,0)Number of balance snapshot records associated with this ledger.
event_countNUMBER(38,0)Number of events emitted in this ledger.