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
0x16cd38b1b54e7abf307cb2697e2d9321e843d5aafalse100525700147064430612941126717810742504516904488672023-07-27T09:07:47.000Z0xc46721c7059f5dc2054eb99ee5c8f54c2c55ff237ce3a4186c3f4f47ac8ddd70
0x16cd38b1b54e7abf307cb2697e2d9321e843d5aafalse10052555610644066607462770734510742051516904398072023-07-27T06:36:47.000Z0x4d45eb971301188fc9ff86fe92adb6f36a998f5059edc0fcf0250096453367d0
0x16cd38b1b54e7abf307cb2697e2d9321e843d5aafalse10052604457351638209939347173410743587716904705312023-07-27T15:08:51.000Z0x69078cbffe90fa93934f6f9b654e645d6de530138effbbdc8510d2c02e8249be
Query with partition filter
SELECT *
FROM `tt-contracts.angle_v1_optimism.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
0xcf5a2934fe43666c24823dfd455c617edff78bb6false2410310651300102023-07-06T06:26:19.000Z0x96912147fad2da9198135cbe35ba3257d211e90477aba18bc86c95a4e807859c497738931961624378485
0xcf5a2934fe43666c24823dfd455c617edff78bb6false3410310651182612023-07-06T05:47:09.000Z0x37159b3348f6a74236f4b9f3d4f4600728ab1d7f13246c93d741eab763ece6a3497739116952179158146
0xcf5a2934fe43666c24823dfd455c617edff78bb6false5810410651646612023-07-06T08:21:49.000Z0xc88af35c0100be3aba193c7c3deaa10296d9d6217592fc4889a6b7fcabe5e147816290953756165968437
Query with partition filter
SELECT *
FROM `tt-contracts.angle_v1_optimism.VaultManager_InternalDebtUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100