alchemix_v1_ethereum

Tables

AlchemistALETH_FundsHarvested_event

Yield harvest events from Alchemix V1 alETH (Alchemix ETH) vaults on Ethereum, recording when protocol strategies withdraw earned yields and decrease vault debt positions. Used for tracking yield generation performance and vault debt management over time.

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_withdrawnAmount`	`STRING`	Amount of tokens withdrawn from the protocol. Numeric string representing the value in the smallest unit of the token.
`in_decreasedValue`	`STRING`	Amount by which the total value decreased in the operation. Numeric string representing the value in the smallest unit of the token (wei for ETH-based tokens, base units for stablecoins).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_decreasedValue	in_withdrawnAmount
0xf8317bd5f48b6fe608a52b48c856d3367540b73b	false	66	13781711	2021-12-11T04:23:45.000Z	0x01cb1fa2b7e30d153ebe52639b0f4819cadf593ecd9811f3207cbb7eef5846df	9295323576586758655	9295323576586758662
0xf8317bd5f48b6fe608a52b48c856d3367540b73b	false	328	14654175	2022-04-25T13:53:58.000Z	0x81cf2273ea1dd0becdd0107e9c573b5bb2787c1db87ede630376d73376348462	39332883441411514129	39332883441411514135
0xf8317bd5f48b6fe608a52b48c856d3367540b73b	false	43	15549952	2022-09-17T01:11:47.000Z	0xe8ed4f5ccfb463617fe0ca67fa7175770b981b5eafe952db8a976d0a760a2c97	11819051905152529389	11819051905152529395

Example Query

Query with partition filter

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

AlchemistALETH_TokensDeposited_event

Token deposit events from Alchemix V1’s Alchemist contract for ETH-backed synthetic assets on Ethereum. Records user collateral deposits with wei-denominated amounts for tracking lending vault positions and protocol TVL (Total Value Locked).

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0xf8317bd5f48b6fe608a52b48c856d3367540b73b	false	9450000000000000000	41	0xf31d84d7d139d7f7f0cd8087b5480212ae88ca0d	12918142	2021-07-29T02:37:48.000Z	0x5fabc6ec5094bbcc65239c7c324cdab73c7224367178cd809a545019ab76c8af
0xf8317bd5f48b6fe608a52b48c856d3367540b73b	false	810000000000000000	272	0x731ba6d73718e86d6b12fd373d648862de3f4056	12920210	2021-07-29T10:28:22.000Z	0x6c1eb143564be5e2c53da6f7a857812a14cf451f227dbad42b32096df41b1144
0xf8317bd5f48b6fe608a52b48c856d3367540b73b	false	465505631750000000	101	0xe5a01b0f801b8ecb1d3fe96f11e19b37977c23f9	12921271	2021-07-29T14:39:14.000Z	0xdaea9f4e6b37d8bb71db1f71661806186168b8a9804ce2244f1bed560875dbb8

Example Query

Query with partition filter

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

AlchemistALETH_TokensWithdrawn_event

Withdrawal events from Alchemix V1’s alETH (Alchemix ETH) Alchemist vault on Ethereum, capturing user account addresses, requested amounts, actual withdrawn amounts, and collateral value decreases. Used for tracking alETH redemptions and analyzing vault outflow patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_requestedAmount`	`STRING`	Amount of alETH tokens the user requested to withdraw from their Alchemix position, denominated in wei (18 decimals). May differ slightly from withdrawn amount due to rounding or available balance constraints.
`in_withdrawnAmount`	`STRING`	Amount of tokens withdrawn from the protocol. Numeric string representing the value in the smallest unit of the token.
`in_decreasedValue`	`STRING`	Amount by which the total value decreased in the operation. Numeric string representing the value in the smallest unit of the token (wei for ETH-based tokens, base units for stablecoins).

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	transaction_hash	in_decreasedValue	in_requestedAmount	in_withdrawnAmount
0xf8317bd5f48b6fe608a52b48c856d3367540b73b	false	81	0xf0a6814755a868b74d1c8c8b8c1a495404ee1c34	13697977	2021-11-27T19:41:57.000Z	0xd251c9b11cd08174e0e58a93c4ef10ff65ecb673ee43706bd121b54c6bbbe7d3	4007478859232332125	4007478859232332125	4007478859232332125
0xf8317bd5f48b6fe608a52b48c856d3367540b73b	false	418	0xe676d7058b1f481ab1d2e7052667fd16146825bb	13693375	2021-11-27T02:17:20.000Z	0xbac1c8599a890e750c39c408be2a631c1cd5e7216938db27d7945484253681fe	376341614595831397	376341614595831398	376341614595831397
0xf8317bd5f48b6fe608a52b48c856d3367540b73b	false	338	0xe5c1607aa00c6134e21d5ad418e59d5fe72d8abf	13696109	2021-11-27T12:38:51.000Z	0x65632d0d34266802d0f542cda5c3b8745006f7eaf1a4f4dab0d71f2627bebade	100000000000000000	100000000000000000	100000000000000000

