vesta_v1_arbitrum

Tables

ActivePool_ActivePoolVSTDebtUpdated_event

VST stablecoin debt balance updates in Vesta Finance’s ActivePool contract on Arbitrum, tracking total debt positions per collateral asset. Used for monitoring protocol-level debt exposure and collateralized debt position (CDP) system health.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__VSTDebt`	`STRING`	Total VST stablecoin debt amount for the specified collateral asset in the Vesta Finance Active Pool, denominated in wei (18 decimals). Updated whenever borrowing positions change for that asset.

Sample Data

address	removed	in__asset	log_index	in__VSTDebt	block_number	block_timestamp	transaction_hash
0xbe3de7fb9aa09b3fa931868fb49d5ba5fee2ebb1	false	0x2f546ad4edd93b956c8999be404cdcafde3e89ae	6	288105835598205964051026	144623110	2023-10-27T21:29:40.000Z	0xfe1f044e4c1627c6ff22e3ddb6133d7e22a629ce8ba9fcdd56c28e157ba5534c
0xbe3de7fb9aa09b3fa931868fb49d5ba5fee2ebb1	false	0xdbf31df14b66535af65aac99c32e9ea844e14501	7	481356648324999999799000	7909855	2022-03-14T23:38:35.000Z	0x43cde95c45c328a73ebdd0feafda48fe536ae4e540c775e0a1a6a42c3f52a72b
0xbe3de7fb9aa09b3fa931868fb49d5ba5fee2ebb1	false	0x8d9ba570d6cb60c7e3e0f31343efe75ab8e65fb1	7	1831545984106774160046062	7901633	2022-03-14T19:29:44.000Z	0x575d11971635aceed09ec84a12062a956a82f88d7305a75e2ac4f69b0eed9529

Example Query

Query with partition filter

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

BorrowerOperations_TroveCreated_event

Trove (collateralized debt position) creation events from Vesta Finance on Arbitrum, capturing borrower addresses, collateral asset types, and sequential array indices. Used for tracking CDP opening activity and analyzing collateral preferences across different asset types.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in_arrayIndex`	`STRING`	Sequential index assigned to the newly created trove within the Vesta protocol’s internal array for the specified collateral asset. Tracks the order of trove creation and is unique per asset type.

Sample Data

address	removed	in__asset	log_index	block_number	in__borrower	in_arrayIndex	block_timestamp	transaction_hash
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	0xdbf31df14b66535af65aac99c32e9ea844e14501	10	5984007	0x580eccb127b287cffdcb8935bc5fc7e9ec0b4123	6	2022-02-13T14:43:59.000Z	0xbe5ca670f3238c11ab9715dba2a2b1471324a17348e0bea037eb40b059e387e8
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	0x8d9ba570d6cb60c7e3e0f31343efe75ab8e65fb1	10	5998399	0x86f2d48ab653d192ac8395d7a92439beb43337cb	133	2022-02-13T19:48:37.000Z	0x1a78774f0956b9276f3c2aad1f0220f72e8c18f40b776a4a4e2d31a4e27a32d5
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	0x8d9ba570d6cb60c7e3e0f31343efe75ab8e65fb1	10	6004688	0x870dc279570833a8c5a72fc7972681db9a96cfb7	134	2022-02-13T22:29:40.000Z	0xf3d9d4174badd31ab982b8b07ab0bba20b8dfb7db7a8e1c8941aeeecf9ba9cfe

Example Query

Query with partition filter

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

BorrowerOperations_TroveUpdated_event

Trove position updates from Vesta Finance lending protocol on Arbitrum, capturing collateral deposits, debt changes, and stake modifications for CDP (Collateralized Debt Position) management. Tracks borrower operations including opens, adjusts, and closes across various collateral assets.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__debt`	`STRING`	Amount of debt owed in the borrowing position denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains.
`in__coll`	`STRING`	Amount of collateral in the borrowing position denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains.
`in_stake`	`STRING`	Amount of staked or collateralized tokens denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains or lamports for Solana.
`in_operation`	`INT64`	Enumerated operation type identifier for the event. Integer code representing the specific operation that triggered the event.

Sample Data

address	removed	in__coll	in_stake	in__asset	log_index	block_number	in__borrower	in_operation	block_timestamp	transaction_hash
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	1250000000000000022	1250000000000000022	0x0000000000000000000000000000000000000000	4	42434889	0xdf56ebd20f80ddd95b729ded241b5c58197a1ba2	2	2022-11-30T12:32:29.000Z	0x0f3d66d78deeea500e2d34a2bd4b3ba11be2b661fc34034a208bd01b01b1f86f
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	11006299999999999970	11006299999999999970	0x0000000000000000000000000000000000000000	4	42401158	0x83f17d3eb2d69091de3677432626f55491f219f8	2	2022-11-30T09:49:07.000Z	0xd6d935826d4d2d467bb1bd9e79175c0e501531dbbfc58d09561a5657d0a893a5
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	21999999999999999837	21999999999999999837	0x0000000000000000000000000000000000000000	4	42337639	0x020eb226e93362d1304bc97a3dd07231b1cdf097	2	2022-11-30T04:08:08.000Z	0x7d66a6a3aa1e1f768410739ed0faad937078cf5d0c47cacca6d8de5de72e204a

Example Query

Query with partition filter

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

BorrowerOperations_VaultParametersBaseChanged_event

Vault parameter base address update events from Vesta Finance borrowing protocol on Arbitrum. Tracks configuration changes to vault parameters contracts, useful for monitoring protocol upgrades and governance 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_newAddress`	`STRING`	Address of the newly set vault parameters base contract in the Vesta protocol. Hex-encoded, 0x-prefixed 40-character string representing the smart contract that defines base configuration parameters for vaults.

Sample Data

address	removed	log_index	block_number	in_newAddress	block_timestamp	transaction_hash
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	1	5559513	0x5f51b0a5e940a3a20502b5f59511b13788ec6ddb	2022-02-07T09:12:38.000Z	0x45ecb89d6bfce18d2bc72775995a697329de58bb99a926339b10d32f99341fbc

Example Query

Query with partition filter

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

BorrowerOperations_VSTBorrowingFeePaid_event

