rook_v2_ethereum

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.

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__claimAddress`	`STRING`	Ethereum address receiving the claimed tokens from the CoordinatedStaking contract. Hex-encoded, 0x-prefixed 40-character string representing the beneficiary of the claim event.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

address	removed	log_index	in__amount	block_number	block_timestamp	in__claimAddress	transaction_hash
0x46168a99d15e6c620577d75ed7c453a6f53bafd5	false	85	57496798940131352	14402218	2022-03-17T05:44:32.000Z	0x02f82fb86e59292a4c9f5875c2e90111746d229b	0x92b1220cebed3cbefe5e2f660054e2b508daddeb2f9fbfba804c56c937842d8c
0x46168a99d15e6c620577d75ed7c453a6f53bafd5	false	131	61499230198528138	14406483	2022-03-17T21:45:13.000Z	0x02f82fb86e59292a4c9f5875c2e90111746d229b	0xc40eefcd29fff502dc0859c44c650218e6e758d5a38ce2427676120f65b4fedc
0x46168a99d15e6c620577d75ed7c453a6f53bafd5	false	157	25143083750593208	14405558	2022-03-17T18:16:37.000Z	0x02f82fb86e59292a4c9f5875c2e90111746d229b	0x330df10fbb05c8215d08df008d71a5e0575b3ec3de151326c6c9c27604320c59

Example Query

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

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CoordinatedStaking_Claimed_event

​Tables

​CoordinatedStaking_Claimed_event

Tables

CoordinatedStaking_Claimed_event