ronin_v1_ronin

Tables

BridgeReward_BridgeRewardScattered_event

Bridge operator reward distribution events from Ronin network’s bridge contract, recording individual reward payouts to validators per period. Used for analyzing validator compensation patterns and bridge operator economics.

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_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_period	log_index	in_operator	block_number	block_timestamp	transaction_hash
0x796a163a21e9a659fc9773166e0afdc1eb01aad1	false	124533001245330012453	19655	14	0x4b3844a29cfa5824f53e2137edb6dc2b54501bea	28817157	2023-10-26T00:09:28.000Z	0x5eb6d7bd7993c2a19f80c6adb7458041469f8461963dd97eb69815c23ac0c6a3
0x796a163a21e9a659fc9773166e0afdc1eb01aad1	false	124533001245330012453	19655	32	0x54c8c42f07007d43c3049bef6f10ea68687d43ef	28817157	2023-10-26T00:09:28.000Z	0x5eb6d7bd7993c2a19f80c6adb7458041469f8461963dd97eb69815c23ac0c6a3
0x796a163a21e9a659fc9773166e0afdc1eb01aad1	false	124533001245330012453	19655	26	0x73f5b22312b7b2b3b1cd179fc62269ab369c8206	28817157	2023-10-26T00:09:28.000Z	0x5eb6d7bd7993c2a19f80c6adb7458041469f8461963dd97eb69815c23ac0c6a3

Example Query

Query with partition filter

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

Staking_RewardClaimed_event

Staking reward claim events from Ronin validator pools, capturing user withdrawals with claim amounts and associated pool addresses. Used for tracking staking yield distributions and analyzing validator pool performance on Ronin sidechain.

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_poolAddr`	`STRING`	Pool contract address where staking rewards were claimed from. Hex-encoded, 0x-prefixed 40-character string identifying the specific staking pool on Ronin chain.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	in_poolAddr	block_number	block_timestamp	transaction_hash
0x545edb750eb8769c868429be9586f5857a768758	0x0044947b268a03a0dfa2ef23859c986da328a34f	false	12812602329366060000	4	0xedcafc4ad8097c2012980a2a7087d74b86bddaf9	27674513	2023-09-16T07:54:51.000Z	0xbfc17f5a6b47f047d7cb95db1c0132420ac4eca7ea4909e0df9758d59e16543a
0x545edb750eb8769c868429be9586f5857a768758	0x0044947b268a03a0dfa2ef23859c986da328a34f	false	13241563878246181343	0	0x32d619dc6188409cebbc52f921ab306f07db085b	27674513	2023-09-16T07:54:51.000Z	0xbfc17f5a6b47f047d7cb95db1c0132420ac4eca7ea4909e0df9758d59e16543a
0x545edb750eb8769c868429be9586f5857a768758	0x0044947b268a03a0dfa2ef23859c986da328a34f	false	34784077390246603391	2	0xfc3e31519b551bd594235dd0ef014375a87c4e21	27674513	2023-09-16T07:54:51.000Z	0xbfc17f5a6b47f047d7cb95db1c0132420ac4eca7ea4909e0df9758d59e16543a

Example Query

Query with partition filter

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

ValidatorSet_BridgeOperatorRewardDistributed_event

Bridge operator reward distribution events from Ronin’s ValidatorSet contract, tracking payments to validators and bridge operators for securing cross-chain transfers. Links consensus validators, bridge operators, and recipient addresses with reward amounts for analyzing validator economics and bridge infrastructure incentives.

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_consensusAddr`	`STRING`	Address of the validator’s consensus node receiving a portion of the bridge operator rewards on Ronin. This address participates in network consensus and is distinct from the operator and recipient addresses.
`in_bridgeOperator`	`STRING`	Bridge operator address responsible for facilitating cross-chain transactions on Ronin. This is the operator that earned the reward being distributed in this event.
`in_recipientAddr`	`STRING`	Address that receives the bridge operator reward distribution on Ronin chain. Hex-encoded, 0x-prefixed 40-character string identifying the wallet or contract receiving the distributed rewards.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	in_consensusAddr	in_recipientAddr	transaction_hash	in_bridgeOperator
0x617c5d73662282ea7ffd231e020eca6d2b0d552f	false	124533001243636363636	79	25332599	2023-06-27T00:01:59.000Z	0xbd4bf317da1928cc2f9f4da9006401f3944a0ab5	0xc4209c31c9bae0636f42bc35ec0bcad49a3ca814	0x96ffc01cafcb7f258e2a5dea823c1f4b576333975c516aa2e39d1901b21ec84e	0xe795f18f2f5df5a666994e839b98263dba86c902
0x617c5d73662282ea7ffd231e020eca6d2b0d552f	false	124533001243636363636	87	25332599	2023-06-27T00:01:59.000Z	0xca54a1700e0403dcb531f8db4ae3847758b90b01	0x75a6e6b7d9c63657bcec0bb493ac81d072353d5f	0x96ffc01cafcb7f258e2a5dea823c1f4b576333975c516aa2e39d1901b21ec84e	0x73f5b22312b7b2b3b1cd179fc62269ab369c8206
0x617c5d73662282ea7ffd231e020eca6d2b0d552f	false	124533001243636363636	41	25332599	2023-06-27T00:01:59.000Z	0x8eec4f1c0878f73e8e09c1be78ac1465cc16544d	0xbb38191e724baf5a1fb2ebd0a7a32015982449a8	0x96ffc01cafcb7f258e2a5dea823c1f4b576333975c516aa2e39d1901b21ec84e	0xd9d5b3e58fa693b468a20c716793b18a1195380a

