ringsprotocol_v1_sonic - Token Terminal Docs

Tables

QuestRingsveBTC_createFixedQuest_function

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.
`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

No sample data available.

Example Query

Query with partition filter

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

QuestRingsveBTC_createRangedQuest_function

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.
`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

No sample data available.

Example Query

Query with partition filter

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

QuestRingsveETH_createFixedQuest_function

Quest creation events from Rings Protocol on Sonic blockchain where users set up fixed-reward voting incentive campaigns. Tracks reward distribution parameters including token amounts, vote types, gauges, and duration for analyzing veETH (vote-escrowed ETH) 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_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	value	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
764937	0	true	525888	0xb8022c515174f41c4ef9211fe5dcfff27b01de87	175	0xa8cf56f9	0xc20824bed473525ba640f6c2ae5d89469636ddcb	1	0	48035909	0xa1eb063e50bd82f3b511bac3084abd67cf79afd4	0	6884615	[]		0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	2025-09-24T14:17:44.000Z	6180000	0x6d782866140047933793c2fa03fe6c8d4d7ea6a466c980257c60c21f2ef8079a	false	172115384
763896	0	true	525159	0x4d62b6e166767988106cf7ee8fe23e480e76ff1d	99	0xa8cf56f9	0xc20824bed473525ba640f6c2ae5d89469636ddcb	1	0	34692511	0x17c3445d3150cb009fe3bd49e3ad1b960e2f66fa	0	192307692307692307691	[]		0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	2025-06-18T16:11:18.000Z	40000000000000000000	0x686cc95199bef1af37ab570cac287883a86a70e776d8cf2834ec2cf75ae458eb	false	4807692307692307692280

Example Query

Query with partition filter

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

QuestRingsveETH_createRangedQuest_function

Quest creation transactions for Rings Protocol veETH gauges on Sonic. Records reward campaigns targeting specific liquidity pools with customizable vote incentive ranges and fee structures for analyzing protocol governance 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.
`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_feeAmount	in_voterList	in_rewardToken	block_timestamp	transaction_hash	in_startNextPeriod	in_maxRewardPerVote	in_minRewardPerVote	in_totalRewardAmount
793235	true	545696	0x4d62b6e166767988106cf7ee8fe23e480e76ff1d	40	0x3ce455a8	0xc20824bed473525ba640f6c2ae5d89469636ddcb	1	21494106	0x17c3445d3150cb009fe3bd49e3ad1b960e2f66fa	96153846153846153845	[]	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	2025-04-22T05:32:57.000Z	0x0f8dc3aa794e46e21cb7248a0b52a6ad89684de2a6fae7d376e0b96a37f80ce5	false	72000000000000000000	24000000000000000000	2403846153846153846144
792416	true	545123	0x2b93eb843a54fa3ecacb5a72a69dcb666b262069	41	0x3ce455a8	0xc20824bed473525ba640f6c2ae5d89469636ddcb	1	21624851	0x009d13e9bec94bf16791098ce4e5c168d27a9f07	192307692307692307692	[]	0xe4a4353cd8f008f1a70f1a564535990479e8ceb7	2025-04-22T21:27:30.000Z	0x28f2f5c397352893c229dea595a8aecbe80c165cb72d891e93ff8e81daa3bc45	false	250000000000000000000	10000000000000000000	4807692307692307692300
794420	true	546526	0xc5e0250037195850e4d987ca25d6aba68ef5fee8	23	0x3ce455a8	0xc20824bed473525ba640f6c2ae5d89469636ddcb	1	17688651	0x693f30c37d5a0db9258c636e93ccf011acd8c90c	23103846153846153	[]	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	2025-04-02T13:11:55.000Z	0xe1966200cf86a113d5f8eb377d93ee386ec095793def67da5f721c347b695fe9	false	18700000000000000	9000000000000000	577596153846153845

Example Query

Query with partition filter

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

QuestRingsveUSD_createFixedQuest_function

Fixed quest creation events from Rings Protocol’s veUSD gauge voting system on Sonic, recording incentive campaigns where protocols deposit rewards to attract votes. Captures reward token amounts, gauge targets, vote parameters, and quest IDs for analyzing voter incentivization strategies.

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	value	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
763860	0	true	525134	0x4d62b6e166767988106cf7ee8fe23e480e76ff1d	111	0xa8cf56f9	0xa04a36614e4c1eb8cc0137d6d34eaac963167828	1	0	34691900	0x17c3445d3150cb009fe3bd49e3ad1b960e2f66fa	0	512807692307692307692	[]		0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	2025-06-18T16:06:03.000Z	20000000000000000	0x87679420ddf9a606e878b37db503fb9216f884195e01b9d93ea5e6f0a32be1ad	false	12820192307692307692307
764919	0	true	525875	0xb8022c515174f41c4ef9211fe5dcfff27b01de87	203	0xa8cf56f9	0xa04a36614e4c1eb8cc0137d6d34eaac963167828	1	0	47934074	0xa1eb063e50bd82f3b511bac3084abd67cf79afd4	0	8269230	[]		0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	2025-09-23T17:48:37.000Z	1922	0xaf8d1645f1748c4b64d76a95a20f40dec38655ad8c4c664e31bc6bbef74ca28b	false	206730769

Example Query

Query with partition filter

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

QuestRingsveUSD_createRangedQuest_function

Quest creation events for Rings Protocol’s veUSD gauge voting system on Sonic. Records ranged quests with reward parameters (min/max per vote), token incentives, and gauge targets for analyzing vote-incentive programs and gauge-weight markets.

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_feeAmount	in_voterList	trace_address	in_rewardToken	block_timestamp	transaction_hash	in_startNextPeriod	in_maxRewardPerVote	in_minRewardPerVote	in_totalRewardAmount
812977	true	520249	0xd9c7206380bd5114590cdd3040e32617416765a5	213	0x3ce455a8	0xa04a36614e4c1eb8cc0137d6d34eaac963167828	1	49753685	0x821d2799e038718413da21d7f712895075403575	38461538461538461538	[]	0,0	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	2025-10-08T08:08:55.000Z	0x84ab64380f46328cbe2f79455e0459e8feceb6384fd462d49ec8930846fff674	false	7000000000000000	6250000000000000	961538461538461538461
1614490	true	496735	0xc5e0250037195850e4d987ca25d6aba68ef5fee8	214	0x3ce455a8	0xa04a36614e4c1eb8cc0137d6d34eaac963167828	1	49777528	0xc5e0250037195850e4d987ca25d6aba68ef5fee8	54680000	[]	0,3,1	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	2025-10-08T13:21:58.000Z	0xb47539993a9ce22feff6489a977df0a4fc9d19741a489bd8d08bec69b2c8c6ff	false	2930	2150	1367000000
793199	true	545671	0xa48260f762fe533a6e32cb1cac8f411d19bfb987	20	0x3ce455a8	0xa04a36614e4c1eb8cc0137d6d34eaac963167828	1	16761807	0x4e4bb679d78a6cc5dd9555ebeebc6409602f4201	615384615384615384615	[]		0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	2025-03-29T10:06:04.000Z	0xa540cf901abfadfcf084dbbe5b503d5311703e2bf0794497d9b019e0a9fd1d2f	false	1000000000000000000	10000000000000000	15384615384615384615384

Example Query

Query with partition filter

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

scBTC_Enter_event

Deposit events for scBTC (synthetic Bitcoin) vault on Rings Protocol deployed on Sonic, recording user deposits of underlying assets in exchange for vault shares. Used for tracking vault entry positions, share issuance, and liquidity provision patterns.

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
0x07c87bc9ccee8810c10abea1f933a41361749dd4	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0x07c87bc9ccee8810c10abea1f933a41361749dd4	false	0x0555e30da8f98308edb960aa94c0db47230d2b9c	13772	13730	2	11099127	2025-03-02T02:50:25.000Z	0x203b50156a46e78c39fcb2700afdacfbd020c0b7aa54fc390c062befac901f11
0x28c974c18c6553b445c4b77f35d83f3499acf58f	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0x28c974c18c6553b445c4b77f35d83f3499acf58f	false	0x0555e30da8f98308edb960aa94c0db47230d2b9c	1678	1672	17	11127922	2025-03-02T06:52:13.000Z	0x7ebe9ec28cbbf7bb7810f8054ca61294994518e841bc02ecd968b35be809243c
0x2d7af52847c63f67b95ff7d5480c50b79b70966d	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0x2d7af52847c63f67b95ff7d5480c50b79b70966d	false	0x0555e30da8f98308edb960aa94c0db47230d2b9c	32789	32690	7	11262905	2025-03-02T21:09:23.000Z	0xc41879d171aab41de0a7acc34420e9cbaafc2f4daca62e14c3d59bf15b55390f

Example Query

Query with partition filter

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

scBTC_Exit_event

Exit events from Rings Protocol’s scBTC vault contract on Sonic, recording withdrawals where users redeem shares for underlying assets. Tracks share burns and asset redemptions for analyzing vault liquidity flows and user exit patterns.

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_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x921bbb663a0164c9867e494b8e0331b84213a984	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0x921bbb663a0164c9867e494b8e0331b84213a984	false	0xecac9c5f704e954931349da37f60e39f515c11c1	4076301	4076301	13	18846234	2025-04-08T02:03:48.000Z	0xd27a311253c39d14bf9e1215517444620330a90547f823dabe307beda8bc8749
0x921bbb663a0164c9867e494b8e0331b84213a984	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0x921bbb663a0164c9867e494b8e0331b84213a984	false	0x0555e30da8f98308edb960aa94c0db47230d2b9c	105190105	105190105	8	18846243	2025-04-08T02:03:52.000Z	0x4d91673eef3b93dd173da9700af4d2d37fd676abe9b83bae21e372ff0ea7f232
0x921bbb663a0164c9867e494b8e0331b84213a984	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	0x921bbb663a0164c9867e494b8e0331b84213a984	false	0xecac9c5f704e954931349da37f60e39f515c11c1	1800000	1800000	4	12805849	2025-03-10T08:20:32.000Z	0xb5e79505ce10695570778847e5a0dbc7a4d4656a57b7a2ed57ef3b36259db35b

Example Query

Query with partition filter

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

scBTCVoter_BudgetDeposited_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_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
`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_sonic.scBTCVoter_BudgetDeposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

