Skip to main content
DatasetMainnetTestnetDescription
ledgersv1.2.0v1.2.0Extended ledger header data with protocol version, fee pool, and Soroban fee tracking
transactionsv1.2.0v1.2.0Transactions with Soroban resource breakdown (instructions, read/write bytes, fee details)
operationsv1.2.0v1.2.0Operations with result codes, event counts, and full ledger/transaction context
eventsv1.2.0v1.2.0System, contract, and diagnostic events from Soroban transactions
transfersv1.2.0v1.2.0Token transfer events with 8 transfer types (burn, claim, clawback, donate, fee, mint, trade, transfer)
ledger_entriesv1.2.0v1.2.0Ledger entry changes including Soroban entry types (contract_data, contract_code, config_setting, ttl)
balancesv1.1.0v1.1.0Per-account, per-asset balance snapshots derived from ledger entry changes, covering native XLM, trustline assets (USDC, AQUA, etc.), and liquidity pool positions
All v1.2.0 datasets (transactions, operations, events, ledgers, ledger_entries, transfers) support starting from a specific ledger sequence using start_at: <ledger_sequence> (e.g., start_at: 60000000). This significantly reduces backfill times compared to starting from earliest.
v1.2.0 performance improvements: Single-pass Arrow builders and optimized memory usage provide faster processing and lower resource consumption.

​
Dataset configuration

For resource sizing options, see Pipeline Configuration.
ParameterRequiredDescription
start_atYesLedger sequence to start indexing from, or latest / earliest
end_atNoStop indexing after this ledger sequence is reached
fetch_batch_sizeNo(Performance) Number of ledgers to fetch per batch, mainly for tuning backfills
fetch_parallelismNo(Performance) Number of parallel fetch ranges to process concurrently (default: 1, recommended: 2-4 for backfills). Higher values improve throughput by overlapping S3 I/O with processing
name: my-stellar-pipeline
resource_size: s

sources:
  stellar_transfers:
    type: dataset
    dataset_name: stellar_mainnet.transfers
    version: 1.2.0
    start_at: 60000000
    end_at: 61000000
    fetch_batch_size: 10
    fetch_parallelism: 2
When using end_at, combine with job: true at the top level so the pipeline auto-terminates after completion. See Job Mode for details.
Be cautious when increasing fetch_batch_size in job mode. Jobs do not automatically restart on failure, so resource errors (e.g., out of memory) will cause the job to fail permanently.

​
Quick start

The fastest way to explore Stellar data is using a blackhole sink with goldsky turbo inspect: 
name: demo-stellar-transfers-blackhole
resource_size: s

sources:
  stellar_transfers:
    type: dataset
    dataset_name: stellar_mainnet.transfers
    version: 1.2.0
    start_at: latest

sinks:
  dev_sink:
    type: blackhole
    from: stellar_transfers

goldsky turbo apply demo.yaml
goldsky turbo inspect demo-stellar-transfers-blackhole
For testnet, simply swap the stellar_mainnet prefix with stellar_testnet in the dataset_name: 
    dataset_name: stellar_testnet.transfers

​
Guide: Monitor transfers for specific assets

name: demo-stellar-asset-tracker
resource_size: s

sources:
  stellar_transfers:
    type: dataset
    dataset_name: stellar_mainnet.transfers
    version: 1.2.0
    start_at: latest

transforms:
  asset_transfers:
    type: sql
    primary_key: id
    sql: |
      SELECT * FROM stellar_transfers
      WHERE asset_code = 'XLM'
      OR (asset_code = 'USDC' AND asset_issuer = 'GA5ZSEJYB37JRC5AVCIA5MOP4RHTM335X2KGX3IHOJAPP5RE34K4KZVN')
      OR (asset_code = 'AQUA' AND asset_issuer = 'GBNZILSTVQZ4R7IKQDGHYGY2QXL5QOFJYQMXPKWRRM5PAV7Y4M67AQUA')

