Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_deployerSTRINGAddress of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string.
in_vaultSTRINGContract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
in_api_versionSTRINGAPI 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.
addressremovedin_tokenin_vaultlog_indexin_deployerblock_numberin_api_versionblock_timestamptransaction_hash
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false0x453d92c7d4263201c69aacfaf589ed14202d83a40xc97232527b62efb0d8ed38cf3ea103a6cca4037e850x0b634a8d61b09820e9f72f79cdcbc8a4d0aad26b156249880.4.32022-09-27T13:28:23.000Z0x9dc2b0e6331dc34e65beb6497f2b9b488265f57f1a0bdd017991002bb769cbab
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false0xfcc5c47be19d06bf83eb04298b026f81069ff65b0x27b5739e22ad9033bcbf192059122d163b60349d800x0b634a8d61b09820e9f72f79cdcbc8a4d0aad26b156249890.4.32022-09-27T13:28:35.000Z0x321b62307f9a607ba5ca33f44d4166f5220771cdbca2d7510623a38d433aa6f2
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false0x02d341ccb60faaf662bc0554d13778015d1b285c0x32413274504908460f0c373c7f20f429fb80ed3a2470x710295b5f326c2e47e6dd2e7f6b5b0f7c5ac2f24120783020.3.32021-03-20T22:05:38.000Z0x488e8ec4db146c2e7fcca57959af8adb9b7272e1cc2c61bd508bf0c3ea0515e8
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.Registry_NewExperimentalVault_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_governanceSTRINGEthereum address of the new governance contract that was set for the Yearn registry. Hex-encoded, 0x-prefixed 40-character string representing the governance authority.
addressremovedlog_indexblock_numberin_governanceblock_timestamptransaction_hash
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false66120519920xfeb4acf3df3cdea7399794d0869ef76a6efaff522021-03-16T20:58:10.000Z0x5c9abb1b2e82f92cf1726b9079f432e348872f84642440000feb296cb6c9174d
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.Registry_NewGovernance_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_release_idSTRINGNumeric 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_templateSTRINGContract 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_versionSTRINGSemantic 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.
addressremovedlog_indexin_templateblock_numberin_release_idin_api_versionblock_timestamptransaction_hash
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false1900x662fbf2c1e4b04342eeba6371ec1c7420042b86f1204563340.3.32021-03-15T21:31:55.000Z0x59c94544c78cb8351db3cfcc9a006d11cfd6a325a41c092fbb3980ddadb9c22e
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false2750x986b4aff588a109c09b50a03f42e4110e29d353f1204557330.3.22021-03-15T21:18:38.000Z0x97cb4952cfe7e2571016894967b514ec6397c42321172a15ab2990ecf1560e6a
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false2720xbfa4d8aa6d8a379abfe7793399d3ddacc5bbecbb1204557300.2.22021-03-15T21:18:38.000Z0x699c5df46ff58e55544b3e8aec997fe944c1f9ecaccf1dfe90fc7e5a9c0dc3e3
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.Registry_NewRelease_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_vault_idSTRINGNumeric 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_vaultSTRINGContract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
in_api_versionSTRINGYearn 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.
addressremovedin_tokenin_vaultlog_indexin_vault_idblock_numberin_api_versionblock_timestamptransaction_hash
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false0x64eda51d3ad40d56b9dfc5554e06f94e1dd786fd0x23d3d0f1c697247d5e0a9efb37d8b0ed0c464f7f1440123207850.3.52021-04-27T06:33:50.000Z0x4c59dccb83dd6f706f4b1c900d4aad7a55d6aefc963fd5da80cf4211f08a3801
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false0x9fc689ccada600b6df723d9e47d84d76664a1f230x28a5b95c101df3ded0c0d9074db80c438774b6a91000127490120.3.52021-07-02T15:31:18.000Z0x8689137a0c6a918fa34c85e3ee23871c586ad7f2a8474087a37896094879ccdf
0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false0xd905e2eaebe188fc92179b6350807d8bd91db0d80x80bbee2fa460da291e796b9045e93d19ef948c6a970127490120.3.52021-07-02T15:31:18.000Z0x8689137a0c6a918fa34c85e3ee23871c586ad7f2a8474087a37896094879ccdf
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.Registry_NewVault_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_vaultSTRINGContract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
in_tagSTRINGTag 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.
in_tagaddressremovedin_vaultlog_indexblock_numberblock_timestamptransaction_hash
Removed0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false0x8a0889d47f9aa0fac1cc718ba34e26b86743788060156756942022-10-04T15:34:59.000Z0xb6cc39db07e0a29385a6b34a347a4196d917e0b1225aff2bbd42a7a1220ad8b3
Removed0x50c1a2ea0a861a967d9d0ffe2ae4012c2e053804false0x61f46c65e403429266e8b569f23f70dd75d9bee761156756942022-10-04T15:34:59.000Z0xb6cc39db07e0a29385a6b34a347a4196d917e0b1225aff2bbd42a7a1220ad8b3
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.Registry_VaultTagged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_profitSTRINGProfit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.
in_lossSTRINGLoss amount incurred by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.
in_debtPaymentSTRINGAmount 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_debtOutstandingSTRINGOutstanding 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.
addressin_lossremovedin_profitlog_indexblock_numberin_debtPaymentblock_timestamptransaction_hashin_debtOutstanding
0x0967afe627c732d152e3dfcadd6f9dbfecde18c30false2961018145869125052781354991002021-11-04T11:19:41.000Z0x4de90525d47856074ee793902df14950c7727ac32820d3136ef6dbd19e466f480
0x33d7e0fa2c7db85ef3abc1c44e07e0b5cb2e4c140false22483807519657497491512331355183002021-11-04T18:32:58.000Z0x66ee7d122d25afe0ddd9b35a9cc4d2c0e3240f9eaf4b58da25c264a32c65716d0
0x1676055fe954ee6fc388f9096210e5ebe0a9070c0false103269604790935795611073351355004402021-11-04T11:52:55.000Z0x87404b58c7b0f060105565b9b86e71019370c135790e8bdd5090c409d97eeb620
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.Strategy_Harvested_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_debtThresholdSTRINGThe 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).
addressremovedlog_indexblock_numberblock_timestampin_debtThresholdtransaction_hash
0x1676055fe954ee6fc388f9096210e5ebe0a9070cfalse230134952082021-10-26T20:52:47.000Z10000000000000000000000000000000x4739da9436a9bda879ffde750d9cae233efbc8f9c270e5d9417a89a05a2206b6
0xaf6f42bfb29e90dfe51f2341ff1b1f99fd776a70false108150588192022-07-01T20:50:23.000Z10000000000000000000000000000000000000000000000xe228355393dc7f0ce0295509002e65ce770f6dac29a2af1f6dfdd63f97b6ee1e
0x4b7fc5661f804d558691ecd3724d4961bb64facafalse417149594872022-06-14T02:55:13.000Z10000000000000000000000000000000000000xf4e7b2341ca387c1eda6b7eefeb83e43c8cf192be6af61c9f4f21e8c4dc221d5
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.Strategy_UpdatedDebtThreshold_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_profitFactorSTRINGNew 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%).
addressremovedlog_indexblock_numberblock_timestampin_profitFactortransaction_hash
0x1de1401c71362c05c680c5fd073888719d8f4196false144155766432022-09-20T19:02:11.000Z10000xe1c94a5947a4c3f632534dfc169c1791afe8b20fdf064743028d7def36d9660b
0xec2db4a1ad431cc3b102059fa91ba643620f0826false128155766432022-09-20T19:02:11.000Z10000xe1c94a5947a4c3f632534dfc169c1791afe8b20fdf064743028d7def36d9660b
0xcbbc393970df99d2a63e845353dbdb040d3eee7cfalse140155766432022-09-20T19:02:11.000Z10000xe1c94a5947a4c3f632534dfc169c1791afe8b20fdf064743028d7def36d9660b
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.Strategy_UpdatedProfitFactor_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_rewardsSTRINGAmount of rewards in the smallest token unit. Numeric string representation of wei or equivalent base unit value.
addressremovedlog_indexin_rewardsblock_numberblock_timestamptransaction_hash
0x4f3c19878da5366fd85648ef8692d96067dee16dfalse610xc491599b9a20c3a2f0a85697ee6d9434efa9f503129854262021-08-08T15:59:32.000Z0x7e599ecdd22e6d2bc1c6099aa0b61f7bf1b9da0c5ec151d5eec47fb5b9d7c356
0x19b2c8b3c601e9690ee524b02d4aca058db8b0d7false1710xc491599b9a20c3a2f0a85697ee6d9434efa9f503134246152021-10-15T19:57:18.000Z0x3def370d66c7226981e4adbfe7ccf662ebec703b9a986c1385047a4d4e115dd1
0x66f7b6e7eb858075d6f2c5615f22659a1a20f6d6false3620x16388463d60ffe0661cf7f1f31a7d658ac790ff7155012412022-09-09T06:22:00.000Z0x2078b3bd9759db53f5a0206cfde5beae9bbc4f4c7828f24d7acd8086550742db
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.Strategy_UpdatedRewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_activeBOOLIndicates 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.
addressremovedin_activelog_indexblock_numberblock_timestamptransaction_hash
0xe537b5cc158eb71037d4125bdd7538421981e6aafalsetrue155149726252022-06-16T09:44:10.000Z0x721f1318716961d44dd26c47be17e66edf3a15fc88c7e1e1a6ed4628856c378e
0xd88dbba3f9c4391ee46f5ff548f289054db6e51cfalsetrue118149726642022-06-16T09:54:23.000Z0x4a15b55b4a59a6c08c71d27f3d618a8443ef394946b3d198b7c952701722933e
0x1635b506a88fbf428465ad65d00e8d6b6e5846c3falsetrue119149726642022-06-16T09:54:23.000Z0x4a15b55b4a59a6c08c71d27f3d618a8443ef394946b3d198b7c952701722933e
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.yVault_EmergencyShutdown_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_strategySTRINGContract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string.
in_debtRatioSTRINGPercentage 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_minDebtPerHarvestSTRINGMinimum amount of debt that the strategy must take on during each harvest operation. Typically set to 0 to allow harvests of any size.
in_maxDebtPerHarvestSTRINGMaximum 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_performanceFeeSTRINGPrevious performance fee rate for the vault. Numeric string representation where the value is basis points divided by 100 to yield the percentage.
addressremovedlog_indexin_strategyblock_numberin_debtRatioblock_timestamptransaction_hashin_performanceFeein_maxDebtPerHarvestin_minDebtPerHarvest
0x132d8d2c76db3812403431facb00f3453fc42125false610xb194dcff4e11d26919ce3b3255f69aeca5951e8812535318102021-05-30T10:57:08.000Z0x75a043508a171f827c256413b782394c6c9116d48168b8f65da418f1c646356410001157920892373161954235709850086879078532699846656405640394575840079131296399350
0xbfedbcbe27171c418cdabc2477042554b1904857false850x8e4aa2e00694adaf37f0311651262671f4d7ac1612535318102021-05-30T10:57:08.000Z0x75a043508a171f827c256413b782394c6c9116d48168b8f65da418f1c646356410001157920892373161954235709850086879078532699846656405640394575840079131296399350
0x25212df29073fffa7a67399acefc2dd75a831a1afalse590x4dc2ccc9e76bd30982243c1cb915003e17a88eb912535745102021-05-30T12:28:22.000Z0x7163badb4c65a1ef8ef8926f6782f26c42247dcaa38fc868e009ed13faa3837910001157920892373161954235709850086879078532699846656405640394575840079131296399350
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.yVault_StrategyAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_oldVersionSTRINGContract 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_newVersionSTRINGContract 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.
addressremovedlog_indexblock_numberin_newVersionin_oldVersionblock_timestamptransaction_hash
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse215130610910xc57a4d3fbef85e675f6c3656498beefe6f9dcb550xcdc3d3a18c9d83ee6e10e91b48b1fcb5268c97b52021-08-20T08:38:05.000Z0x4ea6424ee6b0a9df47329873eabdca7980a114682712c496de976050126932b9
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse220130610910xf9fdc2b5f60355a237deb8bd62cc117b1c907f7b0x8c44cc5c0f5cd2f7f17b9aca85d456df25a61ae82021-08-20T08:38:05.000Z0x4ea6424ee6b0a9df47329873eabdca7980a114682712c496de976050126932b9
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse93146665570xb0f8b341951233bf08a5f15a838a1a85b016aef90x1d4439680c489f18ce480e72deedc235952af9c92022-04-27T12:45:11.000Z0x85dbb64fa0a347be04ac59b46c45ad579f8121b4211be6d7b477ebb199ac5a92
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.yVault_StrategyMigrated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_strategySTRINGContract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string.
in_gainSTRINGProfit 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_lossSTRINGLoss amount incurred by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.
in_debtPaidSTRINGAmount 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_totalGainSTRINGCumulative 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_totalLossSTRINGCumulative 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_totalDebtSTRINGCumulative 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_debtAddedSTRINGAmount 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_debtRatioSTRINGProportion 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.
addressin_gainin_lossremovedlog_indexin_debtPaidin_strategyblock_numberin_debtAddedin_debtRatioin_totalDebtin_totalGainin_totalLossblock_timestamptransaction_hash
0xa258c4606ca8206d8aa700ce2143d7db854d168c13718169733768579770false1131376389221666431651260xb0f8b341951233bf08a5f15a838a1a85b016aef915127872059540733443807305983122444112186756730655958702022-07-12T12:43:58.000Z0x1c7947692791b8c8bc6b363793f47d3f0d0e4b2e3038672690454fe323390cd4
0xa258c4606ca8206d8aa700ce2143d7db854d168c18965386698599367870false804576608914623403514770xf9fdc2b5f60355a237deb8bd62cc117b1c907f7b151278720228515642578254307915396845126213685677672787580102022-07-12T12:43:58.000Z0x1c7947692791b8c8bc6b363793f47d3f0d0e4b2e3038672690454fe323390cd4
0xa258c4606ca8206d8aa700ce2143d7db854d168c96587280506445376520false4400xec2db4a1ad431cc3b102059fa91ba643620f082616362417153694601670816045170241463034244630749953480555616685402778154301971102023-01-08T13:38:23.000Z0x8919fcd35578f430413a3d1d147582d39d15543ae63a1ccd87119587eb50e4b9
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.yVault_StrategyReported_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_strategySTRINGContract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedlog_indexin_strategyblock_numberblock_timestamptransaction_hash
0x4213458c69c19e6792510e1153cb0c5834665fdcfalse5320xc68792944b3f9ee1cf1a42880ddc562d1a7933ca155353402022-09-14T22:14:11.000Z0x2ed7aa04db4c789142512bf78afa2eb2fe6dc434310ce648340402f58ff1365f
0x671a912c10bba0cfa74cfc2d6fba9ba1ed9530b2false2330xa2a182c5b5ea1a3c90cb5bb718f9e62dbe052927135204422021-10-30T19:53:24.000Z0x84b51c10df39ac65c85370758a2028057e1204492851f154d1fa3ab875fa01ac
0xf29ae508698bdef169b89834f76704c3b205aedffalse2250x29d23b73dd0ed729f516bb55622765af102f0e33135204422021-10-30T19:53:24.000Z0x84b51c10df39ac65c85370758a2028057e1204492851f154d1fa3ab875fa01ac
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.yVault_StrategyRevoked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
addressremovedin_valuein_senderlog_indexin_receiverblock_numberblock_timestamptransaction_hash
0x0d4ea8536f9a13e4fba16042a46c30f092b06aa5false723305090113079525120570xfa7f7967328abf5087c9e609b0c1a543aa9a6abb1560x0000000000000000000000000000000000000000136742772021-11-24T01:20:12.000Z0xc1b5c2fbe42d4dba3c6f6d8d5e75d7616bc1b621bd59b7542947a3c007ec2e28
0x19d3364a399d251e894ac732651be8b0e4e85001false816321441095911440555550x9f6e465b94fc2ccb507d39af953e8a503afb2ddd1290x1824df8d751704fa10fa371d62a37f9b8772ab90136787712021-11-24T18:22:46.000Z0xaf346ce517c286257157f5e82f3defb9ccbb4c607a01bae7e976d9ae927021f9
0x19d3364a399d251e894ac732651be8b0e4e85001false816321441095911440555550x1824df8d751704fa10fa371d62a37f9b8772ab901330x0000000000000000000000000000000000000000136787712021-11-24T18:22:46.000Z0xaf346ce517c286257157f5e82f3defb9ccbb4c607a01bae7e976d9ae927021f9
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.yVault_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_managementFeeSTRINGManagement 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.
addressremovedlog_indexblock_numberblock_timestampin_managementFeetransaction_hash
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse317125887942021-06-07T17:48:06.000Z2000xb13def20f4ec56e8480edead2b7452d67ef2edcd7eabd68cff75998ccc4c6f4a
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse154125890652021-06-07T18:48:21.000Z00xa9130f27c8921eada7b09c8028927d818d8e0c91afcf0ead768ca3a6f5310e62
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse161126322082021-06-14T11:08:20.000Z2000x695a8489b4fdc18912b841d241c687c5d41cca3943db545b3ef5e340c766e679
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.yVault_UpdateManagementFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_performanceFeeSTRINGPrevious performance fee rate for the vault. Numeric string representation where the value is basis points divided by 100 to yield the percentage.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_performanceFee
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse316125887942021-06-07T17:48:06.000Z0xb13def20f4ec56e8480edead2b7452d67ef2edcd7eabd68cff75998ccc4c6f4a1000
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse532145349822022-04-06T22:20:25.000Z0xd3de5e039cdb7e85fba3524e929b7de4936643e27ff2930f90e54cf1953b13d92000
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse436145349822022-04-06T22:20:25.000Z0xd3de5e039cdb7e85fba3524e929b7de4936643e27ff2930f90e54cf1953b13d92000
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.yVault_UpdatePerformanceFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_rewardsSTRINGAmount of rewards in the smallest token unit. Numeric string representation of wei or equivalent base unit value.
addressremovedlog_indexin_rewardsblock_numberblock_timestamptransaction_hash
0xa258c4606ca8206d8aa700ce2143d7db854d168cfalse3140x93a62da5a14c80f265dabc077fcee437b1a0efde125887942021-06-07T17:48:06.000Z0xb13def20f4ec56e8480edead2b7452d67ef2edcd7eabd68cff75998ccc4c6f4a
Query with partition filter
SELECT *
FROM `tt-contracts.yearnfinance_v2_ethereum.yVault_UpdateRewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100