| block_slot | The slot of the block containing the tx. | number | 159292973 | |
block_ height | The height of the block containing the tx. | number | 123292963 | |
| block_timestamp | The timestamp of the block containing the tx. | timestamp_ntz | | |
| block_hash | The hash of the block containing the tx. | varchar | 5X6zcnNw6HSAn4X8GaMnzBp8JnWPcNHoAThFwFN1oeph | |
| txn_id | Unique base58 identifier of the transaction | varchar | 5Bc8KuxsmRCiLkBJhL7wYuTsawUiux2enj4xYr7FsPG7eUxVoCPKwqj9LcCAvTztA2drUJghUBTqo8C62qpRMM4H | |
| txn_index | The index of this tx within the block. Used for strict ordering of transactions | number | 5 | |
| signatures | array of signatures for this transaction. usually, the initiator of the tx and fee payor is assumed to be signatures[0] | variant | [“4pGL1btb5pL8ir7nQZdt9uxpkaFTi8aUHRigo2QA1MMgXwb2SzLumGkoy7TLfo6Dv6zvaMj7yjBYxv2TU3wxzBRY”] | |
| fee | Fee this transaction was charged | number | 5000 | |
| err | JSON with info about a transaction error, if a tx fail. Null for a successful tx. | varchar | Null/
{ "InstructionError": [ 0, "InvalidArgument" ] } | |
| account_keys | Accounts needed for the tx | variant | [key1, key2, key3, key4, …] | |
| recent_block_hash | A recent block hash in the past, used as a nonce | varchar | 47S8ZnTiR1my1HqEfdWe9f9XqThW6svjqUwXF5N2ZBBk | |
| signer | first pubkey of account_keys | varchar | key1 | |
| log_messages | array of string log messages or null if log message recording was not enabled during this transaction | variant | ”Program 11111111111111111111111111111111 invoke [1]”, “Program 11111111111111111111111111111111 success”, “Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [1]”, “Program log: Instruction: InitializeMint”, | |
| pre_token_balances | List of token balances from before the transaction was processed | variant | [a,b,c] | |
| post_token_balances | List of token balances from after the transaction was processed | variant | [a,b,c] | |
| pre_balances | array of u64 account balances from before the transaction was processed | variant | [a,b,c] | |
| post_balances | array of u64 account balances after the transaction was processed | variant | [a,b,c] | |
| success | indicates if the transaction was successful | boolean | true/false | |
| | | | Table Columns| Column Name | Description | Sample Value | Column Name |
|---|
| block_timestamp | The time when the block was included on the blockchain. | 2022-09-15 13:51:47 | | | block_number | The length of the chain, in blocks. | 15539508 | | | block_hash | Unique identifier for that block. | 0x25680259dfb40b4ee724ae22fda01a34e6d598c5f2fc25b6d871cb56c488de70 | | | parent_hash | Unique identifier of the block preceding this block, also known as the parent block. | 0x46707e33e9dca09ec95f0fc8b996e3bbce3ad3e02ea270939207bab1f809066f | Table Columns| Column Name | Description | Sample Value | Column Name |
|---|
| block_timestamp | The time when the block was included on the blockchain. | 2022-09-15 13:51:47 | | | block_number | The length of the chain, in blocks. | 15539508 | | | block_hash | Unique identifier for that block. | 0x25680259dfb40b4ee724ae22fda01a34e6d598c5f2fc25b6d871cb56c488de70 | | | parent_hash | Unique identifier of the block preceding this block, also known as the parent block. | 0x46707e33e9dca09ec95f0fc8b996e3bbce3ad3e02ea270939207bab1f809066f | | | gas_limit | Gas limit of the current block. | 30000000 | | | gas_used | Total gas used in the block. | 6999860 | | | miner | Proof of Stake
Address receiving fees from transactions in this block
Proof of Work
Address of the miner that mined this block. | 0x388c818ca8b9251b393131c08a736a67ccb19297 | | | transaction_count | Number of transactions included in this block. | 95 | | | nonce | Proof of Stake
Unused post Merge. The value will always be 0x0000000000000000
Proof of Work
Used to demonstrate proof of work during mining | 0x090c1db284e8b101 | | | difficulty | The effort required to mine this block.
Proof of Stake
Always 0 | 11594723311525902 | | | total_difficulty | Total difficulty of the chain until this block. | 58750003716598352816469 | | | size | The size of the block, in bytes, as determined by the gas_limit. | 23628 | | | base_fee_per_gas | Post London Upgrade (EIP1559), this represents the minimum gas_used required for a transaction to be included in a block.
Represented in wei. | 10966453825 | |
| | gas_limit | Gas limit of the current block. | 30000000 | | | gas_used | Total gas used in the block. | 6999860 | | | miner | Proof of Stake
Address receiving fees from transactions in this block
Proof of Work
Address of the miner that mined this block. | 0x388c818ca8b9251b393131c08a736a67ccb19297 | | | transaction_count | Number of transactions included in this block. | 95 | | | nonce | Proof of Stake
Unused post Merge. The value will always be 0x0000000000000000
Proof of Work
Used to demonstrate proof of work during mining | 0x090c1db284e8b101 | | | difficulty | The effort required to mine this block.
Proof of Stake
Always 0 | 11594723311525902 | | | total_difficulty | Total difficulty of the chain until this block. | 58750003716598352816469 | | | size | The size of the block, in bytes, as determined by the gas_limit. | 23628 | | | base_fee_per_gas | Post London Upgrade (EIP1559), this represents the minimum gas_used required for a transaction to be included in a block.
Represented in wei. | 10966453825 | |
|