sinks:
  asset_transfers_sink:
    type: postgres
    from: asset_transfers
    schema: public
    table: demo_stellar_asset_transfers
    secret_name: MY_POSTGRES_SECRET
    primary_key: id
For more sink types and configuration options, see turbo sinks docs.

​
Guide: Track transactions of a specific account

name: demo-stellar-account-tracker
resource_size: s

# [Centre] Account for managing USDC on Stellar Mainnet
sources:
  stellar_transactions:
    type: dataset
    dataset_name: stellar_mainnet.transactions
    version: 1.2.0
    start_at: latest

transforms:
  account_transactions:
    type: sql
    primary_key: transaction_hash
    sql: |
      SELECT * FROM stellar_transactions
      WHERE account = 'GAFK7XFZHMLSNV7OJTBO7BAIZA66X6QIBV5RMZZYXK4Q7ZSO52J5C3WQ'

sinks:
  account_transactions_sink:
    type: postgres
    from: account_transactions
    schema: public
    table: demo_stellar_account_transactions
    secret_name: MY_POSTGRES_SECRET
    primary_key: transaction_hash

​
Guide: Track contract activity

name: demo-stellar-contract-tracker
resource_size: s

# Track all events and transfers on a specific contract_id
sources:
  stellar_events:
    type: dataset
    dataset_name: stellar_mainnet.events
    version: 1.2.0
    start_at: latest

  stellar_transfers:
    type: dataset
    dataset_name: stellar_mainnet.transfers
    version: 1.2.0
    start_at: latest

transforms:
  contract_events:
    type: sql
    primary_key: id
    sql: |
      SELECT * FROM stellar_events
      WHERE contract_id = 'CAS3J7GYLGXMF6TDJBBYYSE3HQ6BBSMLNUQ34T6TZMYMW2EVH34XOWMA'

  contract_transfers:
    type: sql
    primary_key: id
    sql: |
      SELECT * FROM stellar_transfers
      WHERE contract_id = 'CAS3J7GYLGXMF6TDJBBYYSE3HQ6BBSMLNUQ34T6TZMYMW2EVH34XOWMA'

sinks:
  contract_events_sink:
    type: postgres
    from: contract_events
    schema: public
    table: demo_stellar_contract_events
    secret_name: MY_POSTGRES_SECRET
    primary_key: id

  contract_transfers_sink:
    type: postgres
    from: contract_transfers
    schema: public
    table: demo_stellar_contract_transfers
    secret_name: MY_POSTGRES_SECRET
    primary_key: id

​
Guide: Monitor account balances

name: demo-stellar-balance-tracker
resource_size: s

sources:
  stellar_balances:
    type: dataset
    dataset_name: stellar_mainnet.balances
    version: 1.1.0
    start_at: latest

transforms:
  account_balances:
    type: sql
    primary_key: account_id, asset_code
    sql: |
      SELECT * FROM stellar_balances
      WHERE asset_code = 'XLM'
      OR (asset_code = 'USDC' AND asset_issuer = 'GA5ZSEJYB37JRC5AVCIA5MOP4RHTM335X2KGX3IHOJAPP5RE34K4KZVN')

sinks:
  account_balances_sink:
    type: postgres
    from: account_balances
    schema: public
    table: demo_stellar_account_balances
    secret_name: MY_POSTGRES_SECRET
    primary_key: account_id, asset_code

​
Dataset schemas