Example Query

Query with partition filter

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

ValidatorSet_MiningRewardDistributed_event

Mining reward distribution events from the Ronin ValidatorSet contract tracking payments to validator consensus addresses and their recipients. Used for analyzing validator economics and reward allocation patterns on the Ronin sidechain.

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_consensusAddr`	`STRING`	Consensus address of the validator who participated in block production and earned this mining reward. Hex-encoded, 0x-prefixed 40-character Ronin address representing the validator’s consensus node.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_recipient	block_timestamp	in_consensusAddr	transaction_hash
0x617c5d73662282ea7ffd231e020eca6d2b0d552f	false	747938669693121310614	44	29306599	0x2d593a0087029501ee419b9415dec3fac195fe4a	2023-11-12T00:03:11.000Z	0xd11d9842babd5209b9b1155e46f5878c989125b7	0xc4dbe3e305f1abf6ca4b8088f1449513cdbaf2aa19c496a8bd72322332fd3920
0x617c5d73662282ea7ffd231e020eca6d2b0d552f	false	186142066219864443176	58	29306599	0xe5718182af678c7d65c286851934273aa39e67d6	2023-11-12T00:03:11.000Z	0x05ad3ded6fcc510324af8e2631717af6da5c8b5b	0xc4dbe3e305f1abf6ca4b8088f1449513cdbaf2aa19c496a8bd72322332fd3920
0x617c5d73662282ea7ffd231e020eca6d2b0d552f	false	186685063256412209394	62	29306599	0xa27a1095015dc037c92403f4b26196b04f342961	2023-11-12T00:03:11.000Z	0xedcafc4ad8097c2012980a2a7087d74b86bddaf9	0xc4dbe3e305f1abf6ca4b8088f1449513cdbaf2aa19c496a8bd72322332fd3920

Example Query

Query with partition filter

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

ValidatorSet_StakingRewardDistributed_event

Staking reward distribution events from Ronin’s ValidatorSet contract, recording amounts paid to consensus validators. Contains total distribution amount and individual validator reward allocations for analyzing validator economics and network incentive distribution.

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_totalAmount`	`STRING`	Total amount involved in the transaction or operation. String-encoded integer representing the amount in the token’s smallest unit.
`in_consensusAddrs`	`ARRAY<STRING>`	Array of validator consensus addresses that received staking rewards in this distribution event. Each address corresponds to a reward amount in the parallel `in_amounts` array, with samples showing 22 validators per distribution.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).

Sample Data

