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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_rewardsToken | STRING | Contract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string. |
in_reward | STRING | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | in_user | removed | in_reward | log_index | block_number | block_timestamp | in_rewardsToken | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xa7dd05a6cfc6e5238f04fd6e53d4efa859b492e4 | 0x35119741d2d3c40fcd456a93860f68c1754a4f56 | false | 130522336318822668 | 14 | 212788763 | 2024-05-19T07:40:09.000Z | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x99128a3856da53108439ecb6db5d1e011d9f7c8e4a0713cd7263864befee74aa |
| 0xa7dd05a6cfc6e5238f04fd6e53d4efa859b492e4 | 0x83febcf72458393a3957cc9793a9f04ff59a3d45 | false | 11569913293170525 | 3 | 212872899 | 2024-05-19T13:36:59.000Z | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x4f234a0752f83e789935d31459f117ffa02acd291e6f2c4b360f032cfa7fba38 |
| 0xa7dd05a6cfc6e5238f04fd6e53d4efa859b492e4 | 0x51fbd3162795632471dfcd8a0c9fe4e889fde9e5 | false | 2155685262952987 | 7 | 212735397 | 2024-05-19T03:51:21.000Z | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x0bb9b45b6f2877aef447452afff25fe64cc8e06e9da9b1f27154aae6fe9a8754 |
Example Query
Example Query
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