scBTCVoter_RewardClaimed_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_gauge`	`STRING`	Contract address of the gauge contract. 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_sonic.scBTCVoter_RewardClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

scETH_Enter_event

Deposit events for the scETH (staked collateral ETH) vault on Rings Protocol deployed on Sonic chain. Records user entries with deposit amounts, share allocations, and asset addresses for tracking vault participation and liquidity provision.

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_shares	log_index	block_number	block_timestamp	transaction_hash
0x0a573bc3489d3dc339643ce50767c19eeb3fed70	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x0000000000000000000000000000000000000000	false	0x0000000000000000000000000000000000000000	2000000000000000000	1	19962723	2025-04-13T11:06:24.000Z	0xfb259c1de3afac2cd2e1b560d3c7b6818d704e8883ded2da4866f6ea34f257a4
0x696c9b7dd5fcadbfa0b1170bee6517e87598dcdb	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x0000000000000000000000000000000000000000	false	0x0000000000000000000000000000000000000000	100000000000000000	1	20007500	2025-04-13T16:58:33.000Z	0x4d5dda118c63d5060fb0590de721ebbf7434683128423d3a63f76a08613e2b3d
0xca908d05538387f6299ac8b7134f1aa52c797c30	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x0000000000000000000000000000000000000000	false	0x0000000000000000000000000000000000000000	1250000000000000000	1	19956415	2025-04-13T10:18:47.000Z	0xb0fea6474273af4a0ecc9c7a5599abb63c3c0711b0a8f773dcb83ae83262ec1e

Example Query

Query with partition filter

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

scETH_Exit_event

Exit events from the scETH (staked collateral ETH) vault contract on Rings Protocol deployed on Sonic chain. Tracks withdrawal transactions including share redemptions, asset amounts, and recipient addresses for analyzing vault liquidity and user exit patterns.

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_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x1dabab81ae16b945a747e52c4e5bd41a7b1cb8b3	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x1dabab81ae16b945a747e52c4e5bd41a7b1cb8b3	false	0x50c42deacd8fc9773493ed674b675be577f2634b	67882122672060961	67882122672060961	12	4498122	2025-01-19T07:45:04.000Z	0x386b5689789e714deb224c90e90ebb36ae98f7551a79794a7e16987a7fefa243
0x0000000000000000000000000000000000000000	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x692524c10756b2cec347a35dde0c6b202252eca1	false	0x0000000000000000000000000000000000000000	0	34622459883719593	1	4504550	2025-01-19T08:49:21.000Z	0xb0be280701567011fbf9f3dac3a8ec051af3cc0dff0d104cca82c14fc8f480fd
0x1dabab81ae16b945a747e52c4e5bd41a7b1cb8b3	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	0x1dabab81ae16b945a747e52c4e5bd41a7b1cb8b3	false	0x50c42deacd8fc9773493ed674b675be577f2634b	12323925728794608653	12323925728794608653	39	12164789	2025-03-07T00:36:00.000Z	0x231d1daf1bda55ffd4184c62d99e510993fd002b5a3a809e2359ad881dd12733

Example Query

Query with partition filter

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

scETHAccountant_YieldClaimed_event

Yield distribution events from Rings Protocol’s scETH (staked/compounding ETH) accountant contract on Sonic, tracking when yield rewards are claimed from the underlying yield-bearing asset. Records claim amounts, recipient addresses, and yield asset tokens for analyzing staking rewards and protocol revenue 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_yieldAsset`	`STRING`	Contract address of the yield-bearing asset being claimed in this YieldClaimed event. Hex-encoded, 0x-prefixed 40-character string representing the token contract on Sonic chain.
`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_yieldAsset	block_timestamp	transaction_hash
0x61be1ec20dfe0197c27b80ba0f7fcdb1a6b236e2	false	4781707868418950978	19	12208044	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	2025-03-07T06:00:11.000Z	0x92ef159735d46d2f3dd45b5f6a0dc6a90036ad396dea76ba18dbee549788af95
0x61be1ec20dfe0197c27b80ba0f7fcdb1a6b236e2	false	1379750173168934628	5	19520501	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	2025-04-11T05:14:20.000Z	0xef294cce902d23b54f9baee09fcb63c5d8463a2851eb55f75ba52fac2cdbb2e0
0x61be1ec20dfe0197c27b80ba0f7fcdb1a6b236e2	false	621301528580276769	17	16439816	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	2025-03-27T23:15:02.000Z	0xcc83246015b1815e571659388b6d8467308e8efd8ba19399c019244012353b5f

Example Query

Query with partition filter

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

scETHVoter_BudgetDeposited_event

Budget deposit events from Rings Protocol scETH (staked/collateralized ETH) voter contract on Sonic, tracking periodic deposits with depositor addresses and amounts in wei. Used for analyzing voting power allocation and governance participation patterns across weekly 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_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
`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	block_number	in_depositor	block_timestamp	transaction_hash
0x43739b96b19ae7c2e0d80be7832325846f55fa05	false	8712904158715525813	1742428800	27	13335928	0x6974778fcca17b42af410628debe04bcf41c2280	2025-03-12T22:44:54.000Z	0x23c90c78a1d7c0cd0bb51c514b3fabeb601bfc6ac0af5cb941059735cb5681ae
0x43739b96b19ae7c2e0d80be7832325846f55fa05	false	10956732375694555387	1744848000	23	19244700	0x6974778fcca17b42af410628debe04bcf41c2280	2025-04-09T22:18:20.000Z	0x961cfa50724352ac1e56fecfc82ef677be2976cceab5a3dca2fa28b9bccab7ee
0x43739b96b19ae7c2e0d80be7832325846f55fa05	false	10000000000000000	1741824000	20	11908440	0x6974778fcca17b42af410628debe04bcf41c2280	2025-03-05T21:11:31.000Z	0x7c8c119a757f0c49edcb3c78e5454db701cdb69d2cd0b2ae609540a02ec355de

Example Query

Query with partition filter

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

