Data Sources

Create lightning-fast pipelines with your subgraphs or live streams by Goldsky and the community.

Dataset

Ledgers (v2)

Chain

Stellar

Example data

1

Column	Type	Value
`sequence`		57255191
`ledger_hash`		52c55d2c71770e36cb8c38767c4f72e8c28c313f425cfcc689f103f23d33c480
`previous_ledger_hash`		ec82bda711e2542113e8aa8e7d68407f10aba3671fe27f0d020a62097160bb73
`closed_at`		1748284795000
`protocol_version`		22
`total_coins`		1054439020873472865
`fee_pool`		61698542208062
`base_fee`		100
`base_reserve`		5000000
`max_tx_set_size`		1000
`successful_transaction_count`		388
`failed_transaction_count`		44
`soroban_fee_write_1kb`		10739
`node_id`		GBLJNN3AVZZPG2FYAYTYQKECNWTQYYUUY2KVFN2OUKZKBULXIXBZ4FCT
`signature`		Rv4514JEXJm6hbRQvT74w+nYpNMp0ElpUv6uVO1ihCNiYxEnZGgMsTD33W6R4cd64ERYA8WO0rlINECfU5ZdAg==
`transactions`		[ { "transaction_hash": "9712c48c403a306d6633b0f2b13ddd8f28afb0be480a5d7a5385ffc5670561b7", "account": "GC5TJ3YQDNKGGTWWGPCLTDEOATPBQC7ABE7HTJXDPVUATJPGDHDRZKN7", "account_muxed": null, "account_sequence": 241152183058395946, "max_fee": 269314, "fee_charged": 200745, "fee_account": "GBGWQFSJSOMJ2BTOH5RLZUTZPV544YR2DF5CGYL7WDZ2Y6OSRHR6TUBE", "fee_account_muxed": null, "inner_transaction_hash": "8e1dafd453d972faf887a712da68ef36078e0ea19c5d747953b3e035628ed5a5", "new_max_fee": 269314, "memo_type": "MemoTypeMemoNone", "memo": null, "time_bounds_lower": 0, "time_bounds_upper": 1748285086000, "successful": true, "transaction_result_code": "TransactionResultCodeTxFeeBumpInnerSuccess", "operation_count": 1, "inclusion_fee_bid": 0, "resource_fee": 269113, "soroban_resources_instructions": 4870890, "soroban_resources_read_bytes": 21016, "soroban_resources_write_bytes": 1548, "non_refundable_resource_fee_charged": 165882, "refundable_resource_fee_charged": 34663, "rent_fee_charged": 34623, "tx_signers": [], "operations": [ { "id": "57255191-9712c48c403a306d6633b0f2b13ddd8f28afb0be480a5d7a5385ffc5670561b7-0", "source_account": "GC5TJ3YQDNKGGTWWGPCLTDEOATPBQC7ABE7HTJXDPVUATJPGDHDRZKN7", "source_account_muxed": "", "type": "invoke_host_function", "body": "{\"invoke_host_function\":{\"auth\":[{\"credentials\":{\"address\":{\"address\":\"GDTLBABZ4NHAXUJAT2HIIQ52UDEBXXZLGB5QILBTCMSKEQENRM6PRIZ5\",\"nonce\":\"2120671071548739023\",\"signature\":{\"vec\":[{\"map\":[{\"key\":{\"symbol\":\"public_key\"},\"val\":{\"bytes\":\"e6b08039e34e0bd1209e8e8443baa0c81bdf2b307b042c331324a2408d8b3cf8\"}},{\"key\":{\"symbol\":\"signature\"},\"val\":{\"bytes\":\"d600c9d9eda2ec6314f431065e70c67b23e817ab0df485c0812c7447c8086fc6fb3d00c9582d6229ecc931c43b348aeafb17bb4fd2a42ee66c2549c96850670f\"}}]}]}},\"signature_expiration_ledger\":57255288}},\"root_invocation\":{\"function\":{\"contract_fn\":{\"args\":[{\"address\":\"GDTLBABZ4NHAXUJAT2HIIQ52UDEBXXZLGB5QILBTCMSKEQENRM6PRIZ5\"},{\"i128\":\"0\"}],\"contract_address\":\"CDL74RF5BLYR2YBLCCI7F5FB6TPSCLKEJUBSD2RSVWZ4YHF3VMFAIGWA\",\"function_name\":\"plant\"}},\"sub_invocations\":[]}}],\"host_function\":{\"invoke_contract\":{\"args\":[{\"address\":\"GDTLBABZ4NHAXUJAT2HIIQ52UDEBXXZLGB5QILBTCMSKEQENRM6PRIZ5\"},{\"i128\":\"0\"}],\"contract_address\":\"CDL74RF5BLYR2YBLCCI7F5FB6TPSCLKEJUBSD2RSVWZ4YHF3VMFAIGWA\",\"function_name\":\"plant\"}}}}", "result_code": "InvokeHostFunctionSuccess", "ledger_entry_changes": [ { "id": "57255191-9712c48c403a306d6633b0f2b13ddd8f28afb0be480a5d7a5385ffc5670561b7-0-0", "change_type": "state", "ledger_entry_type": "contract_data", "entry_data": "{\"contract_data\":{\"contract\":\"CDL74RF5BLYR2YBLCCI7F5FB6TPSCLKEJUBSD2RSVWZ4YHF3VMFAIGWA\",\"durability\":\"persistent\",\"ext\":\"v0\",\"key\":\"ledger_key_contract_instance\",\"val\":{\"contract_instance\":{\"executable\":{\"wasm\":\"db2c14290d4964e3805f2527dd132939ba5fb3fccac56b30bfab8fd091011627\"},\"storage\":[{\"key\":{\"vec\":[{\"symbol\":\"FarmBlock\"}]},\"val\":{\"map\":[{\"key\":{\"symbol\":\"entropy\"},\"val\":{\"bytes\":\"0000000000000000000000000000000000000000000000000000000000000000\"}},{\"key\":{\"symbol\":\"max_gap\"},\"val\":{\"u32\":0}},{\"key\":{\"symbol\":\"max_stake\"},\"val\":{\"i128\":\"3000000\"}},{\"key\":{\"symbol\":\"max_zeros\"},\"val\":{\"u32\":0}},{\"key\":{\"symbol\":\"min_gap\"},\"val\":{\"u32\":4294967295}},{\"key\":{\"symbol\":\"min_stake\"},\"val\":{\"i128\":\"0\"}},{\"key\":{\"symbol\":\"min_zeros\"},\"val\":{\"u32\":4294967295}},{\"key\":{\"symbol\":\"normalized_total\"},\"val\":{\"i128\":\"0\"}},{\"key\":{\"symbol\":\"staked_total\"},\"val\":{\"i128\":\"0\"}},{\"key\":{\"symbol\":\"timestamp\"},\"val\":{\"u64\":\"1748284708\"}}]}},{\"key\":{\"vec\":[{\"symbol\":\"FarmEntropy\"}]},\"val\":{\"bytes\":\"00000008aae979415c155306b5d139fcf4ce42d0efdd5550e2ea9ccc6a389139\"}},{\"key\":{\"vec\":[{\"symbol\":\"FarmIndex\"}]},\"val\":{\"u32\":53008}},{\"key\":{\"vec\":[{\"symbol\":\"HomesteadAsset\"}]},\"val\":{\"address\":\"CB23WRDQWGSP6YPMY4UV5C4OW5CBTXKYN3XEATG7KJEZCXMJBYEHOUOV\"}},{\"key\":{\"vec\":[{\"symbol\":\"Homesteader\"}]},\"val\":{\"address\":\"GBDVX4VELCDSQ54KQJYTNHXAHFLBCA77ZY2USQBM4CSHTTV7DME7KALE\"}}]}}}}", "key_data": null, "last_modified_ledger_sequence": 57255191 } ] } ], "events": [ { "id": "57255191-9712c48c403a306d6633b0f2b13ddd8f28afb0be480a5d7a5385ffc5670561b7-event-0", "type": "diagnostic", "contract_id": null, "topics": "[{\"symbol\":\"fn_call\"},{\"bytes\":\"d7fe44bd0af11d602b1091f2f4a1f4df212d444d0321ea32adb3cc1cbbab0a04\"},{\"symbol\":\"plant\"}]", "data": "{\"vec\":[{\"address\":\"GDTLBABZ4NHAXUJAT2HIIQ52UDEBXXZLGB5QILBTCMSKEQENRM6PRIZ5\"},{\"i128\":\"0\"}]}", "in_successful_contract_call": true } ] } ]

Configuration

To create a pipeline with this configuration, download the configuration below and replace YOUR_DATABASE_SECRET with your database secret. Then, run goldsky pipeline apply stellar-ledgers-(v2).yaml to create the pipeline.

stellar-ledgers-(v2).yaml

name: stellar-ledgers-(v2)
apiVersion: 3
sources:
  stellar.ledgers_v2:
    dataset_name: stellar.ledgers_v2
    type: dataset
    version: 1.0.0
transforms: {}
sinks:
  postgres_stellar_ledgers_v2:
    type: postgres
    table: stellar_ledgers_v2
    schema: public
    secret_name: YOUR_DATABASE_SECRET
    description: 'Postgres sink for: stellar.ledgers_v2'
    from: stellar.ledgers_v2

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Foundational

Dataset

Ledgers (v2)

Create Pipeline

Chain

Stellar

Example data

1

Column

Type

Value

Configuration

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Social

Foundational

0 more