Data Sources

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

Dataset

Transactions with Instructions

Chain

Fogo Testnet

Example data

1

Column	Type	Value
`id`	string	sl_transaction_with_instructions_AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co_3
`index`	long	3
`signature`	string	3GD55efbjBeb6f3JSkih1mdeuhnvgoQiWSL8h4P2tghJnyyt6cYjvnJiC6WymENphNbtwgMP9QUM3rbPcvDXghf
`block_hash`	string	AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co
`recent_block_hash`	string	4Abph142yPV4qzAGrwtUb1DSS8xUa7WR2kDTYtcWhELc
`block_slot`	long	109128326
`block_timestamp`	long	1747828003
`fee`	long	5000
`status`	long	1
`err`	string	null
`accounts`	string	[{"pubkey": "8TF8HBp9EoPCfxqPFQGaXSDD8aAoJbPKiXjaEhrghJzP", "signer": true, "source": "transaction", "writable": true}, {"pubkey": "Fvt5CeoSYopGo5gPJvjrS8Rd8wNBjkik8PzjSLbVpz4a", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "11111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "ComputeBudget111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}]
`log_messages`	string	["Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success", "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success"]
`balance_changes`	string	[{"account": "8TF8HBp9EoPCfxqPFQGaXSDD8aAoJbPKiXjaEhrghJzP", "before": 327956835159, "after": 327956830155}, {"account": "Fvt5CeoSYopGo5gPJvjrS8Rd8wNBjkik8PzjSLbVpz4a", "before": 326931743789, "after": 326931743793}, {"account": "11111111111111111111111111111111", "before": 1, "after": 1}, {"account": "ComputeBudget111111111111111111111111111111", "before": 1, "after": 1}]
`pre_token_balances`	string	[]
`post_token_balances`	string	[]
`compute_units_consumed`	decimal	1
`instructions`	string	[{"block_slot": 109128326, "block_timestamp": 1747828003, "block_hash": "AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co", "tx_signature": "3GD55efbjBeb6f3JSkih1mdeuhnvgoQiWSL8h4P2tghJnyyt6cYjvnJiC6WymENphNbtwgMP9QUM3rbPcvDXghf", "tx_status": 1, "tx_index": 3, "tx_fee": 5000, "tx_err": "null", "index": 0, "parent_index": null, "accounts": "null", "data": null, "program": "system", "program_id": "11111111111111111111111111111111", "instruction_type": "transfer", "params": "{\"destination\": \"Fvt5CeoSYopGo5gPJvjrS8Rd8wNBjkik8PzjSLbVpz4a\", \"lamports\": 4, \"source\": \"8TF8HBp9EoPCfxqPFQGaXSDD8aAoJbPKiXjaEhrghJzP\"}", "parsed": "null"}, {"block_slot": 109128326, "block_timestamp": 1747828003, "block_hash": "AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co", "tx_signature": "3GD55efbjBeb6f3JSkih1mdeuhnvgoQiWSL8h4P2tghJnyyt6cYjvnJiC6WymENphNbtwgMP9QUM3rbPcvDXghf", "tx_status": 1, "tx_index": 3, "tx_fee": 5000, "tx_err": "null", "index": 1, "parent_index": null, "accounts": "[]", "data": "FDJTAf", "program": null, "program_id": "ComputeBudget111111111111111111111111111111", "instruction_type": null, "params": "{}", "parsed": "null"}]

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 fogo-testnet-transactions-with-instructions.yaml to create the pipeline.

fogo-testnet-transactions-with-instructions.yaml

name: fogo-testnet-transactions-with-instructions
apiVersion: 3
sources:
  fogo_testnet.raw_transactions_with_instructions:
    dataset_name: fogo_testnet.raw_transactions_with_instructions
    type: dataset
    version: 1.0.0
transforms: {}
sinks:
  postgres_fogo_testnet_raw_transactions_with_instructions:
    type: postgres
    table: fogo_testnet_raw_transactions_with_instructions
    schema: public
    secret_name: YOUR_DATABASE_SECRET
    description: 'Postgres sink for: fogo_testnet.raw_transactions_with_instructions'
    from: fogo_testnet.raw_transactions_with_instructions

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Foundational

Dataset

Transactions with Instructions

Create Pipeline

Chain

Fogo Testnet

Example data

1

Column

Type

Value

Configuration

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Social

Foundational

0 more