alchemix_v2_ethereum

Tables

alETHAlchemist_Deposit_event

Deposit events from Alchemix V2’s alETH Alchemist contract on Ethereum, recording when users deposit yield-bearing ETH tokens as collateral. Useful for tracking collateral flows, depositor behavior, and total value locked (TVL) analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_yieldToken`	`STRING`	Contract address of the yield-bearing token being deposited, withdrawn, or harvested. 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.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	in_recipient	in_yieldToken	block_timestamp	transaction_hash
0x062bf725dc4cdf947aa79ca2aaccd4f385b13b5c	false	76059774897529735	0x2330eb2d92167c3b6b22690c03b508e0ca532980	132	17612846	0x2330eb2d92167c3b6b22690c03b508e0ca532980	0xac3e018457b222d93114458476f3e3416abbe38f	2023-07-03T10:28:11.000Z	0xf6203a22b95067bd7a1140583663520aae6700e83f0d1bf29b235ee49df43ae1
0x062bf725dc4cdf947aa79ca2aaccd4f385b13b5c	false	258458267133099806	0x2330eb2d92167c3b6b22690c03b508e0ca532980	237	17612945	0x2330eb2d92167c3b6b22690c03b508e0ca532980	0xac3e018457b222d93114458476f3e3416abbe38f	2023-07-03T10:48:11.000Z	0x9c5db1e8c840905c18bca89b5b8eaca954c32130eec6faf2487726d7a4a6e209
0x062bf725dc4cdf947aa79ca2aaccd4f385b13b5c	false	278068614971712402	0x5276a8ccf431c46d2cf448b9827eac0f4e4da64c	238	17613691	0x5276a8ccf431c46d2cf448b9827eac0f4e4da64c	0xac3e018457b222d93114458476f3e3416abbe38f	2023-07-03T13:19:47.000Z	0x8c297b3108dc49268946708f33a72031a4453105f2a53e5e51c6c4d15d670df3

Example Query

Query with partition filter

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

alETHAlchemist_Harvest_event

Yield harvest events from Alchemix V2’s alETH Alchemist contract on Ethereum, recording protocol withdrawals from yield-bearing tokens like wstETH (Lido) and yvWETH (Yearn) with harvest amounts and minimum output thresholds. Used for tracking protocol yield generation and liquidation strategies.

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_yieldToken`	`STRING`	Contract address of the yield-bearing token being deposited, withdrawn, or harvested. Hex-encoded, 0x-prefixed, 42-character string.
`in_minimumAmountOut`	`STRING`	Minimum acceptable output amount of tokens for the harvest operation, protecting against slippage. Specified in the smallest denomination (wei for ETH-based tokens), often set to zero for unrestricted swaps or slightly below expected output to allow reasonable slippage.
`in_totalHarvested`	`STRING`	Total amount of yield tokens harvested from the underlying protocol in this transaction, denominated in the smallest unit (wei). Stored as string to preserve precision for large 18-decimal token amounts.

Sample Data

address	removed	log_index	block_number	in_yieldToken	block_timestamp	transaction_hash	in_totalHarvested	in_minimumAmountOut
0x062bf725dc4cdf947aa79ca2aaccd4f385b13b5c	false	63	14723587	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2022-05-06T12:40:37.000Z	0x896eb1fa12949d90cf390cd55c92e3b6c1c7a6dc9fc28de1d812594f34045170	631050261391641851	630933959745966146
0x062bf725dc4cdf947aa79ca2aaccd4f385b13b5c	false	46	14725488	0xa258c4606ca8206d8aa700ce2143d7db854d168c	2022-05-06T19:55:30.000Z	0xb36dc37e428560ccc5ebca7a62ee85e0a7d8021a1905eac224906883f0662d2b	508085214851627249	504670235921798825
0x062bf725dc4cdf947aa79ca2aaccd4f385b13b5c	false	54	14677448	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2022-04-29T05:48:34.000Z	0xbd0e8d389fba5e5cadecfd80ca40e2324366c5d25b3a9ba18f3feec83bde8832	1409843186286963143	1409334760944130870

Example Query

Query with partition filter

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

alETHAlchemist_Withdraw_event

