indexcoop_v1_ethereum

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.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xb93b505ed567982e2b6756177ddd23ab5745f309	0xdc9fd6ab0cd62e08c99bafd6df035a6daec67176	false	2613363497790715839	220	13876166	2021-12-25T19:07:35.000Z	0x87161ec3ddb58d76e2abcb47e959159374ff7df71a3080f54670e23eed0dd434
0xb93b505ed567982e2b6756177ddd23ab5745f309	0xf80896e2e19bfa577c41a933a9a52d509dc5e502	false	146488868427366624	126	13873705	2021-12-25T10:12:59.000Z	0xc14f4ad3dabd0a0608b2533fa76a37bbafab92fbd777bd95e5dd436dfc630e6a
0x5bc4249641b4bf4e37ef513f3fa5c63ecab34881	0x708a0eab6dc82aee59f4daa429caea6d11459aba	false	3392359262553026707	348	12422302	2021-05-12T22:38:08.000Z	0x907102ea4038d5d147039d7b3c7383db682f9ff4018829d3cd9e6584a80027f0

Example Query

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

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

StakingRewards_RewardPaid_event

​Tables

​StakingRewards_RewardPaid_event

Tables

StakingRewards_RewardPaid_event