angle_v1_ethereum

Tables

AngleDistributor_RewardDistributed_event

Reward distribution events from Angle Protocol’s v1 distributor contract on Ethereum, recording token amounts allocated to liquidity gauge addresses. Used for tracking incentive distribution patterns across Angle’s stablecoin liquidity pools.

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_gaugeAddr`	`STRING`	Contract address of the gauge receiving the reward distribution. Hex-encoded, 0x-prefixed 40-character Ethereum address identifying the liquidity gauge contract.
`in_rewardTally`	`STRING`	Cumulative reward amount distributed to the gauge address at the time of this event, denominated in the smallest unit of the reward token. Values are typically large integers representing token amounts with 18 decimals.

Sample Data

address	removed	log_index	block_number	in_gaugeAddr	in_rewardTally	block_timestamp	transaction_hash
0x4f91f01ce8ec07c9b1f6a82c18811848254917ab	false	254	17780704	0xba625b318483516f7483dd2c4706ac92d44dbb2b	52558984449742669532871	2023-07-27T00:02:35.000Z	0x1dce0282d4ed01b529c6b14e0db8735b5f6db3c9f82e5f04ef4056324bf17099
0x4f91f01ce8ec07c9b1f6a82c18811848254917ab	false	245	17780704	0xeb7547a8a734b6fddbb8ce0c314a9e6485100a3c	198843024192361299318885	2023-07-27T00:02:35.000Z	0x1dce0282d4ed01b529c6b14e0db8735b5f6db3c9f82e5f04ef4056324bf17099
0x4f91f01ce8ec07c9b1f6a82c18811848254917ab	false	250	17780704	0x3785ce82be62a342052b9e5431e9d3a839cfb581	573710529376855539753841	2023-07-27T00:02:35.000Z	0x1dce0282d4ed01b529c6b14e0db8735b5f6db3c9f82e5f04ef4056324bf17099

Example Query

Query with partition filter

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

DistributionCreator_FeesSet_event

No description available.

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__fees`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DistributionCreator_Initialized_event

Initialization events from Angle Protocol’s DistributionCreator contract on Ethereum, marking when the contract version was set up. Used to track contract deployment history and version upgrades.

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_version`	`INT64`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x8bb4c975ff3c250e0ceea271728547f3802b36fd	false	253	1	16683154	2023-02-22T09:39:23.000Z	0x0650a3cf3cb142d7923d605d605faf01b8479886fc3787d754034226e79b6202

Example Query

Query with partition filter

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

DistributionCreator_NewCampaign_event

Liquidity mining campaign creation events from Angle Protocol’s DistributionCreator contract on Ethereum. Records reward distribution parameters including campaign ID, reward token, duration, amount, and start timestamp for incentivizing liquidity providers.

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_campaign`	`STRUCT<campaignId STRING, creator STRING, rewardToken STRING, amount STRING, campaignType STRING, startTimestamp STRING, duration STRING, campaignData STRING>`	Nested record containing complete details of a newly created incentive campaign on Angle Protocol. Includes campaign identifier, reward token, amount, duration, creator address, campaign type, start timestamp, and encoded campaign parameters specifying distribution rules.

Sample Data

address	removed	log_index	in_campaign	block_number	block_timestamp	transaction_hash
0x8bb4c975ff3c250e0ceea271728547f3802b36fd	false	198	{“amount”:“500000000000”,“creator”:“0x0c2553e4b9dfa9f83b1a6d3eab96c4baab42d430”,“duration”:“3600”,“campaignId”:“0xcab94999e3c112391f388ed5713df1e3b9ca7e1d93d0598a4a3a4d1528bfbd42”,“rewardToken”:“0xefc0ced4b3d536103e76a1c4c74f0385c8f4bdd3”,“campaignData”:“0x0000000000000000000000000c462dbb9ec8cd1630f1728b2cfd2769d09f0dd500000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000065e136a000000000000000000000000000000000000000000000000000000000000001200000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000022000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d13f8c25cced32cdfa79eb5ed654ce3e484dcaf5000000000000000000000000e55843a90672f7d8218285e51ee8ff8e233f35d50000000000000000000000000000000000000000000000000000000000000000”,“campaignType”:“3”,“startTimestamp”:“1709892000”}	19389529	2024-03-08T09:23:47.000Z	0xcf6aca693cfebdc244dbf88fa4dd334da95f331c330a9a36274b4f89ae242634
0x8bb4c975ff3c250e0ceea271728547f3802b36fd	false	258	{“amount”:“4850000000”,“creator”:“0xcf1a463e0b129b7520e12a98a1f2760837f36a9b”,“duration”:“604800”,“campaignId”:“0x41afdd5d43961313de0c0b7f09768b543d20c7294927300d09aea058769cc702”,“rewardToken”:“0xb60acd2057067dc9ed8c083f5aa227a244044fd6”,“campaignData”:“0x000000000000000000000000c57cac126676471c547d2d9b1c283e56ef1b28f400000000000000000000000000000000000000000000000000000000000003e8000000000000000000000000000000000000000000000000000000000000119400000000000000000000000000000000000000000000000000000000000011940000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023078000000000000000000000000000000000000000000000000000000000000”,“campaignType”:“2”,“startTimestamp”:“1709906400”}	19390848	2024-03-08T13:48:11.000Z	0x62fba21c47d9e0f4fe123188632c87c93ac9a0240d7db4ef12126b34a0935546
0x8bb4c975ff3c250e0ceea271728547f3802b36fd	false	168	{“amount”:“93120000000000000000000”,“creator”:“0xf052e0df010819602f0b22a7cb600e33ffc91358”,“duration”:“604800”,“campaignId”:“0xdb9fc7f3a1f8b4de9c19356c5703b76d1553ea8b4dd8f02fb7d9d10a3a97c8d6”,“rewardToken”:“0x48c3399719b582dd63eb5aadf12a40b4c3f52fa2”,“campaignData”:“0x000000000000000000000000c2a6798447bb70e5abcf1b0d6aeec90bc14fca550000000000000000000000000000000000000000000000000000000000002648000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000160000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000001c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“campaignType”:“2”,“startTimestamp”:“1711076400”}	19483606	2024-03-21T14:23:35.000Z	0xe4f432247e356e6ae2de9ab5b8127bf0b5d7800cff951dd61b3905b77f0a9ee6

Example Query

Query with partition filter

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

DistributionCreator_NewDistribution_event

Liquidity mining reward distribution events from Angle Protocol’s DistributionCreator contract on Ethereum, specifying incentive parameters for Uniswap v3 pools including reward token, amount, epoch duration, and boosting configuration. Used for tracking liquidity incentive campaigns and analyzing reward allocation across pools and LP position wrappers.

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_distribution`	`STRUCT<rewardId STRING, uniV3Pool STRING, rewardToken STRING, amount STRING, positionWrappers ARRAY<STRING>, wrapperTypes ARRAY<STRING>, propToken0 STRING, propToken1 STRING, propFees STRING, epochStart STRING, numEpoch STRING, isOutOfRangeIncentivized STRING, boostedReward STRING, boostingAddress STRING, additionalData STRING>`	Structured data containing the complete parameters of a newly created liquidity incentive distribution on Angle Protocol, including reward token details, Uniswap V3 pool address, distribution amount, epoch configuration, and fee/boosting settings. All nested fields are present in every event with numeric values stored as strings.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_sender	log_index	block_number	block_timestamp	in_distribution	transaction_hash
0x8bb4c975ff3c250e0ceea271728547f3802b36fd	false	0x46918e4b0e64279c1d5f16d13aeb0c7bcd210b87	66	18631028	2023-11-23T01:02:47.000Z	{“amount”:“388725985973573915890496”,“numEpoch”:“168”,“propFees”:“4000”,“rewardId”:“0xca13e3b42db9a2cb9c44dcfd80beb7805bfa3295596e96caa8db3500ba36c20e”,“uniV3Pool”:“0x735a26a57a0a0069dfabd41595a970faf5e1ee8b”,“epochStart”:“1700701200”,“propToken0”:“4000”,“propToken1”:“2000”,“rewardToken”:“0x31429d1856ad1377a8a0079410b297e1a9e214c2”,“wrapperTypes”:[“3”],“boostedReward”:“25000”,“additionalData”:“0x”,“boostingAddress”:“0x52701bfa0599db6db2b2476075d9a2f4cb77dae3”,“positionWrappers”:[“0xeb7547a8a734b6fddbb8ce0c314a9e6485100a3c”],“isOutOfRangeIncentivized”:“0”}	0xa5364d902790cb68a0dceb0a04e268ddc3ca77a86ec413ec2be62d5b40fcfa55
0x8bb4c975ff3c250e0ceea271728547f3802b36fd	false	0x46918e4b0e64279c1d5f16d13aeb0c7bcd210b87	71	18631028	2023-11-23T01:02:47.000Z	{“amount”:“288517402475413337529001”,“numEpoch”:“168”,“propFees”:“4000”,“rewardId”:“0x4bfa403f4537744861a2aeeeab83dc8394545cc45e9d3b236431323a83ca9293”,“uniV3Pool”:“0x8db1b906d47dfc1d84a87fc49bd0522e285b98b9”,“epochStart”:“1700701200”,“propToken0”:“4000”,“propToken1”:“2000”,“rewardToken”:“0x31429d1856ad1377a8a0079410b297e1a9e214c2”,“wrapperTypes”:[“3”],“boostedReward”:“25000”,“additionalData”:“0x”,“boostingAddress”:“0x52701bfa0599db6db2b2476075d9a2f4cb77dae3”,“positionWrappers”:[“0x3785ce82be62a342052b9e5431e9d3a839cfb581”],“isOutOfRangeIncentivized”:“0”}	0xa5364d902790cb68a0dceb0a04e268ddc3ca77a86ec413ec2be62d5b40fcfa55
0x8bb4c975ff3c250e0ceea271728547f3802b36fd	false	0x46918e4b0e64279c1d5f16d13aeb0c7bcd210b87	187	17531477	2023-06-22T00:02:59.000Z	{“amount”:“243975270749935139555664”,“numEpoch”:“168”,“propFees”:“4000”,“rewardId”:“0x375987dbbefb16500717f6fac259c8b79b5643dcf776075b2329a2962594c925”,“uniV3Pool”:“0x8db1b906d47dfc1d84a87fc49bd0522e285b98b9”,“epochStart”:“1687392000”,“propToken0”:“4000”,“propToken1”:“2000”,“rewardToken”:“0x31429d1856ad1377a8a0079410b297e1a9e214c2”,“wrapperTypes”:[“3”],“boostedReward”:“25000”,“additionalData”:“0x”,“boostingAddress”:“0x52701bfa0599db6db2b2476075d9a2f4cb77dae3”,“positionWrappers”:[“0x3785ce82be62a342052b9e5431e9d3a839cfb581”],“isOutOfRangeIncentivized”:“0”}	0x34e686c7f249081a4cb9ebd5119e6aba1017783ac4227044dcddfd13bc022b98

Example Query

Query with partition filter

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

Univ4MerklRouterOracle_CampaignCreated_event

Campaign creation events from Angle Protocol’s Merkl reward distribution system on Ethereum. Tracks incentive programs with reward token amounts, durations, and campaign parameters for Uniswap v4 liquidity mining analysis.

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_campaignId`	`STRING`	Unique identifier for the reward campaign, generated as a keccak256 hash. Hex-encoded, 0x-prefixed 64-character string used to reference specific campaigns in the Angle Protocol’s Uniswap v4 Merkl incentive system.
`in_campaign`	`STRUCT<campaignId STRING, creator STRING, rewardToken STRING, amount STRING, campaignType STRING, startTimestamp STRING, duration STRING, campaignData STRING>`	Nested structure containing the full campaign parameters including reward amount, creator address, duration (in seconds), reward token address, campaign type identifier, start timestamp, and encoded campaign configuration data. All campaign events in the sample use campaign type 13 with 14-day durations (1209600 seconds).

Sample Data

address	removed	log_index	in_campaign	block_number	in_campaignId	block_timestamp	transaction_hash
0x45da561ab3431b8fe914c6ee2238fca0d145e0e1	false	367	{“amount”:“98903000000000000000000”,“creator”:“0x2016ef507cb1b055e21e6bf8d29b7fe51b34c6aa”,“duration”:“1209600”,“campaignId”:“0x3030303030303030303030303030303030303030303030303030303030303030”,“rewardToken”:“0x1f9840a85d5af5bf1d1762f925bdaddc4201f984”,“campaignData”:“0x0000000000000000000000000000000000000000000000000000000000000082000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000264800000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000000000000000000000000000000000000000002053b06f1bb8b622cc4b7dbd9bc9f4a34788034bc48702cd2af4135b48444d5b24000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c0c0c0c0”,“campaignType”:“13”,“startTimestamp”:“1744711200”}	22269169	0xb512ce14e0a610845dafea704fba5dc7a23bf3b4746fd03d996a6f16e3e32b0d	2025-04-14T18:58:47.000Z	0xa650e450e8758ad880d5124bf66c35a20482fab9b3e2cd8ba4da04aca1fc5c2d
0x45da561ab3431b8fe914c6ee2238fca0d145e0e1	false	444	{“amount”:“110637000000000000000000”,“creator”:“0x2016ef507cb1b055e21e6bf8d29b7fe51b34c6aa”,“duration”:“1209600”,“campaignId”:“0x3030303030303030303030303030303030303030303030303030303030303030”,“rewardToken”:“0x1f9840a85d5af5bf1d1762f925bdaddc4201f984”,“campaignData”:“0x0000000000000000000000000000000000000000000000000000000000000082000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000264800000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000000000000000000000000000000000000000002077ea9d2be50eb3e82b62db928a1bcc573064dd2a14f5026847e755518c8659c9000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c0c0c0c0”,“campaignType”:“13”,“startTimestamp”:“1744711200”}	22269169	0x976cab3bee6187aff0e6b9a3492b79385b2ed1e0c40ac45985e901bf13a0d061	2025-04-14T18:58:47.000Z	0xa650e450e8758ad880d5124bf66c35a20482fab9b3e2cd8ba4da04aca1fc5c2d
0x45da561ab3431b8fe914c6ee2238fca0d145e0e1	false	466	{“amount”:“29335000000000000000000”,“creator”:“0x2016ef507cb1b055e21e6bf8d29b7fe51b34c6aa”,“duration”:“1209600”,“campaignId”:“0x3030303030303030303030303030303030303030303030303030303030303030”,“rewardToken”:“0x1f9840a85d5af5bf1d1762f925bdaddc4201f984”,“campaignData”:“0x0000000000000000000000000000000000000000000000000000000000000082000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000264800000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000000000000000000000000000000000000000002088cdc69f6be00de0b69f92de9ae0c4621fb6a3cdba582804010b182238c98dde000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c0c0c0c0”,“campaignType”:“13”,“startTimestamp”:“1744711200”}	22269169	0x51d049fc0e9343da1bb3a2c5a6cadf0a3adacc3edb75fb6c8674a3c22ceca47a	2025-04-14T18:58:47.000Z	0xa650e450e8758ad880d5124bf66c35a20482fab9b3e2cd8ba4da04aca1fc5c2d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.angle_v1_ethereum.Univ4MerklRouterOracle_CampaignCreated_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
0x96de5c30f2bf4683c7903f3e921f720602f8868a	false	1001444683681290628962993975	208	17981000	1692837035	2023-08-24T00:30:35.000Z	0x0b6d6370a061ae9617599362675e06159925036112e6f8d64e4b4c3811b442ae
0x73aaf8694ba137a7537e7ef544fcf5e2475f227b	false	1005963211050066340062698071	441	17983912	1692872243	2023-08-24T10:17:23.000Z	0x2c40e505f997cffa90ef35741227187f4daca63af0a4a1b42d047beedcf634fa
0x241d7598bd1eb819c0e9ded456acb24aca623679	false	1005246258953204432081663966	194	17611542	1688364227	2023-07-03T06:03:47.000Z	0xe60d1e78143ad22060cae691710fe82e8b1fbf664a441f599e0f3f2b0367a7c1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.angle_v1_ethereum.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	in_isIncrease	block_timestamp	transaction_hash	in_internalAmount
0x73aaf8694ba137a7537e7ef544fcf5e2475f227b	false	55	18	17342894	1	2023-05-26T11:10:59.000Z	0xd65d32801fe0b695ee5f6fb1a673d51f8bca91ec7f3326dc2fca164e6da918c9	27868257164309841054117
0x73aaf8694ba137a7537e7ef544fcf5e2475f227b	false	158	15	16649344	1	2023-02-17T15:35:11.000Z	0x0d31b41f0410926b75f2f6a8e0510cde084974bf890c8b203fa460df8a53c899	17366215960953084553974
0xdeee8e8a89338241fe622509414ff535fb02b479	false	253	12	16649149	0	2023-02-17T14:54:59.000Z	0x06bb162ad5ab5bc5c8f98d9c100fbdd86ba08cdc460b1ca236d111259400f124	229843762961407760377185

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AngleDistributor_RewardDistributed_event

DistributionCreator_FeesSet_event

DistributionCreator_Initialized_event

DistributionCreator_NewCampaign_event

DistributionCreator_NewDistribution_event

Univ4MerklRouterOracle_CampaignCreated_event

VaultManager_InterestAccumulatorUpdated_event

VaultManager_InternalDebtUpdated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AngleDistributor_RewardDistributed_event

​DistributionCreator_FeesSet_event

​DistributionCreator_Initialized_event

​DistributionCreator_NewCampaign_event

​DistributionCreator_NewDistribution_event

​Univ4MerklRouterOracle_CampaignCreated_event

​VaultManager_InterestAccumulatorUpdated_event

​VaultManager_InternalDebtUpdated_event

Tables

AngleDistributor_RewardDistributed_event

DistributionCreator_FeesSet_event

DistributionCreator_Initialized_event

DistributionCreator_NewCampaign_event

DistributionCreator_NewDistribution_event

Univ4MerklRouterOracle_CampaignCreated_event

VaultManager_InterestAccumulatorUpdated_event

VaultManager_InternalDebtUpdated_event