VST stablecoin borrowing fee payments from Vesta Finance on Arbitrum, showing fees charged when users borrow VST against collateral assets. Useful for analyzing borrowing costs, protocol revenue, and fee structures across different collateral types.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__VSTFee`	`STRING`	Fee amount paid in VST (Vesta Stablecoin) for borrowing against collateral. String-encoded integer value, often zero in sample transactions.

Sample Data

address	removed	in__asset	log_index	block_number	in__borrower	block_timestamp	transaction_hash
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	0x0000000000000000000000000000000000000000	43	127473912	0x3513c20348ba5c50d721803fe6d05f2bb4ebb569	2023-09-02T22:29:47.000Z	0xee4b4306f367e96225033d75df885c7e64b966ee871ce85398369a649c06c76c
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	0x0000000000000000000000000000000000000000	49	127178102	0x2ac74bd02ee017fa05629432dd3728720c455032	2023-09-02T00:12:37.000Z	0xa57734c5f61ead2a2e5d3b9530ac2f5b546236b1d585c057198ffbbc33245eff
0x3eedf348919d130954929d4ff62d626f26adbfa2	false	0x5979d7b546e38e414f7e9822514be443a4800529	43	127204864	0x26bfd9a8126047621726d818355c72e0bf6ef4f3	2023-09-02T02:30:01.000Z	0xda85b19c61d65bfc9964d5d9b8b8d5f249b789ec1e3a3753b69d91dd1c248a22

Example Query

Query with partition filter

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

DefaultPool_DefaultPoolVSTDebtUpdated_event

VST stablecoin debt balance updates in Vesta Finance’s default pool contract on Arbitrum, tracking collateral asset-specific debt positions. Used for monitoring protocol health and liquidation pool liabilities across different collateral types.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__VSTDebt`	`STRING`	Updated VST (Vesta Stable) debt amount for the specified asset in the Default Pool, stored as a string-encoded integer. Typically zero in the Default Pool, which holds liquidated collateral and debt from defaulted positions.

Sample Data

address	removed	in__asset	log_index	block_number	block_timestamp	transaction_hash
0x996b43aadd750371ff81cb1100f7dcb6d3321247	false	0x8d9ba570d6cb60c7e3e0f31343efe75ab8e65fb1	2	5988672	2022-02-13T16:12:04.000Z	0xb0d59bb472625a800c238bae7e6e5d76da7094e34a4b1fa43cbb9df544f6d260
0x996b43aadd750371ff81cb1100f7dcb6d3321247	false	0x8d9ba570d6cb60c7e3e0f31343efe75ab8e65fb1	2	5991649	2022-02-13T17:12:29.000Z	0x72761bd209a53a8925fb4be8c6ecaeb2542c9f72047df7961e31ee6d4d086348
0x996b43aadd750371ff81cb1100f7dcb6d3321247	false	0x0000000000000000000000000000000000000000	1	65172871	2023-02-27T19:01:19.000Z	0xcdb3ca00b4032d914460ed9897496b9d908183a06f5de4e5a15ca863e1f2ee5c

Example Query

Query with partition filter

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

InterestManager_DebtChanged_event

Debt position change events from Vesta Finance lending protocol on Arbitrum, recording updated debt balances per user and collateral token. Used to track borrowing activity, loan modifications, and collateral-specific debt exposure across 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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_newDebt`	`STRING`	Updated debt balance for the specified user and token after the transaction. Value is denominated in the smallest unit of the token (wei-equivalent) and stored as a string to handle large integers.

Sample Data

address	in_user	removed	in_token	log_index	block_number	block_timestamp	transaction_hash
0x0f5d5e424765bf3b49f932f0e9b8e6f3791d33b1	0x7c23abfa0d6b41972a3d5d627c60ff2bc2dd8690	false	0x0000000000000000000000000000000000000000	21	66523820	2023-03-04T00:01:19.000Z	0xb3271c30878284601707a0313c8d34c3c31f88e0444f3d20f1d2a6127031ecde
0x0f5d5e424765bf3b49f932f0e9b8e6f3791d33b1	0xda36cc4136a24035d2fa1e35873cfb6b4ebf4321	false	0x0000000000000000000000000000000000000000	21	66564943	2023-03-04T03:23:20.000Z	0xbcd7e9026e7ef17419591f653327bf69473ea6714a03410b4dc684b4f4578f46
0x0f5d5e424765bf3b49f932f0e9b8e6f3791d33b1	0x01eda16f6a6c3b051ecc63b0d93c8c3a27491dc2	false	0x0000000000000000000000000000000000000000	33	66618044	2023-03-04T07:28:40.000Z	0x9e7f526ea6452191cec048a57197a0977b14d39e7ae277c697b6711c46d8465e

Example Query

Query with partition filter

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

InterestManager_InterestMinted_event

Interest accrual events from Vesta Finance protocol on Arbitrum, recording the amount of interest minted per lending module. Used to track protocol revenue generation and borrowing costs across different collateral types.

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_module`	`STRING`	Contract address of the Vesta module that accrued interest in this event. Hex-encoded, 0x-prefixed 40-character string identifying the specific lending or collateral module.
`in_interestMinted`	`STRING`	Amount of interest minted in the smallest token unit (wei) for the specified module. Represented as an 18-decimal fixed-point integer string, typically in the range of hundreds of quadrillions of wei.

Sample Data

address	removed	in_module	log_index	block_number	block_timestamp	transaction_hash	in_interestMinted
0x0f5d5e424765bf3b49f932f0e9b8e6f3791d33b1	false	0x3b19ed9c13112cdab31be7972971382f5418f51d	4	79586091	2023-04-12T05:54:24.000Z	0xb234482b0a0c2f16ff4af14b2b450f156cde41d8df22efb2c7313306f74f1ee2	360757905241952320
0x0f5d5e424765bf3b49f932f0e9b8e6f3791d33b1	false	0xf5ecb997039bb1d2c1dd826a7b1609b0fb5a4018	16	79586091	2023-04-12T05:54:24.000Z	0xb234482b0a0c2f16ff4af14b2b450f156cde41d8df22efb2c7313306f74f1ee2	1531290592477868346
0x0f5d5e424765bf3b49f932f0e9b8e6f3791d33b1	false	0x740e3de7bfa7f09b61ab4ce00b59ebd9267af031	7	79586091	2023-04-12T05:54:24.000Z	0xb234482b0a0c2f16ff4af14b2b450f156cde41d8df22efb2c7313306f74f1ee2	1151086157853268543

Example Query

Query with partition filter

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

PriceFeed_TokenPriceUpdated_event