scETHVoter_RewardClaimed_event

Reward claim events from Rings Protocol scETH (staked/liquid ETH) voter contract on Sonic, recording amounts claimed from specific liquidity gauges. Used for tracking voter incentive distributions and gauge reward analytics across the protocol’s vote-escrowed token system.

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_gauge`	`STRING`	Contract address of the gauge contract. 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_gauge	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x43739b96b19ae7c2e0d80be7832325846f55fa05	false	0x4d62b6e166767988106cf7ee8fe23e480e76ff1d	1388082258822650512	24	14736672	2025-03-20T00:25:23.000Z	0xe787851f2817a5c4529475c8139c8b00af3a5460fc57fa0d38de869c2cc9b7ef
0x43739b96b19ae7c2e0d80be7832325846f55fa05	false	0xa48260f762fe533a6e32cb1cac8f411d19bfb987	1714805685829371924	21	14736672	2025-03-20T00:25:23.000Z	0xfd28550e521a4eadcb9cf5d1be5591c657f3e0a9d42ab9767997d3e915335394
0x43739b96b19ae7c2e0d80be7832325846f55fa05	false	0xf564ebac1182578398e94868bea1aba6ba339652	1341587343858680268	26	14736672	2025-03-20T00:25:23.000Z	0xe82952dce9b446be665d354e7259780e66d6a6c9e026f89e2b9b8c376f46d600

Example Query

Query with partition filter

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

scUSD_Enter_event

scUSD vault deposit events from Rings Protocol on Sonic chain, recording when users mint shares by entering the vault with assets. Tracks share issuance with recipient addresses, deposited asset amounts, and corresponding share quantities for analyzing vault deposit activity and share 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_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_shares	log_index	block_number	block_timestamp	transaction_hash
0x07b7fd1ce6f2e31cf0d3eea2d16887082059f5ff	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x0000000000000000000000000000000000000000	false	0x0000000000000000000000000000000000000000	500000000	1	13146435	2025-03-12T00:03:15.000Z	0x00050eced745264aec11a08059a93564d5a03d1500258468b0b2684455383c70
0xf6f40ced4cb39ed9eb2c2857b8cd0ccc2ddac241	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x0000000000000000000000000000000000000000	false	0x0000000000000000000000000000000000000000	25000000	1	13147263	2025-03-12T00:09:48.000Z	0x583c74e10e8a17940cc1a4c607508f478e9e3663be17a871116252fa79cb72ed
0xffaa2fb8e9a2c61c68b81b91f05852bf5a6264f1	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x0000000000000000000000000000000000000000	false	0x0000000000000000000000000000000000000000	1998778862	1	13154312	2025-03-12T01:04:19.000Z	0x3645aeb7429b9f8f463ff58f178ddd1c11e2b6946d4101efcaded1ad52e061f1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ringsprotocol_v1_sonic.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 Sonic, tracking share redemptions and underlying asset withdrawals with sender, recipient, and amounts. Used for analyzing vault liquidity flows and user exit 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	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0xaa672cf1298714ca00324f8ad9dbe366a7959b86	false	0x0000000000000000000000000000000000000000	1000000	4	10727754	2025-02-28T09:27:19.000Z	0xa6ad5025dc36c8f27055cd1938eff76019d1481aa3e02cdf7d1e1430543c59e2
0x0000000000000000000000000000000000000000	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0xc7b99a2d6f1ddff42a9d191d5913902045d70bdb	false	0x0000000000000000000000000000000000000000	7197845275	1	10755624	2025-02-28T12:29:06.000Z	0x902fabc71b4356f11ad980f5f3e370f3104fa661fcf27353a24d53c1b18c0bb3
0x0000000000000000000000000000000000000000	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	0x75c108df63381e5b2fae62d610d79a8915911aa8	false	0x0000000000000000000000000000000000000000	17230713440	1	10680826	2025-02-28T04:28:05.000Z	0x18a764f49a5bddc2b7ada3330586c7081c65c54ba47ce5eee9297c9719c3c358

Example Query

Query with partition filter

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

scUSDAccountant_YieldClaimed_event

Yield claim events from Rings Protocol’s scUSD stablecoin accountant contract on Sonic chain, recording when users harvest accumulated yields from their yield-bearing asset positions. Useful for tracking yield distribution patterns, claim frequency, and returns across the scUSD ecosystem.

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_yieldAsset`	`STRING`	Contract address of the yield-bearing asset being claimed from the Rings Protocol scUSD Accountant contract. Hex-encoded, 0x-prefixed 40-character string representing the token on Sonic chain.
`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_yieldAsset	block_timestamp	transaction_hash
0x13ccc810dfaa6b71957f2b87060afe17e6eb8034	false	17011507503	2	19520501	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	2025-04-11T05:14:20.000Z	0xef294cce902d23b54f9baee09fcb63c5d8463a2851eb55f75ba52fac2cdbb2e0
0x13ccc810dfaa6b71957f2b87060afe17e6eb8034	false	23736683600	16	12208044	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	2025-03-07T06:00:11.000Z	0x92ef159735d46d2f3dd45b5f6a0dc6a90036ad396dea76ba18dbee549788af95
0x13ccc810dfaa6b71957f2b87060afe17e6eb8034	false	11132809898	2	14766211	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	2025-03-20T04:14:04.000Z	0xa3040511830eeef5bcce9f83f3106caaf0306cf4ca14fe982ab973e3601d3035

Example Query

Query with partition filter

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

scUSDVoter_BudgetDeposited_event

Budget deposits into the Rings Protocol scUSD Voter contract on Sonic chain, tracking periodic funding allocations by depositor address. Used for analyzing voting incentive budgets and governance participation patterns across weekly 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_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
`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	block_number	in_depositor	block_timestamp	transaction_hash
0xb84194e28f624bbba3c9181f3a1120ee76469337	false	36563701998	1742428800	17	13335928	0x6974778fcca17b42af410628debe04bcf41c2280	2025-03-12T22:44:54.000Z	0x23c90c78a1d7c0cd0bb51c514b3fabeb601bfc6ac0af5cb941059735cb5681ae
0xb84194e28f624bbba3c9181f3a1120ee76469337	false	30278268518	1741824000	3	11910793	0x6974778fcca17b42af410628debe04bcf41c2280	2025-03-05T21:24:32.000Z	0xf745c8d8d261eadf36340295831f7452853b49bda949d3bc142d8bb9194fe9cd
0xb84194e28f624bbba3c9181f3a1120ee76469337	false	100000000	1741824000	10	11908440	0x6974778fcca17b42af410628debe04bcf41c2280	2025-03-05T21:11:31.000Z	0x7c8c119a757f0c49edcb3c78e5454db701cdb69d2cd0b2ae609540a02ec355de

Example Query

Query with partition filter

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

scUSDVoter_RewardClaimed_event