Full field reference for all Stellar datasets.
FieldTypeDescription
ledger_sequenceUINT32Ledger sequence number
ledger_hashSTRINGLedger hash
ledger_closed_atTIMESTAMPLedger close time (UTC)
ledger_signatureSTRINGLedger signature
transaction_countUINT32Total transactions in ledger
previous_ledger_hashSTRINGPrevious ledger hash
protocol_versionUINT32Stellar protocol version
total_coinsLONGTotal XLM in circulation (stroops)
fee_poolLONGFee pool amount (stroops)
base_feeUINT32Base fee in stroops
base_reserveUINT32Base reserve per account
max_tx_set_sizeUINT32Maximum transaction set size
successful_tx_countUINT32Count of successful transactions
failed_tx_countUINT32Count of failed transactions
soroban_fee_write_1kbLONGSoroban fee per 1KB write (nullable, pre-Soroban)
node_idSTRINGNode identifier
FieldTypeDescription
transaction_hashSTRINGTransaction hash
accountSTRINGSource account
account_muxedSTRINGMuxed account variant
account_sequenceLONGAccount sequence number
max_feeLONGMaximum fee willing to pay
fee_chargedLONGActual fee charged
fee_accountSTRINGFee bump fee account
inner_transaction_hashSTRINGInner transaction hash (fee bump only)
new_max_feeLONGNew max fee (fee bump only)
memo_typeSTRINGMemo type
memoSTRINGMemo value
time_bounds_lowerLONGLower time bound (Unix seconds)
time_bounds_upperLONGUpper time bound (Unix seconds)
successfulBOOLEANWhether transaction succeeded
transaction_result_codeSTRINGTransaction result code
operation_countUINT32Number of operations
event_countUINT32Number of contract events
diagnostic_event_countUINT32Number of diagnostic events
inclusion_fee_bidLONGFee bid for inclusion
resource_feeLONGSoroban resource fee
soroban_resources_instructionsLONGCPU instructions used
soroban_resources_read_bytesLONGBytes read from storage
soroban_resources_write_bytesLONGBytes written to storage
non_refundable_resource_fee_chargedLONGNon-refundable resource fee
refundable_resource_fee_chargedLONGRefundable resource fee
rent_fee_chargedLONGRent fee charged
tx_signersSTRINGJSON array of signature hints
ledger_sequenceUINT32Ledger sequence number
ledger_hashSTRINGLedger hash
ledger_closed_atTIMESTAMPLedger close time
ledger_signatureSTRINGLedger signature
FieldTypeDescription
idSTRINGUnique operation ID ({ledger_sequence}-{tx_hash}-{op_index})
source_accountSTRINGAccount that initiated the operation
source_account_muxedSTRINGMuxed account identifier
typeSTRINGOperation type name
type_iUINT32Operation type as integer
bodySTRINGJSON-serialized operation body
result_codeSTRINGResult code (e.g., PaymentSuccess)
operation_resultSTRINGJSON-serialized full operation result
event_countUINT32Number of contract events generated
ledger_entry_changes_countUINT32Number of ledger entry changes
transaction_hashSTRINGParent transaction hash
transaction_accountSTRINGTransaction source account
transaction_fee_accountSTRINGFee account (for fee bump transactions)
transaction_successfulBOOLEANWhether the transaction succeeded
transaction_indexUINT32Transaction position in ledger
ledger_sequenceUINT32Ledger sequence number
ledger_hashSTRINGLedger hash
ledger_closed_atTIMESTAMPLedger close timestamp
ledger_signatureSTRINGLedger signature
FieldTypeDescription
idSTRINGUnique event ID
typeSTRINGEvent type: system, contract, or diagnostic
contract_idSTRINGContract ID
topicsSTRINGJSON array of event topics
dataSTRINGJSON-serialized event data
in_successful_contract_callBOOLEANWhether in successful contract call
transaction_hashSTRINGParent transaction hash
transaction_accountSTRINGTransaction source account
transaction_account_muxedSTRINGMuxed account variant
transaction_fee_accountSTRINGFee account
transaction_fee_account_muxedSTRINGMuxed fee account variant
transaction_successfulBOOLEANWhether transaction succeeded
transaction_indexUINT32Transaction position in ledger
operation_bodySTRINGJSON operation body
operation_result_codeSTRINGOperation result code
operation_typeSTRINGOperation type
ledger_sequenceUINT32Ledger sequence number
ledger_hashSTRINGLedger hash
ledger_closed_atTIMESTAMPLedger close time
ledger_signatureSTRINGLedger signature
FieldTypeDescription
idSTRINGUnique transfer ID
transfer_typeSTRINGOne of: burn, claim, clawback, donate, fee, mint, trade, transfer
senderSTRINGSender address
recipientSTRINGRecipient address
asset_rawSTRINGRaw asset string (native or CODE:ISSUER)
asset_codeSTRINGParsed asset code (XLM for native)
asset_issuerSTRINGAsset issuer (null for native)
amountDECIMALTransfer amount (i128 precision)
to_muxed_idLONGMuxed account sub-identifier
contract_idSTRINGContract ID
topicsSTRINGJSON array of event topics
dataSTRINGJSON event data
in_successful_contract_callBOOLEANWhether in successful contract call
transaction_hashSTRINGParent transaction hash
transaction_accountSTRINGTransaction source account
transaction_fee_accountSTRINGFee account
transaction_successfulBOOLEANWhether transaction succeeded
transaction_indexUINT32Transaction position in ledger
operation_bodySTRINGJSON operation body
operation_result_codeSTRINGOperation result code
operation_typeSTRINGOperation type
ledger_sequenceUINT32Ledger sequence number
ledger_hashSTRINGLedger hash
ledger_closed_atTIMESTAMPLedger close time
ledger_signatureSTRINGLedger signature
amount_boughtDECIMALAmount bought (trade type only)
trade_feeDECIMALTrade fee (trade type only)
FieldTypeDescription
idSTRINGUnique change ID
change_typeSTRINGOne of: created, updated, removed, state, restored
ledger_entry_typeSTRINGEntry type (e.g., account, trustline, contract_data, ttl)
entry_dataSTRINGJSON entry data (for created/updated/state/restored)
key_dataSTRINGJSON key data (for removed entries)
last_modified_ledger_sequenceUINT32Last modified ledger (null for removed)
operation_idSTRINGParent operation ID
operation_typeSTRINGOperation type
operation_result_codeSTRINGOperation result code
operation_source_accountSTRINGOperation source account
operation_source_account_muxedSTRINGMuxed operation account
operation_bodySTRINGJSON operation body
transaction_hashSTRINGParent transaction hash
transaction_accountSTRINGTransaction source account
transaction_fee_accountSTRINGFee account
transaction_successfulBOOLEANWhether transaction succeeded
transaction_indexUINT32Transaction position in ledger
ledger_sequenceUINT32Ledger sequence number
ledger_hashSTRINGLedger hash
ledger_closed_atTIMESTAMPLedger close time
ledger_signatureSTRINGLedger signature
FieldTypeDescription
account_idSTRINGStellar account address
asset_codeSTRINGAsset code (XLM for native, e.g. USDC for credit assets)
asset_typeSTRINGAsset type: native, credit_alphanum4, or credit_alphanum12
asset_issuerSTRINGAsset issuer account (null for native XLM)
liquidity_pool_idSTRINGLiquidity pool ID (for pool-based balances)
balanceDECIMALBalance amount in stroops
last_modified_ledger_sequenceUINT32Ledger sequence when balance was last modified
change_typeSTRINGType of change: created, updated, removed, restored
ledger_entry_typeSTRINGSource entry type: account, trustline, or liquidity_pool
ingested_atTIMESTAMPTimestamp when the record was ingested

​
Deprecated versions

The following dataset versions are no longer supported and should be migrated to the current stellar_mainnet.* datasets.
Deprecated datasetVersionsMigrate to
stellar.ledgersv3.1.0 and priorstellar_mainnet.ledgers
stellar.transactionsv3.1.0 and priorstellar_mainnet.transactions
stellar.operationsv3.1.0 and priorstellar_mainnet.operations
stellar.eventsv3.2.0 and priorstellar_mainnet.events
stellar.transfersv3.2.0 and priorstellar_mainnet.transfers
stellar.ledger_entriesv3.1.0 and priorstellar_mainnet.ledger_entries
stellar.balancesv3.1.0 and priorstellar_mainnet.balances
These datasets were used with the Mirror product and are no longer supported.
For any questions or feedback, reach out at support@goldsky.com.