Skip to main content

​
Tables

​
StakingV2_RewardPaid_event

Staking reward distribution events emitted when users claim accrued rewards from staking contracts. Records the recipient address, reward token contract, and reward amount paid out.
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_rewardsTokenSTRINGContract address of the reward token being distributed. 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_timestampin_rewardsTokentransaction_hash
0xa7dd05a6cfc6e5238f04fd6e53d4efa859b492e40x35119741d2d3c40fcd456a93860f68c1754a4f56false130522336318822668142127887632024-05-19T07:40:09.000Z0x82af49447d8a07e3bd95bd0d56f35241523fbab10x99128a3856da53108439ecb6db5d1e011d9f7c8e4a0713cd7263864befee74aa
0xa7dd05a6cfc6e5238f04fd6e53d4efa859b492e40x83febcf72458393a3957cc9793a9f04ff59a3d45false1156991329317052532128728992024-05-19T13:36:59.000Z0x82af49447d8a07e3bd95bd0d56f35241523fbab10x4f234a0752f83e789935d31459f117ffa02acd291e6f2c4b360f032cfa7fba38
0xa7dd05a6cfc6e5238f04fd6e53d4efa859b492e40x51fbd3162795632471dfcd8a0c9fe4e889fde9e5false215568526295298772127353972024-05-19T03:51:21.000Z0x82af49447d8a07e3bd95bd0d56f35241523fbab10x0bb9b45b6f2877aef447452afff25fe64cc8e06e9da9b1f27154aae6fe9a8754
Query with partition filter
SELECT *
FROM `tt-contracts.betswirl_v2_arbitrum.StakingV2_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100