Fact Transactions

Schema: monad.core Table: fact_transactions Type: Fact Table

​

What

This table contains comprehensive transaction-level data for EVM blockchains. Each row represents a single transaction with its execution details, gas consumption, and value transfers. This is a high-level table for analyzing on-chain activity, user behavior, and protocol interactions.

​

​

Columns

Examp… | | BLOB_GAS_PRICE | FLOAT | Actual price paid per blob gas unit. Example: 1 | | BLOB_GAS_USED | TEXT | Gas consumed by blob transactions (EIP-4844, post-Dencun)… | | BLOB_VERSIONED_HASHES | TEXT | Array of blob commitment hashes for EIP-4844 transactions… | | BLOCK_NUMBER | NUMBER | Sequential counter representing the position of a block i… | | BLOCK_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the block was produced by validators/m… | | CUMULATIVE_GAS_USED | TEXT | Running total of gas consumed by all transactions up to a… | | EFFECTIVE_GAS_PRICE | FLOAT | Actual price paid per gas unit for EIP-1559 transactions,… | | ETH_VALUE | TEXT | ETH value for cross-chain transactions on L2s. Example: 0.5 | | FACT_TRANSACTIONS_ID | TEXT | Primary key - unique identifier for each row ensuring dat… | | FROM_ADDRESS | TEXT | The externally-owned account (EOA) or contract address th… | | GAS_LIMIT | TEXT | Maximum gas units the sender is willing to consume for th… | | GAS_PRICE | FLOAT | Price per gas unit in Gwei (1 Gwei = 1e-9 native token). … | | GAS_USED | TEXT | Actual gas units consumed by transaction execution. Exam… | | INPUT_DATA | TEXT | Encoded data sent with the transaction, containing functi… | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flip… | | L1_BASE_FEE_SCALAR | FLOAT | Multiplier for L1 base fee in L2 fee calculation. Exampl… | | L1_BLOB_BASE_FEE | FLOAT | L1 blob base fee at time of L2 transaction. Example: 1 | | L1_BLOB_BASE_FEE_SCALAR | FLOAT | Multiplier for blob base fee in L2 calculations. Example… | | L1_FEE | FLOAT | The L1 portion of fees paid. | | L1_FEE_PRECISE | FLOAT | Formatted L1 fee for L2 transactions, in native token uni… | | L1_FEE_PRECISE_RAW | NUMBER | Raw L1 data availability fee for L2 transactions, in Gwei… | | L1_FEE_SCALAR | FLOAT | This value covers the change in L1 gas price between the … | | L1_GAS_PRICE | FLOAT | The gas price for L1 transactions when the transaction wa… | | L1_GAS_USED | TEXT | The gas used on L1 to publish the transaction from the OP… | | MAX_FEE_PER_BLOB_GAS | FLOAT | Maximum price sender will pay per blob gas unit. Example: 3 | | MAX_FEE_PER_GAS | FLOAT | Maximum total fee per gas unit sender is willing to pay (… | | MAX_PRIORITY_FEE_PER_GAS | FLOAT | Maximum tip per gas unit for validator (EIP-1559), in Gwe… | | MINT | TEXT | Minting event data for special transactions. Example: null | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. … | | NONCE | TEXT | Sequential counter of transactions sent by the from_addre… | | OPERATOR_FEE_CONSTANT | FLOAT | OP Stack fixed operator fee component. Example: 0 | | OPERATOR_FEE_SCALAR | FLOAT | OP Stack operator fee multiplier. Example: 100 | | ORIGIN_FUNCTION_SIGNATURE | TEXT | Function signature (first 4 bytes) of the called method. … | | R | TEXT | R component of ECDSA signature (32 bytes). Example: ‘0x1… | | S | TEXT | S component of ECDSA signature (32 bytes). Example: ‘0xa… | | SOURCE_HASH | TEXT | Hash linking L2 transactions to their L1 origin. Example… | | TIMEBOOSTED | TEXT | Arbitrum-specific priority transaction flag. Example: false | | TOKEN_RATIO | TEXT | ETH/MNT price ratio for Mantle network fee calculations. … | | TO_ADDRESS | TEXT | The destination address for the transaction - either an E… | | TX_FEE | FLOAT | Total fee paid for transaction execution in native token … | | TX_FEE_PRECISE | FLOAT | Exact transaction fee as string to prevent floating-point… | | TX_HASH | TEXT | Unique 66-character identifier for the transaction. **Fo… | | TX_POSITION | TEXT | Zero-indexed position of transaction within its block. *… | | TX_SUCCEEDED | TEXT | Boolean indicator of transaction success. Values:

• … | | TX_TYPE | TEXT | Transaction envelope type (EIP-2718).

Example: 2 | | V | TEXT | Recovery identifier for ECDSA signature. Example: 27 | | VALUE | TEXT | Amount of native tokens transferred, in token units (not … | | VALUE_PRECISE | TEXT | String representation of numeric values adjusted for huma… | | VALUE_PRECISE_RAW | TEXT | String representation of numeric values preserving exact … | | Y_PARITY | TEXT | Y coordinate parity for signature recovery (EIP-2098). E… |