ringsprotocol_v1_ethereum

Tables

QuestRingsveBAL_createFixedQuest_function

Quest creation records from Rings Protocol’s veBAL gauge incentive system on Ethereum. Captures fixed-duration incentive campaigns with parameters including gauge address, reward token, duration (in voting periods), and total reward amounts for analyzing liquidity mining programs.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_startNextPeriod`	`BOOL`	Boolean flag indicating whether the quest starts in the next voting period instead of the current period.
`in_duration`	`STRING`	Duration period for the operation or quest. Numeric string representation in seconds.
`in_rewardPerVote`	`STRING`	Reward amount paid per unit of voting power cast on the gauge. Numeric string representation in smallest token denomination.
`in_totalRewardAmount`	`STRING`	Total reward amount allocated for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_voteType`	`INT64`	Enumeration indicating the type of voting mechanism for the quest. Integer value representing the vote type classification.
`in_closeType`	`INT64`	Enumeration indicating the quest closing mechanism. Integer value representing the type of closure condition for the quest.
`in_voterList`	`ARRAY<STRING>`	Array of voter addresses eligible to participate in the quest. Contains hex-encoded, 0x-prefixed, 42-character Ethereum addresses, or empty array if quest is open to all voters.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_gauge	out_anon0	signature	to_address	in_duration	block_number	from_address	in_closeType	in_feeAmount	in_voterList	trace_address	in_rewardToken	block_timestamp	in_rewardPerVote	transaction_hash	in_startNextPeriod	in_totalRewardAmount
1158588	true	582798	0xcc6a23446f6388d78f3037bd55f2eb820352d982	62	0x7e4a3fb4	0xfeb352930ca196a80b708cdd5dcb4eca94805dab	2	20534365	0x71e47a4429d35827e0312aa13162197c23287546	0	4367107500000000000000	[]	0,5,15	0xcdf7028ceab81fa0c6971208e83fa7872994bee5	2024-08-15T13:35:35.000Z	2270000000000000000	0x2f9b8458f644fdfa7261056714ef59dd2b5b3ea89a6ef245fe22e0e703d6052e	false	124774500000000000000000
1123196	true	548598	0xcc6a23446f6388d78f3037bd55f2eb820352d982	77	0x7e4a3fb4	0xfeb352930ca196a80b708cdd5dcb4eca94805dab	2	20638510	0x71e47a4429d35827e0312aa13162197c23287546	0	4762275000000000000000	[]	0,4,15	0xcdf7028ceab81fa0c6971208e83fa7872994bee5	2024-08-30T02:48:35.000Z	2330000000000000000	0xc8547e0103ecb472d8770d48091c18c92074b5f067cf2b223a2feaa7ef338960	false	136065000000000000000000
1741906	true	883460	0x1cce9d493224a19fcb5f7fbade8478630141cb54	225	0x7e4a3fb4	0xfeb352930ca196a80b708cdd5dcb4eca94805dab	4	22267519	0x87d93d9b2c672bf9c9642d853a8682546a5012b5	1	436893203883495145	[]	0,3	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2025-04-14T13:27:11.000Z	5552006279046	0x8722b9d0a3c51613532cbffc2aba014fc3d740b811453b035dade58d5d569ca7	false	14563106796116504851

Example Query

Query with partition filter

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

QuestRingsveBAL_createRangedQuest_function