Oracle price feed updates from Vesta Finance lending protocol on Arbitrum. Tracks token price changes in 18-decimal wei format for collateral and stablecoin valuation in CDP (Collateralized Debt Position) management.

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`	Contract address of the token. Hex-encoded, 0x-prefixed, 42-character string.
`in__price`	`STRING`	Price of the token denominated in wei (18 decimal places), representing the updated oracle price at the time of the event. Values typically range from sub-dollar (e.g., 0.98) to several dollars per token when divided by 10^18.

Sample Data

address	removed	in__price	in__token	block_number	block_timestamp	transaction_hash
0xd218ba424a6166e37a454f8ece2bf8eb2264ecca	false	987392298563071083	0x2f546ad4edd93b956c8999be404cdcafde3e89ae	121997947	2023-08-16T16:00:52.000Z	0x13d720137904c16b61b86098ef36795974ef53261f5b4d67479bcc2d4f6178a7
0xd218ba424a6166e37a454f8ece2bf8eb2264ecca	false	996716570000000000	0x64343594ab9b56e99087bfa6f2335db24c2d1f17	121896573	2023-08-16T08:48:48.000Z	0x0470c28a0f4593acccd375f0a2456a5b015b68c107c6b21b13149e7828cd52d2
0xd218ba424a6166e37a454f8ece2bf8eb2264ecca	false	996716570000000000	0x64343594ab9b56e99087bfa6f2335db24c2d1f17	121899406	2023-08-16T09:00:51.000Z	0x1b7c311c56b080c5c4a266986d16097906a34e2674a4d19faa99a3cac5f1fa31

Example Query

Query with partition filter

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

SavingModule_PoolUpdated_event

Reward distribution events from Vesta Finance’s savings module on Arbitrum, tracking VST stablecoin allocations and rewards added to the savings pool. Useful for analyzing yield accrual patterns and total value locked in Vesta’s savings product.

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_addedReward`	`STRING`	Reward amount added to the savings pool in this update, denominated in the smallest unit (wei-equivalent) of the VST stablecoin. Values are 18-decimal fixed-point integers representing token quantities added during each pool update event.
`in_totalAllocatedVST`	`STRING`	Total amount of VST (Vesta Stablecoin) tokens allocated in the savings pool at the time of this update, denominated in wei (18 decimals). This cumulative value increases with each reward addition as shown by consistent growth across events.

Sample Data

address	removed	log_index	block_number	in_addedReward	block_timestamp	transaction_hash	in_totalAllocatedVST
0x6c7511f378867225fafea0cc8e862bd344d5d1b0	false	24	99835918	2882070298297586962	2023-06-10T20:35:08.000Z	0x207299293179ccb760b75a0d3500881744c8f9aa1e596c75b4f086b6145a3d58	2762612704881985881889
0x6c7511f378867225fafea0cc8e862bd344d5d1b0	false	24	99812370	1386523194994856649	2023-06-10T18:54:20.000Z	0x53d30bf7eb107b8e2c0851aecf59ab5c34e3513382700650667a5a8f1b030210	2753343055044077244109
0x6c7511f378867225fafea0cc8e862bd344d5d1b0	false	24	99612722	233949176041334789	2023-06-10T05:03:09.000Z	0x1699fc72b102b951254b569bddff23d121f04d1dd59d8ed0487e1763530237e6	2668820425030563940019

Example Query

Query with partition filter

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

SavingModule_ShareUpdated_event

Events tracking share balance updates in the Vesta Finance savings module on Arbitrum, recording when user share positions change with their input values in wei. Useful for analyzing user deposit/withdrawal activity and calculating share-based yield 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_val`	`STRING`	Updated share value in the Vesta SavingModule contract, represented in wei (smallest token unit). Values typically range from fractional amounts (2000000000000000) to large deposits (50000000000000000000000), indicating share balance changes.

Sample Data

in_val	address	removed	log_index	block_number	block_timestamp	transaction_hash
15047587018152891635	0x6c7511f378867225fafea0cc8e862bd344d5d1b0	false	23	74542616	2023-03-28T11:09:07.000Z	0xa3ee02ae362fe531e398c90b0acf70526716a72996b86b8986ad38dca8de9b2e
15047587018152891635	0x6c7511f378867225fafea0cc8e862bd344d5d1b0	false	22	74542616	2023-03-28T11:09:07.000Z	0xa3ee02ae362fe531e398c90b0acf70526716a72996b86b8986ad38dca8de9b2e
2533900000000000000	0x6c7511f378867225fafea0cc8e862bd344d5d1b0	false	6	58665472	2023-02-07T02:27:17.000Z	0x87a2085736d7e36b2f7f5c0a295e354c872cce86a8c3ead53e13afdcf4337469

Example Query

Query with partition filter

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

SavingModule_UserClaimed_event

User reward claim events from Vesta Finance’s savings module on Arbitrum, tracking when users withdraw accrued rewards from locked positions. Used for analyzing yield distribution patterns and user withdrawal behavior across lock 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_lockId`	`STRING`	Unique identifier for the locked position within Vesta’s savings module on Arbitrum. Numeric string representing the lock ID associated with the claimed rewards.
`in_claimed`	`STRING`	Amount of tokens or rewards claimed in the transaction. String-encoded integer representing the claimed value in smallest token units.

Sample Data

address	in_user	removed	in_lockId	log_index	in_claimed	block_number	block_timestamp	transaction_hash
0x6c7511f378867225fafea0cc8e862bd344d5d1b0	0xf5d13b0477c1ca0722cf1ed8879cc3c26530c5e9	false	991	3	4121077255198140	203123643	2024-04-20T23:08:49.000Z	0x4b0848caeb85c6cc42c559ed3a45eaec489c0609fb6912e318dc74d1407f2c10
0x6c7511f378867225fafea0cc8e862bd344d5d1b0	0xa3ced3709b4165953cac07cf8dec515994f52f3c	false	1322	67	1369485632968805	124849168	2023-08-25T14:17:32.000Z	0xa27a0a9d50e73c5f3eb462e9eea99a2406b377e212bdfb0745f06d0259f8b850
0x6c7511f378867225fafea0cc8e862bd344d5d1b0	0x8d5c85c58c85d4600e61776b71695f055e09c703	false	930	16	262865281035000	107709282	2023-07-04T06:49:13.000Z	0x57edaa83eea0c6d1e09d873e738e77054caa16824aac4d4fda758ce149173201

Example Query

Query with partition filter

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

SavingModule_VSTReceveidFromVRR_event

