rezerve_v1_sonic

Tables

AppBondDepository_BondCreated_event

Bond creation events from the Rezerve protocol on Sonic chain, recording bond issuance with price and amount data. Used for tracking bond market activity and pricing dynamics across different bond offerings.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.

Sample Data

in_id	address	removed	in_price	in_amount	log_index	block_number	block_timestamp	transaction_hash
1	0xca36616ffc16eae1f33783a8cd082f46d9f2d993	false	2177000000	2177000000	0	44921256	2025-08-28T20:52:08.000Z	0x2d50d2dadf11b53475c52cf013a8bdda8f53b24d1c0a3401593b94a9e9e754be
1	0xca36616ffc16eae1f33783a8cd082f46d9f2d993	false	2166000000	2166000000	7	44869133	2025-08-28T12:52:09.000Z	0x6c39c0fdde5970897eec373fdc73b998f838402760c5d16f0eb187935f8ad291
1	0xca36616ffc16eae1f33783a8cd082f46d9f2d993	false	2564000000	2564000000	3	44826426	2025-08-28T04:52:08.000Z	0x026a2fe8e314a36b323428939c78df2872c9298476aff59d4bf7442472a066a3

Example Query

Query with partition filter

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

AppBondDepository_CompleteBondVesting_event

Bond vesting completion events from Rezerve protocol on Sonic, recording when users claim fully vested bond positions identified by bond ID. Useful for tracking bond redemption patterns and analyzing vesting schedule adherence.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.

Sample Data

in_id	address	removed	block_number	block_timestamp	transaction_hash
85	0x7ad11d53c773026171ef237d166174ea92d713a0	false	41185985	2025-08-01T10:26:40.000Z	0x658be5b0052e27efa1f629bc7a16c4e88a94bdd78e30873e668d5efcee78656a
93	0x7ad11d53c773026171ef237d166174ea92d713a0	false	41186167	2025-08-01T10:28:26.000Z	0xc961609dc7c2a9381a1fad41e56e19c2bf908358ca9389c23c79e4b8da3ea98e
54	0x7ad11d53c773026171ef237d166174ea92d713a0	false	41186068	2025-08-01T10:27:26.000Z	0x9a20a479aa17cc960e7d6cf8ad1343e64999ae7f1649be75b90a8f915a7461e4

Example Query

Query with partition filter

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

AppBondDepository_CreateBond_event

Bond creation events from the Rezerve protocol on Sonic blockchain. Records new bond offerings with initial pricing, capacity limits, and quote token addresses for tracking fixed-income DeFi (Decentralized Finance) product launches.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_initialPrice`	`STRING`	Initial price of the bond at creation, denominated in the quote token’s smallest unit. This raw integer value requires decimal adjustment based on the quote token’s decimals to derive the actual price ratio.
`in_capacity`	`STRING`	Maximum bond capacity for this offering denominated in quote tokens. Represents the total amount of tokens available for bonding, stored as a raw integer value before decimal adjustment.

Sample Data

in_id	address	removed	log_index	in_capacity	block_number	in_quoteToken	block_timestamp	in_initialPrice	transaction_hash
0	0x44b497aa4b742dc48ce0bd26f66da9aeca19bd75	false	0	60513310205146172926466	34080974	0x29219dd400f2bf60e5a23d13be72b486d4038894	2025-06-15T00:02:32.000Z	2360756	0x16660d1c297ffad7323de413c69d0842483e47f34ff2f00d2cca137a9ae14de1
11	0x44b497aa4b742dc48ce0bd26f66da9aeca19bd75	false	0	100000000000000000000000	37508116	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	2025-07-07T17:43:27.000Z	3933128	0xe44c2dfe90b52334773fc0fe357b0b48470b484c404cbffbae86ef40d093b7fc
7	0x44b497aa4b742dc48ce0bd26f66da9aeca19bd75	false	43	15041678516924860273634	35687323	0x9f0df7799f6fdad409300080cff680f5a23df4b1	2025-06-24T12:23:14.000Z	7597936238108020000	0xb46263036919e5729c0344de1a245dae16d1fa2e17712db506d3cd2e530e4f09

Example Query

Query with partition filter

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

AppBondDepository_DisableBond_event

Bond disablement events from Rezerve protocol’s AppBondDepository contract on Sonic, tracking when bond offerings are removed from availability. Used to monitor bond program lifecycle and treasury management actions.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.

Sample Data

in_id	address	removed	log_index	block_number	block_timestamp	transaction_hash
0	0x7ad11d53c773026171ef237d166174ea92d713a0	false	13	40623142	2025-07-28T17:14:35.000Z	0x8300ea77ac2ec7bbc3679d4ebf173c4dac7a7ef380fb186f5534081ed8c3d0f7

Example Query

Query with partition filter

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

AppStaking_PositionCreated_event

Staking position creation events from Rezerve protocol on Sonic chain, capturing when users create new staking positions with token amounts and declared valuations. Useful for analyzing staking behavior, position lifecycle, and liquidity provider activity across different tokenIds.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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_declaredValue`	`STRING`	Declared value of the staked position at creation time, denominated in the smallest token unit (wei-equivalent). Typically equals or exceeds the actual staked amount, representing the user’s commitment or collateral value.

