Transactions with Instructions
Chain
FogoDataset name
fogo.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_FaAJboa3i3PUZeRt7RBraQT2y2QetSBXfrFwXqSM5TrZ_1 | 1 | 9nsW9SCAHqr3uxvuFiJvzbd99T4ds2Td9tLWZe7CYQczViN91c5RdJ1K5rkxobYXB5pf4A94xUQEVWaXwe2T9Eq | FaAJboa3i3PUZeRt7RBraQT2y2QetSBXfrFwXqSM5TrZ | E4Pymadjs6aKhtU5a6cg5htXwdppRw8rP4LpsJXuj3UH | 36216418 | 1760713885 | 5000 | 1 | null | [{"pubkey": "6TSDMQd3EBvjFHXrTEcKdodgMcd4Pze7sDoNXP4xpRcT", "signer": true, "source": "transaction", "writable": true}, {"pubkey": "HdRqqKbcgYtoBSZSCBLbKH67862f77qwHGersbqTWp21", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "Vote111111111111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}] | ["Program Vote111111111111111111111111111111111111111 invoke [1]", "Program Vote111111111111111111111111111111111111111 success"] | [{"account": "6TSDMQd3EBvjFHXrTEcKdodgMcd4Pze7sDoNXP4xpRcT", "before": 1013008992797, "after": 1013008987797}, {"account": "HdRqqKbcgYtoBSZSCBLbKH67862f77qwHGersbqTWp21", "before": 121286250891000, "after": 121286250891000}, {"account": "Vote111111111111111111111111111111111111111", "before": 1, "after": 1}] | [] | [] | 4 | [{"block_slot": 36216418, "block_timestamp": 1760713885, "block_hash": "FaAJboa3i3PUZeRt7RBraQT2y2QetSBXfrFwXqSM5TrZ", "tx_signature": "9nsW9SCAHqr3uxvuFiJvzbd99T4ds2Td9tLWZe7CYQczViN91c5RdJ1K5rkxobYXB5pf4A94xUQEVWaXwe2T9Eq", "tx_status": 1, "tx_index": 1, "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\": \"9rZmoEC8rM7RuXwLZDmqfzfYX47zoskUKJuTWLzj7QgT\", \"hash\": \"6gWmTzDiLASvQNQa8jAkWQKBwDExUsQeJGqVLfUtG3Ly\", \"lockouts\": [{\"confirmation_count\": 31, \"slot\": 36216387}, {\"confirmation_count\": 30, \"slot\": 36216388}, {\"confirmation_count\": 29, \"slot\": 36216389}, {\"confirmation_count\": 28, \"slot\": 36216390}, {\"confirmation_count\": 27, \"slot\": 36216391}, {\"confirmation_count\": 26, \"slot\": 36216392}, {\"confirmation_count\": 25, \"slot\": 36216393}, {\"confirmation_count\": 24, \"slot\": 36216394}, {\"confirmation_count\": 23, \"slot\": 36216395}, {\"confirmation_count\": 22, \"slot\": 36216396}, {\"confirmation_count\": 21, \"slot\": 36216397}, {\"confirmation_count\": 20, \"slot\": 36216398}, {\"confirmation_count\": 19, \"slot\": 36216399}, {\"confirmation_count\": 18, \"slot\": 36216400}, {\"confirmation_count\": 17, \"slot\": 36216401}, {\"confirmation_count\": 16, \"slot\": 36216402}, {\"confirmation_count\": 15, \"slot\": 36216403}, {\"confirmation_count\": 14, \"slot\": 36216404}, {\"confirmation_count\": 13, \"slot\": 36216405}, {\"confirmation_count\": 12, \"slot\": 36216406}, {\"confirmation_count\": 11, \"slot\": 36216407}, {\"confirmation_count\": 10, \"slot\": 36216408}, {\"confirmation_count\": 9, \"slot\": 36216409}, {\"confirmation_count\": 8, \"slot\": 36216410}, {\"confirmation_count\": 7, \"slot\": 36216411}, {\"confirmation_count\": 6, \"slot\": 36216412}, {\"confirmation_count\": 5, \"slot\": 36216413}, {\"confirmation_count\": 4, \"slot\": 36216414}, {\"confirmation_count\": 3, \"slot\": 36216415}, {\"confirmation_count\": 2, \"slot\": 36216416}, {\"confirmation_count\": 1, \"slot\": 36216417}], \"root\": 36216386, \"timestamp\": 1760713885}, \"voteAccount\": \"HdRqqKbcgYtoBSZSCBLbKH67862f77qwHGersbqTWp21\", \"voteAuthority\": \"6TSDMQd3EBvjFHXrTEcKdodgMcd4Pze7sDoNXP4xpRcT\"}", "parsed": "null"}] |
| sl_transaction_with_instructions_GFuD19LwZmX9waX9qUJeousrm3Bsecw1v3AsJLYWnKqS_2 | 2 | w9Zcc5LCxLd3xakGimmLqGapJXJMgh4FpuQaHZYQ4WKGLp1hQZtEqYnm7FsyNdM8N5hWePbB5rkEhJrh7xm1BJa | GFuD19LwZmX9waX9qUJeousrm3Bsecw1v3AsJLYWnKqS | FaAJboa3i3PUZeRt7RBraQT2y2QetSBXfrFwXqSM5TrZ | 36216419 | 1760713885 | 5000 | 1 | null | [{"pubkey": "3ayHBu7k7aWBJxp8dLEuVYFatn2V2frqcxDvTCpmyCsn", "signer": true, "source": "transaction", "writable": true}, {"pubkey": "DPebxDKSC678HxLZJ1V7PgjfsfGfAnmEDTerXwBggbpv", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "Vote111111111111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}] | ["Program Vote111111111111111111111111111111111111111 invoke [1]", "Program Vote111111111111111111111111111111111111111 success"] | [{"account": "3ayHBu7k7aWBJxp8dLEuVYFatn2V2frqcxDvTCpmyCsn", "before": 75788665000, "after": 75788660000}, {"account": "DPebxDKSC678HxLZJ1V7PgjfsfGfAnmEDTerXwBggbpv", "before": 1750315487356259, "after": 1750315487356259}, {"account": "Vote111111111111111111111111111111111111111", "before": 1, "after": 1}] | [] | [] | 4 | [{"block_slot": 36216419, "block_timestamp": 1760713885, "block_hash": "GFuD19LwZmX9waX9qUJeousrm3Bsecw1v3AsJLYWnKqS", "tx_signature": "w9Zcc5LCxLd3xakGimmLqGapJXJMgh4FpuQaHZYQ4WKGLp1hQZtEqYnm7FsyNdM8N5hWePbB5rkEhJrh7xm1BJa", "tx_status": 1, "tx_index": 2, "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\": \"3Cr955vkAjDacgpJ1cJPcmwLFhFaUw9brcch7od4dVZh\", \"hash\": \"GoS9871pWq7xQYPB6CSCXZFSDNDGpNWvJqGzwxQTHQD\", \"lockouts\": [{\"confirmation_count\": 31, \"slot\": 36216388}, {\"confirmation_count\": 30, \"slot\": 36216389}, {\"confirmation_count\": 29, \"slot\": 36216390}, {\"confirmation_count\": 28, \"slot\": 36216391}, {\"confirmation_count\": 27, \"slot\": 36216392}, {\"confirmation_count\": 26, \"slot\": 36216393}, {\"confirmation_count\": 25, \"slot\": 36216394}, {\"confirmation_count\": 24, \"slot\": 36216395}, {\"confirmation_count\": 23, \"slot\": 36216396}, {\"confirmation_count\": 22, \"slot\": 36216397}, {\"confirmation_count\": 21, \"slot\": 36216398}, {\"confirmation_count\": 20, \"slot\": 36216399}, {\"confirmation_count\": 19, \"slot\": 36216400}, {\"confirmation_count\": 18, \"slot\": 36216401}, {\"confirmation_count\": 17, \"slot\": 36216402}, {\"confirmation_count\": 16, \"slot\": 36216403}, {\"confirmation_count\": 15, \"slot\": 36216404}, {\"confirmation_count\": 14, \"slot\": 36216405}, {\"confirmation_count\": 13, \"slot\": 36216406}, {\"confirmation_count\": 12, \"slot\": 36216407}, {\"confirmation_count\": 11, \"slot\": 36216408}, {\"confirmation_count\": 10, \"slot\": 36216409}, {\"confirmation_count\": 9, \"slot\": 36216410}, {\"confirmation_count\": 8, \"slot\": 36216411}, {\"confirmation_count\": 7, \"slot\": 36216412}, {\"confirmation_count\": 6, \"slot\": 36216413}, {\"confirmation_count\": 5, \"slot\": 36216414}, {\"confirmation_count\": 4, \"slot\": 36216415}, {\"confirmation_count\": 3, \"slot\": 36216416}, {\"confirmation_count\": 2, \"slot\": 36216417}, {\"confirmation_count\": 1, \"slot\": 36216418}], \"root\": 36216387, \"timestamp\": 1760713885}, \"voteAccount\": \"DPebxDKSC678HxLZJ1V7PgjfsfGfAnmEDTerXwBggbpv\", \"voteAuthority\": \"3ayHBu7k7aWBJxp8dLEuVYFatn2V2frqcxDvTCpmyCsn\"}", "parsed": "null"}] |
| sl_transaction_with_instructions_CsN6iNvrjh1sxKhnwBw4Kr1NWZq5srtXEdJycuJANmG6_0 | 0 | 3StaQL9FyACJErqzz7TYUwVLmcLbVpfsUAiKsDDNWjwvAwigY4PWpb1eU1UVkgdNeydxBBiBM2DQpCzfNPUe2DJi | CsN6iNvrjh1sxKhnwBw4Kr1NWZq5srtXEdJycuJANmG6 | Emh5wHJKUvn6vcKsXKZoCcZ93j9REboVQkX6CYMbFgsp | 36216425 | 1760713885 | 5000 | 1 | null | [{"pubkey": "FLXAfPmtiDgNCyuwVHKZBVzswy82W3exL4mYAhKKMt2X", "signer": true, "source": "transaction", "writable": true}, {"pubkey": "FLVAzAUpGEtmndEsSqmAoYUEmUE5tENiwpWTRgJX6BUS", "signer": false, "source": "transaction", "writable": true}, {"pubkey": "Vote111111111111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false}] | ["Program Vote111111111111111111111111111111111111111 invoke [1]", "Program Vote111111111111111111111111111111111111111 success"] | [{"account": "FLXAfPmtiDgNCyuwVHKZBVzswy82W3exL4mYAhKKMt2X", "before": 14184715000, "after": 14184710000}, {"account": "FLVAzAUpGEtmndEsSqmAoYUEmUE5tENiwpWTRgJX6BUS", "before": 1342920455898275, "after": 1342920455898275}, {"account": "Vote111111111111111111111111111111111111111", "before": 1, "after": 1}] | [] | [] | 4 | [{"block_slot": 36216425, "block_timestamp": 1760713885, "block_hash": "CsN6iNvrjh1sxKhnwBw4Kr1NWZq5srtXEdJycuJANmG6", "tx_signature": "3StaQL9FyACJErqzz7TYUwVLmcLbVpfsUAiKsDDNWjwvAwigY4PWpb1eU1UVkgdNeydxBBiBM2DQpCzfNPUe2DJi", "tx_status": 1, "tx_index": 0, "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\": \"11111111111111111111111111111111\", \"hash\": \"5EB1tpG4Rmkii6W8J95Pd4fKHW4dFSr41RQBGfwR3Qkx\", \"lockouts\": [{\"confirmation_count\": 31, \"slot\": 36216394}, {\"confirmation_count\": 30, \"slot\": 36216395}, {\"confirmation_count\": 29, \"slot\": 36216396}, {\"confirmation_count\": 28, \"slot\": 36216397}, {\"confirmation_count\": 27, \"slot\": 36216398}, {\"confirmation_count\": 26, \"slot\": 36216399}, {\"confirmation_count\": 25, \"slot\": 36216400}, {\"confirmation_count\": 24, \"slot\": 36216401}, {\"confirmation_count\": 23, \"slot\": 36216402}, {\"confirmation_count\": 22, \"slot\": 36216403}, {\"confirmation_count\": 21, \"slot\": 36216404}, {\"confirmation_count\": 20, \"slot\": 36216405}, {\"confirmation_count\": 19, \"slot\": 36216406}, {\"confirmation_count\": 18, \"slot\": 36216407}, {\"confirmation_count\": 17, \"slot\": 36216408}, {\"confirmation_count\": 16, \"slot\": 36216409}, {\"confirmation_count\": 15, \"slot\": 36216410}, {\"confirmation_count\": 14, \"slot\": 36216411}, {\"confirmation_count\": 13, \"slot\": 36216412}, {\"confirmation_count\": 12, \"slot\": 36216413}, {\"confirmation_count\": 11, \"slot\": 36216414}, {\"confirmation_count\": 10, \"slot\": 36216415}, {\"confirmation_count\": 9, \"slot\": 36216416}, {\"confirmation_count\": 8, \"slot\": 36216417}, {\"confirmation_count\": 7, \"slot\": 36216418}, {\"confirmation_count\": 6, \"slot\": 36216419}, {\"confirmation_count\": 5, \"slot\": 36216420}, {\"confirmation_count\": 4, \"slot\": 36216421}, {\"confirmation_count\": 3, \"slot\": 36216422}, {\"confirmation_count\": 2, \"slot\": 36216423}, {\"confirmation_count\": 1, \"slot\": 36216424}], \"root\": 36216393, \"timestamp\": 1760713885}, \"voteAccount\": \"FLVAzAUpGEtmndEsSqmAoYUEmUE5tENiwpWTRgJX6BUS\", \"voteAuthority\": \"FLXAfPmtiDgNCyuwVHKZBVzswy82W3exL4mYAhKKMt2X\"}", "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 |