Skip to main content

​
Tables

​
StakingRewards_RewardPaid_event

Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across protocols.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0x712f0cf37bdb8299d0666727f73a5caba7c1c24c0x3bda2886f40e4d4464351c5189693e860b5f0705false219751416490576185316103287154772023-06-30T15:03:40.000Z0xb3e0db47ce2aeeefbf9c2e8e2daaed0d4251472e44a676711f42f17797ce2f6c
0x636a7ee78facd079dabc8f81eda1d09aa9d440a70xa1771ce265f7d7b3df2eb536769c27b581696db9false7925782323665462631668287114472023-06-30T09:10:20.000Z0x7e4f2cbe0ed4c71a7aecda8cac08e04ca917f9291a7cad3ce8ef73cd0a6212d5
0x636a7ee78facd079dabc8f81eda1d09aa9d440a70xa1771ce265f7d7b3df2eb536769c27b581696db9false21290313904641741087287137342023-06-30T12:30:40.000Z0xbc29cf8492696554c7a25d36d205f0c828d770a0b70c18f5e0888fd1834edfed
Query with partition filter
SELECT *
FROM `tt-contracts.hop_v1_gnosis.StakingRewards_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
StakingRewardsGNO_RewardPaid_event

Reward claim events from Hop Protocol’s GNO (Gnosis) staking rewards contracts on Gnosis Chain. Tracks individual reward payouts to liquidity providers with reward amounts in wei and recipient addresses for analyzing staking participation and yield distribution.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0x2c2ab81cf235e86374468b387e241df22459a2650x27f383aabde02b06a586399cc26654ae23277498false30646333220889727842252522422022-12-02T04:42:25.000Z0xcf343beae049078eb667190d2a758e2df89fc36553240ed7097767c5a940827e
0xc61ba16e864efbd06a9fe30aab39d18b8f63710a0xc5f32455e7e97564ef6e71c439708d3e12da91c5false54612343570183241252592152022-12-02T16:05:00.000Z0x20e392b49827910b32a8687517f715f79c72110a40edd16758aab2d503bd6264
0xc61ba16e864efbd06a9fe30aab39d18b8f63710a0xd145860c3cad12aeec9d8021d36b48d7fad09454false101050816380562842252627062022-12-02T21:45:00.000Z0xbd7301aa8c2418df39c88f7ebbce533cac183b30c05ccccd0e18fcace9a44466
Query with partition filter
SELECT *
FROM `tt-contracts.hop_v1_gnosis.StakingRewardsGNO_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100