celo_v1_celo

Tables

Election_EpochRewardsDistributedToVoters_event

Epoch reward distribution events from Celo’s Election contract showing CELO tokens paid to voters for participating in validator group elections. Used to track staking rewards by validator group and analyze voter incentive distributions across epochs.

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_group`	`STRING`	Contract address of the validator group that voters delegated to and received epoch rewards from. Hex-encoded, 0x-prefixed 40-character string representing the Celo validator group.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_group	in_value	log_index	block_number	block_timestamp	transaction_hash
0x8d6677192144292870907e3fa8a5527fe55a7ff6	false	0x2fd49e97262d505fd76bb6e0e06ec10e1fd54589	439924052298614951855	465	10713600	2022-01-02T17:56:59.000Z	0x46d927d5b88a0413633a17e4438c3a9ef888368b8ab8341a9539ec2478c9a3ea
0x8d6677192144292870907e3fa8a5527fe55a7ff6	false	0x95ae59515915d6c493a846ae022f93726652b50a	401095404666278706364	435	10713600	2022-01-02T17:56:59.000Z	0x46d927d5b88a0413633a17e4438c3a9ef888368b8ab8341a9539ec2478c9a3ea
0x8d6677192144292870907e3fa8a5527fe55a7ff6	false	0xb35be22bccb0db9dc62967dcf15feb97c20f854e	174440653528166162280	444	10713600	2022-01-02T17:56:59.000Z	0x46d927d5b88a0413633a17e4438c3a9ef888368b8ab8341a9539ec2478c9a3ea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.celo_v1_celo.Election_EpochRewardsDistributedToVoters_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Validators_ValidatorEpochPaymentDistributed_event

Epoch-based validator reward distribution events from Celo’s Validators contract, tracking payment amounts to individual validators and their validator groups. Used for analyzing staking economics, validator performance, and reward distribution patterns across Celo’s proof-of-stake consensus.

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_validator`	`STRING`	Contract address of the individual validator receiving payment within their validator group on Celo. This address is distinct from the group address and identifies the specific validator node being compensated.
`in_validatorPayment`	`STRING`	Payment amount in wei distributed directly to the validator address for their participation in the epoch. Typically zero when rewards are paid to the validator group instead of individual validators.
`in_group`	`STRING`	Contract address of the validator group receiving the epoch payment on Celo. Hex-encoded, 0x-prefixed 40-character string representing the group entity in Celo’s proof-of-stake consensus.
`in_groupPayment`	`STRING`	Payment amount in wei distributed to the validator group for the epoch. Typically ranges around 178 trillion wei (0.178 CELO) per distribution event.

Sample Data

address	removed	in_group	log_index	block_number	in_validator	block_timestamp	in_groupPayment	transaction_hash
0xaeb865bca93ddc8f47b8e29f40c5399ce34d0c58	false	0x0d4f8cea48cdadeae345431577a64983c0535b12	328	7534080	0x2bdc5ccda08a7f821ae0df72b5fda60cd58d6353	2021-07-02T17:31:27.000Z	178027600797312155530	0xae25245c51b98289b311d39afd58daea223e5f891b54ba68d0abd0947ac29d41
0xaeb865bca93ddc8f47b8e29f40c5399ce34d0c58	false	0x0e912990472bfe5948b5b7333ecf528d5da887cf	288	7534080	0x0c7610f8f4da332c77c9800012009ccfa48f23e4	2021-07-02T17:31:27.000Z	178009702546017203728	0xae25245c51b98289b311d39afd58daea223e5f891b54ba68d0abd0947ac29d41
0xaeb865bca93ddc8f47b8e29f40c5399ce34d0c58	false	0x21fb4411fa5828344c2788ab07d4cc12a12571b9	148	7534080	0xdf9121affb220e9095c875a79c3d1fa3ebee4105	2021-07-02T17:31:27.000Z	178026898623620872535	0xae25245c51b98289b311d39afd58daea223e5f891b54ba68d0abd0947ac29d41

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.celo_v1_celo.Validators_ValidatorEpochPaymentDistributed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Election_EpochRewardsDistributedToVoters_event

Validators_ValidatorEpochPaymentDistributed_event

​Tables

​Election_EpochRewardsDistributedToVoters_event

​Validators_ValidatorEpochPaymentDistributed_event

Tables

Election_EpochRewardsDistributedToVoters_event

Validators_ValidatorEpochPaymentDistributed_event