Quest creation events from Rings Protocol’s veBAL (vote-escrowed Balancer) governance system on Ethereum. Tracks ranged voting incentive campaigns with reward parameters, gauge targets, and voter whitelists for analyzing protocol bribe markets and governance 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_startNextPeriod`	`BOOL`	Boolean flag indicating whether the quest starts in the next voting period instead of the current period.
`in_duration`	`STRING`	Duration period for the operation or quest. Numeric string representation in seconds.
`in_minRewardPerVote`	`STRING`	Minimum reward amount per vote for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_maxRewardPerVote`	`STRING`	Maximum reward amount per vote for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_totalRewardAmount`	`STRING`	Total reward amount allocated for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_voteType`	`INT64`	Enumeration indicating the type of voting mechanism for the quest. Integer value representing the vote type classification.
`in_closeType`	`INT64`	Enumeration indicating the quest closing mechanism. Integer value representing the type of closure condition for the quest.
`in_voterList`	`ARRAY<STRING>`	Array of voter addresses eligible to participate in the quest. Contains hex-encoded, 0x-prefixed, 42-character Ethereum addresses, or empty array if quest is open to all voters.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_gauge	out_anon0	signature	to_address	in_duration	in_voteType	block_number	from_address	in_closeType	in_feeAmount	in_voterList	trace_address	in_rewardToken	block_timestamp	transaction_hash	in_startNextPeriod	in_maxRewardPerVote	in_minRewardPerVote	in_totalRewardAmount
663727	true	656516	0x79ef6103a513951a3b25743db509e267685726b7	201	0x29b6a430	0xfeb352930ca196a80b708cdd5dcb4eca94805dab	2	2	21862867	0xb867ea3bbc909954d737019fef5ab25dfdb38cb9	2	67840000000000000000	[“0xaf52695e1bb01a16d33d7194c28c42b10e0dbec2”]	0,4,1	0xd33526068d116ce69f19a9ee46f0bd304f21a51f	2025-02-17T01:36:11.000Z	0x48c5ba1cdc7df0ac14fb1d3a2d1ff6f1b4d7185fee825bd30cf56b47639c1a6f	false	5124000000000000	3014000000000000	3392000000000000000000
964238	true	571585	0x5a099e2c2a41a5a0ad99e4971c711400eeef34db	269	0x29b6a430	0xfeb352930ca196a80b708cdd5dcb4eca94805dab	2	0	23190265	0xa58fbe38aab33b9fadef1b5aaff4d7bc27c43ad4	0	279337332202996216001	[]	11	0x6440f144b7e50d6a8439336510312d2f54beb01d	2025-08-21T15:10:35.000Z	0xe55fd5a1e2e7a5ca766749f5cfc3c4bad1330fc10e986e6b4fdd3865b659962f	false	20000000000000000	12000000000000000	6983433305074905400041
654150	true	651716	0x79ef6103a513951a3b25743db509e267685726b7	158	0x29b6a430	0xfeb352930ca196a80b708cdd5dcb4eca94805dab	2	2	21260218	0xb867ea3bbc909954d737019fef5ab25dfdb38cb9	2	67840000000000000000	[“0xaf52695e1bb01a16d33d7194c28c42b10e0dbec2”]	0,5,2	0xd33526068d116ce69f19a9ee46f0bd304f21a51f	2024-11-24T21:13:47.000Z	0x086c3b03d116dbb957b95a0c992dd758da24b7304f46fb261c27543fc6e58cdb	false	4856000000000000	2856000000000000	3392000000000000000000

Example Query

Query with partition filter

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

QuestRingsveCRV_createFixedQuest_function