Sample Data

address	removed	in_owner	in_amount	log_index	in_tokenId	block_number	block_timestamp	in_declaredValue	transaction_hash
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x63da7034dfb482e10ed84f4ff3c0aba42ecb5f58	9009494810288093495	9	518	41501345	2025-08-03T16:10:29.000Z	9459969550802498169	0x528a41be5d284d1d3dc140f3e7309a8c6bc8a66a98dc86869c64809e20ac43e8
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x204dac213492a815421a2735c0d06dba0cf99caf	36021174033678223380	9	522	41525305	2025-08-03T21:18:37.000Z	37822232735362134549	0x29e38e96c907919517b52bc4598dd2f97d0ea25a832625586da87ca09f2aabf0
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x204dac213492a815421a2735c0d06dba0cf99caf	46525775962836779008	140	521	41524390	2025-08-03T21:06:30.000Z	64670828588343122821	0xc59de23b95a659d310dafe5b89b757270977d4b28214713da86ceff9bc04f499

Example Query

Query with partition filter

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

AppStaking_PositionMerged_event

Staking position merge events from Rezerve protocol on Sonic, recording when users consolidate multiple staked positions (NFTs) into a single position. Tracks merged and surviving token IDs with updated staked amounts and declared values for analyzing position management 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.
`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_survivingTokenId`	`STRING`	Token ID of the staking position that remains active after the merge operation. This position absorbs the amount and declared value from the merged position.
`in_mergedTokenId`	`STRING`	Token ID of the staking position being merged into another position. This position is consumed in the merge operation, with its value consolidated into the surviving token.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_newAmount`	`STRING`	Updated amount of tokens in the position or loan. Numeric string representation in wei units (18 decimals).
`in_newDeclaredValue`	`STRING`	Updated declared value of the staking position after the operation. Numeric string representation in wei units (18 decimals).

Sample Data

address	removed	in_owner	log_index	block_number	in_newAmount	block_timestamp	in_mergedTokenId	transaction_hash	in_newDeclaredValue	in_survivingTokenId
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0xf2e4a05cbae83fb3173becee7a31686e8a6ae3ce	1	37966026	2811720170089210035	2025-07-11T02:06:46.000Z	169	0x2e03e09c879dc543aef95d0cf526b9158f6827244e100427b119754eb0a176a5	11703600000000000400	170
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x2b8c887dc20f8872df8b895efcea1d3fafe72202	1	38043573	80232226919048445455	2025-07-11T13:17:25.000Z	209	0x7cf8b620f91dbfadea8d22fea07fd9e21fec90f4e43d23ec303d5b3125593998	111552828638429684691	211
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x204dac213492a815421a2735c0d06dba0cf99caf	1	38007901	144385172151594944090	2025-07-11T08:27:06.000Z	217	0x5fbbf4c71386dc58e4b3b0388f4f883a5e9ed11fa5761b30bd6b484630029515	438558764479711038613	212

Example Query

Query with partition filter

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

AppStaking_PositionSplit_event

Position split events from Rezerve AppStaking protocol on Sonic, tracking when staking positions (NFTs) are divided into new token IDs with allocated amounts and declared values. Used for analyzing position management strategies and tracking the lineage of split staking positions.

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_originalTokenId`	`STRING`	Token identifier of the original staking position before it was split into separate positions. Numeric string representing the NFT token ID that existed prior to the PositionSplit event.
`in_newTokenId`	`STRING`	Token ID of the newly created staking position resulting from the split operation. Numeric identifier assigned to the position portion transferred to the recipient address.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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_splitAmount`	`STRING`	Token amount being transferred from the original staking position to the newly created position. Value is denominated in the smallest unit (wei-equivalent) of the staked token.
`in_splitDeclaredValue`	`STRING`	Declared value of the newly created position after the split, denominated in the smallest token unit (wei-like precision). Always greater than the split amount, representing the total claimed value of the split portion.

Sample Data

in_to	address	removed	in_owner	log_index	block_number	in_newTokenId	in_splitAmount	block_timestamp	transaction_hash	in_originalTokenId	in_splitDeclaredValue
0x05631891643a2e9dd5cc44293f14caa4b4cd98b2	0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x05631891643a2e9dd5cc44293f14caa4b4cd98b2	11	38210352	249	144033602354520862102	2025-07-12T15:10:43.000Z	0x128f82175ee7b2216501548c8cc859ed218ca2f596abc18c3f61ac1e3f2c5375	237	182194840852499760195
0x05631891643a2e9dd5cc44293f14caa4b4cd98b2	0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x67a298e5b65db2b4616e05c3b455e017275f53cb	4	38209710	243	1590293820200458883	2025-07-12T15:04:56.000Z	0x55a2d88d22443886571f75bb8820c3225490568b1cebe1ff5545386b567684f4	16	2211103702832369832
0x05631891643a2e9dd5cc44293f14caa4b4cd98b2	0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x67a298e5b65db2b4616e05c3b455e017275f53cb	7	38209756	246	1862044465989561	2025-07-12T15:05:21.000Z	0x2c25b07af0b4405f9804025ad194841e5125503ffd68b282657405c24fa98952	16	2588938824568321

Example Query

Query with partition filter

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

AppStaking_PositionUnstaked_event

Unstaking events from Rezerve protocol’s app staking contract on Sonic, recording when users withdraw their staked positions identified by NFT token IDs. Useful for analyzing staking behavior, position liquidity, and participant retention 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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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_owner	in_amount	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x411f9d604766f55cbea7ca57c2d84d27d8193682	72092214739333012697	3	88	37090317	2025-07-04T06:04:27.000Z	0x52ac004cec02d44e73691c62a15e4993147f5d9469dc7396ddc04e9efc976f99
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x204dac213492a815421a2735c0d06dba0cf99caf	2966445788846224964	3	481	41462919	2025-08-03T08:46:31.000Z	0x5cfeac8c4c245d7cdfd608fd14ab2334d88c9e72e7260aa2521ef3a7b8bc3cc4
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x3b022a2264256ddd7de70b8e636045cc466768a0	8835578844679953295	3	468	41525726	2025-08-03T21:24:42.000Z	0x49be6021030e6a9db7ac93c0bf940b4d6761e699ced409c47f292c796781d138

Example Query

Query with partition filter

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

AppStaking_PositionUpdated_event

Staking position update events from Rezerve protocol on Sonic, tracking changes to user staking positions including staked amounts and declared values by NFT position ID. Used for analyzing staking behavior, position sizing, and reward accrual patterns in the protocol.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_newAmount`	`STRING`	Updated amount of tokens in the position or loan. Numeric string representation in wei units (18 decimals).
`in_newDeclaredValue`	`STRING`	Updated declared value of the staking position after the operation. Numeric string representation in wei units (18 decimals).

