Staking
Deposits
Record of all staking deposits (stakes) on the Polygon PoS network
This table captures all staking deposit transactions on the Polygon Proof of Stake (PoS) network, including both validator self-stakes and delegator stakes.
Use Cases
- Analyze staking patterns and trends over time
- Track new validator participation
- Monitor total network stake and growth
- Identify popular validators through delegation patterns
- Analyze staking behavior during network events or market movements
Table Schema
| Column Name | Data Type | Description |
|---|---|---|
| event_type | VARCHAR | Type of deposit (delegator_stake, validator_stake, validator_restake) |
| amount | DECIMAL | Amount of MATIC (POL) tokens deposited in the transaction (as decimal) |
| amount_str | VARCHAR | String representation of MATIC (POL) tokens deposited, preserving full precision |
| staker_address | VARCHAR | Ethereum address of the account that made the stake |
| validator_id | INTEGER | ID of the validator receiving the stake |
| transaction_hash | VARCHAR | Unique hash of the Ethereum transaction containing the stake |
| transaction_index | INTEGER | Index of the transaction within its block |
| log_index | INTEGER | Index of the event log within the transaction |
| block_timestamp | TIMESTAMP | Timestamp when the block containing the stake was mined |
| block_number | INTEGER | Block number containing the stake transaction |
| block_hash | VARCHAR | Hash of the block containing the stake transaction |
| _created_at | TIMESTAMP | Timestamp of when the record was created |
| _updated_at | TIMESTAMP | Timestamp of when the record was updated |