Quest creation events from Rings Protocol’s vote-escrowed CRV (veCRV) bribe marketplace on Ethereum. Captures function calls that establish fixed-duration gauge voting incentive campaigns with reward token distributions and targeted voter lists.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_startNextPeriod`	`BOOL`	Boolean flag indicating whether the quest starts in the next voting period instead of the current period.
`in_duration`	`STRING`	Duration period for the operation or quest. Numeric string representation in seconds.
`in_rewardPerVote`	`STRING`	Reward amount paid per unit of voting power cast on the gauge. Numeric string representation in smallest token denomination.
`in_totalRewardAmount`	`STRING`	Total reward amount allocated for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_voteType`	`INT64`	Enumeration indicating the type of voting mechanism for the quest. Integer value representing the vote type classification.
`in_closeType`	`INT64`	Enumeration indicating the quest closing mechanism. Integer value representing the type of closure condition for the quest.
`in_voterList`	`ARRAY<STRING>`	Array of voter addresses eligible to participate in the quest. Contains hex-encoded, 0x-prefixed, 42-character Ethereum addresses, or empty array if quest is open to all voters.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_gauge	out_anon0	signature	to_address	in_duration	in_voteType	block_number	from_address	in_closeType	in_feeAmount	in_voterList	trace_address	in_rewardToken	block_timestamp	in_rewardPerVote	transaction_hash	in_startNextPeriod	in_totalRewardAmount
1042566	true	643920	0xb251c0885c7c1975d773b57e67c138fbceaa6db4	15	0x7e4a3fb4	0xaa1698f0a51e6d00f5533cc3e5d36010ee4558c6	2	1	20155902	0x9e2b6378ee8ad2a4a95fe481d63caba8fb0ebbf9	2	13526570048309178743	[“0x989aeb4d175e16225e39e87d0d97a3360524ad80”]	0,3	0xdbdb4d16eda451d0503b854cf79d55697f90c8df	2024-06-23T17:32:35.000Z	67573203130083	0xc81596bd6b7dab70c0a08bd8edb5da93d80debdb4f618b8d1c9dc94dcb8801da	false	386473429951690821255
1042548	true	643920	0xb251c0885c7c1975d773b57e67c138fbceaa6db4	91	0x7e4a3fb4	0xaa1698f0a51e6d00f5533cc3e5d36010ee4558c6	2	1	20862419	0x9e2b6378ee8ad2a4a95fe481d63caba8fb0ebbf9	2	13526570048309178743	[“0x989aeb4d175e16225e39e87d0d97a3360524ad80”]	0,3	0xdbdb4d16eda451d0503b854cf79d55697f90c8df	2024-09-30T08:57:47.000Z	59000000000000	0x1451588b1e9fa6ea33d9d4d8b04dc6028babb1c2018ddfdf7acd5272c4b16177	false	386473429951690821255
636019	true	626023	0x0933426f6b63327b9a20e6acde0b45b1b64fdc88	90	0x7e4a3fb4	0xaa1698f0a51e6d00f5533cc3e5d36010ee4558c6	2	0	20862332	0x7bdfe11c4981dd4c33e1aa62457b8773253791b3	0	38461538	[]		0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2024-09-30T08:40:23.000Z	288	0x149d26f1aca22907754708562e70e6bb98c8c896d6e607f2e788d4d4d41dba2f	false	961538461

Example Query

Query with partition filter

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

QuestRingsveCRV_createRangedQuest_function

