| 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_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. |
| FROM_ADDRESS | TEXT | The sending address of this transaction. |
| TO_ADDRESS | TEXT | The receiving address of this transaction. This can be a contract address. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of the contract call. |
| VALUE | FLOAT | The value transacted in ETH. |
| VALUE_PRECISE_RAW | TEXT | The precise, unadjusted amount of the transaction. This is returned as a string to avoid precision loss. |
| VALUE_PRECISE | TEXT | The precise, adjusted amount of the transaction. This is returned as a string to avoid precision loss. |
| TX_FEE | FLOAT | Amount paid to validate the transaction in ETH. |
| TX_FEE_PRECISE | TEXT | The precise amount of the transaction fee. This is returned as a string to avoid precision loss. |
| TX_SUCCEEDED | BOOLEAN | Whether the transaction was successful, returned as a boolean. |
| TX_TYPE | NUMBER | |
| NONCE | NUMBER | The number of transactions sent from a given address. |
| TX_POSITION | NUMBER | The position of the transaction within the block. |
| 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. |
| GAS_PRICE | FLOAT | Cost per unit of gas in Gwei. |
| EFFECTIVE_GAS_PRICE | FLOAT | The total base charge plus tip paid for each unit of gas, in Gwei. |
| GAS_USED | NUMBER | Gas used by transaction. |
| GAS_LIMIT | NUMBER | Maximum amount of gas allocated for the transaction. |
| CUMULATIVE_GAS_USED | NUMBER | The total amount of gas used when this transaction was executed in the block. |
| MAX_FEE_PER_GAS | FLOAT | The maximum fee per gas of the transaction, in Gwei. |
| MAX_PRIORITY_FEE_PER_GAS | FLOAT | The maximum priority fee per gas of the transaction, in Gwei. |
| ACCESS_LIST | VARIANT | |
| Y_PARITY | NUMBER | |
| R | TEXT | The r value of the transaction signature. |
| S | TEXT | The s value of the transaction signature. |
| V | NUMBER | The v value of the transaction signature. |
| FACT_TRANSACTIONS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |
