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

​
Description

This table contains comprehensive metadata for staking pools on the NEAR Protocol blockchain, including pool addresses, owners, reward fee structures, and pool creation details. The data covers all staking pools that participate in NEAR’s proof-of-stake consensus mechanism, providing essential context for staking analysis, validator performance tracking, and governance participation. This dimension table supports all staking-related analytics by providing standardized pool information and enabling proper staking pool categorization and analysis.

​
Key Use Cases

  • Staking pool identification and metadata enrichment
  • Validator performance analysis and pool comparison
  • Staking pool fee structure analysis and optimization
  • Pool creation and lifecycle tracking
  • Cross-pool performance benchmarking
  • Staking pool discovery and participation analysis
  • Governance participation tracking and analysis

​
Important Relationships

  • Enriches gov.fact_staking_actions with pool metadata and context
  • Supports gov.fact_staking_pool_balances with pool identification
  • Provides metadata for gov.ez_staking_actions with enhanced pool context
  • Enables analysis in stats.ez_core_metrics_hourly for staking metrics
  • Supports cross-pool analysis and validator performance comparison
  • Powers governance analytics and staking participation analysis

​
Commonly-used Fields

  • address: Essential for joining with staking action and balance data
  • owner: Critical for validator identification and ownership analysis
  • reward_fee_fraction: Important for fee structure analysis and optimization
  • tx_hash: Essential for pool creation transaction linking and verification
  • block_timestamp: Primary field for time-series analysis and pool lifecycle tracking
  • tx_type: Important for pool operation classification and analysis
  • inserted_timestamp: Useful for pool discovery timeline analysis

​
Columns

Column NameData TypeDescription
TX_HASHTEXTUnique identifier (hash) of this transaction.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block began.
OWNERTEXTThe account of the staking pool owner.
ADDRESSTEXTThe pool address delegated into.
REWARD_FEE_FRACTIONVARIANTAn object representing the fraction of the reward fee taken by the staking pool.
TX_TYPETEXTThe type of transaction involving this staking pool.
Either "Create" for staking pool creation or "Update" for reward_fee_fraction updates.
DIM_STAKING_POOLS_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.