reserve_v1_arbitrum

Tables

RSR_TradeSettled_event

Trade settlement events from Reserve Protocol’s RSR (Reserve Rights) token operations on Arbitrum. Captures token swap executions including buy/sell token addresses, amounts, and trade identifiers for analyzing Reserve Protocol collateral rebalancing and trading 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_trade`	`STRING`	Identifier or structured data representing the trade or swap operation. Specific format varies by protocol implementation.
`in_sell`	`STRING`	Contract address of the token being sold in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_buy`	`STRING`	Contract address of the token being purchased in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_sellAmount`	`STRING`	Amount of tokens sold in the trade. Numeric string representation of token quantity in smallest denomination.
`in_buyAmount`	`STRING`	Amount of tokens received in the trade. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_buy	address	in_sell	removed	in_trade	log_index	block_number	in_buyAmount	in_sellAmount	block_timestamp	transaction_hash
0xca5ca9083702c56b481d1eec86f1776fdbd2e594	0x0642ea3bcf300cae5afc8f82db91b309c9b166b9	0x05d0e5a60251cef203a06b17973c843c8225cc4e	false	0xdf3525a781f15811b5addc9b10be7f755452b18d	2	223912781	0	0	2024-06-20T17:41:10.000Z	0x71933c439f0d0fdcd3942024fb8ea2240e97b39e88505233a93e0b3a34886c2d
0xca5ca9083702c56b481d1eec86f1776fdbd2e594	0x0642ea3bcf300cae5afc8f82db91b309c9b166b9	0x05d0e5a60251cef203a06b17973c843c8225cc4e	false	0x1c0805cf4b1f49c50e0c8982b1a73237f463d21f	2	223908572	0	0	2024-06-20T17:23:39.000Z	0x17a9c6ca0585a21bd8a4e90ab56d068bdc4b734dc290873fb522d1d5cadc58d8
0xca5ca9083702c56b481d1eec86f1776fdbd2e594	0x0642ea3bcf300cae5afc8f82db91b309c9b166b9	0x05d0e5a60251cef203a06b17973c843c8225cc4e	false	0x048c70873673f7cb30d38264f51211f2accffceb	5	223915967	69214846327431978544	400199999800000000	2024-06-20T17:54:23.000Z	0x405c9842c4d3a3e1ee722489a68181587c1426575cbdd1ee1275111445c5323f

Example Query

Query with partition filter

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

RTokenFactory_RTokenCreated_event

RToken deployment events emitted by the Reserve Protocol factory contract when new RToken instances are created. Contains addresses for the deployed RToken, staked RSR (stRSR) contract, main governance contract, initial owner, and protocol version identifier.

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_main`	`STRING`	Contract address of the main protocol component deployed during RToken creation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rToken`	`STRING`	Contract address of the RToken deployed during creation. Hex-encoded, 0x-prefixed, 42-character string.
`in_stRSR`	`STRING`	Contract address of the staked RSR token (stRSR) deployed during RToken creation. 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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	in_main	removed	in_owner	in_stRSR	in_rToken	log_index	in_version	block_number	block_timestamp	transaction_hash
0xfd7eb6b208e1fa7b14e26a1fb10ffc17cf695d68	0x685187758fd65e09c1d45d9055debb655dd81b9c	false	0xe2b652e538543d02f985a5e422645a704633956d	0xac01688f78d7c8cf6843a4d7399aac3e36e1859f	0x9ef21938f4601493afb4e21ba3f9aafef8ffb15f	72	3.4.0	256501835	2024-09-23T11:32:56.000Z	0x41df0ea99a504be9b6f334144f04a894e0ccae6ceea5a90f835f896e718c32cb
0xfd7eb6b208e1fa7b14e26a1fb10ffc17cf695d68	0x77cb75066ee8ddc04bbc4a761a8d9d568c822d82	false	0xe2b652e538543d02f985a5e422645a704633956d	0x2f18d2a8002685e3f6d60dbabd973d705b8e3526	0x635f80eea9df5936772165740120e677878b55a6	90	3.4.0	256502334	2024-09-23T11:35:01.000Z	0xd8e630bb92eccc9b7e094695b862b7ca942e89aae2a751575fb88b2c396a1c70
0xfd7eb6b208e1fa7b14e26a1fb10ffc17cf695d68	0x9ade7cd312d5270d9b03f9a8939551f4f590ffee	false	0xe2b652e538543d02f985a5e422645a704633956d	0x409a3fe9964f028196924740142df1f918e63cda	0x90a23f102b8eaa3e4166bb54b51577b3bbb8aa94	72	3.4.0	329315481	2025-04-23T08:19:33.000Z	0x7aa806fb082c98207c30f52facb820d9be6a3a6c7fe04b2045b7cd5a7a76eef4

Example Query

Query with partition filter

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

RTokenMain_AssetRegistrySet_event

Asset registry update events from Reserve Protocol RToken contracts tracking changes to the asset registry address. Records the old and new registry contract addresses for governance and configuration tracking.

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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0xdda9344f4b477e20b1bf2d0d93215dd747bbc191	false	0xe352b021503cb87a3b6899f4956a27a9a3e6cf80	0x0000000000000000000000000000000000000000	26	329355470	2025-04-23T11:05:36.000Z	0xb0f938f5368196b6ad195a1161390c66c44ad38be3ae85a7f80cbe37829773ad
0xc4d9139c06b628e78e04c28c6f18e2f00485b0dd	false	0x4c34a677dcb816d8a39094f68e3339c629d67e61	0x0000000000000000000000000000000000000000	27	329317126	2025-04-23T08:26:24.000Z	0xe1447b4f4d6466090e197afdfe39bee43e0210d5d81a35d7e92d868a85081240
0xc985052a3d310650d328240683a3c4ea07c8c40e	false	0x3d4727e7fb14c6bdca318c02a51223bae6c43c1b	0x0000000000000000000000000000000000000000	27	329355996	2025-04-23T11:07:46.000Z	0x908f825de65109031742a584c62ee389f60d9a1b1144d3d4e7f7521c5f60c4fa

Example Query

Query with partition filter

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

RTokenMain_BackingManagerSet_event

Reserve Protocol RToken configuration change events recording updates to the backing manager contract address. Tracks the previous and new backing manager addresses during RToken system reconfigurations.

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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0xb8ea9d6569d33f51d10733d3a6d24f4f71d8018a	false	0xb7c47330c20b96fc628fd183d658f352450cb74d	0x0000000000000000000000000000000000000000	19	223866348	2024-06-20T14:29:52.000Z	0xafbaedf7d4b3c4cca082c0d11bd1548f80f3cdc65fc898a2b6d659ae0f8ef2da
0x1fdf12aa92316411994da21c43c62e0d500f78d2	false	0x152f37a9314fb8d20f99259e3091243e4463c168	0x0000000000000000000000000000000000000000	18	209861430	2024-05-10T16:20:54.000Z	0x9f189970db33a0955cd5f163e18cf3e2439770c3d37cebc9ee8217690d145c3b
0x0ebb9067e25e3ba1427cb0d1a7c5660551172825	false	0x06a87139e5ae92b2614d33619df301ca0be6f981	0x0000000000000000000000000000000000000000	18	259328880	2024-10-01T16:59:28.000Z	0x4678d2d1f4a3a52cf92e8381c273983762dbadd502ec205e291e943607b28f47

Example Query

Query with partition filter

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

RTokenMain_BasketHandlerSet_event

Reserve Protocol BasketHandler configuration change events emitted from RToken main contracts, capturing transitions between old and new basket handler addresses. Used for tracking governance updates to collateral basket management components.

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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0x77cb75066ee8ddc04bbc4a761a8d9d568c822d82	false	0xfa91f170923fce4507746311d5194ffffcd146cb	0x0000000000000000000000000000000000000000	37	256502334	2024-09-23T11:35:01.000Z	0xd8e630bb92eccc9b7e094695b862b7ca942e89aae2a751575fb88b2c396a1c70
0x685187758fd65e09c1d45d9055debb655dd81b9c	false	0xdccde8097f6c676aa7053496c76405bd15e436de	0x0000000000000000000000000000000000000000	19	256501835	2024-09-23T11:32:56.000Z	0x41df0ea99a504be9b6f334144f04a894e0ccae6ceea5a90f835f896e718c32cb
0x71ef2eeb3accd9bc2dcc9f1f4745e4b51dd344ff	false	0xfbae1ce1be35e04b0610c3a38b5c5995bb318793	0x0000000000000000000000000000000000000000	29	208438396	2024-05-06T12:50:43.000Z	0x039f2af5e43e70da41e7d71ecd2363c41d9fb88043ea79232db2d969ff0a4490

Example Query

Query with partition filter

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

RTokenMain_BrokerSet_event

Event logs emitted when the broker contract address is updated in the Reserve Protocol RTokenMain contract, capturing both old and new broker addresses. Records configuration changes for the trading component responsible for executing rebalancing trades and revenue auctions.

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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0xb5c6d2a4c8b7dae8042143e473b5723fd05929b2	false	0x13e4e705b83e3d060aaea6d3b13155d249cc98b9	0x0000000000000000000000000000000000000000	44	205045378	2024-04-26T14:54:53.000Z	0x5c992e2c64607f0173e1caa3899be9aa6875668f063150ca43dc2199d216f219
0x84cd46a42f5161a0c59c054d96d038f243c707a3	false	0xe8f943ef78d6bd1b49ba820ec862a62aaab33490	0x0000000000000000000000000000000000000000	75	214591122	2024-05-24T15:52:32.000Z	0x7fdc41b49b21016971d6e147019b25f31ae81cfd9215446224942ca02e3f5b04
0x543396b14c55dc83ab21cf160dad8306d3e1c701	false	0x783ea5342c0bb298e373e39650ab97bcf657f7f2	0x0000000000000000000000000000000000000000	27	204797348	2024-04-25T21:28:42.000Z	0x475dfc66d43d4bb76d4824f1c7ea460a7424079bb50aeae8c38ebd081649c02f

Example Query

Query with partition filter

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

RTokenMain_DistributorSet_event

Revenue distribution configuration change events emitted by RToken (Reserve Token) main contracts when the distributor component address is updated. Captures the previous and new distributor contract addresses for tracking protocol governance changes.

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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0x84cd46a42f5161a0c59c054d96d038f243c707a3	false	0x85dbe57282ae047ca303afabcf58b080c97d2f0b	0x0000000000000000000000000000000000000000	73	214591122	2024-05-24T15:52:32.000Z	0x7fdc41b49b21016971d6e147019b25f31ae81cfd9215446224942ca02e3f5b04
0x543396b14c55dc83ab21cf160dad8306d3e1c701	false	0xccfa2e95765907ec4ae7347ae06ea74593045d30	0x0000000000000000000000000000000000000000	25	204797348	2024-04-25T21:28:42.000Z	0x475dfc66d43d4bb76d4824f1c7ea460a7424079bb50aeae8c38ebd081649c02f
0x63f98e92845ccccf250fe35e4645f584b980902d	false	0x0765d6aa7c4a7282c0472a004a847b9c60f7470c	0x0000000000000000000000000000000000000000	73	204512928	2024-04-25T01:07:19.000Z	0x0cabf41f795823e47a38a533d636d385d134867eb10cb08e1a2d6d88aa4effef

Example Query

Query with partition filter

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

RTokenMain_FurnaceSet_event

Reserve Protocol RToken configuration change event logging updates to the furnace component address. Records old and new contract addresses when the RToken’s furnace mechanism is reconfigured.

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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0xb8ea9d6569d33f51d10733d3a6d24f4f71d8018a	false	0x600db8e7049e91b615c1d3ae2d63d83d6b0308f5	0x0000000000000000000000000000000000000000	25	223866348	2024-06-20T14:29:52.000Z	0xafbaedf7d4b3c4cca082c0d11bd1548f80f3cdc65fc898a2b6d659ae0f8ef2da
0x0ebb9067e25e3ba1427cb0d1a7c5660551172825	false	0x3f0871b0da9b7b25d5abf15c154e50675e0b3365	0x0000000000000000000000000000000000000000	24	259328880	2024-10-01T16:59:28.000Z	0x4678d2d1f4a3a52cf92e8381c273983762dbadd502ec205e291e943607b28f47
0x1fdf12aa92316411994da21c43c62e0d500f78d2	false	0xedca2508873b38da3212f2484a1495b3c3110ca9	0x0000000000000000000000000000000000000000	24	209861430	2024-05-10T16:20:54.000Z	0x9f189970db33a0955cd5f163e18cf3e2439770c3d37cebc9ee8217690d145c3b

Example Query

Query with partition filter

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

RTokenMain_RSRTraderSet_event

Reserve Protocol RSR (Reserve Rights) trader address configuration change events emitted when an RToken sets a new RSR trader contract. Captures the transition from old to new trader addresses for tracking protocol governance and operational 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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0x2f93558566417425f0221882105d7b300a78e1c2	false	0x2c1df6e63c1a1fbdf1778f7806773af23db77053	0x0000000000000000000000000000000000000000	24	266601507	2024-10-22T21:23:45.000Z	0x02d62505543d105a1c4bf80b3be0a01eda87657c26a43d357f1c7f1426fc1a80
0x25082a66b18a84e70d1c17c4c655f092a5aca8ad	false	0xdd241fb3d77f56406c8f863fc474b1129c3acc81	0x0000000000000000000000000000000000000000	22	266507894	2024-10-22T14:51:02.000Z	0x156c74e44847be8d7c1b647b1506dec63c4106880ed738aa2811ce3875bd0851
0x9ade7cd312d5270d9b03f9a8939551f4f590ffee	false	0x8eee1d4d046817fc0bf10113208d57cd3def7e56	0x0000000000000000000000000000000000000000	20	329315481	2025-04-23T08:19:33.000Z	0x7aa806fb082c98207c30f52facb820d9be6a3a6c7fe04b2045b7cd5a7a76eef4

Example Query

Query with partition filter

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

RTokenMain_RTokenSet_event

RToken contract address configuration change events emitted when the RToken contract reference is set or updated. Records the previous and new RToken contract addresses during system initialization or upgrades.

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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0x84cd46a42f5161a0c59c054d96d038f243c707a3	false	0x79ab6c25f74e6366e1951592c2c98698d654df21	0x0000000000000000000000000000000000000000	77	214591122	2024-05-24T15:52:32.000Z	0x7fdc41b49b21016971d6e147019b25f31ae81cfd9215446224942ca02e3f5b04
0x543396b14c55dc83ab21cf160dad8306d3e1c701	false	0x5d94bde814d453afc0d80e116033cac70bac771b	0x0000000000000000000000000000000000000000	29	204797348	2024-04-25T21:28:42.000Z	0x475dfc66d43d4bb76d4824f1c7ea460a7424079bb50aeae8c38ebd081649c02f
0x63f98e92845ccccf250fe35e4645f584b980902d	false	0xb0e5d55cea183f355415ffc45c64d3426eeb6292	0x0000000000000000000000000000000000000000	77	204512928	2024-04-25T01:07:19.000Z	0x0cabf41f795823e47a38a533d636d385d134867eb10cb08e1a2d6d88aa4effef

Example Query

Query with partition filter

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

RTokenMain_RTokenTraderSet_event

RToken trader contract address configuration change events from the Reserve Protocol. Records when the RTokenMain contract updates its trader component address, capturing both previous and new trader contract addresses for governance and configuration tracking.

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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0x8fd71e04f4f467a486681eba7b589f3ee92986db	false	0xd4d6bb103088c12c1564f2587bc963bbe89e915e	0x0000000000000000000000000000000000000000	44	225360800	2024-06-24T22:14:50.000Z	0x04c1b4d1f5f77e4ace155422d7f7ec4911920d9d7ef056481201c608fa9763e5
0x84952ae44d12815eb69c9575d2700d716cbc4ff0	false	0x2b2e2ce85d72c02f0d0103d556a4d5d07a5dfbcc	0x0000000000000000000000000000000000000000	23	258952420	2024-09-30T14:41:39.000Z	0x03d079e6ff87d49c46b14b6598bc9d5d26458278df4f3ac707d0795d51ca0f37
0xb5c6d2a4c8b7dae8042143e473b5723fd05929b2	false	0xa9e8490c6bc8576d1a0cd16923cba2c72bfd500c	0x0000000000000000000000000000000000000000	40	205045378	2024-04-26T14:54:53.000Z	0x5c992e2c64607f0173e1caa3899be9aa6875668f063150ca43dc2199d216f219

Example Query

Query with partition filter

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

RTokenMain_StRSRSet_event

Configuration change events from Reserve Protocol RToken contracts recording updates to the staked RSR (StRSR) contract address. Captures transitions from previous to new StRSR contract addresses during protocol upgrades or reconfigurations.

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_oldVal`	`STRING`	Previous value before the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.
`in_newVal`	`STRING`	New value being set in the configuration change. Hex-encoded, 0x-prefixed, 42-character contract address.