Reward claim events from Rings Protocol’s scUSD voter gauge system on Sonic, tracking token distributions to stakers across different liquidity gauges. Used to analyze reward distribution patterns and gauge participation in the protocol’s vote-escrowed tokenomics model.

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_gauge`	`STRING`	Contract address of the gauge contract. 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_gauge	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xb84194e28f624bbba3c9181f3a1120ee76469337	false	0xc5e0250037195850e4d987ca25d6aba68ef5fee8	11235294062	2	19260209	2025-04-10T00:01:20.000Z	0x174c68cba9baa3152cd95f29112fce5f3ed921ea86fb9d6f057f52d0af937a9e
0xb84194e28f624bbba3c9181f3a1120ee76469337	false	0x589269998df4d7d16351aa2ff996486aec1db6c2	8138494	73	19260211	2025-04-10T00:01:21.000Z	0x73e976418c667b9a5f6fe3f4ab12ea91d159a96e3c04b2c6a5102359996f78f7
0xb84194e28f624bbba3c9181f3a1120ee76469337	false	0xa48260f762fe533a6e32cb1cac8f411d19bfb987	13560598437	17	19260211	2025-04-10T00:01:21.000Z	0x14b5b4d6e4e3b7c3f3e44c041c168cbc516b67acbda1e883f9c5ca1d40db0a5a

Example Query

Query with partition filter

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

stkscBTC_Enter_event

Staking deposit events for stkscBTC (staked scBTC) on Rings Protocol v1 deployed on Sonic, recording users entering the vault with asset amounts and corresponding share issuance. Tracks deposit flows for analyzing TVL (Total Value Locked) growth and user staking 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
0xca736464ddfdb087f337e128a508269b4f41a5b1	0xd0851030c94433c261b405fecbf1dec5e15948d0	0xca736464ddfdb087f337e128a508269b4f41a5b1	false	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	321721	321721	12	10464674	2025-02-27T06:01:56.000Z	0xe1bf47107a9daa04f46dd5edd291cce67b14fb2ab6e188db88704d6aa1dfda32
0x26d067c1bd1762d9bb6efe783b1fcd925f0e746d	0xd0851030c94433c261b405fecbf1dec5e15948d0	0x26d067c1bd1762d9bb6efe783b1fcd925f0e746d	false	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	8374	8374	10	11699459	2025-03-04T21:35:35.000Z	0x63112f5bd9e6e6105d588cfb7a3e362bfca4f037831216ea396171fdd93c3f5d
0x26d067c1bd1762d9bb6efe783b1fcd925f0e746d	0xd0851030c94433c261b405fecbf1dec5e15948d0	0x26d067c1bd1762d9bb6efe783b1fcd925f0e746d	false	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	9058	9058	16	11694108	2025-03-04T21:03:27.000Z	0xcd4a85ed4e6ec0b01baa9b907e728f543a2dc911275495cae9322df4923997ec

Example Query

Query with partition filter

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

stkscBTC_Exit_event

Withdrawal events from Rings Protocol’s staked scBTC (synthetic Bitcoin) vault on Sonic chain. Tracks share redemptions with underlying asset amounts, useful for analyzing staking outflows and user exit patterns.

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_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x563e07c3b6f72206b59db2f8c7b483491ae1e61d	0xd0851030c94433c261b405fecbf1dec5e15948d0	0x563e07c3b6f72206b59db2f8c7b483491ae1e61d	false	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	1256256	1256256	6	15772165	2025-03-25T01:25:39.000Z	0xf1387b3f1c664fe20fbdccac9e9bc3f3f609ff2b789cbea2a483e44bfcb2d6c8
0x563e07c3b6f72206b59db2f8c7b483491ae1e61d	0xd0851030c94433c261b405fecbf1dec5e15948d0	0x563e07c3b6f72206b59db2f8c7b483491ae1e61d	false	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	113073	113073	4	13758144	2025-03-14T22:24:19.000Z	0xb94ee8d222475844f2603bf145c8b31a7d08558b686c2174d5769d8963228cfa
0x563e07c3b6f72206b59db2f8c7b483491ae1e61d	0xd0851030c94433c261b405fecbf1dec5e15948d0	0x563e07c3b6f72206b59db2f8c7b483491ae1e61d	false	0xbb30e76d9bb2cc9631f7fc5eb8e87b5aff32bfbd	3775293	3775293	6	13964228	2025-03-15T23:51:25.000Z	0xb51dfaa8a0e16fa31a39d6bc95695f983751304f27ce2d706b8d8705c98db2a4

Example Query

Query with partition filter

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

stkscETH_Enter_event

Staking deposit events for stkscETH (staked scETH) on Rings Protocol v1 on Sonic, recording when users enter the staking contract by depositing scETH and receiving equivalent share amounts. Useful for tracking staking activity, participant addresses, and deposited asset 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_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
0x00fe994594bacfb5c07f54b873a096b0e9d2cc94	0x455d5f11fea33a8fa9d3e285930b478b6bf85265	0x00fe994594bacfb5c07f54b873a096b0e9d2cc94	false	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	17500000000000000	17500000000000000	7	14282756	2025-03-17T17:29:45.000Z	0x49d7e0943cab9135fb08084911c683e0cdd62bcfed571fc5a4282702e9503fe7
0x0159fe68bf901b2c3867a0b9c25c0cda9cb50a58	0x455d5f11fea33a8fa9d3e285930b478b6bf85265	0x0159fe68bf901b2c3867a0b9c25c0cda9cb50a58	false	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	2130229912902159	2130229912902159	2	14233246	2025-03-17T11:47:15.000Z	0x4381c00a8c5b6d4dacd5c7f43c554926d7702a3b0d7915fc3a06b0e7ba4aabed
0x04e8780029e42c426e76dfe3d3089f632a8c2ce8	0x455d5f11fea33a8fa9d3e285930b478b6bf85265	0x04e8780029e42c426e76dfe3d3089f632a8c2ce8	false	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	2653950038591560	2653950038591560	2	14165022	2025-03-17T02:01:05.000Z	0xdf86697f3a826ad95b2c07b50dd0ef20c5f083f64da5ed2e55111dd14c53cd33

Example Query

Query with partition filter

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

stkscETH_Exit_event

Exit events from the Rings Protocol staked scETH (staked Sonic canary ETH) vault on Sonic. Records unstaking transactions with share redemptions and underlying asset amounts for analyzing liquidity withdrawals and user exit patterns.

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_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x7b332fc33b5376559f4eade4a732fe003dc3e3bd	0x455d5f11fea33a8fa9d3e285930b478b6bf85265	0x7b332fc33b5376559f4eade4a732fe003dc3e3bd	false	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	3933641722765531059	3933641722765531059	12	6209445	2025-02-02T04:49:28.000Z	0x01aea021b47824c23c3946dc5f3390c1df74cbe8ee1c6d9369c0250325116363
0x7b332fc33b5376559f4eade4a732fe003dc3e3bd	0x455d5f11fea33a8fa9d3e285930b478b6bf85265	0x7b332fc33b5376559f4eade4a732fe003dc3e3bd	false	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	16021572824510392289	16021572824510392289	84	19096017	2025-04-09T06:54:02.000Z	0xb021b86c16643241beebdd9c283a92c71c35bafe134de9a4fc0fe81fd74d4cb9
0x7b332fc33b5376559f4eade4a732fe003dc3e3bd	0x455d5f11fea33a8fa9d3e285930b478b6bf85265	0x7b332fc33b5376559f4eade4a732fe003dc3e3bd	false	0x3bce5cb273f0f148010bbea2470e7b5df84c7812	1840000000000000000	1840000000000000000	5	13539707	2025-03-13T21:31:27.000Z	0x90af55cfda294c14573580fcc89bd4e4b688d3c7209ff508b2a32fc3fa763ce3

Example Query

Query with partition filter

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

stkscUSD_Enter_event

Staking entry events for stkscUSD (staked scUSD) on Rings Protocol v1 on Sonic, recording deposits where users stake scUSD assets in exchange for shares. Tracks depositor addresses, staked amounts, and corresponding share allocations for analyzing staking participation and vault TVL (Total Value Locked).

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
0x3b3bf9696d30c811afb01dd1c0eb8b459f151b60	0x4d85ba8c3918359c78ed09581e5bc7578ba932ba	0x3b3bf9696d30c811afb01dd1c0eb8b459f151b60	false	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	7190428232	7190428232	2	10228533	2025-02-26T05:49:29.000Z	0x3a4c4259f81480b05fc1375f96ff666d31fc75d71f361e874be647bf23782b30
0x473910b38f67c634b5e2fb211ce9270e533f0aed	0x4d85ba8c3918359c78ed09581e5bc7578ba932ba	0x473910b38f67c634b5e2fb211ce9270e533f0aed	false	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	500000000	500000000	2	10289417	2025-02-26T12:09:31.000Z	0x3bc587ed5b49e55fb60a50e490f165e411549342e17845b94fbef2c64a842167
0x4ed0f6fe7156efedd299812b8d27f60a6c70ff6d	0x4d85ba8c3918359c78ed09581e5bc7578ba932ba	0x4ed0f6fe7156efedd299812b8d27f60a6c70ff6d	false	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	621627872	621627872	2	10284941	2025-02-26T11:41:38.000Z	0xc37b577a6d6e0f56818cb52bec29283f0a84738bf1853b13d9f1abe4b8b7189e

Example Query

Query with partition filter

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

stkscUSD_Exit_event

Exit events from Rings Protocol’s staked scUSD (stkscUSD) vault on Sonic chain, recording user withdrawals with share redemptions and underlying asset amounts. Used for tracking unstaking activity, liquidity outflows, and vault participation metrics.

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_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x8d2ebd1c343cdd21805c76673e0de275c564c6d8	0x4d85ba8c3918359c78ed09581e5bc7578ba932ba	0x8d2ebd1c343cdd21805c76673e0de275c564c6d8	false	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	508053881970	508053881970	50	10726441	2025-02-28T09:18:46.000Z	0x5623efa74a9dbe5a975a2ad6285cab2effb0837277222724ae19091114d05990
0x8d2ebd1c343cdd21805c76673e0de275c564c6d8	0x4d85ba8c3918359c78ed09581e5bc7578ba932ba	0x8d2ebd1c343cdd21805c76673e0de275c564c6d8	false	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	264282277974	264282277974	45	11930032	2025-03-05T23:29:17.000Z	0x6f730dcdf9a767cee82b3bc8c20d74b0141920c409897d55aad24d71a46d328b
0x8d2ebd1c343cdd21805c76673e0de275c564c6d8	0x4d85ba8c3918359c78ed09581e5bc7578ba932ba	0x8d2ebd1c343cdd21805c76673e0de275c564c6d8	false	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	165858666674	165858666674	39	13964216	2025-03-15T23:51:19.000Z	0xba91b6f23d3c65affe9ebef37ef3da4c778c47acd38433bd829c8ac64a7c4573

Example Query

Query with partition filter

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

veBTC_Deposit_event

Vote-escrowed BTC (veBTC) deposit events from Rings Protocol on Sonic, capturing lock-ups with deposit amounts, lock durations, and NFT position identifiers. Used for analyzing voting power accumulation and token locking behavior in the protocol’s governance system.

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_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_locktime`	`STRING`	Unix timestamp representing the lock expiration date for the vote-escrowed BTC position. Stored as string-encoded seconds since epoch, typically set to future weekly epochs for governance voting weight calculations.
`in_deposit_type`	`INT64`	Numeric code indicating the type of deposit operation performed on the vote-escrowed BTC position. Values are typically 0 for create/initial deposit and 1 for increase amount or extend lock time.
`in_ts`	`STRING`	Unix timestamp representing the time of the deposit or withdrawal operation. Numeric string in seconds since epoch.

