Tables
Registry_NewExperimentalVault_event
Experimental vault deployment events from Yearn Finance v2 registry on Ethereum, capturing new vault addresses, deployer accounts, underlying token addresses, and API versions. Used for tracking Yearn’s product launches and vault version history across different yield strategies.Columns
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_token | STRING | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_deployer | STRING | Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string. |
in_vault | STRING | Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string. |
in_api_version | STRING | API version of the Yearn vault contract at deployment time. Typically follows semantic versioning (e.g., 0.3.3, 0.4.3) indicating the vault implementation standard. |
Sample Data
Sample Data
| address | removed | in_token | in_vault | log_index | in_deployer | block_number | in_api_version | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 0x453d92c7d4263201c69aacfaf589ed14202d83a4 | 0xc97232527b62efb0d8ed38cf3ea103a6cca4037e | 85 | 0x0b634a8d61b09820e9f72f79cdcbc8a4d0aad26b | 15624988 | 0.4.3 | 2022-09-27T13:28:23.000Z | 0x9dc2b0e6331dc34e65beb6497f2b9b488265f57f1a0bdd017991002bb769cbab |
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 0xfcc5c47be19d06bf83eb04298b026f81069ff65b | 0x27b5739e22ad9033bcbf192059122d163b60349d | 80 | 0x0b634a8d61b09820e9f72f79cdcbc8a4d0aad26b | 15624989 | 0.4.3 | 2022-09-27T13:28:35.000Z | 0x321b62307f9a607ba5ca33f44d4166f5220771cdbca2d7510623a38d433aa6f2 |
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 0x02d341ccb60faaf662bc0554d13778015d1b285c | 0x32413274504908460f0c373c7f20f429fb80ed3a | 247 | 0x710295b5f326c2e47e6dd2e7f6b5b0f7c5ac2f24 | 12078302 | 0.3.3 | 2021-03-20T22:05:38.000Z | 0x488e8ec4db146c2e7fcca57959af8adb9b7272e1cc2c61bd508bf0c3ea0515e8 |
Example Query
Example Query
Query with partition filter
Registry_NewGovernance_event
Governance address change events from Yearn Finance V2 vault registry on Ethereum. Captures when protocol governance control is transferred to new addresses for monitoring administrative authority transitions.Columns
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_governance | STRING | Ethereum address of the new governance contract that was set for the Yearn registry. Hex-encoded, 0x-prefixed 40-character string representing the governance authority. |
Sample Data
Sample Data
| address | removed | log_index | block_number | in_governance | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 66 | 12051992 | 0xfeb4acf3df3cdea7399794d0869ef76a6efaff52 | 2021-03-16T20:58:10.000Z | 0x5c9abb1b2e82f92cf1726b9079f432e348872f84642440000feb296cb6c9174d |
Example Query
Example Query
Query with partition filter
Registry_NewRelease_event
Yearn Finance v2 vault template deployment events on Ethereum, recording when new vault API versions are registered with their template addresses and sequential release IDs. Used for tracking Yearn’s vault architecture evolution and identifying which template contracts power different vault versions.Columns
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_release_id | STRING | Numeric identifier for the Yearn vault template release version registered in this event. Increments sequentially with each new vault template version (0, 1, 2, etc.) as Yearn upgrades its vault infrastructure. |
in_template | STRING | Contract address of the vault template used for this Yearn protocol release. Hex-encoded, 0x-prefixed 40-character string representing the deployed template contract that vaults in this release are based on. |
in_api_version | STRING | Semantic version number of the Yearn vault template API being registered in this release. Indicates the vault interface compatibility level, with values like 0.3.3 or 0.4.5 representing incremental updates to vault functionality. |
Sample Data
Sample Data
| address | removed | log_index | in_template | block_number | in_release_id | in_api_version | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 190 | 0x662fbf2c1e4b04342eeba6371ec1c7420042b86f | 12045633 | 4 | 0.3.3 | 2021-03-15T21:31:55.000Z | 0x59c94544c78cb8351db3cfcc9a006d11cfd6a325a41c092fbb3980ddadb9c22e |
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 275 | 0x986b4aff588a109c09b50a03f42e4110e29d353f | 12045573 | 3 | 0.3.2 | 2021-03-15T21:18:38.000Z | 0x97cb4952cfe7e2571016894967b514ec6397c42321172a15ab2990ecf1560e6a |
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 272 | 0xbfa4d8aa6d8a379abfe7793399d3ddacc5bbecbb | 12045573 | 0 | 0.2.2 | 2021-03-15T21:18:38.000Z | 0x699c5df46ff58e55544b3e8aec997fe944c1f9ecaccf1dfe90fc7e5a9c0dc3e3 |
Example Query
Example Query
Query with partition filter
Registry_NewVault_event
Registry vault deployment events from Yearn Finance v2 on Ethereum, recording when new yield-bearing vaults are registered with their underlying token, vault address, and API version. Useful for tracking vault launches and protocol expansion across different asset strategies.Columns
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_token | STRING | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_vault_id | STRING | Numeric identifier distinguishing multiple vaults for the same underlying token within the Yearn registry. Typically ‘0’ for the first vault of a token, incrementing for subsequent vaults of the same asset. |
in_vault | STRING | Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string. |
in_api_version | STRING | Yearn Vault API version that the newly registered vault implements. Values like “0.2.2”, “0.3.0”, and “0.3.5” indicate the vault’s protocol compatibility level. |
Sample Data
Sample Data
| address | removed | in_token | in_vault | log_index | in_vault_id | block_number | in_api_version | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 0x64eda51d3ad40d56b9dfc5554e06f94e1dd786fd | 0x23d3d0f1c697247d5e0a9efb37d8b0ed0c464f7f | 144 | 0 | 12320785 | 0.3.5 | 2021-04-27T06:33:50.000Z | 0x4c59dccb83dd6f706f4b1c900d4aad7a55d6aefc963fd5da80cf4211f08a3801 |
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 0x9fc689ccada600b6df723d9e47d84d76664a1f23 | 0x28a5b95c101df3ded0c0d9074db80c438774b6a9 | 100 | 0 | 12749012 | 0.3.5 | 2021-07-02T15:31:18.000Z | 0x8689137a0c6a918fa34c85e3ee23871c586ad7f2a8474087a37896094879ccdf |
| 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 0xd905e2eaebe188fc92179b6350807d8bd91db0d8 | 0x80bbee2fa460da291e796b9045e93d19ef948c6a | 97 | 0 | 12749012 | 0.3.5 | 2021-07-02T15:31:18.000Z | 0x8689137a0c6a918fa34c85e3ee23871c586ad7f2a8474087a37896094879ccdf |
Example Query
Example Query
Query with partition filter
Registry_VaultTagged_event
Yearn Finance V2 vault tagging events on Ethereum recording when vaults are labeled or unlabeled with classification tags (like “Removed”) in the registry contract. Enables tracking vault categorization changes and registry governance actions over time.Columns
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_vault | STRING | Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string. |
in_tag | STRING | Tag identifier applied to the Yearn vault in this event, typically indicating vault categorization or status. Common values include “Removed” for vaults being de-tagged from the registry. |
Sample Data
Sample Data
| in_tag | address | removed | in_vault | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| Removed | 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 0x8a0889d47f9aa0fac1cc718ba34e26b867437880 | 60 | 15675694 | 2022-10-04T15:34:59.000Z | 0xb6cc39db07e0a29385a6b34a347a4196d917e0b1225aff2bbd42a7a1220ad8b3 |
| Removed | 0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804 | false | 0x61f46c65e403429266e8b569f23f70dd75d9bee7 | 61 | 15675694 | 2022-10-04T15:34:59.000Z | 0xb6cc39db07e0a29385a6b34a347a4196d917e0b1225aff2bbd42a7a1220ad8b3 |
Example Query
Example Query
Query with partition filter
Strategy_Harvested_event
Harvest events from Yearn Finance V2 vaults on Ethereum, recording profit, loss, and debt repayments when strategies realize gains. Used for tracking vault performance, yield generation, and strategy effectiveness over time.Columns
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_profit | STRING | Profit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination. |
in_loss | STRING | Loss amount incurred by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination. |
in_debtPayment | STRING | Amount of debt the strategy repaid to its vault during this harvest, denominated in the vault’s underlying token (wei/smallest unit). Non-zero when strategies return capital to reduce outstanding debt obligations. |
in_debtOutstanding | STRING | Outstanding debt owed by the Yearn V2 strategy to the vault at time of harvest. Expressed as a string-encoded wei amount; consistently zero in sample data suggests debt is typically settled before harvest events. |
Sample Data
Sample Data
| address | in_loss | removed | in_profit | log_index | block_number | in_debtPayment | block_timestamp | transaction_hash | in_debtOutstanding |
|---|---|---|---|---|---|---|---|---|---|
| 0x0967afe627c732d152e3dfcadd6f9dbfecde18c3 | 0 | false | 29610181458691250527 | 8 | 13549910 | 0 | 2021-11-04T11:19:41.000Z | 0x4de90525d47856074ee793902df14950c7727ac32820d3136ef6dbd19e466f48 | 0 |
| 0x33d7e0fa2c7db85ef3abc1c44e07e0b5cb2e4c14 | 0 | false | 22483807519657497491512 | 33 | 13551830 | 0 | 2021-11-04T18:32:58.000Z | 0x66ee7d122d25afe0ddd9b35a9cc4d2c0e3240f9eaf4b58da25c264a32c65716d | 0 |
| 0x1676055fe954ee6fc388f9096210e5ebe0a9070c | 0 | false | 103269604790935795611073 | 35 | 13550044 | 0 | 2021-11-04T11:52:55.000Z | 0x87404b58c7b0f060105565b9b86e71019370c135790e8bdd5090c409d97eeb62 | 0 |
Example Query
Example Query
Query with partition filter
Strategy_UpdatedDebtThreshold_event
Event logs capturing debt threshold configuration changes for Yearn Finance v2 vault strategies on Ethereum. Used to track risk parameter adjustments and strategy management actions across the protocol’s yield-generating vaults.Columns
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_debtThreshold | STRING | The minimum debt change required to trigger automatic debt rebalancing for this Yearn V2 strategy, denominated in the vault’s underlying token with full decimal precision. Values are stored as large integers representing amounts in the smallest unit of the token (e.g., wei for ETH-based vaults). |
Sample Data
Sample Data
| address | removed | log_index | block_number | block_timestamp | in_debtThreshold | transaction_hash |
|---|---|---|---|---|---|---|
| 0x1676055fe954ee6fc388f9096210e5ebe0a9070c | false | 230 | 13495208 | 2021-10-26T20:52:47.000Z | 1000000000000000000000000000000 | 0x4739da9436a9bda879ffde750d9cae233efbc8f9c270e5d9417a89a05a2206b6 |
| 0xaf6f42bfb29e90dfe51f2341ff1b1f99fd776a70 | false | 108 | 15058819 | 2022-07-01T20:50:23.000Z | 1000000000000000000000000000000000000000000000 | 0xe228355393dc7f0ce0295509002e65ce770f6dac29a2af1f6dfdd63f97b6ee1e |
| 0x4b7fc5661f804d558691ecd3724d4961bb64faca | false | 417 | 14959487 | 2022-06-14T02:55:13.000Z | 1000000000000000000000000000000000000 | 0xf4e7b2341ca387c1eda6b7eefeb83e43c8cf192be6af61c9f4f21e8c4dc221d5 |
Example Query
Example Query
Query with partition filter
Strategy_UpdatedProfitFactor_event
Event log tracking profit factor parameter updates for Yearn Finance v2 vault strategies on Ethereum. Used to analyze strategy configuration changes and risk management settings over time.Columns
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_profitFactor | STRING | New profit factor parameter for the Yearn v2 strategy, representing the proportion of gains distributed to strategists. Typically expressed in basis points or as a scaled integer (e.g., 1000 = 10%, 2000000 = 20%). |
Sample Data
Sample Data
| address | removed | log_index | block_number | block_timestamp | in_profitFactor | transaction_hash |
|---|---|---|---|---|---|---|
| 0x1de1401c71362c05c680c5fd073888719d8f4196 | false | 144 | 15576643 | 2022-09-20T19:02:11.000Z | 1000 | 0xe1c94a5947a4c3f632534dfc169c1791afe8b20fdf064743028d7def36d9660b |
| 0xec2db4a1ad431cc3b102059fa91ba643620f0826 | false | 128 | 15576643 | 2022-09-20T19:02:11.000Z | 1000 | 0xe1c94a5947a4c3f632534dfc169c1791afe8b20fdf064743028d7def36d9660b |
| 0xcbbc393970df99d2a63e845353dbdb040d3eee7c | false | 140 | 15576643 | 2022-09-20T19:02:11.000Z | 1000 | 0xe1c94a5947a4c3f632534dfc169c1791afe8b20fdf064743028d7def36d9660b |
Example Query
Example Query
Query with partition filter
Strategy_UpdatedRewards_event
Yearn Finance V2 strategy reward configuration changes on Ethereum, recording when reward tokens are added or removed from vault strategies. Used to track reward token updates and strategy incentive modifications over time.Columns
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_rewards | STRING | Amount of rewards in the smallest token unit. Numeric string representation of wei or equivalent base unit value. |
Sample Data
Sample Data
| address | removed | log_index | in_rewards | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x4f3c19878da5366fd85648ef8692d96067dee16d | false | 61 | 0xc491599b9a20c3a2f0a85697ee6d9434efa9f503 | 12985426 | 2021-08-08T15:59:32.000Z | 0x7e599ecdd22e6d2bc1c6099aa0b61f7bf1b9da0c5ec151d5eec47fb5b9d7c356 |
| 0x19b2c8b3c601e9690ee524b02d4aca058db8b0d7 | false | 171 | 0xc491599b9a20c3a2f0a85697ee6d9434efa9f503 | 13424615 | 2021-10-15T19:57:18.000Z | 0x3def370d66c7226981e4adbfe7ccf662ebec703b9a986c1385047a4d4e115dd1 |
| 0x66f7b6e7eb858075d6f2c5615f22659a1a20f6d6 | false | 362 | 0x16388463d60ffe0661cf7f1f31a7d658ac790ff7 | 15501241 | 2022-09-09T06:22:00.000Z | 0x2078b3bd9759db53f5a0206cfde5beae9bbc4f4c7828f24d7acd8086550742db |
Example Query
Example Query
Query with partition filter
yVault_EmergencyShutdown_event
Emergency shutdown events from Yearn Finance v2 vaults on Ethereum, tracking when vaults are paused or reactivated. Used for monitoring vault security incidents and operational status changes.Columns
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_active | BOOL | Indicates whether the Yearn vault emergency shutdown is currently active (true) or has been deactivated (false). Sample data shows vaults initially shutting down then later being reactivated within a two-day period. |
Sample Data
Sample Data
| address | removed | in_active | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0xe537b5cc158eb71037d4125bdd7538421981e6aa | false | true | 155 | 14972625 | 2022-06-16T09:44:10.000Z | 0x721f1318716961d44dd26c47be17e66edf3a15fc88c7e1e1a6ed4628856c378e |
| 0xd88dbba3f9c4391ee46f5ff548f289054db6e51c | false | true | 118 | 14972664 | 2022-06-16T09:54:23.000Z | 0x4a15b55b4a59a6c08c71d27f3d618a8443ef394946b3d198b7c952701722933e |
| 0x1635b506a88fbf428465ad65d00e8d6b6e5846c3 | false | true | 119 | 14972664 | 2022-06-16T09:54:23.000Z | 0x4a15b55b4a59a6c08c71d27f3d618a8443ef394946b3d198b7c952701722933e |
Example Query
Example Query
Query with partition filter
yVault_StrategyAdded_event
Strategy addition events from Yearn Finance V2 vaults on Ethereum, capturing when new yield strategies are deployed to vaults with their debt allocation parameters and performance fee settings. Used for tracking vault strategy configurations and analyzing yield optimization changes over time.Columns
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_strategy | STRING | Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string. |
in_debtRatio | STRING | Percentage of vault’s total assets allocated to this strategy, expressed in basis points where 10000 equals 100%. Values typically range from 0 (inactive) to 10000 (full allocation). |
in_minDebtPerHarvest | STRING | Minimum amount of debt that the strategy must take on during each harvest operation. Typically set to 0 to allow harvests of any size. |
in_maxDebtPerHarvest | STRING | Maximum debt amount the strategy can take on in a single harvest operation, specified in the vault’s underlying token units. Typically set to uint256 max value to allow unlimited per-harvest borrowing from the vault. |
in_performanceFee | STRING | Previous performance fee rate for the vault. Numeric string representation where the value is basis points divided by 100 to yield the percentage. |
Sample Data
Sample Data
| address | removed | log_index | in_strategy | block_number | in_debtRatio | block_timestamp | transaction_hash | in_performanceFee | in_maxDebtPerHarvest | in_minDebtPerHarvest |
|---|---|---|---|---|---|---|---|---|---|---|
| 0x132d8d2c76db3812403431facb00f3453fc42125 | false | 61 | 0xb194dcff4e11d26919ce3b3255f69aeca5951e88 | 12535318 | 10 | 2021-05-30T10:57:08.000Z | 0x75a043508a171f827c256413b782394c6c9116d48168b8f65da418f1c6463564 | 1000 | 115792089237316195423570985008687907853269984665640564039457584007913129639935 | 0 |
| 0xbfedbcbe27171c418cdabc2477042554b1904857 | false | 85 | 0x8e4aa2e00694adaf37f0311651262671f4d7ac16 | 12535318 | 10 | 2021-05-30T10:57:08.000Z | 0x75a043508a171f827c256413b782394c6c9116d48168b8f65da418f1c6463564 | 1000 | 115792089237316195423570985008687907853269984665640564039457584007913129639935 | 0 |
| 0x25212df29073fffa7a67399acefc2dd75a831a1a | false | 59 | 0x4dc2ccc9e76bd30982243c1cb915003e17a88eb9 | 12535745 | 10 | 2021-05-30T12:28:22.000Z | 0x7163badb4c65a1ef8ef8926f6782f26c42247dcaa38fc868e009ed13faa38379 | 1000 | 115792089237316195423570985008687907853269984665640564039457584007913129639935 | 0 |
Example Query
Example Query
Query with partition filter
yVault_StrategyMigrated_event
Strategy migration events from Yearn Finance V2 vaults on Ethereum, recording when vault strategies are upgraded from old to new contract versions. Used for tracking vault strategy changes and protocol upgrades over time.Columns
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_oldVersion | STRING | Contract address of the previous strategy version being replaced in this Yearn vault migration event. Hex-encoded, 0x-prefixed 40-character Ethereum address that is being deprecated. |
in_newVersion | STRING | Contract address of the new strategy version being activated in this Yearn V2 vault migration. Hex-encoded, 0x-prefixed 40-character Ethereum address replacing the previous strategy implementation. |
Sample Data
Sample Data
| address | removed | log_index | block_number | in_newVersion | in_oldVersion | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 215 | 13061091 | 0xc57a4d3fbef85e675f6c3656498beefe6f9dcb55 | 0xcdc3d3a18c9d83ee6e10e91b48b1fcb5268c97b5 | 2021-08-20T08:38:05.000Z | 0x4ea6424ee6b0a9df47329873eabdca7980a114682712c496de976050126932b9 |
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 220 | 13061091 | 0xf9fdc2b5f60355a237deb8bd62cc117b1c907f7b | 0x8c44cc5c0f5cd2f7f17b9aca85d456df25a61ae8 | 2021-08-20T08:38:05.000Z | 0x4ea6424ee6b0a9df47329873eabdca7980a114682712c496de976050126932b9 |
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 93 | 14666557 | 0xb0f8b341951233bf08a5f15a838a1a85b016aef9 | 0x1d4439680c489f18ce480e72deedc235952af9c9 | 2022-04-27T12:45:11.000Z | 0x85dbb64fa0a347be04ac59b46c45ad579f8121b4211be6d7b477ebb199ac5a92 |
Example Query
Example Query
Query with partition filter
yVault_StrategyReported_event
Strategy performance reports from Yearn Finance V2 vaults on Ethereum, tracking gains, losses, debt changes, and capital allocation ratios per harvest. Used for analyzing vault strategy returns, debt management, and vault keeper activity.Columns
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_strategy | STRING | Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string. |
in_gain | STRING | Profit generated by the strategy since the last report, denominated in the vault’s underlying token with 18 decimal precision. Always non-negative; losses are tracked separately in the in_loss field. |
in_loss | STRING | Loss amount incurred by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination. |
in_debtPaid | STRING | Amount of debt the strategy returned to the vault in this report, denominated in the vault’s underlying token with 18 decimal precision. Zero when debt is added rather than repaid. |
in_totalGain | STRING | Cumulative profit generated by this strategy for the vault since deployment, measured in the vault’s base token with 18 decimal precision. This value increases over time as the strategy realizes gains from its yield-generating activities. |
in_totalLoss | STRING | Cumulative losses incurred by this strategy since its deployment to the vault, denominated in the vault’s underlying token with full decimal precision. Value remains at zero when no losses have occurred. |
in_totalDebt | STRING | Cumulative debt currently owed to this strategy by the vault, denominated in the vault’s underlying token (wei). Represents the total capital allocated by the vault that the strategy is responsible for managing. |
in_debtAdded | STRING | Amount of new debt allocated to the strategy in this report, denominated in the vault’s underlying token with full decimal precision. Zero when debt is being reduced rather than increased. |
in_debtRatio | STRING | Proportion of vault’s total assets allocated to this strategy, expressed in basis points (10000 = 100%). Determines the maximum debt the vault can deploy to the strategy relative to total vault assets. |
Sample Data
Sample Data
| address | in_gain | in_loss | removed | log_index | in_debtPaid | in_strategy | block_number | in_debtAdded | in_debtRatio | in_totalDebt | in_totalGain | in_totalLoss | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | 1371816973376857977 | 0 | false | 113 | 137638922166643165126 | 0xb0f8b341951233bf08a5f15a838a1a85b016aef9 | 15127872 | 0 | 595 | 4073344380730598312244 | 41121867567306559587 | 0 | 2022-07-12T12:43:58.000Z | 0x1c7947692791b8c8bc6b363793f47d3f0d0e4b2e3038672690454fe323390cd4 |
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | 1896538669859936787 | 0 | false | 80 | 457660891462340351477 | 0xf9fdc2b5f60355a237deb8bd62cc117b1c907f7b | 15127872 | 0 | 2285 | 15642578254307915396845 | 1262136856776727875801 | 0 | 2022-07-12T12:43:58.000Z | 0x1c7947692791b8c8bc6b363793f47d3f0d0e4b2e3038672690454fe323390cd4 |
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | 9658728050644537652 | 0 | false | 44 | 0 | 0xec2db4a1ad431cc3b102059fa91ba643620f0826 | 16362417 | 1536946016708160451702 | 4146 | 30342446307499534805556 | 166854027781543019711 | 0 | 2023-01-08T13:38:23.000Z | 0x8919fcd35578f430413a3d1d147582d39d15543ae63a1ccd87119587eb50e4b9 |
Example Query
Example Query
Query with partition filter
yVault_StrategyRevoked_event
Strategy removal events from Yearn Finance V2 vaults on Ethereum. Records when vault strategies are revoked with vault and strategy addresses for tracking yield optimization changes and vault governance actions.Columns
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_strategy | STRING | Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | removed | log_index | in_strategy | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x4213458c69c19e6792510e1153cb0c5834665fdc | false | 532 | 0xc68792944b3f9ee1cf1a42880ddc562d1a7933ca | 15535340 | 2022-09-14T22:14:11.000Z | 0x2ed7aa04db4c789142512bf78afa2eb2fe6dc434310ce648340402f58ff1365f |
| 0x671a912c10bba0cfa74cfc2d6fba9ba1ed9530b2 | false | 233 | 0xa2a182c5b5ea1a3c90cb5bb718f9e62dbe052927 | 13520442 | 2021-10-30T19:53:24.000Z | 0x84b51c10df39ac65c85370758a2028057e1204492851f154d1fa3ab875fa01ac |
| 0xf29ae508698bdef169b89834f76704c3b205aedf | false | 225 | 0x29d23b73dd0ed729f516bb55622765af102f0e33 | 13520442 | 2021-10-30T19:53:24.000Z | 0x84b51c10df39ac65c85370758a2028057e1204492851f154d1fa3ab875fa01ac |
Example Query
Example Query
Query with partition filter
yVault_Transfer_event
Yearn Finance v2 vault share token transfers on Ethereum, tracking deposits (mints from zero address), withdrawals (burns to zero address), and share movements between accounts. Essential for analyzing vault user flows, total value locked changes, and liquidity provider behavior.Columns
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_sender | STRING | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_receiver | STRING | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_value | STRING | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
Sample Data
Sample Data
| address | removed | in_value | in_sender | log_index | in_receiver | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x0d4ea8536f9a13e4fba16042a46c30f092b06aa5 | false | 72330509011307952512057 | 0xfa7f7967328abf5087c9e609b0c1a543aa9a6abb | 156 | 0x0000000000000000000000000000000000000000 | 13674277 | 2021-11-24T01:20:12.000Z | 0xc1b5c2fbe42d4dba3c6f6d8d5e75d7616bc1b621bd59b7542947a3c007ec2e28 |
| 0x19d3364a399d251e894ac732651be8b0e4e85001 | false | 81632144109591144055555 | 0x9f6e465b94fc2ccb507d39af953e8a503afb2ddd | 129 | 0x1824df8d751704fa10fa371d62a37f9b8772ab90 | 13678771 | 2021-11-24T18:22:46.000Z | 0xaf346ce517c286257157f5e82f3defb9ccbb4c607a01bae7e976d9ae927021f9 |
| 0x19d3364a399d251e894ac732651be8b0e4e85001 | false | 81632144109591144055555 | 0x1824df8d751704fa10fa371d62a37f9b8772ab90 | 133 | 0x0000000000000000000000000000000000000000 | 13678771 | 2021-11-24T18:22:46.000Z | 0xaf346ce517c286257157f5e82f3defb9ccbb4c607a01bae7e976d9ae927021f9 |
Example Query
Example Query
Query with partition filter
yVault_UpdateManagementFee_event
Management fee parameter changes for Yearn Finance V2 vaults on Ethereum. Tracks vault governance updates to annual management fee rates (in basis points) for analyzing vault economics and fee structures over time.Columns
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_managementFee | STRING | Management fee rate charged by the Yearn vault, expressed in basis points where 200 equals 2% annual fee. This parameter determines the percentage of assets under management extracted as protocol revenue. |
Sample Data
Sample Data
| address | removed | log_index | block_number | block_timestamp | in_managementFee | transaction_hash |
|---|---|---|---|---|---|---|
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 317 | 12588794 | 2021-06-07T17:48:06.000Z | 200 | 0xb13def20f4ec56e8480edead2b7452d67ef2edcd7eabd68cff75998ccc4c6f4a |
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 154 | 12589065 | 2021-06-07T18:48:21.000Z | 0 | 0xa9130f27c8921eada7b09c8028927d818d8e0c91afcf0ead768ca3a6f5310e62 |
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 161 | 12632208 | 2021-06-14T11:08:20.000Z | 200 | 0x695a8489b4fdc18912b841d241c687c5d41cca3943db545b3ef5e340c766e679 |
Example Query
Example Query
Query with partition filter
yVault_UpdatePerformanceFee_event
Performance fee change events from Yearn Finance v2 vaults on Ethereum, capturing updates to the fee percentage charged on vault profits. Useful for tracking vault fee structure changes and governance decisions over time.Columns
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_performanceFee | STRING | Previous performance fee rate for the vault. Numeric string representation where the value is basis points divided by 100 to yield the percentage. |
Sample Data
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash | in_performanceFee |
|---|---|---|---|---|---|---|
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 316 | 12588794 | 2021-06-07T17:48:06.000Z | 0xb13def20f4ec56e8480edead2b7452d67ef2edcd7eabd68cff75998ccc4c6f4a | 1000 |
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 532 | 14534982 | 2022-04-06T22:20:25.000Z | 0xd3de5e039cdb7e85fba3524e929b7de4936643e27ff2930f90e54cf1953b13d9 | 2000 |
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 436 | 14534982 | 2022-04-06T22:20:25.000Z | 0xd3de5e039cdb7e85fba3524e929b7de4936643e27ff2930f90e54cf1953b13d9 | 2000 |
Example Query
Example Query
Query with partition filter
yVault_UpdateRewards_event
UpdateRewards events from Yearn Finance v2 vaults on Ethereum, tracking when vault reward token addresses are modified. Used for monitoring vault configuration changes and analyzing reward token distributions across the protocol.Columns
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_rewards | STRING | Amount of rewards in the smallest token unit. Numeric string representation of wei or equivalent base unit value. |
Sample Data
Sample Data
| address | removed | log_index | in_rewards | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0xa258c4606ca8206d8aa700ce2143d7db854d168c | false | 314 | 0x93a62da5a14c80f265dabc077fcee437b1a0efde | 12588794 | 2021-06-07T17:48:06.000Z | 0xb13def20f4ec56e8480edead2b7452d67ef2edcd7eabd68cff75998ccc4c6f4a |
Example Query
Example Query
Query with partition filter