Quest creation transactions for Rings Protocol’s veCRV (vote-escrowed Curve) gauge voting incentive system on Ethereum. Tracks parameters for bribes including reward token, gauge address, duration, min/max reward per vote, and fee amounts for analyzing incentive campaigns targeting Curve DAO governance participants.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_startNextPeriod`	`BOOL`	Boolean flag indicating whether the quest starts in the next voting period instead of the current period.
`in_duration`	`STRING`	Duration period for the operation or quest. Numeric string representation in seconds.
`in_minRewardPerVote`	`STRING`	Minimum reward amount per vote for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_maxRewardPerVote`	`STRING`	Maximum reward amount per vote for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_totalRewardAmount`	`STRING`	Total reward amount allocated for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_voteType`	`INT64`	Enumeration indicating the type of voting mechanism for the quest. Integer value representing the vote type classification.
`in_closeType`	`INT64`	Enumeration indicating the quest closing mechanism. Integer value representing the type of closure condition for the quest.
`in_voterList`	`ARRAY<STRING>`	Array of voter addresses eligible to participate in the quest. Contains hex-encoded, 0x-prefixed, 42-character Ethereum addresses, or empty array if quest is open to all voters.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_gauge	out_anon0	signature	to_address	in_duration	block_number	from_address	in_closeType	in_feeAmount	in_voterList	trace_address	in_rewardToken	block_timestamp	transaction_hash	in_startNextPeriod	in_maxRewardPerVote	in_minRewardPerVote	in_totalRewardAmount
2904477	false	588082	0x1e4b83f6bfe9dbeb6d5b92a5237e5c18a44176f4	195	0x29b6a430	0xaa1698f0a51e6d00f5533cc3e5d36010ee4558c6	2	21764963	0xa1c93d2687f7014aaf588c764e3ce80af016229b	2	307692307692307692307	[]	0,0,0,2,1	0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f	2025-02-03T09:03:35.000Z	0xef24e49596a9071496b069e33691750e227c7d687f04a51ed5e32b267606f148	false	1900000000000000	1400000000000000	7692307692307692307691
929795	true	578030	0x8682fa9c4b6495ddf38643807ca088ebe0d22b8b	57	0x29b6a430	0xaa1698f0a51e6d00f5533cc3e5d36010ee4558c6	2	20540092	0x1ae6dcbc88d6f81a7bcfccc7198397d776f3592e	0	1288000000000000000000	[]	0,4,1	0xab846fb6c81370327e784ae7cbb6d6a6af6ff4bf	2024-08-16T08:47:23.000Z	0xbf9fa25940821f16225fc6190035a06c36d665d23724846bb33e27df4767408c	false	19800000000000000	17000000000000000	32200000000000000000000
1022466	true	637352	0x8682fa9c4b6495ddf38643807ca088ebe0d22b8b	6	0x29b6a430	0xaa1698f0a51e6d00f5533cc3e5d36010ee4558c6	2	20045751	0x1ae6dcbc88d6f81a7bcfccc7198397d776f3592e	1	1242000000000000000000	[]	0,5,1	0xab846fb6c81370327e784ae7cbb6d6a6af6ff4bf	2024-06-08T07:55:11.000Z	0x5eac6504b5d8444a1119bd556496efd7e463760eaeb9fcc40b3ef57a0ab22e56	false	14500000000000000	13400000000000000	31050000000000000000000

Example Query

Query with partition filter

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

QuestRingsveFXN_createFixedQuest_function

Fixed quest creation transactions for Rings Protocol’s veFXN (vote-escrowed FXN) gauge voting incentives on Ethereum. Captures reward parameters including token addresses, amounts per vote, duration, and fee structure for analyzing bribe campaigns targeting specific gauges.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_startNextPeriod`	`BOOL`	Boolean flag indicating whether the quest starts in the next voting period instead of the current period.
`in_duration`	`STRING`	Duration period for the operation or quest. Numeric string representation in seconds.
`in_rewardPerVote`	`STRING`	Reward amount paid per unit of voting power cast on the gauge. Numeric string representation in smallest token denomination.
`in_totalRewardAmount`	`STRING`	Total reward amount allocated for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_voteType`	`INT64`	Enumeration indicating the type of voting mechanism for the quest. Integer value representing the vote type classification.
`in_closeType`	`INT64`	Enumeration indicating the quest closing mechanism. Integer value representing the type of closure condition for the quest.
`in_voterList`	`ARRAY<STRING>`	Array of voter addresses eligible to participate in the quest. Contains hex-encoded, 0x-prefixed, 42-character Ethereum addresses, or empty array if quest is open to all voters.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_gauge	out_anon0	signature	to_address	in_duration	block_number	from_address	in_feeAmount	in_voterList	in_rewardToken	block_timestamp	in_rewardPerVote	transaction_hash	in_startNextPeriod	in_totalRewardAmount
774624	true	502887	0xa295829c082c4d21fe37dbc8c96bfa0ef6dbaa92	60	0x7e4a3fb4	0x59abf8642f4c7d8d3c5633edcbbf6b12234ff02d	1	22297446	0xeab3e2010264ca77b2ebcf9d4672a79d24c924e6	5769230769230769230768	[]	0x5de8ab7e27f6e7a1fff3e5b337584aa43961beef	2025-04-18T17:42:47.000Z	20000000000000000000	0xffec966d44a484ede2f9c034f73348e6e657555cc8cecac4d64e7b4f69df109e	false	144230769230769230769220
771423	true	507663	0xa295829c082c4d21fe37dbc8c96bfa0ef6dbaa92	61	0x7e4a3fb4	0x59abf8642f4c7d8d3c5633edcbbf6b12234ff02d	1	22337893	0xeab3e2010264ca77b2ebcf9d4672a79d24c924e6	7692307692307692307692	[]	0x5de8ab7e27f6e7a1fff3e5b337584aa43961beef	2025-04-24T09:11:23.000Z	20000000000000000000	0x15b290d68d634e3b70aab32c131cafe3b43a055fc0ece70a383b92035be63997	false	192307692307692307692300
830984	true	540019	0xa295829c082c4d21fe37dbc8c96bfa0ef6dbaa92	57	0x7e4a3fb4	0x59abf8642f4c7d8d3c5633edcbbf6b12234ff02d	1	22267024	0xeab3e2010264ca77b2ebcf9d4672a79d24c924e6	4807692307692307692306	[]	0x5de8ab7e27f6e7a1fff3e5b337584aa43961beef	2025-04-14T11:47:23.000Z	29000000000000000000	0xdcf24debf0aa282a86a023ba7240f7b946cd662025069d8f2fd670334fcc0d24	false	120192307692307692307671

Example Query

Query with partition filter

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

QuestRingsveFXN_createRangedQuest_function

Quest creation events for veFXN (vote-escrowed FXN) gauge bribe campaigns on Rings Protocol. Tracks reward parameters including token addresses, reward amounts per vote, duration, and targeted voter lists for analyzing vote incentive programs.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_startNextPeriod`	`BOOL`	Boolean flag indicating whether the quest starts in the next voting period instead of the current period.
`in_duration`	`STRING`	Duration period for the operation or quest. Numeric string representation in seconds.
`in_minRewardPerVote`	`STRING`	Minimum reward amount per vote for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_maxRewardPerVote`	`STRING`	Maximum reward amount per vote for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_totalRewardAmount`	`STRING`	Total reward amount allocated for the quest. Numeric string representation of token quantity in its smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_voteType`	`INT64`	Enumeration indicating the type of voting mechanism for the quest. Integer value representing the vote type classification.
`in_closeType`	`INT64`	Enumeration indicating the quest closing mechanism. Integer value representing the type of closure condition for the quest.
`in_voterList`	`ARRAY<STRING>`	Array of voter addresses eligible to participate in the quest. Contains hex-encoded, 0x-prefixed, 42-character Ethereum addresses, or empty array if quest is open to all voters.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_gauge	out_anon0	signature	to_address	in_duration	in_voteType	block_number	from_address	in_closeType	in_feeAmount	in_voterList	trace_address	in_rewardToken	block_timestamp	transaction_hash	in_startNextPeriod	in_maxRewardPerVote	in_minRewardPerVote	in_totalRewardAmount
1029704	true	635549	0x9c7003bc16f2a1aa47451c858fee6480b755363e	37	0x29b6a430	0x59abf8642f4c7d8d3c5633edcbbf6b12234ff02d	2	0	21356872	0x9e2b6378ee8ad2a4a95fe481d63caba8fb0ebbf9	0	2705314009661835748	[]	0,3	0xdbdb4d16eda451d0503b854cf79d55697f90c8df	2024-12-08T09:27:47.000Z	0xc515f2bd6ddf929eb087aa34280c8e86da5fa7d483c170bb0381c1d0536934bb	false	30000000000000000	15000000000000000	77294685990338164249
1067781	true	649226	0xf0a3eced42dbd8353569639c0eaa833857aa0a75	38	0x29b6a430	0x59abf8642f4c7d8d3c5633edcbbf6b12234ff02d	2	1	21360991	0xa1c93d2687f7014aaf588c764e3ce80af016229b	1	384615384615384615384	[“0xd11a4ee017ca0beca8fa45ff2abfe9c6267b7881”]	0,1,0,2	0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f	2024-12-08T23:14:35.000Z	0x781e78cc9ff603a2635f1d7753f220405d720c7f7e4d46f8d85e1140018b58dd	false	1500000000000000000	900482236210144211	9615384615384615384613
1148176	true	683426	0xf0a3eced42dbd8353569639c0eaa833857aa0a75	64	0x29b6a430	0x59abf8642f4c7d8d3c5633edcbbf6b12234ff02d	2	1	22451190	0xa1c93d2687f7014aaf588c764e3ce80af016229b	1	480769230769230769230	[“0xd11a4ee017ca0beca8fa45ff2abfe9c6267b7881”]	0,2,0	0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f	2025-05-10T06:23:23.000Z	0xcaf64ac23a746ae2cf324a630100771691d3fef917da5365821c09f2cea2b2ba	false	220000000000000000	100000000000000	12019230769230769230768

