Use Cases
- Track delegation ownership changes over time
- Identify large delegation movements between addresses
- Analyze validator popularity through delegation transfer behavior
- Detect delegation activity correlated with network events or governance changes
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| from_address | VARCHAR | Ethereum address transferring the delegation shares |
| to_address | VARCHAR | Ethereum address receiving the delegation shares |
| raw_amount_str | VARCHAR | Amount of delegation shares transferred as a string (preserving precision) |
| validator_id | INTEGER | ID of the validator whose delegation shares are being transferred |
| transaction_hash | VARCHAR | Unique hash of the Ethereum transaction containing the transfer |
| 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 transfer was mined |
| block_number | INTEGER | Block number containing the transfer transaction |
| block_hash | VARCHAR | Hash of the block containing the transfer transaction |
| _created_at | TIMESTAMP | Timestamp of when the record was created |
| _updated_at | TIMESTAMP | Timestamp of when the record was updated |