Skip to main content
Schema: flow.core_evm Table: fact_transactions Type: Base Table

​
Description

A comprehensive fact table containing transaction-level data for EVM-compatible blockchains. This table serves as the primary source for transaction analysis, providing detailed information about each transaction including sender/receiver addresses, values, gas usage, fees, and execution status. The table supports analysis of transaction patterns, user behavior, and network activity across multiple EVM chains. Each record represents a single transaction with complete execution details and metadata.

​
Key Use Cases

  • Transaction Analysis: Tracking transaction volumes, success rates, and execution patterns
  • User Behavior Analysis: Understanding transaction patterns and user activity across EVM chains
  • Gas Analysis: Monitoring gas usage, fee structures, and transaction economics
  • Cross-Chain Activity: Comparing transaction patterns across different EVM-compatible blockchains
  • Contract Interaction Analysis: Understanding smart contract usage and interaction patterns
  • Network Performance: Monitoring transaction processing efficiency and network health

​
Important Relationships

  • core_evm__fact_blocks: Links to block data containing each transaction
  • core_evm__fact_event_logs: Links to event logs emitted by transactions
  • core_evm__fact_traces: Links to execution traces for detailed transaction analysis
  • core_evm__dim_contracts: Links to contract metadata for contract interactions
  • core_evm__dim_labels: Links to address labels for user identification
  • core__fact_transactions: May provide comparison data with native Flow transactions

​
Commonly-used Fields

  • TX_HASH: Essential for transaction identification and blockchain verification
  • FROM_ADDRESS/TO_ADDRESS: Critical for transaction flow analysis and user behavior studies
  • VALUE: Important for transaction value analysis and economic activity tracking
  • GAS_USED/GAS_PRICE: Key for gas economics and transaction cost analysis
  • TX_SUCCEEDED: Critical for success rate analysis and error tracking
  • BLOCK_TIMESTAMP: Essential for time-series analysis and temporal data aggregation

​
Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
FROM_ADDRESSTEXTThe sending address of this transaction.
TO_ADDRESSTEXTThe receiving address of this transaction. This can be a contract address.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of the call that triggered this transaction.
VALUEFLOATThe value transacted in the native asset.
VALUE_PRECISE_RAWTEXTThe precise, unadjusted amount of the transaction. This is returned as a string to avoid precision loss.
VALUE_PRECISETEXTThe precise, adjusted amount of the transaction. This is returned as a string to avoid precision loss.
TX_FEEFLOATAmount paid to validate the transaction in the native asset.
TX_FEE_PRECISETEXTThe precise amount of the transaction fee. This is returned as a string to avoid precision loss.
TX_SUCCEEDEDBOOLEANWhether the transaction was successful, returned as a boolean.
TX_TYPENUMBERThe type of transaction.
NONCENUMBERThe number of transactions sent from a given address.
TX_POSITIONNUMBERThe position of the transaction within the block.
INPUT_DATATEXTThis 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_PRICEFLOATCost per unit of gas in Gwei.
GAS_USEDNUMBERGas used by the transaction.
GAS_LIMITNUMBERMaximum amount of gas allocated for the transaction.
CUMULATIVE_GAS_USEDNUMBERThe total amount of gas used when this transaction was executed in the block.
EFFECTIVE_GAS_PRICENUMBERThe total base charge plus tip paid for each unit of gas, in Gwei.
MAX_FEE_PER_GASFLOATThe maximum fee per gas of the transaction, in Gwei.
MAX_PRIORITY_FEE_PER_GASFLOATThe maximum priority fee per gas of the transaction, in Gwei.
Y_PARITYNUMBERThe y parity for the transaction.
ACCESS_LISTVARIANTThe access list for the transaction.
RTEXTThe r value of the transaction signature.
STEXTThe s value of the transaction signature.
VNUMBERThe v value of the transaction signature.
FACT_TRANSACTIONS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was last modified.