Example Query

Query with partition filter

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

scBTC_Enter_event

Deposit events for Rings Protocol scBTC vault on Ethereum, tracking when users enter by depositing BTC-backed assets in exchange for vault shares. Useful for analyzing vault inflows, share pricing, and depositor behavior.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xe418ee2df21ef818d20194113281d3f4300aead3	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0xe418ee2df21ef818d20194113281d3f4300aead3	false	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	200311949	200311949	214	22128633	2025-03-26T04:17:23.000Z	0xfe100c8688c20dc35bc02f58d9f0afba43eb1a38402ba0707bca129627e32f7d
0xcdb0d9481d3b7b29d8b6925332c309f8c17b5f5e	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0xcdb0d9481d3b7b29d8b6925332c309f8c17b5f5e	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	400000	398800	55	22130844	2025-03-26T11:41:11.000Z	0x9e421ca02373323d586c82b2fc7fa60251f6ad1a483954a444da8a10951bc84b
0xba9a6d2ba76fae1e08bb1d12a8ccbc46ea7735cf	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0xba9a6d2ba76fae1e08bb1d12a8ccbc46ea7735cf	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	8374440	8349316	298	22132584	2025-03-26T17:29:35.000Z	0x0642dd802d69991a4cee103283ac0d45883787bbbaa76788b2bf1849a5ce43ab

Example Query

Query with partition filter

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

scBTC_Exit_event

Withdrawal events from Rings Protocol’s scBTC (synthetic Bitcoin) vault on Ethereum, recording share redemptions from user accounts. Tracks exit transactions with share amounts and participant addresses for analyzing vault outflows and user behavior.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

in_to	address	in_from	removed	in_asset	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0xf8553c8552f906c19286f21711721e206ee4909e	false	0x0000000000000000000000000000000000000000	10000	417	21835785	2025-02-13T06:30:23.000Z	0xcc34112639ca0751058bbeddd0992772e7fb7e3b622ec20ec0db6651faae9842
0x0000000000000000000000000000000000000000	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0x502e2514d5f5f191de0a4a3b7f5190f8e53c010d	false	0x0000000000000000000000000000000000000000	98798	1097	22028154	2025-03-12T03:39:23.000Z	0x7bba49f1c512bae500ccd4670faa3876f1ca17ce39889724b2ebf473380845e5
0x0000000000000000000000000000000000000000	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0x3367a005c2bef54f2836a616ce3e4fa2d35910da	false	0x0000000000000000000000000000000000000000	1213293	345	22028154	2025-03-12T03:39:23.000Z	0xca76376e05a69b862ffc5f6014500ad01451c2f802a7f5f661e78c066530a80e

Example Query

