Data Sources

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

Dataset

Non-Vote Edge Transactions with Instructions

Chain

Solana

Example data

1

Column	Type	Value
`id`	string	sl_transaction_with_instructions_Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R_940
`index`	long	940
`signature`	string	4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa
`block_hash`	string	Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R
`recent_block_hash`	string	C3wwh7hhk26fMpZcYHu9kfHZWnkb3Am3VCzwLFAo93dj
`block_slot`	long	316536780
`block_timestamp`	long	1737914132
`fee`	long	1005000
`status`	long	1
`err`	string	null
`accounts`	string	[{"pubkey": "54Mqxmm2S4Usfb1WzWbdMGem5B8T83MUBXSwVYvMTPFG", "signer": true, "source": "transaction", "writable": true}, {"pubkey": "97p7LtDejMRUeG7QtJG15RTmrxZx5jW7ffMJWm2ZrPa7", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "BB5dnY55FXS1e1NXqZDwCzgdYJdMCj3B92PU6Q5Fb6DT", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "GBZWDGdtqUvcD1p5g5FWDED5ENksdSHXJjrpj45nHnLx", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "HYuYZJsN7ZmuZGasAA6mytnBnssDrSyxGZVcXm8W1jxA", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "11111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "4wTV1YmiEkRvAtNtsSGPtUrqRYQMe5SKy2uB4Jjaxnjf", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "5qJaT2vZZ6gRuesjwvWgM8KTJZDkiQX1MVkQDo5Ppump", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "Ce6TQqeHC9p8KetsN6JsjHK7UTZk7nasjjnr7XxXp9F1", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "ComputeBudget111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "SysvarRent111111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "signer": false, "source": "transaction", "writable": false}]
`log_messages`	string	["Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program 6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P invoke [1]", "Program log: Instruction: Buy", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [2]", "Program log: Instruction: Transfer", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA consumed 4645 of 278063 compute units", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA success", "Program 11111111111111111111111111111111 invoke [2]", "Program 11111111111111111111111111111111 success", "Program 11111111111111111111111111111111 invoke [2]", "Program 11111111111111111111111111111111 success", "Program 6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P invoke [2]", "Program 6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P consumed 2003 of 265975 compute units", "Program 6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P success", "Program data: vdt/007mYe5HzoAmRAbnc+4ImugR7p49/r66XFjpt43cmzGaBhk7L+APlwAAAAAA4/D5wwkAAAABPEsPB1BusiEknaVM/zOkN186cLTC+SW1R0azLfEDS4MUd5ZnAAAAAMSM1EsUAAAAJauJydlPAQDE4LBPDQAAACUTd31IUQAA", "Program 6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P consumed 37453 of 299700 compute units", "Program 6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P success", "Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success"]
`balance_changes`	string	[]
`pre_token_balances`	string	[{"accountIndex": 1, "mint": "5qJaT2vZZ6gRuesjwvWgM8KTJZDkiQX1MVkQDo5Ppump", "owner": "HYuYZJsN7ZmuZGasAA6mytnBnssDrSyxGZVcXm8W1jxA", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "296313727093768", "decimals": 6, "uiAmount": 296313727.093768, "uiAmountString": "296313727.093768"}}, {"accountIndex": 4, "mint": "5qJaT2vZZ6gRuesjwvWgM8KTJZDkiQX1MVkQDo5Ppump", "owner": "54Mqxmm2S4Usfb1WzWbdMGem5B8T83MUBXSwVYvMTPFG", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "180682925715", "decimals": 6, "uiAmount": 180682.925715, "uiAmountString": "180682.925715"}}]
`post_token_balances`	string	[{"accountIndex": 1, "mint": "5qJaT2vZZ6gRuesjwvWgM8KTJZDkiQX1MVkQDo5Ppump", "owner": "HYuYZJsN7ZmuZGasAA6mytnBnssDrSyxGZVcXm8W1jxA", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "296271784450853", "decimals": 6, "uiAmount": 296271784.450853, "uiAmountString": "296271784.450853"}}, {"accountIndex": 4, "mint": "5qJaT2vZZ6gRuesjwvWgM8KTJZDkiQX1MVkQDo5Ppump", "owner": "54Mqxmm2S4Usfb1WzWbdMGem5B8T83MUBXSwVYvMTPFG", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": {"amount": "222625568630", "decimals": 6, "uiAmount": 222625.56863, "uiAmountString": "222625.56863"}}]
`compute_units_consumed`	decimal
`instructions`	string	[{"block_slot": 316536780, "block_timestamp": 1737914132, "block_hash": "Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R", "tx_signature": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa", "tx_status": 1, "tx_index": 940, "tx_fee": 1005000, "tx_err": "null", "index": 0, "parent_index": null, "accounts": "null", "data": null, "program": "spl-token", "program_id": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "instruction_type": "transfer", "params": "{\"amount\": \"41942642915\", \"authority\": \"HYuYZJsN7ZmuZGasAA6mytnBnssDrSyxGZVcXm8W1jxA\", \"destination\": \"GBZWDGdtqUvcD1p5g5FWDED5ENksdSHXJjrpj45nHnLx\", \"source\": \"97p7LtDejMRUeG7QtJG15RTmrxZx5jW7ffMJWm2ZrPa7\"}", "parsed": "null", "instruction_id": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa_2_0"}, {"block_slot": 316536780, "block_timestamp": 1737914132, "block_hash": "Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R", "tx_signature": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa", "tx_status": 1, "tx_index": 940, "tx_fee": 1005000, "tx_err": "null", "index": 1, "parent_index": null, "accounts": "null", "data": null, "program": "system", "program_id": "11111111111111111111111111111111", "instruction_type": "transfer", "params": "{\"destination\": \"HYuYZJsN7ZmuZGasAA6mytnBnssDrSyxGZVcXm8W1jxA\", \"lamports\": 9900000, \"source\": \"54Mqxmm2S4Usfb1WzWbdMGem5B8T83MUBXSwVYvMTPFG\"}", "parsed": "null", "instruction_id": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa_2_1"}, {"block_slot": 316536780, "block_timestamp": 1737914132, "block_hash": "Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R", "tx_signature": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa", "tx_status": 1, "tx_index": 940, "tx_fee": 1005000, "tx_err": "null", "index": 2, "parent_index": null, "accounts": "null", "data": null, "program": "system", "program_id": "11111111111111111111111111111111", "instruction_type": "transfer", "params": "{\"destination\": \"CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM\", \"lamports\": 99000, \"source\": \"54Mqxmm2S4Usfb1WzWbdMGem5B8T83MUBXSwVYvMTPFG\"}", "parsed": "null", "instruction_id": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa_2_2"}, {"block_slot": 316536780, "block_timestamp": 1737914132, "block_hash": "Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R", "tx_signature": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa", "tx_status": 1, "tx_index": 940, "tx_fee": 1005000, "tx_err": "null", "index": 3, "parent_index": null, "accounts": "[\"Ce6TQqeHC9p8KetsN6JsjHK7UTZk7nasjjnr7XxXp9F1\"]", "data": "2K7nL28PxCW8ejnyCeuMpbWL4UMP8GD3uuTamTjTM6eDz3hHWwgPFFZAua4NT9D4xJUzmSTagw8d2G4poXZjD52nQZHLirYnezcGKJSYsWDPTb3vvzwKUEvLjjUtfsECmtX6cRb1QSpGNZHmpEcqMv6Kvi8rcojmVZMG2neMJRKe7Cvh8CwmydknAjTV", "program": null, "program_id": "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P", "instruction_type": null, "params": "{}", "parsed": "null", "instruction_id": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa_2_3"}, {"block_slot": 316536780, "block_timestamp": 1737914132, "block_hash": "Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R", "tx_signature": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa", "tx_status": 1, "tx_index": 940, "tx_fee": 1005000, "tx_err": "null", "index": 0, "parent_index": null, "accounts": "[]", "data": "3qEGrGUXVibh", "program": null, "program_id": "ComputeBudget111111111111111111111111111111", "instruction_type": null, "params": "{}", "parsed": "null", "instruction_id": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa_None_0"}, {"block_slot": 316536780, "block_timestamp": 1737914132, "block_hash": "Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R", "tx_signature": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa", "tx_status": 1, "tx_index": 940, "tx_fee": 1005000, "tx_err": "null", "index": 1, "parent_index": null, "accounts": "[]", "data": "Kq1GWK", "program": null, "program_id": "ComputeBudget111111111111111111111111111111", "instruction_type": null, "params": "{}", "parsed": "null", "instruction_id": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa_None_1"}, {"block_slot": 316536780, "block_timestamp": 1737914132, "block_hash": "Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R", "tx_signature": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa", "tx_status": 1, "tx_index": 940, "tx_fee": 1005000, "tx_err": "null", "index": 2, "parent_index": null, "accounts": "[\"4wTV1YmiEkRvAtNtsSGPtUrqRYQMe5SKy2uB4Jjaxnjf\", \"CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM\", \"5qJaT2vZZ6gRuesjwvWgM8KTJZDkiQX1MVkQDo5Ppump\", \"HYuYZJsN7ZmuZGasAA6mytnBnssDrSyxGZVcXm8W1jxA\", \"97p7LtDejMRUeG7QtJG15RTmrxZx5jW7ffMJWm2ZrPa7\", \"GBZWDGdtqUvcD1p5g5FWDED5ENksdSHXJjrpj45nHnLx\", \"54Mqxmm2S4Usfb1WzWbdMGem5B8T83MUBXSwVYvMTPFG\", \"11111111111111111111111111111111\", \"TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA\", \"SysvarRent111111111111111111111111111111111\", \"Ce6TQqeHC9p8KetsN6JsjHK7UTZk7nasjjnr7XxXp9F1\", \"6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P\"]", "data": "AJTQ2h9DXrC7Hh8JwWFsXBXUJUsxveCEB", "program": null, "program_id": "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P", "instruction_type": null, "params": "{}", "parsed": "null", "instruction_id": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa_None_2"}, {"block_slot": 316536780, "block_timestamp": 1737914132, "block_hash": "Bmthyu7jBuJmqBENEZNRWTjAeU69qpWbVPAHiFDSjd8R", "tx_signature": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa", "tx_status": 1, "tx_index": 940, "tx_fee": 1005000, "tx_err": "null", "index": 3, "parent_index": null, "accounts": "null", "data": null, "program": "system", "program_id": "11111111111111111111111111111111", "instruction_type": "transfer", "params": "{\"destination\": \"BB5dnY55FXS1e1NXqZDwCzgdYJdMCj3B92PU6Q5Fb6DT\", \"lamports\": 100000, \"source\": \"54Mqxmm2S4Usfb1WzWbdMGem5B8T83MUBXSwVYvMTPFG\"}", "parsed": "null", "instruction_id": "4w5THXLh3ojVJ4NDJfCdoLrEG7GofQsz8PhLnWvrwCqskdg7TRV9THabdmriHVv3idLXe7CnXLnQaqZEynbr4MKa_None_3"}]
`is_vote_instruction`	int	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-non-vote-edge-transactions-with-instructions.yaml to create the pipeline.

solana-non-vote-edge-transactions-with-instructions.yaml

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

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Foundational

Dataset

Non-Vote 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