Transactions with Instructions
Chain
Fogo TestnetDataset name
fogo_testnet.raw_transactions_with_instructionsVersion
1.0.0Description
Enriched transaction data including instructions, accounts, balance changes, and metadata for the block.
Example data
| id | index | signature | block_hash | recent_block_hash | block_slot | block_timestamp | fee | status | err | accounts | log_messages | balance_changes | pre_token_balances | post_token_balances | compute_units_consumed | instructions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| sl_transaction_with_instructions_AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co_3 | 3 | 3GD55efbjBeb6f3JSkih1mdeuhnvgoQiWSL8h4P2tghJnyyt6cYjvnJiC6WymENphNbtwgMP9QUM3rbPcvDXghf | AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co | 4Abph142yPV4qzAGrwtUb1DSS8xUa7WR2kDTYtcWhELc | 109128326 | 1747828003 | 5000 | 1 | null | [{"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}] | ["Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success", "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success"] | [{"account": "8TF8HBp9EoPCfxqPFQGaXSDD8aAoJbPKiXjaEhrghJzP", "before": 327956835159, "after": 327956830155}, {"account": "Fvt5CeoSYopGo5gPJvjrS8Rd8wNBjkik8PzjSLbVpz4a", "before": 326931743789, "after": 326931743793}, {"account": "11111111111111111111111111111111", "before": 1, "after": 1}, {"account": "ComputeBudget111111111111111111111111111111", "before": 1, "after": 1}] | [] | [] | 1 | [{"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"}] |
| sl_transaction_with_instructions_AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co_23 | 23 | 36pYz6WKHEENsXZu1dej1TyVB4gydmSbVVUVyT2m5qky5piCzQR2t4UYEKdDskaZq5AB1PSxewCGaTwCGZj28Zaj | AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co | 4Abph142yPV4qzAGrwtUb1DSS8xUa7WR2kDTYtcWhELc | 109128326 | 1747828003 | 5000 | 1 | null | [{"pubkey": "FjLHdH44f8uN3kxrnxEuuLyLqeR7mp6jZ4d8NT3bk5os", "signer": true, "source": "transaction", "writable": true}, {"pubkey": "8zz8eLTvPU2Ajx6UnbaqcKgxy9VXiY3sMKbD5AKVmXcm", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "11111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}, {"pubkey": "ComputeBudget111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}] | ["Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success", "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success"] | [{"account": "FjLHdH44f8uN3kxrnxEuuLyLqeR7mp6jZ4d8NT3bk5os", "before": 326916451555, "after": 326916446550}, {"account": "8zz8eLTvPU2Ajx6UnbaqcKgxy9VXiY3sMKbD5AKVmXcm", "before": 326941770778, "after": 326941770783}, {"account": "11111111111111111111111111111111", "before": 1, "after": 1}, {"account": "ComputeBudget111111111111111111111111111111", "before": 1, "after": 1}] | [] | [] | 1 | [{"block_slot": 109128326, "block_timestamp": 1747828003, "block_hash": "AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co", "tx_signature": "36pYz6WKHEENsXZu1dej1TyVB4gydmSbVVUVyT2m5qky5piCzQR2t4UYEKdDskaZq5AB1PSxewCGaTwCGZj28Zaj", "tx_status": 1, "tx_index": 23, "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\": \"8zz8eLTvPU2Ajx6UnbaqcKgxy9VXiY3sMKbD5AKVmXcm\", \"lamports\": 5, \"source\": \"FjLHdH44f8uN3kxrnxEuuLyLqeR7mp6jZ4d8NT3bk5os\"}", "parsed": "null"}, {"block_slot": 109128326, "block_timestamp": 1747828003, "block_hash": "AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co", "tx_signature": "36pYz6WKHEENsXZu1dej1TyVB4gydmSbVVUVyT2m5qky5piCzQR2t4UYEKdDskaZq5AB1PSxewCGaTwCGZj28Zaj", "tx_status": 1, "tx_index": 23, "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"}] |
| sl_transaction_with_instructions_AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co_49 | 49 | 21yyf5N1xpBF1FVq2sZnvFSoc81gp2wyMpnRKYcZayZ7wdZy3uJvFNwLuz2j4SPqTKXBSMQJkGvpYvLNJ6cbds3r | AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co | 9USuFo2uoeQjXEmLw3mZRghfVSvhAEAe4NwVMgbnCRZ3 | 109128326 | 1747828003 | 5000 | 1 | null | [{"pubkey": "EFvgxLbUFEPsWTdLXEr32peGvcofpa6WWHDk9gwKFCqU", "signer": true, "source": "transaction", "writable": true}, {"pubkey": "4mzPaWyuM7HrTAhFGZ3UWwcBAqbths93Bo2sWGxxFciM", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "Vote111111111111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}] | ["Program Vote111111111111111111111111111111111111111 invoke [1]", "Program Vote111111111111111111111111111111111111111 success"] | [{"account": "EFvgxLbUFEPsWTdLXEr32peGvcofpa6WWHDk9gwKFCqU", "before": 967408855000, "after": 967408850000}, {"account": "4mzPaWyuM7HrTAhFGZ3UWwcBAqbths93Bo2sWGxxFciM", "before": 27074400, "after": 27074400}, {"account": "Vote111111111111111111111111111111111111111", "before": 1, "after": 1}] | [] | [] | 1 | [{"block_slot": 109128326, "block_timestamp": 1747828003, "block_hash": "AGwN77fVieYa3VHRj462uUrcuLqjjYgn45DxYeXUE5co", "tx_signature": "21yyf5N1xpBF1FVq2sZnvFSoc81gp2wyMpnRKYcZayZ7wdZy3uJvFNwLuz2j4SPqTKXBSMQJkGvpYvLNJ6cbds3r", "tx_status": 1, "tx_index": 49, "tx_fee": 5000, "tx_err": "null", "index": 0, "parent_index": null, "accounts": "null", "data": null, "program": "vote", "program_id": "Vote111111111111111111111111111111111111111", "instruction_type": "towersync", "params": "{\"towerSync\": {\"blockId\": \"7T2zFJatmGerXDiT4vioaT2ZBsYXuA1qPbEawbkVMWTN\", \"hash\": \"EDCWbTznKKf6HowvWNofwQzn1ZysXwHJVfiXvU5DBgVe\", \"lockouts\": [{\"confirmation_count\": 31, \"slot\": 109128295}, {\"confirmation_count\": 30, \"slot\": 109128296}, {\"confirmation_count\": 29, \"slot\": 109128297}, {\"confirmation_count\": 28, \"slot\": 109128298}, {\"confirmation_count\": 27, \"slot\": 109128299}, {\"confirmation_count\": 26, \"slot\": 109128300}, {\"confirmation_count\": 25, \"slot\": 109128301}, {\"confirmation_count\": 24, \"slot\": 109128302}, {\"confirmation_count\": 23, \"slot\": 109128303}, {\"confirmation_count\": 22, \"slot\": 109128304}, {\"confirmation_count\": 21, \"slot\": 109128305}, {\"confirmation_count\": 20, \"slot\": 109128306}, {\"confirmation_count\": 19, \"slot\": 109128307}, {\"confirmation_count\": 18, \"slot\": 109128308}, {\"confirmation_count\": 17, \"slot\": 109128309}, {\"confirmation_count\": 16, \"slot\": 109128310}, {\"confirmation_count\": 15, \"slot\": 109128311}, {\"confirmation_count\": 14, \"slot\": 109128312}, {\"confirmation_count\": 13, \"slot\": 109128313}, {\"confirmation_count\": 12, \"slot\": 109128314}, {\"confirmation_count\": 11, \"slot\": 109128315}, {\"confirmation_count\": 10, \"slot\": 109128316}, {\"confirmation_count\": 9, \"slot\": 109128317}, {\"confirmation_count\": 8, \"slot\": 109128318}, {\"confirmation_count\": 7, \"slot\": 109128319}, {\"confirmation_count\": 6, \"slot\": 109128320}, {\"confirmation_count\": 5, \"slot\": 109128321}, {\"confirmation_count\": 4, \"slot\": 109128322}, {\"confirmation_count\": 3, \"slot\": 109128323}, {\"confirmation_count\": 2, \"slot\": 109128324}, {\"confirmation_count\": 1, \"slot\": 109128325}], \"root\": 109128294, \"timestamp\": 1747828003}, \"voteAccount\": \"4mzPaWyuM7HrTAhFGZ3UWwcBAqbths93Bo2sWGxxFciM\", \"voteAuthority\": \"EFvgxLbUFEPsWTdLXEr32peGvcofpa6WWHDk9gwKFCqU\"}", "parsed": "null"}] |
Schema
| Column | Type |
|---|---|
| id | string |
| index | long |
| signature | string |
| block_hash | string |
| recent_block_hash | string |
| block_slot | long |
| block_timestamp | long |
| fee | long |
| status | long |
| err | string |
| accounts | string |
| log_messages | string |
| balance_changes | string |
| pre_token_balances | string |
| post_token_balances | string |
| compute_units_consumed | decimal |
| instructions | string |