Sample Data

in_ts	address	removed	in_value	log_index	in_tokenId	in_locktime	in_provider	block_number	block_timestamp	in_deposit_type	transaction_hash
1741970416	0x7585d9c32db1528ceae4770fd1d01b888f5afa9e	false	48947480000000000	30	51	1743033600	0x1196cd2e4ed4b7847de3c3b57b7cc4bb62528371	13706203	2025-03-14T16:40:16.000Z	1	0xb49985e01a3b4a9bdd5403b9a1a67c3c51aa600a35d6514fedb291e165d90beb
1744572945	0x7585d9c32db1528ceae4770fd1d01b888f5afa9e	false	4945740000000000	9	110	1745452800	0xb9d31586015b9866c34abb6f1a2ee5929b7a4fc2	20029085	2025-04-13T19:35:45.000Z	1	0xb3bb6afb185fe900a35282fc7b5f222fe113d214fb528cde2c431af830eeb89f
1744553770	0x7585d9c32db1528ceae4770fd1d01b888f5afa9e	false	88420440000000000	2	109	1744848000	0x1196cd2e4ed4b7847de3c3b57b7cc4bb62528371	19987488	2025-04-13T14:16:10.000Z	1	0x0673be0ca5a044c339f2564b0ba69a398f2cac56345943d1d20914b86955e83f

Example Query

Query with partition filter

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

veBTC_Supply_event

Vote-escrowed BTC (veBTC) supply change events from Rings Protocol on Sonic, tracking the circulating supply of locked BTC tokens with previous and current supply snapshots. Used for analyzing veBTC token supply dynamics and lock/unlock activity 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_prevSupply`	`STRING`	Total supply of veBTC (vote-escrowed BTC) before this supply change event, denominated in wei (18 decimals). Tracks the prior state to enable calculating net changes in locked token supply.
`in_supply`	`STRING`	Total supply of shares or tokens after the transaction. Integer value stored as string, denominated in the token’s smallest unit.

Sample Data

address	removed	in_supply	log_index	block_number	in_prevSupply	block_timestamp	transaction_hash
0x7585d9c32db1528ceae4770fd1d01b888f5afa9e	false	740205960000000000	11	12416039	693826450000000000	2025-03-08T07:26:17.000Z	0x328255abd71c216a1af51210a4a42b542eb7cf491df41064e067e1d297b981e0
0x7585d9c32db1528ceae4770fd1d01b888f5afa9e	false	739074640000000000	5	12452429	740205960000000000	2025-03-08T11:51:05.000Z	0x9a130c0020cccfdf7de38632107e1558eeda3c70e03180f7ec224e6dd534046b
0x7585d9c32db1528ceae4770fd1d01b888f5afa9e	false	739050860000000000	5	12506495	739093030000000000	2025-03-08T18:19:30.000Z	0xe4700107e71775d89f8fedf34d1862e2c72b227e5cddedc5ba39e5399fae1eb8

Example Query

Query with partition filter

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

veBTC_Withdraw_event

Withdrawal events from vote-escrowed BTC (veBTC) positions on Rings Protocol deployed on Sonic chain, recording when users unlock their staked BTC from NFT-based tokenized positions. Used for analyzing lock-up behavior, liquidity flows, and governance participation patterns.

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_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_ts`	`STRING`	Unix timestamp representing the time of the deposit or withdrawal operation. Numeric string in seconds since epoch.

Sample Data

in_ts	address	removed	in_value	log_index	in_tokenId	in_provider	block_number	block_timestamp	transaction_hash
1743927758	0x7585d9c32db1528ceae4770fd1d01b888f5afa9e	false	10482170000000000	4	71	0x0aa9b164bea1c9a223834cfc899b7130fcb92f6b	18459683	2025-04-06T08:22:38.000Z	0xbede5d652aa11ab8ed9d76c0ee307b11f278ee190178bccb6a2075cf2435abfd
1743147377	0x7585d9c32db1528ceae4770fd1d01b888f5afa9e	false	6594850000000000	79	46	0x472a13f98015ee09b4a8bc4a9697d153c3d025a8	16514117	2025-03-28T07:36:17.000Z	0x851ef62133093536ede7d2e579719104276e09ca62601988abe0b7f006ef4366
1743136569	0x7585d9c32db1528ceae4770fd1d01b888f5afa9e	false	4000000000000000	14	70	0x0d747b9e050164f1ae82774615f5e9b9de570c38	16485950	2025-03-28T04:36:09.000Z	0x170fdaf4b2b33b8a0539045db87f2c29fb5f2d9b7cae41ce6ceab888e483f97e

Example Query

Query with partition filter

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

veETH_Deposit_event