VST (Vesta stablecoin) transfer events from the VRR (Vesta Revenue Reserve) to the Saving Module contract on Arbitrum. Used to track revenue distribution flows and analyze protocol earnings allocation in the Vesta Finance 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_receivedVST`	`STRING`	Amount of VST tokens received from the VRR (Vesta Revenue Reserve) by the Saving Module contract. Value is denominated in wei (smallest unit), requiring division by 10^18 to get the human-readable VST amount.

Sample Data

address	removed	log_index	block_number	in_receivedVST	block_timestamp	transaction_hash
0x6c7511f378867225fafea0cc8e862bd344d5d1b0	false	19	70263918	1905700038508032001	2023-03-16T02:39:27.000Z	0xfa25c382222bbd09005cfe0e35d0e67e1c9ea9daa1ab9807e2227e214db48e49
0x6c7511f378867225fafea0cc8e862bd344d5d1b0	false	19	70384476	716403728798236397	2023-03-16T11:10:09.000Z	0xc20557e57b7b02187979fd8a99d6a3f636fbb0d75e2e2baa9713964b033b2866
0x6c7511f378867225fafea0cc8e862bd344d5d1b0	false	19	70464905	4538597594521212260	2023-03-16T16:41:09.000Z	0xf52483094dc0beab6e0ec53d2ebfe2da128076a042cb643d27109cd6a7a8a1e8

Example Query

Query with partition filter

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

StabilityPool_DepositSnapshotUpdated_event

Stability pool deposit snapshot updates from Vesta Finance on Arbitrum, tracking product terms (P), sum snapshots (S), and gain parameters (G) for each depositor account. Used for analyzing stability pool participation, liquidation gains distribution, and depositor position changes 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__depositor`	`STRING`	Address of the user who made the deposit into the stability pool. Hex-encoded, 0x-prefixed, 42-character string.
`in__P`	`STRING`	Product variable P representing the scaling factor for stability pool deposits at the time of snapshot. Used in Vesta Finance’s stability pool accounting to track deposit value changes over time.
`in__S`	`STRING`	Snapshot value of the sum of asset balances per unit staked in Vesta’s stability pool at the time of the deposit update. Typically a large integer value, with 0 indicating initial deposits or pool resets.
`in__G`	`STRING`	Product of reward snapshots used to track accumulated gains for the depositor in Vesta’s stability pool. Large integer values indicate cumulative reward state at the time of deposit update.

Sample Data

in__G	in__P	in__S	address	removed	log_index	block_number	in__depositor	block_timestamp	transaction_hash
162691038286171486005357009741186	141759327221973298	2320581804218272730638203396077118	0x0b1be49dcb62d6cbc27e510361e910a8a30f37a9	false	11	78887227	0x12924049e2d21664e35387c69429c98e9891a820	2023-04-10T04:50:13.000Z	0x08a9514673366b3e1b4615c4ec7616e9cfb9a59edcce64444cddd81f0ef8d1f5
162811702854271262101198390379428	141759327221973298	2320581804218272730638203396077118	0x0b1be49dcb62d6cbc27e510361e910a8a30f37a9	false	10	79120116	0x0b6d90463eca29dee0b945d496f3352db72fdc1b	2023-04-10T21:01:16.000Z	0xafdd807d5c5b09d924ee2d1ed63e74d96be0f9065d3122bc2fbd8d090cad73db
0	1000000000000000000	0	0x2a8b4700e6aa7ea523c3307fe8b57f0fc8fc5e82	false	22	78922371	0x8993425e638e9d290a9463887f03f00be01c1b00	2023-04-10T07:17:45.000Z	0x6c64f92f5e5a5e8b2847e527ff82a1f34874da9c81c19378d210e1e88f8a7830

Example Query

Query with partition filter

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

StabilityPool_StabilityPoolVSTBalanceUpdated_event

Balance updates for VST (Vesta stablecoin) deposits in the Stability Pool on Arbitrum. Used to track user deposits, withdrawals, and liquidation gains across the protocol’s stability mechanism.

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__newBalance`	`STRING`	New balance after the event or transaction. String-encoded integer representing the balance in smallest unit (wei for ETH, base units for tokens).

Sample Data

address	removed	log_index	block_number	in__newBalance	block_timestamp	transaction_hash
0x2a8b4700e6aa7ea523c3307fe8b57f0fc8fc5e82	false	5	69568579	500000000000000000	2023-03-13T23:05:20.000Z	0x2e08856c66b507e58b8e06780aec5ee2417c517681fdb84addc41036d76903de
0x0b1be49dcb62d6cbc27e510361e910a8a30f37a9	false	6	69468545	31405140200427026054080	2023-03-13T14:57:06.000Z	0x1e7cbc1e663f58f6e2c0faf7d3d49f07f65889a0e9532a8841445d28ed71157d
0x78d46cecf0ae4757f430d95b2d7eaa18d7087872	false	6	69515366	39536588071532408398489	2023-03-13T18:30:06.000Z	0x541db6089eb2d9729668f3988ba8b9eb61d5441538f35eacf188142fa4c821fd

Example Query

Query with partition filter

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

StabilityPool_SystemSnapshotUpdated_event

System snapshot events from Vesta Finance’s Stability Pool on Arbitrum tracking product-of-scale factors (P) and epoch-to-scale-to-sum values (G). Used for calculating staker rewards and losses in the collateralized debt position 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__P`	`STRING`	Product scale factor for the Stability Pool at snapshot time. This internal scaling parameter maintains numerical precision during reward calculations, typically starting at 1e18 (wei precision) and decreasing as liquidations occur.
`in__G`	`STRING`	Snapshot value of accumulated gains (G) in Vesta’s StabilityPool at the time of system state update. Expressed as an integer with 18 decimal places of precision, tracking cumulative ETH or asset gains per deposited stablecoin unit.

Sample Data

in__G	in__P	address	removed	log_index	block_number	block_timestamp	transaction_hash
130952724908583559095949227645137	202505828631051681	0x0b1be49dcb62d6cbc27e510361e910a8a30f37a9	false	3	25161538	2022-09-18T18:50:55.000Z	0x0c211cd8d62763356bdb4ffbccac8f57806f40c44c9ac8597decd85544de9ee2
130963427261108570161126249814408	202505828631051681	0x0b1be49dcb62d6cbc27e510361e910a8a30f37a9	false	3	25177274	2022-09-18T21:26:50.000Z	0x9d856c8a92b6f7fed12acfe13e0dd1d7d34677c40e8c45b68c6408cd128dc6f9
130972883575777613324599568377343	202505828631051681	0x0b1be49dcb62d6cbc27e510361e910a8a30f37a9	false	3	25189615	2022-09-18T23:40:31.000Z	0x0392d45b0c621c2087deda4bd592459a7a8411df6128de081b0a19e3ac409ade

Example Query

Query with partition filter

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

StabilityPool_UserDepositChanged_event

