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
0xb93b505ed567982e2b6756177ddd23ab5745f3090xdc9fd6ab0cd62e08c99bafd6df035a6daec67176false2613363497790715839220138761662021-12-25T19:07:35.000Z0x87161ec3ddb58d76e2abcb47e959159374ff7df71a3080f54670e23eed0dd434
0xb93b505ed567982e2b6756177ddd23ab5745f3090xf80896e2e19bfa577c41a933a9a52d509dc5e502false146488868427366624126138737052021-12-25T10:12:59.000Z0xc14f4ad3dabd0a0608b2533fa76a37bbafab92fbd777bd95e5dd436dfc630e6a
0x5bc4249641b4bf4e37ef513f3fa5c63ecab348810x708a0eab6dc82aee59f4daa429caea6d11459abafalse3392359262553026707348124223022021-05-12T22:38:08.000Z0x907102ea4038d5d147039d7b3c7383db682f9ff4018829d3cd9e6584a80027f0
Query with partition filter
SELECT *
FROM `tt-contracts.indexcoop_v1_ethereum.StakingRewards_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100