Vote-escrowed ETH (veETH) deposit events from Rings Protocol on Sonic, tracking ETH locks with token IDs, amounts, lock durations, and deposit types for analyzing veTokenomics participation and governance power accumulation.

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_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_locktime`	`STRING`	Timestamp when the veETH (vote-escrowed ETH) lock expires, stored as a Unix epoch string. Sample values indicate lock periods ranging from weeks to years in the future.
`in_deposit_type`	`INT64`	Type of deposit action being performed on the vote-escrowed token (veETH), where 1 indicates a create/deposit operation, 2 indicates adding to an existing lock, and 3 indicates a lock time extension. This categorizes how users are interacting with their locked positions in the Rings Protocol.
`in_ts`	`STRING`	Unix timestamp representing the time of the deposit or withdrawal operation. Numeric string in seconds since epoch.

Sample Data

in_ts	address	removed	in_value	log_index	in_tokenId	in_locktime	in_provider	block_number	block_timestamp	in_deposit_type	transaction_hash
1743255813	0x1ec2b9a77a7226acd457954820197f89b3e3a578	false	1900000000000000000	2	1102	1774483200	0x8711ae1f332541209bc6109c2e7b9ae4a6c37e28	16795173	2025-03-29T13:43:33.000Z	1	0x75c4c1abbdd7d0225989aba53fa23bbd7da55b416a5f99e982bb441201dc1991
1743236072	0x1ec2b9a77a7226acd457954820197f89b3e3a578	false	1400000000000000000	2	1100	1743638400	0x0d747b9e050164f1ae82774615f5e9b9de570c38	16744614	2025-03-29T08:14:32.000Z	1	0x71c1e78777a2defdc605540aa4c8ca99e366ec71a32be8a97d28b5b51b409a18
1743266150	0x1ec2b9a77a7226acd457954820197f89b3e3a578	false	70074164664405850	2	1104	1745452800	0x0ca17672d2b37412dc6abae8059ca912dd7c998a	16822777	2025-03-29T16:35:50.000Z	1	0xf23206ec01d1191440ad8e75199eb8957221cc83c95b304134b301069cb12933

Example Query

Query with partition filter

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

veETH_Supply_event

Vote-escrowed ETH (veETH) supply change events from Rings Protocol on Sonic, tracking total circulating supply with previous and current values. Used for analyzing veETH token economics and supply dynamics 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_prevSupply`	`STRING`	Total supply of vote-escrowed ETH (veETH) tokens before the supply change event, denominated in wei (10^18 units per ETH). This value represents the baseline supply level prior to the current transaction’s impact.
`in_supply`	`STRING`	Total supply of shares or tokens after the transaction. Integer value stored as string, denominated in the token’s smallest unit.

Sample Data

address	removed	in_supply	log_index	block_number	in_prevSupply	block_timestamp	transaction_hash
0x1ec2b9a77a7226acd457954820197f89b3e3a578	false	143141975515413261440	1	7605500	143141975515413261440	2025-02-12T22:51:15.000Z	0xa218083cbad6fa34897d445d158d38d1aad9e6cb031d8e307011e96f7a562b17
0x1ec2b9a77a7226acd457954820197f89b3e3a578	false	137291975515413261440	1	7604048	137291975515413261440	2025-02-12T22:39:35.000Z	0xef2013cded0148d19ca164ea31f27648ee2fe7ea730cfaf4185c6665e2f513c3
0x1ec2b9a77a7226acd457954820197f89b3e3a578	false	144041975515413261440	2	7606334	143141975515413261440	2025-02-12T22:58:26.000Z	0xfb7944605514d185177666e59205fdeaf72340a6342428f88b6877c17c66e0e6

Example Query

Query with partition filter

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

veETH_Withdraw_event

Vote-escrowed ETH (veETH) withdrawal events from Rings Protocol on Sonic, capturing token ID redemptions with withdrawal amounts and provider addresses. Used for tracking liquidity unlock events and analyzing veETH position exits.

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_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_ts`	`STRING`	Unix timestamp representing the time of the deposit or withdrawal operation. Numeric string in seconds since epoch.

Sample Data

in_ts	address	removed	in_value	log_index	in_tokenId	in_provider	block_number	block_timestamp	transaction_hash
1743844456	0x1ec2b9a77a7226acd457954820197f89b3e3a578	false	461251447334881153	4	1111	0xa30d5c669e4c6d62d4e801b5562fedb599b8033d	18287558	2025-04-05T09:14:16.000Z	0x6af1999154f43b4a8b5c99aaefdf39e4a95b9db271cc58cd33805a771dcd8fd2
1743866258	0x1ec2b9a77a7226acd457954820197f89b3e3a578	false	705108930000000000	4	854	0x3d565392b08ee10b9aece002b14f2306435fb58b	18335640	2025-04-05T15:17:38.000Z	0x0755f858f738a5464c3426cbc833c32b705960f8bdef7b9263ccd43f3c5f12f6
1743854289	0x1ec2b9a77a7226acd457954820197f89b3e3a578	false	16327001913697370	4	73	0x2decdd1345aec81519c5177167de4bebec72da3f	18309033	2025-04-05T11:58:09.000Z	0x397544917fdc74397a949dfffe31aa75fbfa562d285d6f30c4b5c8c79e856ad9

Example Query

Query with partition filter

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

veUSD_Deposit_event

Vote-escrowed USD (veUSD) deposit events from Rings Protocol on Sonic chain, tracking user lock deposits with token amounts, lock durations, and NFT position IDs. Used for analyzing veUSD staking behavior and governance participation patterns.

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_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_locktime`	`STRING`	Unix timestamp representing the expiration date of the vote-escrowed position lock. Determines when the locked veUSD tokens become withdrawable by the provider.
`in_deposit_type`	`INT64`	Type of deposit operation performed, where 1 typically indicates a create or increase lock action. Values indicate different veUSD deposit mechanisms such as initial deposits, extensions, or merges.
`in_ts`	`STRING`	Unix timestamp representing the time of the deposit or withdrawal operation. Numeric string in seconds since epoch.

Sample Data

in_ts	address	removed	in_value	log_index	in_tokenId	in_locktime	in_provider	block_number	block_timestamp	in_deposit_type	transaction_hash
1741334300	0x0966cae7338518961c2d35493d3eb481a75bb86b	false	110000000	2	3838	1741824000	0x90625535340087a90ee8a25fcefdb82a83afe6d9	12223821	2025-03-07T07:58:20.000Z	1	0x8b120585d7b8699415c8083f41a80ce1a074c6b1a9e5366f503fba4a114449df
1741331701	0x0966cae7338518961c2d35493d3eb481a75bb86b	false	1016174251	20	3835	1741824000	0x5e64a5a9a06bbdb9186a410c765b88ea8fe8e5df	12218117	2025-03-07T07:15:01.000Z	1	0x1798a8e748d405c12736071cd37ef6ae4b22fb871712e5152cb8e834fe63bf46
1741333286	0x0966cae7338518961c2d35493d3eb481a75bb86b	false	34180083	2	3836	1741824000	0x1597306c0b5b4209bd8570cf509b78c7beabcc5f	12221562	2025-03-07T07:41:26.000Z	1	0x18ee5044ce4c011d1f43722488baf46b24b891853e4304d60dccd3712a50f950

Example Query

Query with partition filter

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

veUSD_Supply_event

Vote-escrowed USD (veUSD) supply change events from Rings Protocol on Sonic, tracking total supply adjustments with previous and current supply values. Used for monitoring veUSD token supply dynamics and staking activity in the protocol’s governance system.

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_prevSupply`	`STRING`	Total circulating supply of vote-escrowed USD tokens before the current supply change event. Denominated in the smallest unit of veUSD, tracking supply transitions within the Rings Protocol governance system.
`in_supply`	`STRING`	Total supply of shares or tokens after the transaction. Integer value stored as string, denominated in the token’s smallest unit.

Sample Data

address	removed	in_supply	log_index	block_number	in_prevSupply	block_timestamp	transaction_hash
0x0966cae7338518961c2d35493d3eb481a75bb86b	false	628355115850	2	5225640	628355115447	2025-01-24T06:22:33.000Z	0x6c43a5d8e4fda5bff5ac0f646675a5386768a76b9a98eadeb73299a92ccbb2bd
0x0966cae7338518961c2d35493d3eb481a75bb86b	false	628171441970	3	5211061	627170441970	2025-01-24T03:19:03.000Z	0x747c65acb97059f8f34534cfc1730024f1f73377d601eca83a25c864e341eeb4
0x0966cae7338518961c2d35493d3eb481a75bb86b	false	636337308968	3	5260666	636336596862	2025-01-24T13:32:28.000Z	0xc1db94da4182c98c7b68d74c0e5ac17ada25337990232f4a76c2be451df0d4ad

Example Query

Query with partition filter

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

veUSD_Withdraw_event

Withdrawal events from Rings Protocol’s vote-escrowed USD (veUSD) NFT positions on Sonic, recording when users unlock staked tokens from their tokenized voting escrow positions. Tracks withdrawal amounts, token IDs, and provider addresses for analyzing veUSD position lifecycle 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_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_ts`	`STRING`	Unix timestamp representing the time of the deposit or withdrawal operation. Numeric string in seconds since epoch.

