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.
Table Details
| Property | Value |
|---|---|
| Table Name | stellar_testnet.raw.ledgers |
| Table Status | Beta 🌱 |
| Unique Key | close_time, sequence |
| Clustering Key(s) | to_date("close_time") |
| Search Optimization | sequence |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| sequence | NUMBER(38,0) | The sequence number of the ledger |
| close_time | TIMESTAMP_NTZ(9) | The timestamp when the ledger was closed (Unix timestamp) |
| hash | VARCHAR(16777216) | The hash of the ledger header |
| base_fee | NUMBER(38,0) | The base fee for operations in this ledger (in stroops) |
| base_reserve | NUMBER(38,0) | The base reserve for accounts in this ledger (in stroops) |
| id_pool | NUMBER(38,0) | The ID pool for this ledger |
| inflation_seq | NUMBER(38,0) | The inflation sequence number for this ledger |
| fee_pool | NUMBER(38,0) | The fee pool for this ledger (in stroops) |
| total_coins | NUMBER(38,0) | The total number of lumens in circulation |
| previous_ledger_hash | VARCHAR(16777216) | The hash of the previous ledger |
| extension | VARCHAR(16777216) | Extension data for the ledger |
| node_id | VARCHAR(16777216) | The ID of the node that closed this ledger |
| signature | VARCHAR(16777216) | The signature of the ledger header |
| skip_list | VARIANT | List of ledger hashes that were skipped |
| bucket_list_hash | VARCHAR(16777216) | The hash of the bucket list |
| max_tx_set_size | NUMBER(38,0) | The maximum size of the transaction set |
| tx_set_hash | VARCHAR(16777216) | The hash of the transaction set |
| tx_set_result_hash | VARCHAR(16777216) | The hash of the transaction set results |
| upgrades | VARCHAR(16777216) | Any protocol upgrades applied in this ledger |
| total_byte_size_of_bucket_list | NUMBER(38,0) | The total byte size of the bucket list |
| protocol_version | NUMBER(38,0) | The protocol version used in this ledger |
| transaction_count | NUMBER(38,0) | The total number of transactions in this ledger |
| successful_transaction_count | NUMBER(38,0) | The number of successful transactions in this ledger |
| failed_transaction_count | NUMBER(38,0) | The number of failed transactions in this ledger |
| operation_count | NUMBER(38,0) | The total number of operations in this ledger |
| effect_count | NUMBER(38,0) | The total number of effects generated in this ledger |
| contract_event_count | NUMBER(38,0) | The number of contract events in this ledger |
| diagnostic_event_count | NUMBER(38,0) | The number of diagnostic events in this ledger |
| metadata | VARIANT | Additional metadata for the ledger |
| _extra_fields | VARIANT | Additional fields not explicitly defined |
| token_transfer_count | NUMBER(38,0) | Number of token transfer records produced by this ledger. |
| balance_snapshot_count | NUMBER(38,0) | Number of balance snapshot records produced by this ledger. |
| event_count | NUMBER(38,0) | Number of events emitted in this ledger. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |