Skip to main content

​
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.
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_groupSTRINGContract 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_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
addressremovedin_groupin_valuelog_indexblock_numberblock_timestamptransaction_hash
0x8d6677192144292870907e3fa8a5527fe55a7ff6false0x2fd49e97262d505fd76bb6e0e06ec10e1fd54589439924052298614951855465107136002022-01-02T17:56:59.000Z0x46d927d5b88a0413633a17e4438c3a9ef888368b8ab8341a9539ec2478c9a3ea
0x8d6677192144292870907e3fa8a5527fe55a7ff6false0x95ae59515915d6c493a846ae022f93726652b50a401095404666278706364435107136002022-01-02T17:56:59.000Z0x46d927d5b88a0413633a17e4438c3a9ef888368b8ab8341a9539ec2478c9a3ea
0x8d6677192144292870907e3fa8a5527fe55a7ff6false0xb35be22bccb0db9dc62967dcf15feb97c20f854e174440653528166162280444107136002022-01-02T17:56:59.000Z0x46d927d5b88a0413633a17e4438c3a9ef888368b8ab8341a9539ec2478c9a3ea
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.
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_validatorSTRINGContract 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_validatorPaymentSTRINGPayment 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_groupSTRINGContract 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_groupPaymentSTRINGPayment amount in wei distributed to the validator group for the epoch. Typically ranges around 178 trillion wei (0.178 CELO) per distribution event.
addressremovedin_grouplog_indexblock_numberin_validatorblock_timestampin_groupPaymenttransaction_hashin_validatorPayment
0xaeb865bca93ddc8f47b8e29f40c5399ce34d0c58false0x0d4f8cea48cdadeae345431577a64983c0535b1232875340800x2bdc5ccda08a7f821ae0df72b5fda60cd58d63532021-07-02T17:31:27.000Z1780276007973121555300xae25245c51b98289b311d39afd58daea223e5f891b54ba68d0abd0947ac29d410
0xaeb865bca93ddc8f47b8e29f40c5399ce34d0c58false0x0e912990472bfe5948b5b7333ecf528d5da887cf28875340800x0c7610f8f4da332c77c9800012009ccfa48f23e42021-07-02T17:31:27.000Z1780097025460172037280xae25245c51b98289b311d39afd58daea223e5f891b54ba68d0abd0947ac29d410
0xaeb865bca93ddc8f47b8e29f40c5399ce34d0c58false0x21fb4411fa5828344c2788ab07d4cc12a12571b914875340800xdf9121affb220e9095c875a79c3d1fa3ebee41052021-07-02T17:31:27.000Z1780268986236208725350xae25245c51b98289b311d39afd58daea223e5f891b54ba68d0abd0947ac29d410
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