Skip to main content

Tables

VaultManager_InterestAccumulatorUpdated_event

Interest accumulator update events emitted by Angle Protocol vault managers tracking cumulative interest calculations. Records timestamp and accumulated interest value for debt tracking in collateralized debt positions (CDPs).
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_timestampSTRINGUnix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
addressremovedin_valuelog_indexblock_numberin_timestampblock_timestamptransaction_hash
0x65e4992250b296790c07fadf0f0723902a07e91dfalse100041320112245924748698685372485001216735377742023-01-12T15:36:14.000Z0x4a0c8394acc969fa566587cc23c02de19896ef4c640bb1aa6cfdd74d7b74e147
0x65e4992250b296790c07fadf0f0723902a07e91dfalse1000411072600699144414591876102484324916735243212023-01-12T11:52:01.000Z0xf84ef51aaa60b7bb9eac0330cfa60fd332c2e0999f4cbaf70ed79d3ea76e60b9
0x65e4992250b296790c07fadf0f0723902a07e91dfalse100041111547803473542471174932484338316735245922023-01-12T11:56:32.000Z0xc1d7aeeb20a31dde3853d62e5a02ac81cf24b7fa417de3b54a8e7d6033535979
Query with partition filter
SELECT *
FROM `tt-contracts.angle_v1_avalanche.VaultManager_InterestAccumulatorUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VaultManager_InternalDebtUpdated_event

Debt position updates for collateralized vaults in Angle Protocol, recording changes to internal debt amounts. Contains vault identifier, debt amount delta, and direction flag (increase or decrease) for tracking borrowing activity and liquidation events.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_vaultIDSTRINGUnique identifier for the vault position within the Angle Protocol VaultManager contract. Numeric string representation of an integer ID.
in_internalAmountSTRINGInternal debt amount denominated in the smallest unit of the stablecoin. Numeric string representation of wei-equivalent units.
in_isIncreaseINT64Boolean flag indicating whether the internal debt update represents an increase or decrease. Integer encoded as 1 for increase, 0 for decrease.
addressremovedlog_indexin_vaultIDblock_numberin_isIncreaseblock_timestamptransaction_hashin_internalAmount
0x65e4992250b296790c07fadf0f0723902a07e91dfalse162737709502023-03-13T08:12:29.000Z0xb65aa1bb54212cf8caa226b6f9d8bb8bde8e2261309f5a698322111d3572efe89992462829773205392231
0x65e4992250b296790c07fadf0f0723902a07e91dfalse1662739167602023-03-13T16:22:54.000Z0x7cec1d71fc46da391fe0e9f7e70ebde86b4b9e79d1583b817585fc6e12c2457211311885076646486321293
0x65e4992250b296790c07fadf0f0723902a07e91dfalse2433093692002023-06-05T10:29:07.000Z0xb4ab29038d8e455321bdc62c8586ade172a7ab1fc041f477d62946097f915a37897862442007203
Query with partition filter
SELECT *
FROM `tt-contracts.angle_v1_avalanche.VaultManager_InternalDebtUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100