Delegator Balances Daily - Allium Documentation Hub

Use Cases
Table Schema

This table provides daily snapshots of delegator balances for each validator on the BNB Smart Chain (BSC), including both stake credit tokens and equivalent BNB amounts.

Use Cases

Track delegator participation and stake distribution over time
Monitor validator popularity through delegation trends
Analyze staking behavior during network events
Calculate daily staking returns and rewards
Measure validator market share changes

Table Schema

Column Name	Data Type	Description
day	DATE	The date of the balance snapshot
address	VARCHAR	The delegator’s wallet address holding the credit contract token
operator_address	VARCHAR	The validator’s operator address
consensus_address	VARCHAR	The validator’s consensus address used for block validation
credit_contract	VARCHAR	The address of the validator’s stake credit token contract
credit_contract_name	VARCHAR	The name of the validator’s stake credit token
bnb_balance_str	VARCHAR	String representation of the delegator’s BNB balance
bnb_balance	DECIMAL	Float representation of the delegator’s BNB balance
stake_credit_balance_str	VARCHAR	String representation of the delegator’s stake credit token balance
stake_credit_balance	DECIMAL	Float representation of the delegator’s stake credit token balance
last_block_timestamp	TIMESTAMP	Timestamp of the last block where the balance was updated
last_block_number	INTEGER	Block number of the last balance update
last_block_hash	VARCHAR	Hash of the last block where the balance was updated
unique_id	VARCHAR	Unique identifier for the daily balance record

Staking Staking Events

⌘I