Sample Data

address	removed	in_owner	log_index	in_tokenId	block_number	in_newAmount	block_timestamp	transaction_hash	in_newDeclaredValue
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x3d8cf44efa1a56b2de2a768908d3da4fb6062818	3	39	37507370	29016855685773482467	2025-07-07T17:35:44.000Z	0x16fc597a223d30a85d456a5117de7b3a68440596cbfe2979f6b94ea9b84f289b	36620000000000000000
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x67a298e5b65db2b4616e05c3b455e017275f53cb	18	16	37485810	49050824089685421336897	2025-07-07T13:57:22.000Z	0x0a79de89e62a2337ec37d1cc4c852d8b9c78844b25338955e6e04d10fb2c5abc	68199006583278742641985
0xd060499ddc9cb7deb07f080baeb1add36aa2c650	false	0x67a298e5b65db2b4616e05c3b455e017275f53cb	25	16	37485810	49075902090877161138616	2025-07-07T13:57:22.000Z	0x0a79de89e62a2337ec37d1cc4c852d8b9c78844b25338955e6e04d10fb2c5abc	68233874392422338088225

Example Query

Query with partition filter

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

AppStaking_Transfer_event

NFT transfer events from the Rezerve AppStaking contract on Sonic, tracking staking position movements with all transfers to the zero address indicating unstaking or burn operations. Useful for analyzing staking position lifecycles and user unstaking 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_to`	`STRING`	Destination address receiving tokens or assets 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.

Sample Data

in_to	address	in_from	removed	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0xd060499ddc9cb7deb07f080baeb1add36aa2c650	0xeb557914b7062331219c76214f9097d746b51d47	false	2	100	38753063	2025-07-16T12:28:27.000Z	0x3d4b55300496ea5034a3198fa57fa7bf231ff38cbecb66c3c9d6998ebb93d6ed
0x0000000000000000000000000000000000000000	0xd060499ddc9cb7deb07f080baeb1add36aa2c650	0xeb557914b7062331219c76214f9097d746b51d47	false	2	106	38753044	2025-07-16T12:28:13.000Z	0xd7152d5e7a35470684da05ee2e409a20bb8188b21cb31921f3bca3ac06e263eb
0x0000000000000000000000000000000000000000	0xd060499ddc9cb7deb07f080baeb1add36aa2c650	0x56f2c4cb8518d0a4ec749593df574f7597a36140	false	311	253	38784460	2025-07-16T16:33:50.000Z	0xda5459639af5150b0a436b4f3c84553f95b82a88db7998cd9be380cb95f335b8

Example Query

Query with partition filter

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

AppTreasury_Deposit_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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_usdValue`	`STRING`	-
`in_rzrValue`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

