Skip to main content

​
Tables

​
CoordinatedStaking_Claimed_event

Staking reward claim events from the Rook Protocol v2 CoordinatedStaking contract on Ethereum, recording token withdrawals by recipient addresses with claimed amounts in wei. Used for tracking staking yield distributions and participant claim activity.
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__claimAddressSTRINGEthereum address receiving the claimed tokens from the CoordinatedStaking contract. Hex-encoded, 0x-prefixed 40-character string representing the beneficiary of the claim event.
in__amountSTRINGAmount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
addressremovedlog_indexin__amountblock_numberblock_timestampin__claimAddresstransaction_hash
0x46168a99d15e6c620577d75ed7c453a6f53bafd5false8557496798940131352144022182022-03-17T05:44:32.000Z0x02f82fb86e59292a4c9f5875c2e90111746d229b0x92b1220cebed3cbefe5e2f660054e2b508daddeb2f9fbfba804c56c937842d8c
0x46168a99d15e6c620577d75ed7c453a6f53bafd5false13161499230198528138144064832022-03-17T21:45:13.000Z0x02f82fb86e59292a4c9f5875c2e90111746d229b0xc40eefcd29fff502dc0859c44c650218e6e758d5a38ce2427676120f65b4fedc
0x46168a99d15e6c620577d75ed7c453a6f53bafd5false15725143083750593208144055582022-03-17T18:16:37.000Z0x02f82fb86e59292a4c9f5875c2e90111746d229b0x330df10fbb05c8215d08df008d71a5e0575b3ec3de151326c6c9c27604320c59
Query with partition filter
SELECT *
FROM `tt-contracts.rook_v2_ethereum.CoordinatedStaking_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100