Deposit change events from Vesta Finance Stability Pool on Arbitrum, tracking when users add or withdraw stablecoin deposits with updated balance amounts. Used for analyzing liquidity provision patterns and stability pool participation 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__depositor`	`STRING`	Address of the user who made the deposit into the stability pool. Hex-encoded, 0x-prefixed, 42-character string.
`in__newDeposit`	`STRING`	Updated deposit balance for the user in the Vesta stability pool, denominated in the smallest unit of the stablecoin (typically 18 decimals). Can be zero when user fully withdraws their position.

Sample Data

address	removed	log_index	block_number	in__depositor	in__newDeposit	block_timestamp	transaction_hash
0x64ca46508ad4559e1fd94b3cf48f3164b4a77e42	false	8	18116376	0x394b67c6bc05abb14c73a57706dcd5cb85231c4e	200000000000000000000	2022-07-20T14:08:03.000Z	0xe1e601551ac3ff7d96d375cca9def87320c87da768f57ff88f742d93c7f97f38
0x6e53d20d674c27b858a005cf4a72cfaaf4434ecb	false	8	18135738	0x0561a78021d8966ddd20c28c6c4318d8675ee1f0	99840160000000000000000	2022-07-20T19:25:28.000Z	0x69e13e7c423347217898b2c7e2d7534262f341afa069ddd7696f2882260db548
0x64ca46508ad4559e1fd94b3cf48f3164b4a77e42	false	9	18132171	0x697f21718a14a93bd76b1b97b32dc02f1f3ff382	1542220000000000000000	2022-07-20T18:13:25.000Z	0x237d44675aa27678e44b441e32c7b27154070526da5902e0890f6088c4cd96f3

Example Query

Query with partition filter

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

StabilityPool_VSTAPaidToDepositor_event

VSTA token reward distributions from Vesta Finance’s Stability Pool on Arbitrum, tracking governance token payments to depositors. Used for analyzing protocol incentive payouts and depositor rewards 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__depositor`	`STRING`	Address of the user who made the deposit into the stability pool. Hex-encoded, 0x-prefixed, 42-character string.
`in__VSTA`	`STRING`	Amount of VSTA tokens paid to the depositor as rewards from the Vesta stability pool. Value is in the smallest token unit (wei equivalent) and may be zero when no rewards are distributed.

Sample Data

address	removed	log_index	block_number	in__depositor	block_timestamp	transaction_hash
0x64ca46508ad4559e1fd94b3cf48f3164b4a77e42	false	1	117960781	0x0506312083c0b558dc0849cb28324074da62b48b	2023-08-04T04:50:03.000Z	0xf69d080f9a33f7f5568dbabfef5cdf799d627f2168439360998f98d4ab9996e9
0x64ca46508ad4559e1fd94b3cf48f3164b4a77e42	false	1	117959750	0x0506312083c0b558dc0849cb28324074da62b48b	2023-08-04T04:45:30.000Z	0xd8d128d752e50239fa988fa71cadad4815323ec57bee671b15cdae273182bff4
0x64ca46508ad4559e1fd94b3cf48f3164b4a77e42	false	31	117961256	0x0506312083c0b558dc0849cb28324074da62b48b	2023-08-04T04:52:08.000Z	0x16b73fcb366c8b1fb99b3e07d825cb5367086afbd557df11590084bdb7cfc9b6

Example Query

Query with partition filter

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

Treasury_SafeReceived_event

SafeReceived events from the Vesta Finance protocol treasury on Arbitrum, tracking incoming transfers with sender addresses and transfer amounts. Used for monitoring treasury inflows and revenue analysis.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x4a4651b31d747d1ddbddadcf1b1e24a5f6dcc7b0	false	461053299890212	0xb9b8f95568d5a305c6d70d10cc1361d9df3e9f9a	28	39335273	2022-11-19T14:05:14.000Z	0xba360c3264be3c9fba7b259faac4dbc1575f20ed80101177bc1a2b54d4526f78
0x4a4651b31d747d1ddbddadcf1b1e24a5f6dcc7b0	false	8420051370656676	0xb9b8f95568d5a305c6d70d10cc1361d9df3e9f9a	28	39181765	2022-11-19T01:14:24.000Z	0xf4b6f0b1fa1250b7ff43b754f7f5d4597d332ce9c7a0330a8f9b7dbb872a45af
0x4a4651b31d747d1ddbddadcf1b1e24a5f6dcc7b0	false	27055311527542	0xb9b8f95568d5a305c6d70d10cc1361d9df3e9f9a	34	39415149	2022-11-19T19:43:19.000Z	0x83a7641b6ebaa3d1c812be55d6e4a2d179edb064a69a3c34a82f0a6c41a4979e

Example Query

Query with partition filter

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

VaultManager_BaseRateUpdated_event

Base rate parameter changes for collateral assets in Vesta Finance’s lending protocol on Arbitrum. Tracks interest rate adjustments per asset used for calculating borrowing costs in the protocol’s vault 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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__baseRate`	`STRING`	Base interest rate applied to borrowing positions for the specified asset in Vesta Finance’s vault system. Stored as a string-encoded integer (commonly ‘0’ in samples), representing the rate before any additional fees or adjustments.

Sample Data

address	removed	in__asset	log_index	block_number	block_timestamp	transaction_hash
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	1	58786006	2023-02-07T12:04:00.000Z	0x4e70e7aa8653cad0267dec656faf2d085a163fb826879de15917636c62caae1a
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	1	58728057	2023-02-07T07:49:33.000Z	0x794bf480decddcd1394d6653f9ad4049ff20a19ae07356d337e2bc87ee89350b
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	1	58675065	2023-02-07T03:17:54.000Z	0x0648264adbff01452ffd9626c48d875c3cbcd00562d7a1f16c82e643c86d95e4

Example Query

Query with partition filter

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

VaultManager_Liquidation_event

Liquidation events from Vesta Finance’s vault management protocol on Arbitrum, recording undercollateralized position closures with seized collateral amounts, repaid debt (VST stablecoin), and gas compensation rewards. Used for analyzing liquidation cascades, vault health metrics, and liquidator profitability across different collateral types.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__liquidatedDebt`	`STRING`	Amount of VST stablecoin debt liquidated from the vault, denominated in wei (18 decimals). Represents the outstanding debt position closed during liquidation to restore protocol collateralization ratios.
`in__liquidatedColl`	`STRING`	Amount of collateral seized from the liquidated position, denominated in the smallest unit of the collateral asset token. Typically ranges from small fractions to thousands of tokens depending on position size and asset decimals.
`in__collGasCompensation`	`STRING`	Gas compensation paid in collateral token to the liquidator for executing the liquidation transaction. Denominated in the smallest unit of the collateral asset (wei-equivalent), with values typically ranging from 3-40 tokens based on liquidation size.
`in__VSTGasCompensation`	`STRING`	VST stablecoin amount paid to the liquidator as gas compensation for executing the liquidation transaction. Denominated in wei (18 decimals), commonly 30 VST in earlier liquidations and 0 in more recent events.

Sample Data

address	removed	in__asset	log_index	block_number	block_timestamp	transaction_hash	in__liquidatedColl	in__liquidatedDebt	in__VSTGasCompensation	in__collGasCompensation
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x6c2c06790b3e3e3c38e12ee22f8183b37a13ee55	19	10988921	2022-05-01T21:30:25.000Z	0xaf5ebf0a3b815bd3831fc1229d878daefb2506b91442607c900bbd1f83f10225	598158000000000000	354000000000000000000	30000000000000000000	6042000000000000
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	19	7840509	2022-03-13T12:38:30.000Z	0xa61d2eaab8fba13df58bc1d009a6474386f0bc6dad3c6007d418f5e2e906b069	297000000000000000	693300000000000000000	30000000000000000000	3000000000000000
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x8d9ba570d6cb60c7e3e0f31343efe75ab8e65fb1	20	7861342	2022-03-13T23:53:24.000Z	0xf13022e22f6b8cc003b4ae1ab3678726d505daa5dbb95e6e15ac083a75986575	323103030303030304	536250000000000000000	30000000000000000000	10096969696969696