AppTreasury_ReservesAudited_event

Reserve audit snapshots from Rezerve protocol on Sonic, capturing total reserves and credit-adjusted reserves for treasury monitoring. Useful for tracking protocol solvency and reserve backing 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_totalReserves`	`STRING`	Total reserves held by the Rezerve protocol treasury contract at the time of the audit event, denominated in the protocol’s base unit (wei-equivalent). This represents the backing assets without accounting for credit extensions.
`in_totalReservesWithCredit`	`STRING`	Total reserves including available credit lines, denominated in the smallest token unit (wei for EVM chains). This value can exceed `in_totalReserves` when credit facilities are available to the treasury.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_totalReserves	transaction_hash	in_totalReservesWithCredit
0xe22e10f8246df1f0845ee3e9f2f0318bd60efc85	false	3	45524667	2025-09-02T19:59:03.000Z	426332159641618844407707	0xae534c9bf4b5786936e6b8ff54b2c03f8a7f4739c28f4fbc85e9477e5d19a7d5	198275129325209563164171
0xe22e10f8246df1f0845ee3e9f2f0318bd60efc85	false	4	44603685	2025-08-26T13:22:10.000Z	443235729514091442408398	0x57d166478ce7946ba11bff0604f0afe3f8019537ec5d2ed1faf4a145156a3b11	253983291829384544192118
0xe22e10f8246df1f0845ee3e9f2f0318bd60efc85	false	12	53341212	2025-11-03T08:46:54.000Z	112701155301961928493852	0x39eccbdd129695a56bd1fd7a67349c2eae7e2aaa0742a33889360a480a4088f2	162706511040882795905897

Example Query

Query with partition filter

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

AppTreasury_TokenEnabled_event

Token enablement events from the Rezerve protocol treasury contract on Sonic, tracking which token addresses (in_addr) are activated or deactivated for treasury operations. Used for monitoring protocol token whitelist changes and treasury configuration updates.

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_addr`	`STRING`	Contract address referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_result`	`BOOL`	Output amount received from the swap operation or boolean flag indicating the enabled state of a token.

Sample Data

address	in_addr	removed	in_result	log_index	block_number	block_timestamp	transaction_hash
0xe22e10f8246df1f0845ee3e9f2f0318bd60efc85	0x8c7a2c0729afb927da27d4c9aa172bc5a5fb12bb	false	true	2	46010907	2025-09-07T04:05:23.000Z	0x339713b495c79ce0974acee773c39c73e9009958981591fbd2b38facf469d100
0xe22e10f8246df1f0845ee3e9f2f0318bd60efc85	0x7db3e4fe32424efd566ed89ec4ea21d62adefd67	false	true	0	37661557	2025-07-08T23:34:17.000Z	0x6e9d61e2248cfad150415549406f1d86fee78c5bfbf0e3c9d6c6826f0f4f2a5e
0xe22e10f8246df1f0845ee3e9f2f0318bd60efc85	0xe70a4c4af0fcbef07bd7fb55c9a89a9f5a059572	false	true	6	37656837	2025-07-08T22:26:14.000Z	0x7425d96382fd7bd0ab6dc679956e0797b1c15a1f533123c77cdeb246cae769fb

Example Query

Query with partition filter

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

Staking4626_Deposit_event

Deposit events from Rezerve protocol’s ERC-4626 compliant staking vault on Sonic chain, tracking asset deposits with corresponding share amounts minted to stakers. Used for analyzing staking flows, share-to-asset conversion rates, and vault 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_sender`	`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

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x67a298e5b65db2b4616e05c3b455e017275f53cb	false	0x30ccf4bbee313fcd19f3e295b3ba2920a24e2f62	14066014911863359	0x30ccf4bbee313fcd19f3e295b3ba2920a24e2f62	10494691839279770	5	45991882	2025-09-06T22:56:57.000Z	0x72faf80a4ac67202267c8d2ee9e4b0e7f6fbcaa678c97bf012591bd4999ce300
0x67a298e5b65db2b4616e05c3b455e017275f53cb	false	0xd235ccc3f9eee2ed41f97177549a5c573d92c30c	7544998027067446258	0xa25f6ba0136c65e61200ebf0885ea8da022e83fa	5629343472063560372	8	45966764	2025-09-06T16:40:49.000Z	0xc2b9004224b00a3365d7b4d0cc68959788e330d4af1daaa5b677ba666fdf6d7e
0x67a298e5b65db2b4616e05c3b455e017275f53cb	false	0x7cf80eb70b99251463a5fa981e3592873e47d5c7	154760441704490392	0xa25f6ba0136c65e61200ebf0885ea8da022e83fa	115467184897523413	7	45973309	2025-09-06T18:12:45.000Z	0xeec9982518881292c4644238999d4e22dc93d7d7810286374e9567de32112529

Example Query

Query with partition filter

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

Staking4626_Transfer_event

Transfer events from Rezerve’s ERC-4626 staking vault on Sonic, tracking deposits, withdrawals, and share token movements between user addresses and the vault contract. Useful for analyzing staking flows, vault utilization, and identifying deposit/withdrawal patterns in the Rezerve protocol.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xed2a9579ac3a5c3c3803179aa528e9e5749c3416	0x67a298e5b65db2b4616e05c3b455e017275f53cb	0xba1333333333a1ba1108e8412f11850a5c319ba9	false	688285553444661310756	3	44801250	2025-08-28T00:13:38.000Z	0xab30bb385f89e0cedfc0fa7a813b6ef817a7d43090e8932150784d9b39ef2277
0xa8af95c5a3bfbce9337be02f8d0a1549cfbd2554	0x67a298e5b65db2b4616e05c3b455e017275f53cb	0x5e8c10b0569d37d0ab4f3962786dc2adc49d5933	false	1424001053690940233	22	44803760	2025-08-28T00:36:19.000Z	0x1892774d77690e3c34c26818e38630fe8a87309c4bc73de4fb1448d591ae1974
0x5e8c10b0569d37d0ab4f3962786dc2adc49d5933	0x67a298e5b65db2b4616e05c3b455e017275f53cb	0xba1333333333a1ba1108e8412f11850a5c319ba9	false	1424001053690940233	17	44803760	2025-08-28T00:36:19.000Z	0x1892774d77690e3c34c26818e38630fe8a87309c4bc73de4fb1448d591ae1974

Example Query

Query with partition filter

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

Staking4626_Withdraw_event

Withdrawal events from Rezerve’s ERC-4626 staking vaults on Sonic, recording unstaking transactions with share redemption amounts and underlying asset values. Tracks owner, sender, receiver addresses and share-to-asset conversion rates for analyzing staking vault withdrawals 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x67a298e5b65db2b4616e05c3b455e017275f53cb	false	0x0be8b961cbf6564bd1931b0803d35c0659e0d016	21257853528550369911	0x0be8b961cbf6564bd1931b0803d35c0659e0d016	18187811208294844339	9	0x0be8b961cbf6564bd1931b0803d35c0659e0d016	39698748	2025-07-22T14:28:31.000Z	0x7d18cf3d09e2ea784517beede4e22bb58f6ad5726fa17755ee8fbc48afe1c4e1
0x67a298e5b65db2b4616e05c3b455e017275f53cb	false	0xd87ecc6c74f486b044824a222326a96f696fcfa2	11668338610408903816	0xd87ecc6c74f486b044824a222326a96f696fcfa2	10000000000000000000	9	0xd87ecc6c74f486b044824a222326a96f696fcfa2	39620225	2025-07-22T03:04:34.000Z	0x4f0753a9745bdc8421bcb006517c2cdaab0821d8727c1cec88f3a3a6c2f221e6
0x67a298e5b65db2b4616e05c3b455e017275f53cb	false	0xd87ecc6c74f486b044824a222326a96f696fcfa2	11694102930712644905	0xd87ecc6c74f486b044824a222326a96f696fcfa2	10000000000000000000	16	0xd87ecc6c74f486b044824a222326a96f696fcfa2	39729400	2025-07-22T18:08:13.000Z	0x6f5021552db6f1d750ffd8fa14ef88ea64c8f6eed41393ea7873dbdaeff39994

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AppBondDepository_BondCreated_event

AppBondDepository_CompleteBondVesting_event

AppBondDepository_CreateBond_event

AppBondDepository_DisableBond_event

AppStaking_PositionCreated_event

AppStaking_PositionMerged_event

AppStaking_PositionSplit_event

AppStaking_PositionUnstaked_event

AppStaking_PositionUpdated_event

AppStaking_Transfer_event

AppTreasury_Deposit_event

AppTreasury_ReservesAudited_event

AppTreasury_TokenEnabled_event

Staking4626_Deposit_event

Staking4626_Transfer_event

Staking4626_Withdraw_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AppBondDepository_BondCreated_event

​AppBondDepository_CompleteBondVesting_event

​AppBondDepository_CreateBond_event

​AppBondDepository_DisableBond_event

​AppStaking_PositionCreated_event

​AppStaking_PositionMerged_event

​AppStaking_PositionSplit_event

​AppStaking_PositionUnstaked_event

​AppStaking_PositionUpdated_event

​AppStaking_Transfer_event

​AppTreasury_Deposit_event

​AppTreasury_ReservesAudited_event

​AppTreasury_TokenEnabled_event

​Staking4626_Deposit_event

​Staking4626_Transfer_event

​Staking4626_Withdraw_event

Tables

AppBondDepository_BondCreated_event

AppBondDepository_CompleteBondVesting_event

AppBondDepository_CreateBond_event

AppBondDepository_DisableBond_event

AppStaking_PositionCreated_event

AppStaking_PositionMerged_event

AppStaking_PositionSplit_event

AppStaking_PositionUnstaked_event

AppStaking_PositionUpdated_event

AppStaking_Transfer_event

AppTreasury_Deposit_event

AppTreasury_ReservesAudited_event

AppTreasury_TokenEnabled_event

Staking4626_Deposit_event

Staking4626_Transfer_event

Staking4626_Withdraw_event