angle_v1_arbitrum

Tables

Distributor_Claimed_event

Token claim events from Angle Protocol’s distributor contract on Arbitrum, recording user addresses, claimed token addresses, and amounts. Used for tracking reward distributions and analyzing claim patterns across different 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x3ef3d8ba38ebe18db133cec108f4d14ce00dd9ae	0x000000e28faa823d5b53ff6c2922c28335840375	false	0x912ce59144191c1204e64559fe8253a0e49e6548	13244506160783871808	3	236022338	2024-07-25T20:55:50.000Z	0xb0e7f04b0acf7d6a9136cff1600258b60e0cf9648443b90b7f39a1e5100f6711
0x3ef3d8ba38ebe18db133cec108f4d14ce00dd9ae	0x000003f6dce87f24ad0a4332e496c7016fb04222	false	0xfa7f8980b0f1e64a2062791cc3b0871572f1f7f0	2113482570000000000	12	235740615	2024-07-25T01:17:52.000Z	0x0d6f17729ce721957f1b7d37ee972f739baf121cba1f1bfe481657c9e5e36114
0x3ef3d8ba38ebe18db133cec108f4d14ce00dd9ae	0x000003f6dce87f24ad0a4332e496c7016fb04222	false	0x912ce59144191c1204e64559fe8253a0e49e6548	18155424690000000000	10	235740615	2024-07-25T01:17:52.000Z	0x0d6f17729ce721957f1b7d37ee972f739baf121cba1f1bfe481657c9e5e36114

Example Query

Query with partition filter

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

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
0xe9f183fc656656f1f17af1f2b0df79b8ff9ad8ed	false	1029701318332703940262063593	0	211378436	1715741763	2024-05-15T02:56:03.000Z	0x73e5f8a4666ee7df9e02060677753c0f6b236617328488e09be35733bc4fb0f9
0xe9f183fc656656f1f17af1f2b0df79b8ff9ad8ed	false	1029696975760560113642524847	0	211364944	1715738372	2024-05-15T01:59:32.000Z	0xec1f1481c7b6c9586dfabd85d935082739fa9b6703805511595c78250a5d6c82
0xe9f183fc656656f1f17af1f2b0df79b8ff9ad8ed	false	1029733706994149738538089653	2	211478037	1715767054	2024-05-15T09:57:34.000Z	0x445f1d0658b6b3eeeece9a0f0e0906cc95326f71262fef571e9143283b51d59d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.angle_v1_arbitrum.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
0xe9f183fc656656f1f17af1f2b0df79b8ff9ad8ed	false	54	227	223926048	2024-06-20T18:36:20.000Z	0xbc7785053e4a6b67b1942208378e0a94a8fd114d88e6def46ea1a6a90d658076	1593753835596272010596
0xe9f183fc656656f1f17af1f2b0df79b8ff9ad8ed	false	1	227	223927970	2024-06-20T18:44:21.000Z	0xdcb8863f69e017df3b186861298677aabec06d50e1ea46dc957fd9537b8d00c7	411492971606619915784
0xe9f183fc656656f1f17af1f2b0df79b8ff9ad8ed	false	1	227	223926638	2024-06-20T18:38:48.000Z	0x716d8d4ce1c73da74bebad250df91ab928730f86cba2c862e35f0e014195d721	3181938432170466919395

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Distributor_Claimed_event

VaultManager_InterestAccumulatorUpdated_event

VaultManager_InternalDebtUpdated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Distributor_Claimed_event

​VaultManager_InterestAccumulatorUpdated_event

​VaultManager_InternalDebtUpdated_event

Tables

Distributor_Claimed_event

VaultManager_InterestAccumulatorUpdated_event

VaultManager_InternalDebtUpdated_event