Withdrawal events from Alchemix V2’s alETH Alchemist vault on Ethereum, tracking users redeeming yield-bearing token shares for underlying assets. Records owner addresses, share amounts withdrawn, recipient addresses, and specific yield token contracts for analyzing vault exit activity.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_yieldToken`	`STRING`	Contract address of the yield-bearing token being deposited, withdrawn, or harvested. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_owner	in_shares	log_index	block_number	in_recipient	in_yieldToken	block_timestamp	transaction_hash
0x062bf725dc4cdf947aa79ca2aaccd4f385b13b5c	false	0xd3320391a0a7d59f49b54f9c3b2ca65dc3978063	990386595631212857	25	16104163	0x1dff114dfbbcaedca5f0d46dc8e9615dfc2645bd	0x61134511187a9a2df38d10dbe07ba2e8e5563967	2022-12-03T12:03:23.000Z	0x993ae9b3b5630ec25d35bb08e4c74f24e65db2a55565e854f1390da0ce5844dd
0x062bf725dc4cdf947aa79ca2aaccd4f385b13b5c	false	0x62dd85faddd8a263442bc04517b3748e5532088e	4351402212557528918	244	15575016	0xa22a7ec2d82a471b1dacc4b37345cf428e76d67a	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2022-09-20T13:34:11.000Z	0xb1b20bbe1fcf6d1c43419511978a2dee043702b1eeb036b93826dbb420e9838a
0x062bf725dc4cdf947aa79ca2aaccd4f385b13b5c	false	0x6543b529094ee8ac9ed9aa81f455de34cc3be0a7	517420299843872017301	370	16668271	0xa22a7ec2d82a471b1dacc4b37345cf428e76d67a	0xa258c4606ca8206d8aa700ce2143d7db854d168c	2023-02-20T07:27:35.000Z	0x67a409acad17d011641d0bd422d259e76c080ec84a7d0379fb847b1634166298

Example Query

Query with partition filter

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

alETHAMO_ClaimRewards_event

Reward claim events from Alchemix V2’s alETH Alchemist Meta Option (AMO) contract on Ethereum, tracking Curve and Convex token distributions. Records successful reward harvests with amounts claimed from both Curve LP rewards and Convex staking incentives.

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_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.
`in_amountCurve`	`STRING`	Amount of Curve Finance protocol rewards claimed in this event, denominated in the smallest unit (wei-equivalent) of the reward token. String-encoded to preserve precision for large token amounts with 18 decimals.
`in_amountConvex`	`STRING`	Amount of Convex Finance protocol rewards claimed in this transaction, denominated in the smallest unit (wei-equivalent). String-encoded to preserve precision for large token amounts up to ~2.5 trillion base units.

Sample Data

address	removed	log_index	in_success	block_number	in_amountCurve	block_timestamp	in_amountConvex	transaction_hash
0xe761bf731a06fe8259fee05897b2687d56933110	false	164	true	16946840	107931630819990415311567	2023-03-31T11:18:11.000Z	2482427508859779552166	0x7d0d7157aae979070cb888aa2b44b13a773306da360118dcff731dfd2860cf54
0xe761bf731a06fe8259fee05897b2687d56933110	false	328	true	14846428	26385715014099936888021	2022-05-26T06:17:17.000Z	2533028641353593941250	0xb7b5a05d52322277d90fd9e85f58c4f9f0c6934502fe8f98e25cdc7ac9d770b6
0xe761bf731a06fe8259fee05897b2687d56933110	false	365	true	14773596	3054470459192285225468	2022-05-14T12:22:28.000Z	308501516378420807772	0x3c0470ccb76d506f055f62e0b955bf8024315ec814a093ed2a31b6bea00ae6f3

Example Query

Query with partition filter

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

alUSDAlchemist_Deposit_event

Deposit events from Alchemix V2’s alUSD Alchemist contract on Ethereum, recording yield-bearing token deposits with sender, recipient, amount, and token address. Used for tracking collateral deposits and user participation in the alUSD synthetic stablecoin protocol.

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_yieldToken`	`STRING`	Contract address of the yield-bearing token being deposited, withdrawn, or harvested. 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.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	in_recipient	in_yieldToken	block_timestamp	transaction_hash
0x5c6374a2ac4ebc38dea0fc1f8716e5ea1add94dd	false	10475313390620148018126	0xe3cfdbfa339b749c6df27854e11df3398b12d56e	432	14642235	0x6f3fbbd7a55981c386a638648706b6d08b34de4e	0xda816459f1ab5631232fe5e97a05bbbb94970c95	2022-04-23T16:48:16.000Z	0xfac314dbb383bc1275234a745a861bad7e7881b4f6ec9bfc6f4d0197f3313c26
0x5c6374a2ac4ebc38dea0fc1f8716e5ea1add94dd	false	27147658862284793592	0xe3cfdbfa339b749c6df27854e11df3398b12d56e	448	14642235	0x6f3fbbd7a55981c386a638648706b6d08b34de4e	0xda816459f1ab5631232fe5e97a05bbbb94970c95	2022-04-23T16:48:16.000Z	0xfac314dbb383bc1275234a745a861bad7e7881b4f6ec9bfc6f4d0197f3313c26
0x5c6374a2ac4ebc38dea0fc1f8716e5ea1add94dd	false	23027403531600122924482	0xe3cfdbfa339b749c6df27854e11df3398b12d56e	400	14638080	0x57a54161b2c29a30db215fbf389439bd93815046	0xda816459f1ab5631232fe5e97a05bbbb94970c95	2022-04-23T01:06:23.000Z	0x3524da3c911ec93f67d0c54fdd05a454a64c1948f8e3fd66cfab27a3d086e64e