address	removed	log_index	in_amounts	block_number	in_totalAmount	block_timestamp	transaction_hash	in_consensusAddrs
0x617c5d73662282ea7ffd231e020eca6d2b0d552f	false	74	[“3367485370356358338000”,“3480234468292819800000”,“3443262240557224480800”,“3368882915983100573010”,“3373564807988449161911”,“3367798827526495953000”,“3368931790118429052000”,“2994367013487535224000”,“2994096194859653460949”,“2993720803758680000000”,“2994275398691091200000”,“2996583275989256709656”,“3555841183560932904500”,“3553652474461090000000”,“3557743047085934312500”,“3555517540923397000000”,“3556283626012099996500”,“3554538108083437000000”,“3367725980470675200000”,“3368723093071655320602”,“3368621566112322437670”,“3368186146993242276000”]	25102199	73550035874383880401098	2023-06-19T00:01:57.000Z	0x2d703eacd7b061cec07046319493d3e6b0a7fd1dcb8b5bd31a26168e30218703	[“0xf41af21f0a800dc4d86efb14ad46cfb9884fdf38”,“0x9b959d27840a31988410ee69991bcf0110d61f02”,“0x6e46924371d0e910769aabe0d867590deac20684”,“0x32d619dc6188409cebbc52f921ab306f07db085b”,“0xfc3e31519b551bd594235dd0ef014375a87c4e21”,“0x8eec4f1c0878f73e8e09c1be78ac1465cc16544d”,“0xee11d2016e9f2fae606b2f12986811f4abbe6215”,“0xec702628f44c31acc56c3a59555be47e1f16eb1e”,“0xe07d7e56588a6fd860c5073c70a099658c060f3d”,“0x52349003240770727900b06a3b3a90f5c0219ade”,“0xd11d9842babd5209b9b1155e46f5878c989125b7”,“0x210744c64eea863cf0f972e5aebc683b98fb1984”,“0xedcafc4ad8097c2012980a2a7087d74b86bddaf9”,“0x05ad3ded6fcc510324af8e2631717af6da5c8b5b”,“0xae53daac1bf3c4633d4921b8c3f8d579e757f5bc”,“0x4e7ea047ec7e95c7a02cb117128b94ccdd8356bf”,“0xbd4bf317da1928cc2f9f4da9006401f3944a0ab5”,“0x6aaabf51c5f6d2d93212cf7dad73d67afa0148d0”,“0x61089875ff9e506ae78c7fe9f7c388416520e386”,“0x2bddcaae1c6ccd53e436179b3fc07307ee6f3ef8”,“0x47cfcb64f8ea44d6ea7fab32f13efa2f8e65eec1”,“0xca54a1700e0403dcb531f8db4ae3847758b90b01”]
0x617c5d73662282ea7ffd231e020eca6d2b0d552f	false	71	[“3367165768919994515746”,“3480306354102372807351”,“3442408300564903099238”,“3367425297338157994233”,“3371975144732134180160”,“3367075906244809149486”,“3367214620506887739777”,“2992716628265632255421”,“2993759090580247416642”,“2993353184701538492600”,“2993649129104399983833”,“2995302399912286842174”,“3554434703304894349445”,“3554285947346919884612”,“3557340622938397877433”,“3552884403815147516252”,“3555536657338241679037”,“3366639490224701806385”,“3368601587143878517734”,“3367395548550560315744”,“3554221432056730906726”,“3367041016413416172174”]	25418999	73530733234106253502203	2023-06-30T00:02:00.000Z	0xfd9bb12dac146fef4468384c010d29bea426185a5820ca89e34bcc196f1db9b5	[“0xf41af21f0a800dc4d86efb14ad46cfb9884fdf38”,“0x9b959d27840a31988410ee69991bcf0110d61f02”,“0x6e46924371d0e910769aabe0d867590deac20684”,“0x32d619dc6188409cebbc52f921ab306f07db085b”,“0xfc3e31519b551bd594235dd0ef014375a87c4e21”,“0x8eec4f1c0878f73e8e09c1be78ac1465cc16544d”,“0xee11d2016e9f2fae606b2f12986811f4abbe6215”,“0xe07d7e56588a6fd860c5073c70a099658c060f3d”,“0x52349003240770727900b06a3b3a90f5c0219ade”,“0xec702628f44c31acc56c3a59555be47e1f16eb1e”,“0xd11d9842babd5209b9b1155e46f5878c989125b7”,“0x210744c64eea863cf0f972e5aebc683b98fb1984”,“0xedcafc4ad8097c2012980a2a7087d74b86bddaf9”,“0x4e7ea047ec7e95c7a02cb117128b94ccdd8356bf”,“0xae53daac1bf3c4633d4921b8c3f8d579e757f5bc”,“0x05ad3ded6fcc510324af8e2631717af6da5c8b5b”,“0xbd4bf317da1928cc2f9f4da9006401f3944a0ab5”,“0x2bddcaae1c6ccd53e436179b3fc07307ee6f3ef8”,“0x61089875ff9e506ae78c7fe9f7c388416520e386”,“0x47cfcb64f8ea44d6ea7fab32f13efa2f8e65eec1”,“0x6aaabf51c5f6d2d93212cf7dad73d67afa0148d0”,“0xca54a1700e0403dcb531f8db4ae3847758b90b01”]
0x617c5d73662282ea7ffd231e020eca6d2b0d552f	false	71	[“3358860966517063742946”,“3472772821987515678246”,“3435100412814083182476”,“3364527587794915555874”,“3371246707546113713675”,“3358452630733377861203”,“2989146324021503932743”,“2986422540025160167626”,“2987314574759811264156”,“2987714686615204974397”,“2986074771590667966459”,“2987259959819908604898”,“3535694996987457798100”,“3546518998997869411979”,“3548497199175959482359”,“3547489671000437532111”,“3546586473627958867000”,“3546699219023529136200”,“3359883748286571747454”,“3362451659292752558898”,“3360621112373241472729”,“3359803023426168835452”]	28989799	72999140086417273486981	2023-11-01T00:01:35.000Z	0x4db8d2b03b5b817cdc5c9ca80da7b0527927ddcf117a14d9b85774d812e49687	[“0xf41af21f0a800dc4d86efb14ad46cfb9884fdf38”,“0x9b959d27840a31988410ee69991bcf0110d61f02”,“0x6e46924371d0e910769aabe0d867590deac20684”,“0x32d619dc6188409cebbc52f921ab306f07db085b”,“0xfc3e31519b551bd594235dd0ef014375a87c4e21”,“0x8eec4f1c0878f73e8e09c1be78ac1465cc16544d”,“0xd11d9842babd5209b9b1155e46f5878c989125b7”,“0x52349003240770727900b06a3b3a90f5c0219ade”,“0x210744c64eea863cf0f972e5aebc683b98fb1984”,“0xee11d2016e9f2fae606b2f12986811f4abbe6215”,“0xec702628f44c31acc56c3a59555be47e1f16eb1e”,“0xe07d7e56588a6fd860c5073c70a099658c060f3d”,“0x05ad3ded6fcc510324af8e2631717af6da5c8b5b”,“0x4e7ea047ec7e95c7a02cb117128b94ccdd8356bf”,“0xbd4bf317da1928cc2f9f4da9006401f3944a0ab5”,“0xedcafc4ad8097c2012980a2a7087d74b86bddaf9”,“0x6aaabf51c5f6d2d93212cf7dad73d67afa0148d0”,“0xae53daac1bf3c4633d4921b8c3f8d579e757f5bc”,“0xca54a1700e0403dcb531f8db4ae3847758b90b01”,“0x2bddcaae1c6ccd53e436179b3fc07307ee6f3ef8”,“0x61089875ff9e506ae78c7fe9f7c388416520e386”,“0x47cfcb64f8ea44d6ea7fab32f13efa2f8e65eec1”]

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BridgeReward_BridgeRewardScattered_event

Staking_RewardClaimed_event

ValidatorSet_BridgeOperatorRewardDistributed_event

ValidatorSet_MiningRewardDistributed_event

ValidatorSet_StakingRewardDistributed_event

​Tables

​BridgeReward_BridgeRewardScattered_event

​Staking_RewardClaimed_event

​ValidatorSet_BridgeOperatorRewardDistributed_event

​ValidatorSet_MiningRewardDistributed_event

​ValidatorSet_StakingRewardDistributed_event

Tables

BridgeReward_BridgeRewardScattered_event

Staking_RewardClaimed_event

ValidatorSet_BridgeOperatorRewardDistributed_event

ValidatorSet_MiningRewardDistributed_event

ValidatorSet_StakingRewardDistributed_event