Example Query

Query with partition filter

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

VaultManager_Redemption_event

VST stablecoin redemption events from Vesta Finance on Arbitrum, recording when users burn VST tokens to reclaim collateral assets with attempted amounts, actual amounts redeemed, assets received, and protocol fees charged.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__attemptedVSTAmount`	`STRING`	VST stablecoin amount (wei-denominated) that the user requested to redeem in this transaction. May differ from actual amount redeemed if the redemption was partially filled due to liquidity constraints.
`in__actualVSTAmount`	`STRING`	Actual amount of VST (Vesta Stable Token) redeemed in the transaction, denominated in wei (18 decimals). This is the VST amount successfully burned in exchange for collateral assets.
`in__AssetSent`	`STRING`	Amount of collateral asset sent to the redeemer in exchange for their VST stablecoin. Value is in the smallest unit of the asset (wei for ETH, base units for tokens) and excludes the redemption fee.
`in__AssetFee`	`STRING`	Fee charged in the collateral asset for processing the redemption, denominated in the asset’s smallest unit (wei-equivalent). Typically represents 0.5% of the redeemed collateral amount based on sample values.

Sample Data

address	removed	in__asset	log_index	block_number	in__AssetFee	in__AssetSent	block_timestamp	transaction_hash	in__actualVSTAmount	in__attemptedVSTAmount
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	12	11628221	47664696879114	8763205054616675	2022-05-09T18:50:53.000Z	0x7242ad939d71556d2d398b9d7a0ff60a63bf325f529ddac4a022ac65102bdf0b	20000000000000000000	20000000000000000000
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	12	11542825	1991334075233	396746437404221	2022-05-09T00:03:23.000Z	0x6b95309335e852b5393d0567f5008d4680bf3004eda676f286441ca6e7d67bb8	999999999999887200	999999999999887200
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	13	11635235	237172057581954	43787832408613645	2022-05-09T20:21:03.000Z	0x2726f5f5f13b37d0a8faa3d6df6dc36130f831405e0fd6556e2c67660d15d9a2	101598148904264500000	101598148904264500000

Example Query

Query with partition filter

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

VaultManager_SystemSnapshotsUpdated_event

System-wide collateral and stakes snapshots from Vesta Finance collateralized debt position (CDP) protocol on Arbitrum. Tracks aggregate position metrics per asset for monitoring protocol solvency and liquidation risk.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__totalStakesSnapshot`	`STRING`	Snapshot of the total staked amount across all positions for the specified asset at this event, denominated in the asset’s smallest unit (wei for ETH). Values represent 18-decimal fixed-point integers tracking aggregate protocol collateral stakes.
`in__totalCollateralSnapshot`	`STRING`	Total collateral amount held by the Vesta protocol vault for the specified asset at the time of the snapshot. Denominated in the asset’s smallest unit (wei for ETH), matching the total stakes value in most observations.

Sample Data

address	removed	in__asset	log_index	block_number	block_timestamp	transaction_hash	in__totalStakesSnapshot	in__totalCollateralSnapshot
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	17	30816558	2022-10-18T15:43:44.000Z	0x47de828e1f8087244862dcbb682a9c1da01dabc60da166736d8823ef9b037e1d	798313133193950874458	798313133193950874458
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	16	14556923	2022-06-14T01:55:02.000Z	0xbfb631a7cba028d558f42132a6b501cc48483ad10ef2fa2ebf8ad6d895b32c62	2593796762075974624725	2593796762075974624725
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	17	14559817	2022-06-14T02:27:21.000Z	0xb56878fc02aa555034e23c6b54303f26c2d808e1fd52fa072b6589da73863004	2596691762075974624015	2596691762075974624015

Example Query

Query with partition filter

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

VaultManager_SystemUnpaidInterestUpdated_event

Event logs tracking accrued but unpaid interest updates in Vesta Finance lending vaults on Arbitrum. Records interest accumulation per collateral asset for monitoring protocol debt and interest rate analytics.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_unpaidInterest`	`STRING`	Accumulated unpaid interest amount for the specified asset in the Vesta vault system, denominated in the asset’s smallest unit (wei-equivalent). This value represents outstanding interest that has accrued but not yet been paid or settled.

Sample Data

address	removed	in__asset	log_index	block_number	block_timestamp	transaction_hash	in_unpaidInterest
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x5979d7b546e38e414f7e9822514be443a4800529	49	94129989	2023-05-25T01:36:40.000Z	0xcb6d1cda7ce76f969582c4ffaab85eee4c240a0c7dea4c0a2909398c493f2373	10860538633116296395
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x5979d7b546e38e414f7e9822514be443a4800529	29	94151658	2023-05-25T03:08:14.000Z	0xa14af72c1b163fc67d129196ce2ecdaa43d044715704dbe60871edd068da646d	10860538633116296395
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x5979d7b546e38e414f7e9822514be443a4800529	39	94385515	2023-05-25T19:20:21.000Z	0x5b7fb492f76db52074bae4183c96ac609bdfbbb6d0d82ac187b1734515b7c746	11482377888762523523

Example Query

Query with partition filter

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

VaultManager_TotalStakesUpdated_event

Total collateral stakes update events from Vesta Finance’s VaultManager contract on Arbitrum, tracking aggregate staked amounts by asset address. Used for monitoring protocol-wide collateral positions and calculating total value locked (TVL) across different collateral types including ETH and DPX tokens.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__newTotalStakes`	`STRING`	Updated total amount of stakes held by the vault manager for the specified asset. Denominated in the asset’s smallest unit (wei for ETH), represented as a string to handle large integer values.

Sample Data

address	removed	in__asset	log_index	block_number	block_timestamp	transaction_hash	in__newTotalStakes
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	1	114764646	2023-07-25T10:20:06.000Z	0x929ecd5bfd547a0ec0325b83b3fe9d8fbbf6d80930e74fca28cb78e72e43b34a	1319795582758532982961
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	1	114948480	2023-07-25T23:59:43.000Z	0xe3c48cf96cf36b097eba3ccb1d707f29318c1c5dbd13127d6a5ce8e26e309989	1336812309346057040688
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x6c2c06790b3e3e3c38e12ee22f8183b37a13ee55	1	114926209	2023-07-25T22:14:03.000Z	0x5ddc1bbf0c93d187b755cd947a0c0a65e2cfc87e81183987ab5c15f010b56798	10132127238000000457620