Example Query

Query with partition filter

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

alUSDAlchemist_Harvest_event

Yield harvesting events from Alchemix V2’s alUSD vaults on Ethereum, recording when accumulated yield from underlying yield-bearing tokens is collected and converted. Used for tracking vault performance, yield generation rates, and minimum output expectations across different collateral types.

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_yieldToken`	`STRING`	Contract address of the yield-bearing token being deposited, withdrawn, or harvested. Hex-encoded, 0x-prefixed, 42-character string.
`in_minimumAmountOut`	`STRING`	Minimum acceptable output amount for the harvest operation, specified as slippage protection in the smallest token unit (wei for 18-decimal tokens). This value is zero when no slippage protection is set, and typically 99-99.9% of the total harvested amount when specified.
`in_totalHarvested`	`STRING`	Total amount of yield harvested from the specified yield token in this transaction, denominated in the token’s smallest unit (wei for 18-decimal tokens). This raw integer value represents the gross harvest before any slippage protection or fees are applied.

Sample Data

address	removed	log_index	block_number	in_yieldToken	block_timestamp	transaction_hash	in_totalHarvested	in_minimumAmountOut
0x5c6374a2ac4ebc38dea0fc1f8716e5ea1add94dd	false	71	14610874	0xda816459f1ab5631232fe5e97a05bbbb94970c95	2022-04-18T18:51:53.000Z	0x73cc6ba21b770e2acf7164fdba858f4a7449073b8621cd0e55677a158bdf312d	1251258726899738972959	1247426477162213486019
0x5c6374a2ac4ebc38dea0fc1f8716e5ea1add94dd	false	31	14546081	0xda816459f1ab5631232fe5e97a05bbbb94970c95	2022-04-08T15:57:42.000Z	0xf6ad95be83aced0d38bc02db518622ea543c6a844c35164857e796f75575d536	5113259222641259247802	5108145963418617984554
0x5c6374a2ac4ebc38dea0fc1f8716e5ea1add94dd	false	93	14546088	0xa354f35829ae975e850e23e9615b11da1b3dc4de	2022-04-08T15:58:52.000Z	0xa7185526a0cd6bbb5823fae34b4bee0b91163fa65e270b8b69fc946fbc117f03	2255487250	2253230876

Example Query

Query with partition filter

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

alUSDAlchemist_Withdraw_event

Withdrawal events from Alchemix V2’s alUSD Alchemist vault on Ethereum, recording when users redeem yield-bearing token shares. Tracks withdrawal amounts, yield token addresses, and owner/recipient relationships for monitoring vault liquidity and user 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_yieldToken`	`STRING`	Contract address of the yield-bearing token being deposited, withdrawn, or harvested. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_owner	in_shares	log_index	block_number	in_recipient	in_yieldToken	block_timestamp	transaction_hash
0x5c6374a2ac4ebc38dea0fc1f8716e5ea1add94dd	false	0x8065ce3646de4aaadef0e23340ec169f77ede9de	41180120280672676437723	241	17607501	0x8065ce3646de4aaadef0e23340ec169f77ede9de	0xda816459f1ab5631232fe5e97a05bbbb94970c95	2023-07-02T16:26:47.000Z	0x6fa8a1264dc2e2586e88e483d10505149be65b879d44f648f643315bf7f8d3b0
0x5c6374a2ac4ebc38dea0fc1f8716e5ea1add94dd	false	0xe8787b5a359c30318d9b805651d18275f33fa1bd	2066969187902596999871	448	14774262	0xe8787b5a359c30318d9b805651d18275f33fa1bd	0xda816459f1ab5631232fe5e97a05bbbb94970c95	2022-05-14T15:02:47.000Z	0xd34172a26408a7c45784e73f6c7034adf76d7eb50a4980d2a62184f3429e40d5
0x5c6374a2ac4ebc38dea0fc1f8716e5ea1add94dd	false	0x8da6bd2c9526fd3bb3b1a20540edc4b2f8affe2c	29390589765031723919427	229	14773413	0x8da6bd2c9526fd3bb3b1a20540edc4b2f8affe2c	0xda816459f1ab5631232fe5e97a05bbbb94970c95	2022-05-14T11:41:08.000Z	0xc4add18cc418a1da8618a1ef3d6a606bc7164bdaf53fc174a7be8ae10cfeb498

