monad.gov Table: ez_validator_balances_daily Type: Base Table
What
Daily wallet balances for validator addresses (auth_address from ValidatorCreated events). Forward fills missing days from ez_balances_native_daily since that table only has rows for days when the balance changed. Includes USD valuation using end of day native price.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BALANCE_DATE | DATE | Date of the balance snapshot |
| VALIDATOR_ID | NUMBER | ID of the validator |
| VALIDATOR_NAME | TEXT | Human-readable validator name from labels, or ‘Validator N’ if not labeled |
| CONSENSUS_ADDRESS | TEXT | Block producer address derived from secp_pubkey. Appears as “miner” in block headers. |
| VALIDATOR_ADDRESS | TEXT | Wallet address of the validator (auth_address) |
| BALANCE | FLOAT | Native MON balance (decimal adjusted) |
| BALANCE_RAW | NUMBER | Raw balance in wei |
| MON_PRICE_USD | FLOAT | End of day MON price in USD |
| BALANCE_USD | FLOAT | Balance value in USD |
| IS_FORWARD_FILLED | BOOLEAN | Whether this row was forward filled from a previous day (no balance change on this day) |
| EZ_VALIDATOR_BALANCES_DAILY_ID | TEXT | Unique identifier for this record |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was inserted |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was last modified |