Skip to main content

Table Details

PropertyValue
Table Namecosmos.staking.delegation_events
Table StatusProduction-Ready
Unique Keyblock_timestamp, unique_id
Clustering Key(s)block_timestamp::date, event_type

Table Columns

Column NameData TypeDescription
event_typeVARCHAR(16777216)Type of delegation event (delegate, undelegate, redelegate, cancel_unbonding_delegation).
delegatorVARCHAR(16777216)Address of the delegator.
validatorVARCHAR(16777216)Address of the validator.
amount_strVARCHAR(16777216)Normalized amount of tokens involved in the delegation event as a string.
amountFLOATNormalized amount of tokens involved in the delegation event as a float.
usd_amountFLOATUSD value of the tokens at the time of the event.
usd_exchange_rateFLOATUSD exchange rate at the time of the event.
denomVARCHAR(16777216)Token denomination involved in the delegation.
paramsVARIANTAdditional parameters associated with the delegation event.
source_validatorVARCHAR(16777216)Source validator address for redelegation events.
destination_validatorVARCHAR(16777216)Destination validator address for redelegation events.
transaction_hashVARCHAR(16777216)Hash of the transaction containing the delegation event.
transaction_indexNUMBER(38,0)Index of the transaction within the block.
block_timestampTIMESTAMP_NTZ(9)Timestamp when the block containing the event was created.
block_heightNUMBER(38,0)Height of the block containing the event.
block_hashVARCHAR(16777216)Hash of the block containing the event.
message_actionVARCHAR(16777216)Action type of the message that triggered the event.
message_indexNUMBER(38,0)Index of the message within the transaction.
event_indexNUMBER(38,0)Index of the event within the message.
unique_idVARCHAR(16777216)Unique identifier for the delegation event.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.