Sample Data

in_ts	address	removed	in_value	log_index	in_tokenId	in_provider	block_number	block_timestamp	transaction_hash
1740240132	0x0966cae7338518961c2d35493d3eb481a75bb86b	false	100000000	4	1943	0x3ff08b4723f4af4aadd7d5ed143c9a584b4af3a6	9390616	2025-02-22T16:02:12.000Z	0xa78054de879a9fe6c95321cfd1d2fb7e934b127643fa309fdb89ec321d2a3d43
1740214755	0x0966cae7338518961c2d35493d3eb481a75bb86b	false	40822474	4	2111	0xe136fa25a6464f1de8f692e8a8671bd115e7ee94	9322229	2025-02-22T08:59:15.000Z	0xaf662dbb2366818f23448875bd206020ad9e3eb3c8aa4cbe3208b0964bc55b55
1740266890	0x0966cae7338518961c2d35493d3eb481a75bb86b	false	80000000	4	2508	0x316771f0b8bff7a23477d15c57da489b0eb0b406	9460241	2025-02-22T23:28:10.000Z	0xb6f5691e47ac3b4cd39c06079b7da763fc86627b7d796f8e02d3f3481c89c0e7

Example Query

Query with partition filter

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

wstkscBTC_Deposit_event

Deposit events for the wstkscBTC (wrapped staked Bitcoin) vault on Rings Protocol on Sonic chain, recording user deposits with asset amounts and corresponding share tokens minted. Useful for tracking vault participation, deposit flows, and share-to-asset conversion ratios.

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_by`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`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_by	address	removed	in_owner	in_assets	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x2c06c9d02a3455f1b22b9365eb76bf558db1b947	0xdb58c4db1a0f45dda3d2f8e44c3300bb6510c866	false	0x2c06c9d02a3455f1b22b9365eb76bf558db1b947	1500000	1500000	13	17039757	2025-03-30T15:47:27.000Z	0xb9da9fe66e3d2e55a387286d1a0b82e6bf4eb6d46bd8b478066e598dd42419cd
0x2c06c9d02a3455f1b22b9365eb76bf558db1b947	0xdb58c4db1a0f45dda3d2f8e44c3300bb6510c866	false	0x2c06c9d02a3455f1b22b9365eb76bf558db1b947	600000	600000	15	16970340	2025-03-30T08:34:12.000Z	0x27b645f6be53a151eb891d6872ea719c9a791a0c0faf8134346c8529673ac463
0x2c06c9d02a3455f1b22b9365eb76bf558db1b947	0xdb58c4db1a0f45dda3d2f8e44c3300bb6510c866	false	0x2c06c9d02a3455f1b22b9365eb76bf558db1b947	118	118	23	14587421	2025-03-19T07:40:41.000Z	0x2cd8f79e76f9ea312b4552b7dd688d180fbc957dd042c15dc8b9f7bb70539431

Example Query

Query with partition filter

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

wstkscBTC_PerformanceFeeUpdated_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_newPerformanceFee`	`STRING`	New performance fee rate for the vault. Decimal representation stored as string, where the value divided by 1e10 yields the percentage (e.g., ‘100000000000000000’ equals 10%).

Sample Data

No sample data available.

Example Query

Query with partition filter

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

wstkscBTC_Withdraw_event

Withdrawal events from the wstkscBTC (wrapped staked Bitcoin) vault contract on Rings Protocol v1 deployed on Sonic chain. Tracks vault share redemptions with asset amounts, recipient addresses, and initiator data for analyzing liquidity flows and user withdrawal patterns.

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_by`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`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_by	in_to	address	removed	in_owner	in_assets	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xacea9a95b8a4c4dac2750a597bc6892083dab150	0xacea9a95b8a4c4dac2750a597bc6892083dab150	0xdb58c4db1a0f45dda3d2f8e44c3300bb6510c866	false	0xacea9a95b8a4c4dac2750a597bc6892083dab150	4483	4483	2	10221828	2025-02-26T05:05:02.000Z	0x5c625395637b29b8a881a0f11b75e6b91abafd2cc19c3103b769f37c6c1e1f35
0x74532f863a318a4c5019c0034a63446fcc8a4348	0x74532f863a318a4c5019c0034a63446fcc8a4348	0xdb58c4db1a0f45dda3d2f8e44c3300bb6510c866	false	0x74532f863a318a4c5019c0034a63446fcc8a4348	567849	567849	2	15928808	2025-03-25T18:58:06.000Z	0xa3a0c3c9efab62f8fb8c93e3bc083e1882440f8c8e6847323801ff587caffd64
0x747276019e3340104c96397bf6537ad01f93d7df	0x747276019e3340104c96397bf6537ad01f93d7df	0xdb58c4db1a0f45dda3d2f8e44c3300bb6510c866	false	0x747276019e3340104c96397bf6537ad01f93d7df	4170	4170	59	20040900	2025-04-13T20:43:29.000Z	0x3d39cb981cfeb10f6c46f8264463a5a0ee7e025fb74c143eb849058161bdf39d

Example Query

Query with partition filter

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

wstkscETH_Deposit_event

Deposit events from the Rings Protocol wstkscETH (wrapped staked Sonic Chain ETH) vault contract on Sonic, recording user deposits with asset amounts and corresponding vault shares issued. Used for tracking vault inflows, share issuance patterns, and depositor 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.
`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_by`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`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_by	address	removed	in_owner	in_assets	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xafe350c76d31b73b5901eaccb86f2834c5ec0a3b	0xe8a41c62bb4d5863c6eadc96792cfe90a1f37c47	false	0xafe350c76d31b73b5901eaccb86f2834c5ec0a3b	649434780000000000	649434780000000000	2	7197651	2025-02-09T23:51:11.000Z	0xe4187fc636d389fcd08ce2efad8ef047e07ec0114572a98fed5214a5e7092ed3
0x56f2c4cb8518d0a4ec749593df574f7597a36140	0xe8a41c62bb4d5863c6eadc96792cfe90a1f37c47	false	0x56f2c4cb8518d0a4ec749593df574f7597a36140	147525887870635684	147525887870635684	2	7091027	2025-02-09T02:09:40.000Z	0xc8fed123ac3574e30dbfd624673ff75e3fda75fad8b0cf47e0061f81b9e600b8
0x54aaa6bc9b6f3d3b364c55e0c967e0c8bbc044c3	0xe8a41c62bb4d5863c6eadc96792cfe90a1f37c47	false	0x54aaa6bc9b6f3d3b364c55e0c967e0c8bbc044c3	6088102660000000000	6088102660000000000	2	7088645	2025-02-09T01:35:53.000Z	0xd5b07f1352f9d2b9cc21ab4c5a7c04cbc01daea862ca217048e1c928993aaeb2

Example Query

Query with partition filter

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