Example Query

Query with partition filter

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

AlchemistALUSD_FundsHarvested_event

Yield harvest events from Alchemix v1 alUSD (Alchemix USD) vaults on Ethereum, recording withdrawal amounts and debt decreases when protocol profits are realized. Used for tracking vault performance and yield generation over time.

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_withdrawnAmount`	`STRING`	Amount of tokens withdrawn from the protocol. Numeric string representing the value in the smallest unit of the token.
`in_decreasedValue`	`STRING`	Amount by which the total value decreased in the operation. Numeric string representing the value in the smallest unit of the token (wei for ETH-based tokens, base units for stablecoins).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_decreasedValue	in_withdrawnAmount
0xc21d353ff4ee73c572425697f4f5aad2109fe35b	false	10	13728378	2021-12-02T16:26:25.000Z	0x1629331cdd727c12e0f8a69de45a5425d0c9dc25219f5ba808bef45556e5d761	59277863098628493843596	59277863098628493888571
0xc21d353ff4ee73c572425697f4f5aad2109fe35b	false	77	12359493	2021-05-03T06:05:19.000Z	0x474ca23901115d5f28fab1a675fa890f8d180e459758f79f09977e368ccde1ca	30387636939141590667701	30387636939141590680467
0xc21d353ff4ee73c572425697f4f5aad2109fe35b	false	117	12361368	2021-05-03T13:00:59.000Z	0xf4cec683e1a2ccad0d44a0d0517286000c8fc2d10e87dd1a5fb46db0605a1071	113467457480079103704132	113467457480079103811429

Example Query

Query with partition filter

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

AlchemistALUSD_TokensDeposited_event

Collateral deposit events for Alchemix V1’s alUSD vault on Ethereum, tracking user deposits of yield-bearing tokens into the Alchemist contract. Used for analyzing vault inflows, user deposit patterns, and total value locked (TVL) changes over time.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0xc21d353ff4ee73c572425697f4f5aad2109fe35b	false	1093670914514236823646	256	0xa10ef20598eb14720c4498aea7a479f0382a4114	12220489	2021-04-11T19:08:43.000Z	0x70fdca12821b3abacb5ca0b9d5732d4eae65dd203e051b7c78208402877c1c74
0xc21d353ff4ee73c572425697f4f5aad2109fe35b	false	335754105773688240094938	258	0x23b11ff67c2193b97cb37771d15a537b977d2278	12215432	2021-04-11T00:28:25.000Z	0xdaa7e980c89da787b6c7a018e706b7685c0ce99aea7682559057413c5377a225
0xc21d353ff4ee73c572425697f4f5aad2109fe35b	false	66871921018326643999	258	0x0efddcf523ffe33a6f6afa146563b3e3ae070932	12219897	2021-04-11T17:02:52.000Z	0x073d70ebd6ae94374feb8ecfa9b9f9bcb9ba66fca628233eb81dd67c12002c33

Example Query

Query with partition filter

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

AlchemistALUSD_TokensWithdrawn_event

Token withdrawal events from Alchemix V1’s alUSD vault (Alchemist contract) on Ethereum, capturing requested versus actual withdrawn amounts and debt position changes. Used for tracking user withdrawals, analyzing vault liquidity, and monitoring collateral redemption patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_requestedAmount`	`STRING`	Amount of alUSD tokens requested for withdrawal by the user, denominated in wei (18 decimals). Values typically differ slightly from the actual withdrawn amount due to rounding or fees.
`in_withdrawnAmount`	`STRING`	Amount of tokens withdrawn from the protocol. Numeric string representing the value in the smallest unit of the token.
`in_decreasedValue`	`STRING`	Amount by which the total value decreased in the operation. Numeric string representing the value in the smallest unit of the token (wei for ETH-based tokens, base units for stablecoins).

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	transaction_hash	in_requestedAmount
0xc21d353ff4ee73c572425697f4f5aad2109fe35b	false	196	0x15113c13258b10aa5f84e18918267eb2e0108b10	16269595	2022-12-26T14:42:59.000Z	0xe9ae75b4890a27f257b1190bd0a37c0dd25d22e25c1bdd44af24d6c95fdd971d	1
0xc21d353ff4ee73c572425697f4f5aad2109fe35b	false	288	0x32ea27d0aabd08a3f012ae16acd2b39b9fa3fd9c	16269656	2022-12-26T14:55:11.000Z	0x59d187a29e43f30d9ec319991f0b565669ccda35555cbd1d1671f274701507f7	1
0xc21d353ff4ee73c572425697f4f5aad2109fe35b	false	154	0x0174998c7e8fa81d45de706a1c911497921a8122	15901685	2022-11-05T05:19:47.000Z	0x790ad2040d2ffc844dccabd3a9d93903cc9d1c7295c2f64ed01d206463671b47	1

