> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Delegation Events

### Table Details

| Property          | Value                               |
| ----------------- | ----------------------------------- |
| Table Name        | `cosmos.staking.delegation_events`  |
| Table Status      | Production-Ready                    |
| Unique Key        | `block_timestamp`, `unique_id`      |
| Clustering Key(s) | `block_timestamp::date, event_type` |

### Table Columns

| Column Name            | Data Type         | Description                                                                                 |
| ---------------------- | ----------------- | ------------------------------------------------------------------------------------------- |
| event\_type            | VARCHAR(16777216) | Type of delegation event (delegate, undelegate, redelegate, cancel\_unbonding\_delegation). |
| delegator              | VARCHAR(16777216) | Address of the delegator.                                                                   |
| validator              | VARCHAR(16777216) | Address of the validator.                                                                   |
| amount\_str            | VARCHAR(16777216) | Normalized amount of tokens involved in the delegation event as a string.                   |
| amount                 | FLOAT             | Normalized amount of tokens involved in the delegation event as a float.                    |
| usd\_amount            | FLOAT             | USD value of the tokens at the time of the event.                                           |
| usd\_exchange\_rate    | FLOAT             | USD exchange rate at the time of the event.                                                 |
| denom                  | VARCHAR(16777216) | Token denomination involved in the delegation.                                              |
| params                 | VARIANT           | Additional parameters associated with the delegation event.                                 |
| source\_validator      | VARCHAR(16777216) | Source validator address for redelegation events.                                           |
| destination\_validator | VARCHAR(16777216) | Destination validator address for redelegation events.                                      |
| transaction\_hash      | VARCHAR(16777216) | Hash of the transaction containing the delegation event.                                    |
| transaction\_index     | NUMBER(38,0)      | Index of the transaction within the block.                                                  |
| block\_timestamp       | TIMESTAMP\_NTZ(9) | Timestamp when the block containing the event was created.                                  |
| block\_height          | NUMBER(38,0)      | Height of the block containing the event.                                                   |
| block\_hash            | VARCHAR(16777216) | Hash of the block containing the event.                                                     |
| message\_action        | VARCHAR(16777216) | Action type of the message that triggered the event.                                        |
| message\_index         | NUMBER(38,0)      | Index of the message within the transaction.                                                |
| event\_index           | NUMBER(38,0)      | Index of the event within the message.                                                      |
| unique\_id             | VARCHAR(16777216) | Unique identifier for the delegation event.                                                 |
| \_created\_at          | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                    |
| \_updated\_at          | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                               |