Skip to main content

Table Details

PropertyValue
Table Namecosmos.staking.withdraw_rewards
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 the event (withdraw_reward).
delegatorVARCHAR(16777216)Address of the delegator who is withdrawing rewards.
validatorVARCHAR(16777216)Address of the validator from whom rewards are being withdrawn.
denomVARCHAR(16777216)Token denomination of the withdrawn rewards. Note that there can be rewards that are not the same denom as the native token staked for the blockchain.
decimalsNUMBER(38,0)Number of decimals of the token denomination.
raw_amount_strVARCHAR(16777216)Raw amount of tokens withdrawn as a string (preserving precision).
amount_strVARCHAR(16777216)Normalized amount of tokens withdrawn as a string.
amountFLOATNormalized amount of tokens withdrawn as a float.
usd_amountFLOATUSD value of the withdrawn tokens at the time of withdrawal.
usd_exchange_rateFLOATUSD exchange rate at the time of withdrawal.
paramsVARIANTAdditional parameters associated with the withdrawal event.
transaction_hashVARCHAR(16777216)Hash of the transaction containing the withdrawal.
transaction_indexNUMBER(38,0)Index of the transaction within the block.
block_timestampTIMESTAMP_NTZ(9)Timestamp when the block containing the withdrawal was created.
block_heightNUMBER(38,0)Height of the block containing the withdrawal.
block_hashVARCHAR(16777216)Hash of the block containing the withdrawal.
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 withdrawal 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.