Sample Data

address	removed	in_newVal	in_oldVal	log_index	block_number	block_timestamp	transaction_hash
0x71ef2eeb3accd9bc2dcc9f1f4745e4b51dd344ff	false	0x89f90f8ce9ebc848c67881e4a03926537ccbff73	0x0000000000000000000000000000000000000000	36	208438396	2024-05-06T12:50:43.000Z	0x039f2af5e43e70da41e7d71ecd2363c41d9fb88043ea79232db2d969ff0a4490
0x78103523ff1714af75144b1788bc6c6f6d2549e2	false	0xdcebdea46e4fb38baaeb0bdfefa89be373f4680b	0x0000000000000000000000000000000000000000	46	208446865	2024-05-06T13:26:43.000Z	0xf6d5801d829705ebfdd8626ed9a32a59910952165f2260627e305496a06510cd
0xb0f377e58f4fa4bc42067868a699666bd7dac565	false	0x813c74a73db6e48a0b9beb4ae072139b59dcd90c	0x0000000000000000000000000000000000000000	36	206160037	2024-04-29T21:08:07.000Z	0x0b5022d81764ed9e5e9c3d2e97093d897f91dabf2e8cd8d4cf25b2b2e03f95e9

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

RSR_TradeSettled_event

RTokenFactory_RTokenCreated_event

