| 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 call that triggered this transaction. |
| VALUE | FLOAT | The value transacted in the native asset. |
| 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 the native asset. |
| 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. |
| GAS_USED | NUMBER | Gas used by the 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. |
| EFFECTIVE_GAS_PRICE | FLOAT | The total base charge plus tip paid for each unit of gas, in Gwei. |
| 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. |
| L1_GAS_PRICE | FLOAT | The gas price for L1 transactions when the transaction was processed from the OP stack L2 chain. |
| L1_GAS_USED | FLOAT | The gas used on L1 to publish the transaction from the OP stack L2 chain. |
| L1_FEE_SCALAR | FLOAT | This value covers the change in L1 gas price between the time the transaction is submitted and when it is published from the OP stack L2 chain. |
| L1_FEE_PRECISE | TEXT | The precise amount of the L1 fee. This is returned as a string to avoid precision loss. |
| L1_FEE | FLOAT | The L1 portion of fees paid. |
| Y_PARITY | TEXT | The y parity of the transaction signature. |
| R | TEXT | The r value of the transaction signature. |
| S | TEXT | The s value of the transaction signature. |
| V | TEXT | 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. |
| BLOCK_HASH | TEXT | This column is being deprecated for standardization purposes. Please remove from your queries by March 10, 2025. |
| STATUS | TEXT | This column is being deprecated for standardization purposes. Please update your queries to use the tx_succeeded column instead by March 10, 2025. |
| POSITION | NUMBER | This column is being deprecated for standardization purposes. Please update your queries to use the tx_position column instead by March 10, 2025. |
| DEPOSIT_NONCE | NUMBER | This column is being deprecated for standardization purposes. Please remove from your queries by March 10, 2025. |
| DEPOSIT_RECEIPT_VERSION | NUMBER | This column is being deprecated for standardization purposes. Please remove from your queries by March 10, 2025. |