Query with partition filter

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

scBTCAccountant_FeesClaimed_event

No description available.

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_feeAsset`	`STRING`	Contract address of the token in which fees are denominated. 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

No sample data available.

Example Query

Query with partition filter

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

scETH_Enter_event

Deposit events for the scETH (staked compound ETH) vault on Rings Protocol Ethereum, recording when users stake ETH or WETH in exchange for scETH vault shares. Used for analyzing vault deposit activity, share issuance, and liquidity provider behavior.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x217d452b93dd9d369d4242c744da5484e59db312	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x0000000000000000000000000000000000000000	false	0x0000000000000000000000000000000000000000	0	1000000000000000000	193	21607832	2025-01-12T10:32:23.000Z	0x9c5bb6f679039226d52349b79a93f1600df8b96fe7b34a7aa41c15e57e32b105
0x1f92b5affd12981ef0fa7ba22a802379fd36929e	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x1f92b5affd12981ef0fa7ba22a802379fd36929e	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	6000000000000000000	6000000000000000000	266	21607843	2025-01-12T10:34:35.000Z	0xe50dbc0a71b77177b752a3aa56e91115ea8f288d27fdc20e3601b5c2bebd6aa8
0x3b30d44df9afffc07a51457e18410c4ca0f90896	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x3b30d44df9afffc07a51457e18410c4ca0f90896	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	261224081557192608	261224081557192608	133	21606315	2025-01-12T05:27:59.000Z	0x1d8e75092deecd085c3d62de8ae45c80e03612e3f691dd339d2638c095464196

Example Query

Query with partition filter

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

scETH_Exit_event

Withdrawal events from Rings Protocol scETH (staked ETH) vault on Ethereum, recording user exits by burning shares. Tracks user addresses, share amounts burned, and corresponding asset values for analyzing vault redemption patterns and liquidity flows.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

in_to	address	in_from	removed	in_asset	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x22ac3ccf9956636d44c146d25c2ab43f3266273b	false	0x0000000000000000000000000000000000000000	1724663302592346782	413	21633114	2025-01-15T23:17:47.000Z	0x3eaa1300ef02a2a9d84dad114dea2e1864839f045440ec67722444ca595802ce
0x0000000000000000000000000000000000000000	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x664ba0ac858fc3ba5f44e812148b590848d480e1	false	0x0000000000000000000000000000000000000000	5000000000000000	136	21628484	2025-01-15T07:46:59.000Z	0x35bd5ac04bbcbe6e239daf16916cd9aeceecaf7388d143ebfdc9c9594522da23
0x0000000000000000000000000000000000000000	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x8288090f6016bd90dc234fc619baeaa6ba031ba6	false	0x0000000000000000000000000000000000000000	200000000000000000	265	21632973	2025-01-15T22:49:11.000Z	0x7561dec53872d98975abd019360f7ae16029095fb5def89d1f4151bf9744a425

Example Query

Query with partition filter

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

scETHAccountant_FeesClaimed_event

No description available.

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_feeAsset`	`STRING`	Contract address of the token in which fees are denominated. 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

No sample data available.

Example Query

Query with partition filter

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

scUSD_Enter_event

Deposit events for Rings Protocol’s scUSD vault on Ethereum, recording user deposits of USDC (0xa0b8…eb48) in exchange for scUSD shares. Useful for tracking vault inflows, user participation, and share issuance over time.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x009d13e9bec94bf16791098ce4e5c168d27a9f07	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x009d13e9bec94bf16791098ce4e5c168d27a9f07	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	4898675547	4898675547	370	21790519	2025-02-06T22:41:59.000Z	0x404ace943c978e7432f15905909a49a9c6e91eca9559b7e043db7a371214b06f
0x0f95f342a5939afbed32548d392b72fb56a9940c	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x0f95f342a5939afbed32548d392b72fb56a9940c	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	500000000	500000000	256	21783797	2025-02-06T00:11:35.000Z	0xfd8f7c1905400769c32f100c25edbaf9b7deb7f8ec0a862715f0d5ecd9a21508
0x0f95f342a5939afbed32548d392b72fb56a9940c	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x0f95f342a5939afbed32548d392b72fb56a9940c	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	3493924	3493924	221	21783834	2025-02-06T00:18:59.000Z	0xf66499fdb3b2c51883ea572b4161feb0159748ff501baab0db008e58cbc66b67

