Skip to main content
Schema: near.gov Table: fact_staking_actions Type: View

​
Description

This table contains all staking-related transactions on the NEAR Protocol blockchain, capturing staking actions such as deposits, withdrawals, and reward distributions. The data includes staking amounts, action types, and associated metadata, providing comprehensive tracking of staking participation and validator interactions. This table provides the foundation for staking analytics, validator performance analysis, and governance participation tracking across the NEAR ecosystem.

​
Key Use Cases

  • Staking participation analysis and user behavior tracking
  • Validator performance analysis and staking pool comparison
  • Staking reward analysis and yield optimization
  • Staking pattern analysis and trend identification
  • Cross-pool staking comparison and performance benchmarking
  • Staking pool health monitoring and risk assessment
  • Governance participation analysis and voting power tracking

​
Important Relationships

  • Links to core.fact_transactions through tx_hash for transaction context
  • Connects to core.fact_blocks through block_id for temporal context
  • Provides staking data for gov.ez_staking_actions with enhanced metadata
  • Supports gov.fact_staking_pool_balances with action impact analysis
  • Enables analysis in stats.ez_core_metrics_hourly for staking metrics
  • Powers cross-pool analysis and validator performance comparison

​
Commonly-used Fields

  • tx_hash: Essential for linking to transaction details and verification
  • block_timestamp: Primary field for time-series analysis and trend detection
  • action: Critical for staking action classification and analysis
  • amount: Important for staking volume analysis and participation tracking
  • address: Essential for staking pool identification and analysis
  • signer_id: Important for user behavior analysis and staking patterns
  • predecessor_id: Useful for action flow tracking and context analysis

​
Columns

Column NameData TypeDescription
TX_HASHTEXTUnique identifier (hash) of this transaction.
BLOCK_IDNUMBERThe height of the chain this block corresponds with.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block began.
RECEIPT_OBJECT_IDTEXTPlease note this column is being deprecated in favor of simply “receipt_id”.
ADDRESSTEXTThe NEAR address of the staking pool.
PREDECESSOR_IDTEXTAccount that called the relevant receipt (often the same as tx_signer, but can be system as well). This field identifies the account that directly invoked the receipt being processed. In simple transactions, this is typically the same as the transaction signer. However, in cross-contract calls or system operations, this may be a different account or the system account. This is crucial for understanding the call chain and access control in NEAR’s execution model.
SIGNER_IDTEXTSigner of the receipt, often same as tx_signer, sometimes system in the case of systemic gas refunds. This field identifies the account that has the authority to execute the receipt. In most cases, this is the same as the transaction signer, but in system operations like gas refunds, this may be the system account. The signer is the account that originally signed the transaction that began the blockchain activity, which may or may not include cross-contract calls.
ACTIONTEXTThe staking action performed in this transaction. Can be "Stake" or "Unstake" if in the deprecating dim_staking_actions table, or staking, unstaking, deposited, withdrawing if in the new fact_staking_actions table. These method names are taken directly from the log in which they occur.
AMOUNTFLOATThe amount of tokens transferred
If in the ez* view, this number is decimal adjusted to actual amount. If in silver level or a fact* view, the raw amount is presented
FACT_STAKING_ACTIONS_IDTEXTA unique identifier for the record.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe timestamp at which the record was initially created and inserted into this table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe timestamp at which this record was last modified by an internal process.