Data Sources

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

Dataset

Edge Transactions with Instructions

Chain

Solana

Example data

1

Column	Type	Value
`id`	string	sl_transaction_with_instructions_4VC23n9G5MhEFyq6TrsQy5dXMvwnqcGvSE9n7XF9B6KX_19
`index`	long	19
`signature`	string	5Zv4iB7D8yCicfQZQqCMJ888YZgaGGpAPufePTZxzPodvMumvRXn37JyMXWEcG29v6xhpixBzMffQWDA71dQhaJ
`block_hash`	string	4VC23n9G5MhEFyq6TrsQy5dXMvwnqcGvSE9n7XF9B6KX
`recent_block_hash`	string	6hdos4EsorGhzkihxViuZ9V5NKid4vNowT3oQYJrSV39
`block_slot`	long	316536766
`block_timestamp`	long	1737914127
`fee`	long	5000
`status`	long	1
`err`	string	null
`accounts`	string	[{"pubkey": "A5nvA7aUhcQWBeKFaf8WC7e5Ryzp4piuWc3hkvpLfgSs", "signer": true, "source": "transaction", "writable": true}, {"pubkey": "GdRKUZKdiXMEATjddQW6q4W8bPgXRBYJKayfeqdQcEPa", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "Vote111111111111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}]
`log_messages`	string	["Program Vote111111111111111111111111111111111111111 invoke [1]", "Program Vote111111111111111111111111111111111111111 success"]
`balance_changes`	string	[]
`pre_token_balances`	string	[]
`post_token_balances`	string	[]
`compute_units_consumed`	decimal	4
`instructions`	string	[{"block_slot": 316536766, "block_timestamp": 1737914127, "block_hash": "4VC23n9G5MhEFyq6TrsQy5dXMvwnqcGvSE9n7XF9B6KX", "tx_signature": "5Zv4iB7D8yCicfQZQqCMJ888YZgaGGpAPufePTZxzPodvMumvRXn37JyMXWEcG29v6xhpixBzMffQWDA71dQhaJ", "tx_status": 1, "tx_index": 19, "tx_fee": 5000, "tx_err": "null", "index": 0, "parent_index": null, "accounts": "null", "data": null, "program": "vote", "program_id": "Vote111111111111111111111111111111111111111", "instruction_type": "compactupdatevotestate", "params": "{\"voteAccount\": \"GdRKUZKdiXMEATjddQW6q4W8bPgXRBYJKayfeqdQcEPa\", \"voteAuthority\": \"A5nvA7aUhcQWBeKFaf8WC7e5Ryzp4piuWc3hkvpLfgSs\", \"voteStateUpdate\": {\"hash\": \"EQNdax2b5a8VsLwvsbcBkqru2b1UhYrqY4zmaZnGJsDR\", \"lockouts\": [{\"confirmation_count\": 31, \"slot\": 316536734}, {\"confirmation_count\": 30, \"slot\": 316536735}, {\"confirmation_count\": 29, \"slot\": 316536736}, {\"confirmation_count\": 28, \"slot\": 316536737}, {\"confirmation_count\": 27, \"slot\": 316536738}, {\"confirmation_count\": 26, \"slot\": 316536739}, {\"confirmation_count\": 25, \"slot\": 316536740}, {\"confirmation_count\": 24, \"slot\": 316536741}, {\"confirmation_count\": 23, \"slot\": 316536742}, {\"confirmation_count\": 22, \"slot\": 316536743}, {\"confirmation_count\": 21, \"slot\": 316536744}, {\"confirmation_count\": 20, \"slot\": 316536745}, {\"confirmation_count\": 19, \"slot\": 316536746}, {\"confirmation_count\": 18, \"slot\": 316536747}, {\"confirmation_count\": 17, \"slot\": 316536748}, {\"confirmation_count\": 16, \"slot\": 316536749}, {\"confirmation_count\": 15, \"slot\": 316536750}, {\"confirmation_count\": 14, \"slot\": 316536751}, {\"confirmation_count\": 13, \"slot\": 316536752}, {\"confirmation_count\": 12, \"slot\": 316536753}, {\"confirmation_count\": 11, \"slot\": 316536754}, {\"confirmation_count\": 10, \"slot\": 316536755}, {\"confirmation_count\": 9, \"slot\": 316536756}, {\"confirmation_count\": 8, \"slot\": 316536757}, {\"confirmation_count\": 7, \"slot\": 316536758}, {\"confirmation_count\": 6, \"slot\": 316536759}, {\"confirmation_count\": 5, \"slot\": 316536760}, {\"confirmation_count\": 4, \"slot\": 316536761}, {\"confirmation_count\": 3, \"slot\": 316536762}, {\"confirmation_count\": 2, \"slot\": 316536763}, {\"confirmation_count\": 1, \"slot\": 316536764}], \"root\": 316536733, \"timestamp\": 1737914127}}", "parsed": "null", "instruction_id": "5Zv4iB7D8yCicfQZQqCMJ888YZgaGGpAPufePTZxzPodvMumvRXn37JyMXWEcG29v6xhpixBzMffQWDA71dQhaJ_None_0"}]

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

solana-edge-transactions-with-instructions.yaml

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

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Foundational

Dataset

Edge Transactions with Instructions

Create Pipeline

Chain

Solana

Example data

1

Column

Type

Value

Configuration

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Social

Foundational

0 more