Ledger Entries
Chain
Stellar MainnetDataset name
stellar_mainnet.ledger_entriesVersion
1.2.0Description
Ledger entry changes capture individual modifications to the Stellar ledger state (accounts, trustlines, offers, etc.) as they occur within operations, transactions, and ledgers on the Stellar network. Exclusively for turbo pipelines.
Example data
| id | change_type | ledger_entry_type | entry_data | key_data | last_modified_ledger_sequence | operation_id | operation_type | operation_result_code | operation_source_account | operation_source_account_muxed | operation_body | transaction_hash | transaction_account | transaction_fee_account | transaction_successful | transaction_index | ledger_sequence | ledger_hash | ledger_closed_at | ledger_signature |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60028754-04d29bf3075e47ae97992169edb39c4711d2215ee77bf29baeb130692eee1ac4-0-0 | state | account | {"account":{"account_id":"GBYUYEAO52BYHZEUMLHMHM5SWENBB2RHKAGDVAKBUHZLJTSSRMR6SZYL","balance":"14946364525","ext":{"v1":{"ext":{"v2":{"ext":{"v3":{"ext":"v0","seq_ledger":56176131,"seq_time":"1742126782"}},"num_sponsored":0,"num_sponsoring":0,"signer_sponsoring_i_ds":[]}},"liabilities":{"buying":"2184670861","selling":"878227320"}}},"flags":0,"home_domain":"","inflation_dest":null,"num_sub_entries":9,"seq_num":"125312130499401448","signers":[],"thresholds":"01000000"}} | 60028754 | 60028754-04d29bf3075e47ae97992169edb39c4711d2215ee77bf29baeb130692eee1ac4-0 | manage_sell_offer | ManageSellOfferSuccess | GBYUYEAO52BYHZEUMLHMHM5SWENBB2RHKAGDVAKBUHZLJTSSRMR6SZYL | {"manage_sell_offer":{"amount":"1","buying":"native","offer_id":"0","price":{"d":1,"n":2147483647},"selling":{"credit_alphanum4":{"asset_code":"XXA","issuer":"GC4HS4CQCZULIOTGLLPGRAAMSBDLFRR6Y7HCUQG66LNQDISXKIXXADIM"}}}} | 04d29bf3075e47ae97992169edb39c4711d2215ee77bf29baeb130692eee1ac4 | GBM4BSR7VGAOYF7BY6NJ5ZUB2KYVBBYEDTRPRUBZUDKYHO6QCQUKGQIK | 1 | 28 | 60028754 | 427c8f184f3a06ad8327a2ab91397ae17cb28d2ec6d82be6fce38ce1d32e619a | 2025-11-26 11:52:08 | +uYtetjRjh+bUhTttZ5VMGVGA64fmEnunJ1UiXWS0gnALeSGtTf2/JO3YtHNKe6HC4PBWC3cwUK+YLVSMuHrAg== |
Schema
| Column | Type |
|---|---|
| id | string |
| change_type | string |
| ledger_entry_type | string |
| entry_data | string |
| key_data | string |
| last_modified_ledger_sequence | long |
| operation_id | string |
| operation_type | string |
| operation_result_code | string |
| operation_source_account | string |
| operation_source_account_muxed | string |
| operation_body | string |
| transaction_hash | string |
| transaction_account | string |
| transaction_fee_account | string |
| transaction_successful | boolean |
| transaction_index | long |
| ledger_sequence | long |
| ledger_hash | string |
| ledger_closed_at | string |
| ledger_signature | string |