wstkscETH_PerformanceFeeUpdated_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_newPerformanceFee`	`STRING`	New performance fee rate for the vault. Decimal representation stored as string, where the value divided by 1e10 yields the percentage (e.g., ‘100000000000000000’ equals 10%).

Sample Data

No sample data available.

Example Query

Query with partition filter

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

wstkscETH_Withdraw_event

Withdrawal events from the wstkscETH (wrapped staked scETH) vault contract on Rings Protocol deployed on Sonic chain, capturing redemptions where users burn vault shares to receive underlying assets. Useful for tracking vault outflows, analyzing withdrawal patterns, and monitoring liquidity dynamics in the staked ETH wrapper.

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_by`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`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_by	in_to	address	removed	in_owner	in_assets	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x394bbb5f3020bab3f786c51821508f683a20f72a	0x394bbb5f3020bab3f786c51821508f683a20f72a	0xe8a41c62bb4d5863c6eadc96792cfe90a1f37c47	false	0x394bbb5f3020bab3f786c51821508f683a20f72a	247288632689061822	247288632689061822	2	8375211	2025-02-18T01:46:27.000Z	0x4872892f51b9a3ffc6b1f0d8e7738f439ede45c6520575ebb6777aa2928f48c2
0x11bf6cadea898415c515608b58d337941faab6ac	0x11bf6cadea898415c515608b58d337941faab6ac	0xe8a41c62bb4d5863c6eadc96792cfe90a1f37c47	false	0x11bf6cadea898415c515608b58d337941faab6ac	1100000000000000000	1100000000000000000	2	8382929	2025-02-18T02:52:45.000Z	0xd7ad7ec6ce889fb3bd150b9aa3026b71d64e8b90cc1faf1aec9901493c21db95
0xc45d05cdc809d20c7b14959e8cd4a1199e3e966f	0xc45d05cdc809d20c7b14959e8cd4a1199e3e966f	0xe8a41c62bb4d5863c6eadc96792cfe90a1f37c47	false	0xc45d05cdc809d20c7b14959e8cd4a1199e3e966f	4737001407074260010	4737001407074260010	2	8416822	2025-02-18T07:38:41.000Z	0x4d7b32af8db51c07f837a554698c95dbe0b84c547a20fb8bf6cd2bed60fbeedd

Example Query

Query with partition filter

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

wstkscUSD_Deposit_event

Deposit events for the wstkscUSD (wrapped staked scUSD) vault on Rings Protocol on Sonic chain, recording asset deposits converted to vault shares. Captures depositor addresses, asset amounts, and corresponding share allocations for tracking vault participation and liquidity provision.

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_by`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`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_by	address	removed	in_owner	in_assets	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x06b179f681a4a45bdd108f12e2f9ca2d09442d8d	0x9fb76f7ce5fceaa2c42887ff441d46095e494206	false	0x06b179f681a4a45bdd108f12e2f9ca2d09442d8d	1004740069	1004740069	2	7965110	2025-02-15T08:00:37.000Z	0xcac929748275dd022f629e8dde4de12a2921b177dada36fa0022622064c47264
0x175ab3277a7803d85e88817ff770185e0002297c	0x9fb76f7ce5fceaa2c42887ff441d46095e494206	false	0x175ab3277a7803d85e88817ff770185e0002297c	1000000000	1000000000	2	7933452	2025-02-15T02:00:37.000Z	0x2e44353e2563aa873795b3505a8b35142f3edfa682f3ba0be495328be9fb00f8
0x2875968c02147188c68c719362d9e781a34444d7	0x9fb76f7ce5fceaa2c42887ff441d46095e494206	false	0x2875968c02147188c68c719362d9e781a34444d7	43442138	43442138	2	7999815	2025-02-15T13:55:15.000Z	0x31de17f11b162024342fc7cef81bc2993f7590951df4c64a9aef86f6fa81bb44

Example Query

Query with partition filter

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

wstkscUSD_PerformanceFeeUpdated_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_newPerformanceFee`	`STRING`	New performance fee rate for the vault. Decimal representation stored as string, where the value divided by 1e10 yields the percentage (e.g., ‘100000000000000000’ equals 10%).

Sample Data

No sample data available.

Example Query

Query with partition filter

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

wstkscUSD_Withdraw_event

Withdrawal events from the wstkscUSD (wrapped staked scUSD) vault on Rings Protocol on Sonic chain, tracking redemptions of vault shares for underlying assets. Contains share-to-asset conversions, owner and recipient addresses 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_by`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`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_by	in_to	address	removed	in_owner	in_assets	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x41722457cbfa517bd1070d7e64e00bc71539e4ce	0x41722457cbfa517bd1070d7e64e00bc71539e4ce	0x9fb76f7ce5fceaa2c42887ff441d46095e494206	false	0x41722457cbfa517bd1070d7e64e00bc71539e4ce	100000000000	100000000000	3	12245495	2025-03-07T10:32:51.000Z	0x5f2aacbe2da1de53b8ca5738c1a4e9d960bb68e5b80e94d1a45cb1143caefbf0
0x69b235c1c3f16f828b2394193a7abea79ee40c07	0x69b235c1c3f16f828b2394193a7abea79ee40c07	0x9fb76f7ce5fceaa2c42887ff441d46095e494206	false	0x69b235c1c3f16f828b2394193a7abea79ee40c07	2500000000	2500000000	9	12192212	2025-03-07T03:47:42.000Z	0xf91ecb72f025ffacf26e2e30c1b6fe714cee13feebcab0e591415d8506a68d16
0x896f4d49916ac5cfc36d7a260a7039ba4ea317b6	0x313e7ef7d52f5c10ac04ebaa4d33cdc68634c212	0x9fb76f7ce5fceaa2c42887ff441d46095e494206	false	0x896f4d49916ac5cfc36d7a260a7039ba4ea317b6	3143835239	3143763431	48	12275167	2025-03-07T14:07:20.000Z	0x5063f1f3c7b197991daa52fa7a7772dab2968c6b867448683ec8d09f00381a01

Example Query

Query with partition filter

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

​Tables

​QuestRingsveBTC_createFixedQuest_function

​QuestRingsveBTC_createRangedQuest_function

​QuestRingsveETH_createFixedQuest_function

​QuestRingsveETH_createRangedQuest_function

​QuestRingsveUSD_createFixedQuest_function

​QuestRingsveUSD_createRangedQuest_function

​scBTC_Enter_event

​scBTC_Exit_event

​scBTCVoter_BudgetDeposited_event

​scBTCVoter_RewardClaimed_event

​scETH_Enter_event

​scETH_Exit_event

​scETHAccountant_YieldClaimed_event

​scETHVoter_BudgetDeposited_event

​scETHVoter_RewardClaimed_event

​scUSD_Enter_event

​scUSD_Exit_event

​scUSDAccountant_YieldClaimed_event

​scUSDVoter_BudgetDeposited_event

​scUSDVoter_RewardClaimed_event

​stkscBTC_Enter_event

​stkscBTC_Exit_event

​stkscETH_Enter_event

​stkscETH_Exit_event

​stkscUSD_Enter_event

​stkscUSD_Exit_event

​veBTC_Deposit_event

​veBTC_Supply_event

​veBTC_Withdraw_event

​veETH_Deposit_event

​veETH_Supply_event

​veETH_Withdraw_event

​veUSD_Deposit_event

​veUSD_Supply_event

​veUSD_Withdraw_event

​wstkscBTC_Deposit_event

​wstkscBTC_PerformanceFeeUpdated_event

​wstkscBTC_Withdraw_event

​wstkscETH_Deposit_event

​wstkscETH_PerformanceFeeUpdated_event

​wstkscETH_Withdraw_event

​wstkscUSD_Deposit_event

​wstkscUSD_PerformanceFeeUpdated_event

​wstkscUSD_Withdraw_event

Tables

QuestRingsveBTC_createFixedQuest_function

QuestRingsveBTC_createRangedQuest_function

QuestRingsveETH_createFixedQuest_function

QuestRingsveETH_createRangedQuest_function

QuestRingsveUSD_createFixedQuest_function

QuestRingsveUSD_createRangedQuest_function

scBTC_Enter_event

scBTC_Exit_event

scBTCVoter_BudgetDeposited_event

scBTCVoter_RewardClaimed_event

scETH_Enter_event

scETH_Exit_event

scETHAccountant_YieldClaimed_event

scETHVoter_BudgetDeposited_event

scETHVoter_RewardClaimed_event

scUSD_Enter_event

scUSD_Exit_event

scUSDAccountant_YieldClaimed_event

scUSDVoter_BudgetDeposited_event

scUSDVoter_RewardClaimed_event

stkscBTC_Enter_event

stkscBTC_Exit_event

stkscETH_Enter_event

stkscETH_Exit_event

stkscUSD_Enter_event

stkscUSD_Exit_event

veBTC_Deposit_event

veBTC_Supply_event

veBTC_Withdraw_event

veETH_Deposit_event

veETH_Supply_event

veETH_Withdraw_event

veUSD_Deposit_event

veUSD_Supply_event

veUSD_Withdraw_event

wstkscBTC_Deposit_event

wstkscBTC_PerformanceFeeUpdated_event

wstkscBTC_Withdraw_event

wstkscETH_Deposit_event

wstkscETH_PerformanceFeeUpdated_event

wstkscETH_Withdraw_event

wstkscUSD_Deposit_event

wstkscUSD_PerformanceFeeUpdated_event

wstkscUSD_Withdraw_event