Example Query

Query with partition filter

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

scUSD_Exit_event

Withdrawal events from Rings Protocol’s scUSD vault on Ethereum, recording when users exit positions by redeeming shares. Tracks share amounts burned, user addresses, and vault state for analyzing redemption patterns and liquidity flows.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

in_to	address	in_from	removed	in_asset	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x1e05f2c9edf7aa25771c795db763de144a752f37	false	0x0000000000000000000000000000000000000000	5000000	162	21727755	2025-01-29T04:19:35.000Z	0x100522567b22b9943f3a0f5e2eb69b7193d4410ecaae9024f35e9b335cee80a6
0x0000000000000000000000000000000000000000	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x2371e3710a45e29de6075255c1c7b0a9276a0375	false	0x0000000000000000000000000000000000000000	347571263	586	21728663	2025-01-29T07:21:59.000Z	0xb6c98fd322e14a745d9d5b2e7e791bf356d72f3d8eeee4138973fbaf1192efed
0x0000000000000000000000000000000000000000	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x554bb0ebabc7024d2182286912739ef68645250a	false	0x0000000000000000000000000000000000000000	997500000	410	21728948	2025-01-29T08:19:23.000Z	0xd81c76c25cc715e207dd802d72d91b8c9e6ee74a2bf6b60a56cb197a68de76b1

Example Query

Query with partition filter

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

scUSDAccountant_FeesClaimed_event

No description available.

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_feeAsset`	`STRING`	Contract address of the token in which fees are denominated. 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

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

QuestRingsveBAL_createFixedQuest_function

QuestRingsveBAL_createRangedQuest_function

QuestRingsveCRV_createFixedQuest_function

QuestRingsveCRV_createRangedQuest_function

QuestRingsveFXN_createFixedQuest_function

QuestRingsveFXN_createRangedQuest_function

scBTC_Enter_event

scBTC_Exit_event

scBTCAccountant_FeesClaimed_event

scETH_Enter_event

scETH_Exit_event

scETHAccountant_FeesClaimed_event

scUSD_Enter_event

scUSD_Exit_event

scUSDAccountant_FeesClaimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​QuestRingsveBAL_createFixedQuest_function

​QuestRingsveBAL_createRangedQuest_function

​QuestRingsveCRV_createFixedQuest_function

​QuestRingsveCRV_createRangedQuest_function

​QuestRingsveFXN_createFixedQuest_function

​QuestRingsveFXN_createRangedQuest_function

​scBTC_Enter_event

​scBTC_Exit_event

​scBTCAccountant_FeesClaimed_event

​scETH_Enter_event

​scETH_Exit_event

​scETHAccountant_FeesClaimed_event

​scUSD_Enter_event

​scUSD_Exit_event

​scUSDAccountant_FeesClaimed_event

Tables

QuestRingsveBAL_createFixedQuest_function

QuestRingsveBAL_createRangedQuest_function

QuestRingsveCRV_createFixedQuest_function

QuestRingsveCRV_createRangedQuest_function

QuestRingsveFXN_createFixedQuest_function

QuestRingsveFXN_createRangedQuest_function

scBTC_Enter_event

scBTC_Exit_event

scBTCAccountant_FeesClaimed_event

scETH_Enter_event

scETH_Exit_event

scETHAccountant_FeesClaimed_event

scUSD_Enter_event

scUSD_Exit_event

scUSDAccountant_FeesClaimed_event