Example Query

Query with partition filter

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

VaultManager_TroveLiquidated_event

Liquidation events from Vesta Finance collateralized debt positions (Troves) on Arbitrum, recording borrower addresses, liquidated collateral amounts, debt values, and asset types. Used for analyzing liquidation patterns, collateral ratios, and protocol risk across multiple collateral assets.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__debt`	`STRING`	Amount of debt owed in the borrowing position denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains.
`in__coll`	`STRING`	Amount of collateral in the borrowing position denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains.
`in_operation`	`INT64`	Enumerated operation type identifier for the event. Integer code representing the specific operation that triggered the event.

Sample Data

address	removed	in__coll	in__debt	in__asset	log_index	block_number	in__borrower	in_operation	block_timestamp	transaction_hash
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	230000000000000000	300140846902381074078	0x0000000000000000000000000000000000000000	29	68347766	0x564715fbca8161ceaa756dadfc81238db4379a86	1	2023-03-09T22:52:40.000Z	0x3c78245857e71406e3f6c3994adaa4419ce6a9f339de8c9e1430fc4facf684e8
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	424868778000000000000	304045729790313830976	0x2f546ad4edd93b956c8999be404cdcafde3e89ae	74	68323982	0xfc13ab4b466f17f3e1e5443147de34d96ccf1629	1	2023-03-09T20:59:43.000Z	0xdc50248b8ecaa83394ac990b8857ee9fe3dc6a23cc2cd98f5fc6d879a5099430
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	446858951000000000000	324505351791334448539	0x2f546ad4edd93b956c8999be404cdcafde3e89ae	77	68320191	0x2993e1d02b11377f44455aedc618c705acbb0591	1	2023-03-09T20:43:57.000Z	0x44311effc7cf2cffaf794ccabfc74c16a47d4dc0e770edfc933b455dc51a2892

Example Query

Query with partition filter

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

VaultManager_TroveSnapshotsUpdated_event

Trove snapshot update events from Vesta Finance’s VaultManager contract on Arbitrum, tracking ETH collateral and VST (Vesta Stable) debt redistribution snapshots per asset. Used for analyzing collateralized debt position (CDP) risk distribution and liquidation accounting across different collateral types.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__L_ETH`	`STRING`	Cumulative ETH per unit staked snapshot value for the collateral pool, used in Vesta’s reward distribution calculations. String-encoded integer value, typically zero during snapshot updates.
`in__L_VSTDebt`	`STRING`	Cumulative VST debt redistribution snapshot for the Vesta protocol trove at the time of the event. String-encoded wei value, typically zero in sampled events indicating no debt redistribution has occurred.

Sample Data

address	removed	in__asset	log_index	block_number	block_timestamp	transaction_hash
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	7	12468906	2022-05-19T09:41:21.000Z	0x3fd9e99bb5d42a9e0a9c04dcc2da284c2cf0468de16833ee290d7c3de838bed6
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	20	12499292	2022-05-19T16:53:42.000Z	0x247a689a74d7f20055ccf7c80db669ed44ed722105a69ce5dee8616f04b8f89e
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	7	12470726	2022-05-19T10:05:14.000Z	0xa6eaf1f7d65ff4c911fbbeef2c2065a57ce3851c953e4d49e0d23d772e149f5d

Example Query

Query with partition filter

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

VaultManager_TroveUpdated_event

Collateralized debt position (CDP) state changes from Vesta Finance protocol on Arbitrum, tracking collateral amounts, debt levels, and operation types for borrower positions. Used for monitoring liquidation risk, collateralization ratios, and lending protocol health across different asset types.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__debt`	`STRING`	Amount of debt owed in the borrowing position denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains.
`in__coll`	`STRING`	Amount of collateral in the borrowing position denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains.
`in_stake`	`STRING`	Amount of staked or collateralized tokens denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains or lamports for Solana.
`in_operation`	`INT64`	Enumerated operation type identifier for the event. Integer code representing the specific operation that triggered the event.

Sample Data

address	removed	in__coll	in__debt	in_stake	in__asset	log_index	block_number	in__borrower	in_operation	block_timestamp	transaction_hash
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	233999487474298572552114	168026747056952772926383	233999487474298572552114	0x2f546ad4edd93b956c8999be404cdcafde3e89ae	49	32904329	0x54426307974b659b48e70b1faa44f17aa0e3c4cf	3	2022-10-27T01:51:18.000Z	0x47657caea08a15050f667f2c11972a3b0c6286eeb4cabac66115c0ec6f5e96c0
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	233747893387063960501214	167791608156952772926383	233747893387063960501214	0x2f546ad4edd93b956c8999be404cdcafde3e89ae	49	33110809	0x54426307974b659b48e70b1faa44f17aa0e3c4cf	3	2022-10-27T17:40:01.000Z	0x73a1da6b7c8235914236883efeb378737bcce68ca0dd7ce9100598c6b78fbc74
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	233999498167797650204865	168026757056952772926383	233999498167797650204865	0x2f546ad4edd93b956c8999be404cdcafde3e89ae	49	32896261	0x54426307974b659b48e70b1faa44f17aa0e3c4cf	3	2022-10-27T01:05:14.000Z	0x4f502094cafe0f18fd1951dbd04766a9ae4b9e3b02d0d3a767ee738ed41f0b76

Example Query

Query with partition filter

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

VaultManager_VaultParametersBaseChanged_event

Configuration change events from Vesta Finance’s VaultManager contract on Arbitrum, tracking updates to vault parameter base addresses. Records when parameter addresses are added or removed for analyzing protocol configuration history and governance 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_newAddress`	`STRING`	New base contract address set for vault parameters in the VaultManager system. Hex-encoded, 0x-prefixed 40-character Ethereum address on Arbitrum chain.

Sample Data

address	removed	log_index	block_number	in_newAddress	block_timestamp	transaction_hash
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	1	5559503	0x5f51b0a5e940a3a20502b5f59511b13788ec6ddb	2022-02-07T09:12:38.000Z	0xb67a524de80cd2b69ce1f714cf0548bdacd03b2315dfc85a9b3f17df0f2afca7

Example Query

Query with partition filter

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

VaultManager_VaultUnpaidInterestUpdated_event