Example Query

Query with partition filter

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

StakingPools_TokensClaimed_event

Token reward claim events from Alchemix v1 staking pools on Ethereum. Records user withdrawals of earned rewards with claimed amounts and pool identifiers for analyzing staking incentive distribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	in_poolId	log_index	block_number	block_timestamp	transaction_hash
0xab8e74017a8cc7c15ffccd726603790d26d7deca	0x022ce4715b44ef6f0ead8561b29da676928d16f3	false	422445667651459877	1	112	14398049	2022-03-16T14:08:45.000Z	0x93dbd7f72ac2c47fa586699f06f126e57dbc22a62f1f01aaf97a62bfde249999
0xab8e74017a8cc7c15ffccd726603790d26d7deca	0x07cbd4e4473140b6078aa987907aaff5e500b9f1	false	9001673839125079065	1	430	14398528	2022-03-16T15:49:20.000Z	0x5c61d958bb92e0ec9d51ce8425853a37767984782520e8fc63d0c5b980048f6c
0xab8e74017a8cc7c15ffccd726603790d26d7deca	0x11d42300b6e1bb4039ef359cc5a53ccbf3d10c72	false	0	1	251	14397220	2022-03-16T11:09:50.000Z	0x0379bfca042895b5fd6658aaf7f6e85c9f2076fa7bd8577e42f3065bb0c7bd40

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AlchemistALETH_FundsHarvested_event

AlchemistALETH_TokensDeposited_event

AlchemistALETH_TokensWithdrawn_event

AlchemistALUSD_FundsHarvested_event

AlchemistALUSD_TokensDeposited_event

AlchemistALUSD_TokensWithdrawn_event

StakingPools_TokensClaimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AlchemistALETH_FundsHarvested_event

​AlchemistALETH_TokensDeposited_event

​AlchemistALETH_TokensWithdrawn_event

​AlchemistALUSD_FundsHarvested_event

​AlchemistALUSD_TokensDeposited_event

​AlchemistALUSD_TokensWithdrawn_event

​StakingPools_TokensClaimed_event

Tables

AlchemistALETH_FundsHarvested_event

AlchemistALETH_TokensDeposited_event

AlchemistALETH_TokensWithdrawn_event

AlchemistALUSD_FundsHarvested_event

AlchemistALUSD_TokensDeposited_event

AlchemistALUSD_TokensWithdrawn_event

StakingPools_TokensClaimed_event