| BLOCK_NUMBER | NUMBER | Also known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block. |
| BLOCK_HASH | TEXT | Block hash is a unique 66-character identifier that is generate when a block is produced. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced. |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. |
| NONCE | NUMBER | The number of transactions sent from a given address. |
| POSITION | NUMBER | The position of the transaction within the block. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of the contract call. |
| FROM_ADDRESS | TEXT | Address from where the transaction was sent |
| TO_ADDRESS | TEXT | To address is a unique 42-character identifier that is generated when a transaction is produced. |
| VALUE | FLOAT | Value of the transaction. |
| TX_FEE | FLOAT | The transaction fee. |
| Note: this may be null for the transactions that are reverted, as described in the docs landing page. | | |
| GAS_PRICE | FLOAT | Cost per unit of gas in Gwei. |
| GAS_LIMIT | NUMBER | Total gas limit provided by all transactions in the block. |
| GAS_USED | NUMBER | Gas used by the transaction. |
| CUMULATIVE_GAS_USED | NUMBER | The total amount of gas used when this transaction was executed in the block. |
| Note: this may be null for the transactions that are reverted, as described in the docs landing page. | | |
| INPUT_DATA | TEXT | This column contains additional data for this transaction, and is commonly used as part of a contract interaction or as a message to the recipient. |
| STATUS | TEXT | Status of the transaction. |
| Note: this may be null for the transactions that are reverted, as described in the docs landing page. | | |
| MAX_FEE_PER_GAS | FLOAT | The maximum fee per gas of the transaction, in wei. |
| MAX_PRIORITY_FEE_PER_GAS | FLOAT | The maximum priority fee per gas of the transaction, in wei. |
| R | TEXT | |
| S | TEXT | |
| V | TEXT | |
| TX_TYPE | NUMBER | The type of transaction as introducced in EIP-2718. |
| Note: this may be null for the transactions that are reverted, as described in the docs landing page. | | |
| FACT_TRANSACTIONS_ID | TEXT | A uniquely generated identifier assigned by a surrogate key |
| INSERTED_TIMESTAMP | TIMESTAMP_LTZ | The timestamp at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_LTZ | The timestamp at which this record was last modified by an internal process. |