Example Query

Query with partition filter

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

alUSDAMO_ClaimRewards_event

Reward claim events from Alchemix V2’s alUSD Alchemist Multi-Operation (AMO) contract on Ethereum, tracking Curve (CRV) and Convex (CVX) token distributions. Used to analyze yield farming rewards and protocol revenue generation for the alUSD stablecoin system.

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_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.
`in_amountCurve`	`STRING`	Amount of CRV (Curve DAO) tokens claimed as rewards, denominated in wei (1e-18 CRV). This value represents Curve protocol rewards distributed to the Alchemix alUSD AMO contract.
`in_amountConvex`	`STRING`	Amount of Convex Finance (CVX) reward tokens claimed in this event, denominated in wei (smallest unit). Values represent 18-decimal precision token amounts that can be divided by 10^18 to get the human-readable quantity.

Sample Data

address	removed	log_index	in_success	block_number	in_amountCurve	block_timestamp	in_amountConvex	transaction_hash
0x9735f7d3ea56b454b24ffd74c58e9bd85cfad31b	false	289	true	16846734	13898117908319448112051	2023-03-17T09:46:35.000Z	333554829799666754689	0x812f639b48dde922115d96b7398c86e9198f35738b39bc3870535c61807e6593
0x9735f7d3ea56b454b24ffd74c58e9bd85cfad31b	false	152	true	15831632	49469264129714413685377	2022-10-26T10:24:59.000Z	2275586149966863029527	0x560d39dee252a0a5622ec62debe8dcd2ebaa0e8ced270b07c4fe7cbdb470fce9
0x9735f7d3ea56b454b24ffd74c58e9bd85cfad31b	false	227	true	17551538	10502882940633572218219	2023-06-24T19:46:11.000Z	168046127050137155491	0xb255422f7100c65d735a76b3233bb4e92520e35889fba5d4e705d7916415f018

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

alETHAlchemist_Deposit_event

alETHAlchemist_Harvest_event

alETHAlchemist_Withdraw_event

alETHAMO_ClaimRewards_event

alUSDAlchemist_Deposit_event

alUSDAlchemist_Harvest_event

alUSDAlchemist_Withdraw_event

alUSDAMO_ClaimRewards_event

​Tables

​alETHAlchemist_Deposit_event

​alETHAlchemist_Harvest_event

​alETHAlchemist_Withdraw_event

​alETHAMO_ClaimRewards_event

​alUSDAlchemist_Deposit_event

​alUSDAlchemist_Harvest_event

​alUSDAlchemist_Withdraw_event

​alUSDAMO_ClaimRewards_event

Tables

alETHAlchemist_Deposit_event

alETHAlchemist_Harvest_event

alETHAlchemist_Withdraw_event

alETHAMO_ClaimRewards_event

alUSDAlchemist_Deposit_event

alUSDAlchemist_Harvest_event

alUSDAlchemist_Withdraw_event

alUSDAMO_ClaimRewards_event