Data Sources

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

Dataset

Edge Transactions with Instructions

Select a chain

Example data

1

Column	Type	Value
`id`	string	sl_transaction_with_instructions_6R3mKdJLEvJQ1SQzUmgCcjW14izoNgshHGuoeV7k7pYb_11
`index`	long	11
`signature`	string	UchZSVizb3vYtEAoCppPYwMDu3VYKnDfQ1bbCVpA3uoFLig1rzAH3kWS3YNHaTg54cD6o7Z7XqgketJUqrYt5wq
`block_hash`	string	6R3mKdJLEvJQ1SQzUmgCcjW14izoNgshHGuoeV7k7pYb
`recent_block_hash`	string	DcRyE1qJ9CT3AWTANxkEcC8Tya87rzgy1tKAuWcUUY8G
`block_slot`	long	394696656
`block_timestamp`	long	1752669665
`fee`	long	16253
`status`	long	1
`err`	string	null
`accounts`	string	[{"pubkey": "5UFeDg6LRBjuxQcByhPEhkMM5yv8z5qCYARevBo9GbA7", "signer": true, "source": "transaction", "writable": true}, {"pubkey": "4UFmCebEmzESoDTtHrmaftXj7YAsAH4HMios3yMWyVUT", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "4kF8oWNC54qAH8vFbWYmtto3Q1waMxbHnxi8hSmAgPHp", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "5ust7QH4BKebGALEbeH2tAnNYG4ziH7UnVTcxr7wpM4J", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "7XY27WkVSZuDgxrUAYZDs23tuR91Ks8819UJibjmXox8", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "7ZMuYEwqtSyVG8qKrFTt4SvPCE9RB5LSne2MuUhJMzMb", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "9BwVtABrnaa9pAyQB1PUjVb2jq1fjFnm93wetQ2v8LTp", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "AoV7goNVFFQwyLFVbggdp3zL9UbZqW5iXndwxUnHPkyf", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "BeZ4tU4HNe2fGQGUzJmNS2UU2TcZdMUUgnCH6RPg4Dpi", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "BfLybvfuLrCzva8tuXC6QfDnh47Q7zBpxpRX8UaiVzJw", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "CzgBQmwfC66xFQHy2S1XE9zYuTE7jfCAyZNToRhSVVFn", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "EYTaKrJhYgPsSuD8t33aum4aAQYuucK2o3UPPPJYpVze", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "11111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "ComputeBudget111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "SBSTk6t52R89MmCdD739Rdd97HdbTQUFHe41vCX7pTt", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "So11111111111111111111111111111111111111112", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "AGxEfuo9e99QaRfEyMbptLuidqnLg6vDCT4of5NtUtwv", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "Aio4gaXjXzJNVLtzwtNVmSqGKpANtXhybbkhtAC94ji2", "signer": false, "source": "transaction", "writable": false}]
`log_messages`	string	["Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program Aio4gaXjXzJNVLtzwtNVmSqGKpANtXhybbkhtAC94ji2 invoke [1]", "Program log: Instruction: OracleHeartbeat", "Program log: OracleHeartbeat:validate", "Program log: OracleHeartbeat:actuate", "Program log: Rotating mega slot", "Program Aio4gaXjXzJNVLtzwtNVmSqGKpANtXhybbkhtAC94ji2 consumed 32782 of 55685 compute units", "Program Aio4gaXjXzJNVLtzwtNVmSqGKpANtXhybbkhtAC94ji2 success"]
`balance_changes`	string	[{"account": "5UFeDg6LRBjuxQcByhPEhkMM5yv8z5qCYARevBo9GbA7", "before": 2095145651, "after": 2095129398}, {"account": "4UFmCebEmzESoDTtHrmaftXj7YAsAH4HMios3yMWyVUT", "before": 15757440, "after": 15757440}, {"account": "4kF8oWNC54qAH8vFbWYmtto3Q1waMxbHnxi8hSmAgPHp", "before": 2039280, "after": 2039280}, {"account": "5ust7QH4BKebGALEbeH2tAnNYG4ziH7UnVTcxr7wpM4J", "before": 34410240, "after": 34410240}, {"account": "7XY27WkVSZuDgxrUAYZDs23tuR91Ks8819UJibjmXox8", "before": 34410240, "after": 34410240}, {"account": "7ZMuYEwqtSyVG8qKrFTt4SvPCE9RB5LSne2MuUhJMzMb", "before": 2039280, "after": 2039280}, {"account": "9BwVtABrnaa9pAyQB1PUjVb2jq1fjFnm93wetQ2v8LTp", "before": 0, "after": 0}, {"account": "AoV7goNVFFQwyLFVbggdp3zL9UbZqW5iXndwxUnHPkyf", "before": 3340800, "after": 3340800}, {"account": "BeZ4tU4HNe2fGQGUzJmNS2UU2TcZdMUUgnCH6RPg4Dpi", "before": 44599680, "after": 44599680}, {"account": "BfLybvfuLrCzva8tuXC6QfDnh47Q7zBpxpRX8UaiVzJw", "before": 18764160, "after": 18764160}, {"account": "CzgBQmwfC66xFQHy2S1XE9zYuTE7jfCAyZNToRhSVVFn", "before": 9521280, "after": 9521280}, {"account": "EYTaKrJhYgPsSuD8t33aum4aAQYuucK2o3UPPPJYpVze", "before": 2039280, "after": 2039280}, {"account": "11111111111111111111111111111111", "before": 1, "after": 1}, {"account": "ComputeBudget111111111111111111111111111111", "before": 1, "after": 1}, {"account": "SBSTk6t52R89MmCdD739Rdd97HdbTQUFHe41vCX7pTt", "before": 1141440, "after": 1141440}, {"account": "So11111111111111111111111111111111111111112", "before": 1337661623628, "after": 1337661623628}, {"account": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "before": 1934087680, "after": 1934087680}, {"account": "AGxEfuo9e99QaRfEyMbptLuidqnLg6vDCT4of5NtUtwv", "before": 1461600, "after": 1461600}, {"account": "Aio4gaXjXzJNVLtzwtNVmSqGKpANtXhybbkhtAC94ji2", "before": 1141440, "after": 1141440}]
`pre_token_balances`	string	[{"accountIndex": 2, "mint": "So11111111111111111111111111111111111111112", "owner": "4UFmCebEmzESoDTtHrmaftXj7YAsAH4HMios3yMWyVUT", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "0", "decimals": 9, "uiAmount": null, "uiAmountString": "0"}}, {"accountIndex": 5, "mint": "So11111111111111111111111111111111111111112", "owner": "BfLybvfuLrCzva8tuXC6QfDnh47Q7zBpxpRX8UaiVzJw", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "0", "decimals": 9, "uiAmount": null, "uiAmountString": "0"}}, {"accountIndex": 11, "mint": "AGxEfuo9e99QaRfEyMbptLuidqnLg6vDCT4of5NtUtwv", "owner": "4UFmCebEmzESoDTtHrmaftXj7YAsAH4HMios3yMWyVUT", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "109589041095975", "decimals": 9, "uiAmount": 109589.041095975, "uiAmountString": "109589.041095975"}}]
`post_token_balances`	string	[{"accountIndex": 2, "mint": "So11111111111111111111111111111111111111112", "owner": "4UFmCebEmzESoDTtHrmaftXj7YAsAH4HMios3yMWyVUT", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "0", "decimals": 9, "uiAmount": null, "uiAmountString": "0"}}, {"accountIndex": 5, "mint": "So11111111111111111111111111111111111111112", "owner": "BfLybvfuLrCzva8tuXC6QfDnh47Q7zBpxpRX8UaiVzJw", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "0", "decimals": 9, "uiAmount": null, "uiAmountString": "0"}}, {"accountIndex": 11, "mint": "AGxEfuo9e99QaRfEyMbptLuidqnLg6vDCT4of5NtUtwv", "owner": "4UFmCebEmzESoDTtHrmaftXj7YAsAH4HMios3yMWyVUT", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "109589041095975", "decimals": 9, "uiAmount": 109589.041095975, "uiAmountString": "109589.041095975"}}]
`compute_units_consumed`	decimal
`instructions`	string	[{"block_slot": 394696656, "block_timestamp": 1752669665, "block_hash": "6R3mKdJLEvJQ1SQzUmgCcjW14izoNgshHGuoeV7k7pYb", "tx_signature": "UchZSVizb3vYtEAoCppPYwMDu3VYKnDfQ1bbCVpA3uoFLig1rzAH3kWS3YNHaTg54cD6o7Z7XqgketJUqrYt5wq", "tx_status": 1, "tx_index": 11, "tx_fee": 16253, "tx_err": "null", "index": 0, "parent_index": null, "accounts": "[]", "data": "3LAFtugJpNN3", "program": null, "program_id": "ComputeBudget111111111111111111111111111111", "instruction_type": null, "params": "{}", "parsed": "null"}, {"block_slot": 394696656, "block_timestamp": 1752669665, "block_hash": "6R3mKdJLEvJQ1SQzUmgCcjW14izoNgshHGuoeV7k7pYb", "tx_signature": "UchZSVizb3vYtEAoCppPYwMDu3VYKnDfQ1bbCVpA3uoFLig1rzAH3kWS3YNHaTg54cD6o7Z7XqgketJUqrYt5wq", "tx_status": 1, "tx_index": 11, "tx_fee": 16253, "tx_err": "null", "index": 1, "parent_index": null, "accounts": "[]", "data": "Jdjh9Z", "program": null, "program_id": "ComputeBudget111111111111111111111111111111", "instruction_type": null, "params": "{}", "parsed": "null"}, {"block_slot": 394696656, "block_timestamp": 1752669665, "block_hash": "6R3mKdJLEvJQ1SQzUmgCcjW14izoNgshHGuoeV7k7pYb", "tx_signature": "UchZSVizb3vYtEAoCppPYwMDu3VYKnDfQ1bbCVpA3uoFLig1rzAH3kWS3YNHaTg54cD6o7Z7XqgketJUqrYt5wq", "tx_status": 1, "tx_index": 11, "tx_fee": 16253, "tx_err": "null", "index": 2, "parent_index": null, "accounts": "[\"7XY27WkVSZuDgxrUAYZDs23tuR91Ks8819UJibjmXox8\", \"CzgBQmwfC66xFQHy2S1XE9zYuTE7jfCAyZNToRhSVVFn\", \"5UFeDg6LRBjuxQcByhPEhkMM5yv8z5qCYARevBo9GbA7\", \"BeZ4tU4HNe2fGQGUzJmNS2UU2TcZdMUUgnCH6RPg4Dpi\", \"5ust7QH4BKebGALEbeH2tAnNYG4ziH7UnVTcxr7wpM4J\", \"4UFmCebEmzESoDTtHrmaftXj7YAsAH4HMios3yMWyVUT\", \"5UFeDg6LRBjuxQcByhPEhkMM5yv8z5qCYARevBo9GbA7\", \"11111111111111111111111111111111\", \"TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA\", \"So11111111111111111111111111111111111111112\", \"4kF8oWNC54qAH8vFbWYmtto3Q1waMxbHnxi8hSmAgPHp\", \"SBSTk6t52R89MmCdD739Rdd97HdbTQUFHe41vCX7pTt\", \"BfLybvfuLrCzva8tuXC6QfDnh47Q7zBpxpRX8UaiVzJw\", \"AoV7goNVFFQwyLFVbggdp3zL9UbZqW5iXndwxUnHPkyf\", \"EYTaKrJhYgPsSuD8t33aum4aAQYuucK2o3UPPPJYpVze\", \"7ZMuYEwqtSyVG8qKrFTt4SvPCE9RB5LSne2MuUhJMzMb\", \"9BwVtABrnaa9pAyQB1PUjVb2jq1fjFnm93wetQ2v8LTp\", \"7ZMuYEwqtSyVG8qKrFTt4SvPCE9RB5LSne2MuUhJMzMb\", \"9BwVtABrnaa9pAyQB1PUjVb2jq1fjFnm93wetQ2v8LTp\", \"EYTaKrJhYgPsSuD8t33aum4aAQYuucK2o3UPPPJYpVze\", \"AGxEfuo9e99QaRfEyMbptLuidqnLg6vDCT4of5NtUtwv\"]", "data": "hP9bqZU6qVsexWjcP9NGjHsyKE5EzvVMa1sLFwVhyVnUYBw6LGScipmKbNS9fVeNo5PikVRtZa3AbfWeGKmvJqDv9riRvb8h3CB", "program": null, "program_id": "Aio4gaXjXzJNVLtzwtNVmSqGKpANtXhybbkhtAC94ji2", "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 solana-devnet-edge-transactions-with-instructions.yaml to create the pipeline.

solana-devnet-edge-transactions-with-instructions.yaml

name: solana-devnet-edge-transactions-with-instructions
apiVersion: 3
sources:
  solana_devnet.raw_edge_transactions_with_instructions:
    dataset_name: solana_devnet.raw_edge_transactions_with_instructions
    type: dataset
    version: 1.0.0
transforms: {}
sinks:
  postgres_solana_devnet_raw_edge_transactions_with_instructions:
    type: postgres
    table: solana_devnet_raw_edge_transactions_with_instructions
    schema: public
    secret_name: YOUR_DATABASE_SECRET
    description: 'Postgres sink for: solana_devnet.raw_edge_transactions_with_instructions'
    from: solana_devnet.raw_edge_transactions_with_instructions

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Foundational

Dataset

Edge Transactions with Instructions

Create pipeline

Select a chain

Solana Devnet

Solana

Example data

1

Column

Type

Value

Configuration

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Social

Foundational

0 more