angle_v1_avalanche

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

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

address	removed	in_value	log_index	block_number	in_timestamp	block_timestamp	transaction_hash
0x65e4992250b296790c07fadf0f0723902a07e91d	false	1000413201122459247486986853	7	24850012	1673537774	2023-01-12T15:36:14.000Z	0x4a0c8394acc969fa566587cc23c02de19896ef4c640bb1aa6cfdd74d7b74e147
0x65e4992250b296790c07fadf0f0723902a07e91d	false	1000411072600699144414591876	10	24843249	1673524321	2023-01-12T11:52:01.000Z	0xf84ef51aaa60b7bb9eac0330cfa60fd332c2e0999f4cbaf70ed79d3ea76e60b9
0x65e4992250b296790c07fadf0f0723902a07e91d	false	1000411115478034735424711749	3	24843383	1673524592	2023-01-12T11:56:32.000Z	0xc1d7aeeb20a31dde3853d62e5a02ac81cf24b7fa417de3b54a8e7d6033535979

Example Query

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.

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_vaultID`	`STRING`	Unique identifier for the vault position within the Angle Protocol VaultManager contract. Numeric string representation of an integer ID.
`in_internalAmount`	`STRING`	Internal debt amount denominated in the smallest unit of the stablecoin. Numeric string representation of wei-equivalent units.
`in_isIncrease`	`INT64`	Boolean flag indicating whether the internal debt update represents an increase or decrease. Integer encoded as 1 for increase, 0 for decrease.

Sample Data

address	removed	log_index	in_vaultID	block_number	block_timestamp	transaction_hash	in_internalAmount
0x65e4992250b296790c07fadf0f0723902a07e91d	false	1	6	27377095	2023-03-13T08:12:29.000Z	0xb65aa1bb54212cf8caa226b6f9d8bb8bde8e2261309f5a698322111d3572efe8	9992462829773205392231
0x65e4992250b296790c07fadf0f0723902a07e91d	false	16	6	27391676	2023-03-13T16:22:54.000Z	0x7cec1d71fc46da391fe0e9f7e70ebde86b4b9e79d1583b817585fc6e12c24572	11311885076646486321293
0x65e4992250b296790c07fadf0f0723902a07e91d	false	24	3	30936920	2023-06-05T10:29:07.000Z	0xb4ab29038d8e455321bdc62c8586ade172a7ab1fc041f477d62946097f915a37	897862442007203

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

VaultManager_InterestAccumulatorUpdated_event

VaultManager_InternalDebtUpdated_event

​Tables

​VaultManager_InterestAccumulatorUpdated_event

​VaultManager_InternalDebtUpdated_event

Tables

VaultManager_InterestAccumulatorUpdated_event

VaultManager_InternalDebtUpdated_event