RTokenMain_AssetRegistrySet_event

RTokenMain_BackingManagerSet_event

RTokenMain_BasketHandlerSet_event

RTokenMain_BrokerSet_event

RTokenMain_DistributorSet_event

RTokenMain_FurnaceSet_event

RTokenMain_RSRTraderSet_event

RTokenMain_RTokenSet_event

RTokenMain_RTokenTraderSet_event

RTokenMain_StRSRSet_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​RSR_TradeSettled_event

​RTokenFactory_RTokenCreated_event

​RTokenMain_AssetRegistrySet_event

​RTokenMain_BackingManagerSet_event

​RTokenMain_BasketHandlerSet_event

​RTokenMain_BrokerSet_event

​RTokenMain_DistributorSet_event

​RTokenMain_FurnaceSet_event

​RTokenMain_RSRTraderSet_event

​RTokenMain_RTokenSet_event

​RTokenMain_RTokenTraderSet_event

​RTokenMain_StRSRSet_event

Tables

RSR_TradeSettled_event

RTokenFactory_RTokenCreated_event

RTokenMain_AssetRegistrySet_event

RTokenMain_BackingManagerSet_event

RTokenMain_BasketHandlerSet_event

RTokenMain_BrokerSet_event

RTokenMain_DistributorSet_event

RTokenMain_FurnaceSet_event

RTokenMain_RSRTraderSet_event

RTokenMain_RTokenSet_event

RTokenMain_RTokenTraderSet_event

RTokenMain_StRSRSet_event