Unpaid interest accrual updates for Vesta Finance collateralized debt positions (vaults) on Arbitrum, tracking interest amounts per vault and asset combination. Useful for analyzing borrowing costs and protocol revenue generation across different collateral types.

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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_unpaidInterest`	`STRING`	Accumulated unpaid interest amount for the vault denominated in the smallest unit of the asset. Stored as a string-encoded integer to handle large values; often zero when interest has been settled or no interest has accrued.

Sample Data

address	removed	in__asset	in__vault	log_index	block_number	block_timestamp	transaction_hash
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	0x6d29a57a27355946b04246d47686dc958b9c1368	20	43736286	2022-12-05T06:57:58.000Z	0x9ee2d5564493b57694272e0faf27f1ca0c6341601f05e067124ae9c4c31c1e5e
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	0x9a3d898491af730e03ec57f145150b8c552e9302	24	43730167	2022-12-05T06:22:02.000Z	0xca47b511448d1cf5b7d13344e3e2ceb1a6673fc81dc90fd30e9ed5fcf644b511
0x100ec08129e0fd59959df93a8b914944a3bbd5df	false	0x0000000000000000000000000000000000000000	0x992dac69827a200ba112a0303fe8f79f03c37d9d	29	43913190	2022-12-05T21:20:15.000Z	0x8a390b636fd5ea99b00d5672c2020cd2dd6b6b162bf8f893b19d7b3b59989e68

Example Query

Query with partition filter

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

VestaFarming_RewardPaid_event

Reward distribution events from Vesta Finance’s farming contract on Arbitrum, recording token rewards paid to liquidity providers. Used for tracking yield farming payouts and analyzing reward distribution patterns across staking participants.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x65207da01293c692a37f59d1d9b1624f0f21177c	0xf7411a3f727b36f56ff3a871163c21e56d672656	false	19837461930985001376492	7	132267958	2023-09-18T16:11:32.000Z	0x823bfb56e2a951475549e0ec7e8d04ed1a3d57d775f647cee2154dc8f952f475
0x65207da01293c692a37f59d1d9b1624f0f21177c	0x707acc9693237c9f6f200c3bf7c114803a6fc10f	false	233003021079333557777	11	132131092	2023-09-18T06:20:51.000Z	0x892afc4a594400c37969c816d3e2c55580268a6b826ecc9a36d003bed63bf8ed
0x65207da01293c692a37f59d1d9b1624f0f21177c	0x72ebe79ead612ebeb52912eede9df947f291dc90	false	89234795896637058950	2	132158896	2023-09-18T08:22:25.000Z	0x6a4076c2b1f705f89593570836020621a7dddf3da3996d8fcfb79454653d32a8

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ActivePool_ActivePoolVSTDebtUpdated_event

BorrowerOperations_TroveCreated_event

BorrowerOperations_TroveUpdated_event

BorrowerOperations_VaultParametersBaseChanged_event

BorrowerOperations_VSTBorrowingFeePaid_event

DefaultPool_DefaultPoolVSTDebtUpdated_event

InterestManager_DebtChanged_event

InterestManager_InterestMinted_event

PriceFeed_TokenPriceUpdated_event

SavingModule_PoolUpdated_event

SavingModule_ShareUpdated_event

SavingModule_UserClaimed_event

SavingModule_VSTReceveidFromVRR_event

StabilityPool_DepositSnapshotUpdated_event

StabilityPool_StabilityPoolVSTBalanceUpdated_event

StabilityPool_SystemSnapshotUpdated_event

StabilityPool_UserDepositChanged_event

StabilityPool_VSTAPaidToDepositor_event

Treasury_SafeReceived_event

VaultManager_BaseRateUpdated_event

VaultManager_Liquidation_event

VaultManager_Redemption_event

VaultManager_SystemSnapshotsUpdated_event

VaultManager_SystemUnpaidInterestUpdated_event

VaultManager_TotalStakesUpdated_event

VaultManager_TroveLiquidated_event

VaultManager_TroveSnapshotsUpdated_event

VaultManager_TroveUpdated_event

VaultManager_VaultParametersBaseChanged_event

VaultManager_VaultUnpaidInterestUpdated_event

VestaFarming_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ActivePool_ActivePoolVSTDebtUpdated_event

​BorrowerOperations_TroveCreated_event

​BorrowerOperations_TroveUpdated_event

​BorrowerOperations_VaultParametersBaseChanged_event

​BorrowerOperations_VSTBorrowingFeePaid_event

​DefaultPool_DefaultPoolVSTDebtUpdated_event

​InterestManager_DebtChanged_event

​InterestManager_InterestMinted_event

​PriceFeed_TokenPriceUpdated_event

​SavingModule_PoolUpdated_event

​SavingModule_ShareUpdated_event

​SavingModule_UserClaimed_event

​SavingModule_VSTReceveidFromVRR_event

​StabilityPool_DepositSnapshotUpdated_event

​StabilityPool_StabilityPoolVSTBalanceUpdated_event

​StabilityPool_SystemSnapshotUpdated_event

​StabilityPool_UserDepositChanged_event

​StabilityPool_VSTAPaidToDepositor_event

​Treasury_SafeReceived_event

​VaultManager_BaseRateUpdated_event

​VaultManager_Liquidation_event

​VaultManager_Redemption_event

​VaultManager_SystemSnapshotsUpdated_event

​VaultManager_SystemUnpaidInterestUpdated_event

​VaultManager_TotalStakesUpdated_event

​VaultManager_TroveLiquidated_event

​VaultManager_TroveSnapshotsUpdated_event

​VaultManager_TroveUpdated_event

​VaultManager_VaultParametersBaseChanged_event

​VaultManager_VaultUnpaidInterestUpdated_event

​VestaFarming_RewardPaid_event

Tables

ActivePool_ActivePoolVSTDebtUpdated_event

BorrowerOperations_TroveCreated_event

BorrowerOperations_TroveUpdated_event

BorrowerOperations_VaultParametersBaseChanged_event

BorrowerOperations_VSTBorrowingFeePaid_event

DefaultPool_DefaultPoolVSTDebtUpdated_event

InterestManager_DebtChanged_event

InterestManager_InterestMinted_event

PriceFeed_TokenPriceUpdated_event

SavingModule_PoolUpdated_event

SavingModule_ShareUpdated_event

SavingModule_UserClaimed_event

SavingModule_VSTReceveidFromVRR_event

StabilityPool_DepositSnapshotUpdated_event

StabilityPool_StabilityPoolVSTBalanceUpdated_event

StabilityPool_SystemSnapshotUpdated_event

StabilityPool_UserDepositChanged_event

StabilityPool_VSTAPaidToDepositor_event

Treasury_SafeReceived_event

VaultManager_BaseRateUpdated_event

VaultManager_Liquidation_event

VaultManager_Redemption_event

VaultManager_SystemSnapshotsUpdated_event

VaultManager_SystemUnpaidInterestUpdated_event

VaultManager_TotalStakesUpdated_event

VaultManager_TroveLiquidated_event

VaultManager_TroveSnapshotsUpdated_event

VaultManager_TroveUpdated_event

VaultManager_VaultParametersBaseChanged_event

VaultManager_VaultUnpaidInterestUpdated_event

VestaFarming_RewardPaid_event