| EPOCH | NUMBER | A period of time consisting of 432,000 blocks, which represents a higher-level timekeeping unit within the Solana network |
| EPOCH_START_TIMESTAMP | TIMESTAMP_NTZ | The timestamp of the first block in the epoch, providing the actual start time of the epoch based on real block production. Used for accurate time-based analysis and USD price lookups. |
| EPOCH_END_TIMESTAMP | TIMESTAMP_NTZ | The timestamp of the last block in the epoch, providing the actual end time of the epoch based on real block production. Used for calculating epoch duration and time-based analysis. |
| VOTE_PUBKEY | TEXT | Account address of voter |
| NODE_PUBKEY | TEXT | The account for the validator node on the Solana network. This field identifies the specific validator that participates in network consensus and receives stake delegations. Data type: STRING (Solana address) Business context: Used to identify validators, track performance, and analyze stake delegation patterns. Analytics use cases: Validator identification, performance tracking, and stake delegation analysis. Example: ‘9WzDXwBbmkg8ZTbNMqUxvQRAyrZzDsGYdLVL9zYtAWWM’ |
| AUTHORIZED_WITHDRAWER | TEXT | The base58-encoded public key authorized to withdraw funds from the validator’s vote account. This controls access to validator earnings and stake withdrawals, providing security for validator operations. |
| VALIDATOR_NAME | TEXT | The name of the validator. This field provides a human-readable identifier for the validator, enabling easier identification and branding analysis. Data type: STRING (validator name) Business context: Used to identify validators, analyze branding, and track user experience with different validators. Analytics use cases: Validator identification, branding analysis, and user experience tracking. Example: ‘Solana Foundation’, ‘Chorus One’, ‘Stakefish’ |
| ACTIVE_STAKE_SOL | FLOAT | The total amount of SOL actively staked to this validator during the epoch, converted from lamports to SOL (divided by 1e9). This represents the validator’s voting power and determines their share of rewards. |
| COMMISSION | NUMBER | The percentage of rewards payout to the vote account. This field represents the fee rate that the validator charges on staking rewards, expressed as a decimal percentage. Data type: DECIMAL (percentage as decimal) Business context: Used to analyze validator fee structures, model reward distributions, and study validator economics. Analytics use cases: Validator fee analysis, reward distribution modeling, and validator economics studies. Example: 0.05, 0.10, 0.00 |
| DELINQUENT | BOOLEAN | A boolean flag indicating whether the validator is offline or delinquent. This field tracks the operational status of validators, enabling network health monitoring and reliability analysis. Data type: BOOLEAN (TRUE/FALSE) Business context: Used to monitor network health, analyze validator reliability, and track uptime performance. Analytics use cases: Network health monitoring, validator reliability analysis, and uptime tracking. Example: TRUE, FALSE |
| VALIDATOR_INFLATION_EARNINGS_SOL | FLOAT | SOL earned by the validator from inflation rewards (voting rewards) during the epoch. This represents the validator’s share of network inflation distributed based on their voting participation and commission rate. |
| VALIDATOR_FEE_EARNINGS_SOL | FLOAT | SOL earned by the validator from transaction fees during the epoch. Validators earn fees from transactions in blocks they produce, providing additional income beyond inflation rewards. |
| VALIDATOR_TOTAL_EARNINGS_SOL | FLOAT | Total SOL earned by the validator from traditional sources (inflation + fees) during the epoch, excluding MEV earnings. This represents the validator’s base earnings before considering MEV participation. |
| VALIDATOR_INFLATION_EARNINGS_USD | FLOAT | USD value of SOL earned by the validator from inflation rewards during the epoch, calculated using SOL price at epoch start time. Provides dollar-denominated view of validator inflation earnings for financial analysis. |
| VALIDATOR_FEE_EARNINGS_USD | FLOAT | USD value of SOL earned by the validator from transaction fees during the epoch, calculated using SOL price at epoch start time. Shows the dollar value of fee-based validator income. |
| VALIDATOR_TOTAL_EARNINGS_USD | FLOAT | USD value of total SOL earned by the validator from traditional sources (inflation + fees) during the epoch, calculated using SOL price at epoch start time. Excludes MEV earnings for baseline validator income analysis. |
| DELEGATOR_EARNINGS_SOL | FLOAT | Total SOL earned by all delegators staking to this validator during the epoch. This represents the portion of rewards distributed to delegators after the validator’s commission is deducted. |
| DELEGATOR_EARNINGS_USD | FLOAT | USD value of total SOL earned by all delegators staking to this validator during the epoch, calculated using SOL price at epoch start time. Shows the dollar value of rewards distributed to delegators. |
| TOTAL_REWARDS_SOL | FLOAT | Total SOL rewards distributed for this validator during the epoch, including both validator earnings and delegator earnings. This represents the complete reward pool before commission splits. |
| TOTAL_REWARDS_USD | FLOAT | USD value of total SOL rewards distributed for this validator during the epoch, calculated using SOL price at epoch start time. Represents the complete reward pool in dollar terms before commission splits. |
| MEV_EARNED_EPOCH_SOL | NUMBER | Total SOL earned from Maximum Extractable Value (MEV) activities during the epoch through Jito. This includes MEV rewards from transaction ordering, arbitrage opportunities, and other value extraction methods. |
| MEV_COMMISSION_EARNED_SOL | NUMBER | SOL earned by the validator as commission from MEV activities during the epoch. This is calculated as MEV earnings multiplied by the validator’s MEV commission rate, representing the validator’s share of MEV profits. |
| PRIORITY_FEE_REWARDS_SOL | NUMBER | SOL earned from priority fees during the epoch through Jito. Priority fees are additional payments users make to have their transactions processed faster, providing extra income for participating validators. |
| MEV_EARNED_EPOCH_USD | FLOAT | USD value of total SOL earned from MEV activities during the epoch, calculated using SOL price at epoch start time. Provides dollar-denominated view of MEV earnings for financial analysis. |
| MEV_COMMISSION_EARNED_USD | FLOAT | USD value of SOL earned by the validator as commission from MEV activities, calculated using SOL price at epoch start time. Shows the dollar value of the validator’s MEV commission earnings. |
| PRIORITY_FEE_REWARDS_USD | FLOAT | USD value of SOL earned from priority fees during the epoch, calculated using SOL price at epoch start time. Represents the dollar value of priority fee income through Jito. |
| STAKE_POOLS_LIST | ARRAY | Array of stake pool names that the validator participates in or is associated with. Stake pools are services that aggregate stake from multiple delegators and distribute it across validators. Common examples include “Jito”, “Marinade”, “Lido”, and others. This field helps identify which liquid staking protocols or delegation services the validator works with. Data type: ARRAY (of strings) |
| ACTIVE_STAKE_USD | FLOAT | USD value of total SOL actively staked to this validator during the epoch, calculated using SOL price at epoch start time. Provides dollar-denominated view of validator stake size for financial analysis. |
| ASSIGNED_SLOTS | NUMBER | Number of leader slots assigned to this validator during the epoch. Leader slots are opportunities to produce blocks and earn transaction fees, allocated based on the validator’s stake weight. |
| BLOCKS_PRODUCED | NUMBER | Number of blocks successfully produced by this validator during the epoch. This indicates the validator’s reliability and directly impacts their fee earnings and network contribution. |
| MISSED_SLOTS | NUMBER | Number of assigned leader slots where the validator failed to produce a block. High missed slots indicate performance issues and result in lost fee earnings and reduced network efficiency. |
| UPTIME_PCT | FLOAT | Percentage of assigned slots where the validator successfully produced blocks (blocksproduced / assignedslots * 100). Higher uptime indicates better validator performance and reliability. |
| MISS_RATE_PCT | FLOAT | Percentage of assigned slots where the validator failed to produce blocks (missedslots / assignedslots * 100). Lower miss rates indicate better validator performance and higher earnings potential. |
| TOTAL_VALIDATOR_EARNINGS_WITH_MEV_SOL | FLOAT | Total SOL earned by the validator including both traditional earnings (inflation + fees) and MEV commission earnings. This represents the validator’s complete income for the epoch across all revenue sources. |
| TOTAL_VALIDATOR_EARNINGS_WITH_MEV_USD | FLOAT | USD value of total SOL earned by the validator including both traditional earnings and MEV commission, calculated using SOL price at epoch start time. Represents the validator’s complete income in dollar terms. |
| DELEGATOR_APR_PCT | FLOAT | Annualized Percentage Rate (APR) for delegators staking to this validator, calculated using simple interest. Based on delegator earnings relative to active stake, annualized using 146 epochs per year (365 days ÷ 2.5 days per epoch). |
| DELEGATOR_APY_PCT | FLOAT | Annualized Percentage Yield (APY) for delegators staking to this validator, calculated using compound interest. This accounts for the compounding effect of reinvesting rewards and provides a more accurate long-term yield projection. |
| VALIDATOR_APR_PCT | FLOAT | Annualized Percentage Rate (APR) for the validator’s total earnings including MEV, calculated using simple interest. Based on total validator earnings relative to active stake, showing the validator’s complete return on staked capital. |
| VALIDATOR_APY_PCT | FLOAT | Annualized Percentage Yield (APY) for the validator’s total earnings including MEV, calculated using compound interest. This represents the validator’s complete annualized return accounting for compounding effects. |
| VALIDATOR_EPOCH_METRICS_ID | TEXT | A unique, stable identifier for each record in this table. The primary key (PK) ensures that every row is uniquely identifiable and supports efficient joins, lookups, and data integrity across models. The PK may be a natural key (such as a blockchain transaction hash) or a surrogate key generated from one or more fields, depending on the table’s structure and requirements. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |
| _INVOCATION_ID | TEXT | _INVOCATION_ID column |
