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
0xfb16d8e96c0c6e9b72541bfd8d4c3d9e867c990bfalse10060822214590473980981336121214768108416950191692023-09-18T06:39:29.000Z0xbbf69d171c3d7f8fe2ae0656291a87cfdbb435a7895261211ce01754d038f5ed
0xfb16d8e96c0c6e9b72541bfd8d4c3d9e867c990bfalse1012774670151363850539112010305104157417023764122023-12-12T10:20:12.000Z0x41106ae4b0c74b56e2c8a9d627bd47e3b6c8c3fb1e42b52b079254b1af350699
0xfb16d8e96c0c6e9b72541bfd8d4c3d9e867c990bfalse10127617646965409951314267391805103710617023661662023-12-12T07:29:26.000Z0x7f28965d75852dd6761958c2688ecb1b904dd9bc81497a182a89ab5389fcb047
Query with partition filter
SELECT *
FROM `tt-contracts.angle_v1_polygon.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
0xfb16d8e96c0c6e9b72541bfd8d4c3d9e867c990bfalse71210244646131802023-08-18T15:26:15.000Z0x0b643b1183b37272c401701425b5e47648274cee547a6b7aaa0e36b87369584a1988353838613502435080
0xfb16d8e96c0c6e9b72541bfd8d4c3d9e867c990bfalse2833134646519002023-08-18T17:44:23.000Z0x05e7f521ad144525dd02c01626b20580978897adb0380c8bb04d53ac135db4cc49718470113286415877632
0x0945de4f356de3569fe12850ab85a91f533b87a0false368364646957202023-08-18T20:20:09.000Z0x3abbfbae442fbc384dab90622ae5aa4e0606e90bf561ddee796114d3412d6ce2524474981225610357183
Query with partition filter
SELECT *
FROM `tt-contracts.angle_v1_polygon.VaultManager_InternalDebtUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100