axelar.gov Table: fact_staking Type: View
Information about all deledation, redelegation, and undelegation activity on Axelar.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| TX_ID | TEXT | A unique key that identifies a transaction. Called “TxHash” on block explorers. |
| TX_SUCCEEDED | BOOLEAN | Transaction status is “TRUE” if the transaction went through, “FALSE” if the transaction failed. |
| TX_CALLER_ADDRESS | TEXT | The wallet address of the individual who initiated the transaction. |
| ACTION | TEXT | The staking action. Values include delegate, redelegate, and undelegate |
| DELEGATOR_ADDRESS | TEXT | The wallet address of the individual who owns the delegated asset. |
| VALIDATOR_ADDRESS | TEXT | The wallet address of the validator related to the staking action. |
| AMOUNT | NUMBER | The amount of tokens in the staking action |
| CURRENCY | TEXT | The currency that was used in the transaction message. |
| REDELEGATE_SOURCE_VALIDATOR_ADDRESS | TEXT | The wallet address of the source validator in a redelegation staking action. |
| COMPLETION_TIME | TIMESTAMP_NTZ | The time at which the undelegate or redelegate staking action is completed. |
| _MSG_GROUP | NUMBER | Value grouping different messages together to represent a single action. Format will include the numeric msg_group and msg_sub_group with a ”:” seperator. The subgroup will always be 0 except for “Exec” actions. NULL group means messages are related to the header (overall transaction) |
| FACT_STAKING_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |