> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# angle_v1_ethereum
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | log\_index | in\_version | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8bb4c975ff3c250e0ceea271728547f3802b36fd | false | 253 | 1 | 16683154 | 2023-02-22T09:39:23.000Z | 0x0650a3cf3cb142d7923d605d605faf01b8479886fc3787d754034226e79b6202 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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, wrapperTypes ARRAY, 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
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).
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.angle_v1_ethereum.VaultManager_InternalDebtUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***