> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# curve_v1_ethereum
> Tables in tt-contracts.curve_v1_ethereum
## Tables
### BasePoolRegistry\_BasePoolAdded\_event
Events emitted when new base liquidity pools are registered in Curve Finance's BasePoolRegistry contract on Ethereum. Used to track the addition of underlying pools that can be composed into metapools for analyzing Curve's pool architecture evolution.
| 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_basepool` | `STRING` | Contract address of the base pool being added to the Curve registry. Base pools are foundational liquidity pools (like 3pool or sUSD) that can be composed with other pools in the Curve ecosystem. |
| address | removed | log\_index | in\_basepool | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xde3ead9b2145bba2eb74007e58ed07308716b725 | false | 128 | 0xae34574ac03a15cd58a92dc79de7b1a0800f1ce3 | 16832770 | 2023-03-15T10:41:11.000Z | 0xa49bc5955a531f5e1de5b8be085cc08e9fd29b0e50114b65131046d845977e14 |
| 0xde3ead9b2145bba2eb74007e58ed07308716b725 | false | 247 | 0xf253f83aca21aabd2a20553ae0bf7f65c755a07f | 16234648 | 2022-12-21T17:44:11.000Z | 0x898921c2b82ea6b6c6db5ba3236bddd83eb8e92d834e6fed60e41ac157719a17 |
| 0xde3ead9b2145bba2eb74007e58ed07308716b725 | false | 316 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 15753352 | 2022-10-15T11:55:47.000Z | 0x5727adaad973d4c214538a167bd4e1ebaa0ca5a0934eb9b66a5eed1614bc1a99 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.BasePoolRegistry_BasePoolAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Controller\_Borrow\_event
Borrow event records from Curve V1 lending markets on Ethereum, tracking when users increase their loan positions with corresponding collateral changes. Used for analyzing leverage activity, collateral ratios, and lending market utilization across Curve's collateralized debt positions.
| 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_collateral_increase` | `STRING` | Amount of collateral added to the user's position in this borrow transaction, denominated in the smallest unit of the collateral token (wei for ETH). Can be zero when only loan amount increases without additional collateral deposit. |
| `in_loan_increase` | `STRING` | Amount by which the user's loan position increased in this borrow transaction, denominated in the smallest unit of the borrowed token (wei-equivalent). Can be zero when only collateral is added without increasing the loan. |
| address | in\_user | removed | log\_index | block\_number | block\_timestamp | in\_loan\_increase | transaction\_hash | in\_collateral\_increase |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | 0x0eb973cc696e412c87a758f07c738f87559b3afd | false | 408 | 18561457 | 2023-11-13T07:20:59.000Z | 9000000000000000000000 | 0xd0bf27774c5a10f670dc168a131548a6c3567ebb196d5ecf765a61f884d41ad0 | 7828316036790449830 |
| 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | 0x16fa6b8fcc2d5f459600713cf961e349067a278c | false | 367 | 18560197 | 2023-11-13T03:06:59.000Z | 50000000000000000000000 | 0xcd19ce6d4854a3fc62e3387b4206a157bcac9af46e6156c6df8a3162759e9f94 | 0 |
| 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | 0x294125ebe0a93815a68e0165935c521275e2dc1e | false | 237 | 18561579 | 2023-11-13T07:45:35.000Z | 100000000000000000000000 | 0x2dea076fe1deb312bef75f7c6424ace4db23ff7ef83767321442b6e8f638dbd7 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.Controller_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Controller\_CollectFees\_event
Fee collection events from Curve V1 protocol controller contracts on Ethereum, tracking accumulated trading fees and resulting supply changes for fee-bearing tokens. Used for analyzing protocol revenue distribution and tokenomics across different Curve pool controllers.
| 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_new_supply` | `STRING` | Total supply of the fee token after the collection event. Denominated in the smallest unit of the token (wei-equivalent), represented as a string to handle large integers. |
| address | removed | in\_amount | log\_index | block\_number | in\_new\_supply | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ----------------------- | ---------- | ------------- | -------------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | false | 46105377112865235604959 | 177 | 18273095 | 53864733979580938594560278 | 2023-10-03T22:51:35.000Z | 0x72f1501bb61cf5b8931ed67127a05e25819bdee42a3c456213d6635f54166075 |
| 0x8472a9a7632b173c8cf3a86d3afec50c35548e76 | false | 1963156759517207084493 | 252 | 18273094 | 2286743626793467403512169 | 2023-10-03T22:51:23.000Z | 0x25e9ab6cfda97fe7ba8e6e1c8b2c87f38086116e81b94e355beeb0db5fc41667 |
| 0x1c91da0223c763d2e0173243eadaa0a2ea47e704 | false | 1561144956655870532559 | 260 | 18273099 | 3074633053107790701133399 | 2023-10-03T22:52:23.000Z | 0x3d4decaa08e58c8cfb4076f341730916b80234f7e63347890b45f90c3909fbfb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.Controller_CollectFees_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Controller\_Liquidate\_event
Liquidation events from Curve V1 lending markets on Ethereum capturing when undercollateralized positions are liquidated. Records liquidator addresses, user positions liquidated, debt amounts, and collateral/stablecoin received for analyzing liquidation activity and risk management.
| 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_liquidator` | `STRING` | Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_collateral_received` | `STRING` | Amount of collateral tokens received by the liquidator during the liquidation event, denominated in the smallest unit of the collateral token. Values are represented as raw integer strings without decimal adjustment. |
| `in_stablecoin_received` | `STRING` | Amount of stablecoin tokens received by the liquidator as a result of the liquidation event. Value is denominated in the smallest unit (wei equivalent) of the stablecoin. |
| `in_debt` | `STRING` | Amount of debt outstanding in the protocol position or vault. Numeric string representation in smallest token denomination. |
| address | in\_debt | in\_user | removed | log\_index | block\_number | in\_liquidator | block\_timestamp | transaction\_hash | in\_collateral\_received | in\_stablecoin\_received |
| ------------------------------------------ | ------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------ |
| 0xa920de414ea4ab66b97da1bfe9e6eca7d4219635 | 35325303892731754615019 | 0x442abe3cef7665cec0e57715ee8ba686762865ae | false | 21 | 20233459 | 0x8c76a73693a52e8eb35fb0234e5ec74152540378 | 2024-07-04T13:30:11.000Z | 0xe19f57fd1f491a889dc9c779e1783fa7ec72b0144390ac9a441959c8925fcaa0 | 3739862376341305989 | 25936232678992572826845 |
| 0x4e59541306910ad6dc1dac0ac9dfb29bd9f15c67 | 138151785327122881132905 | 0xe5350e927b904fdb4d2af55c566e269bb3df1941 | false | 370 | 17991573 | 0xe5350e927b904fdb4d2af55c566e269bb3df1941 | 2023-08-25T12:01:11.000Z | 0xb2ccc1b8a6653c42b2cbbfa83420c958691c32ca8721981a30bc0a1b06b10a2a | 624934693 | 18146744770329228188093 |
| 0x1c91da0223c763d2e0173243eadaa0a2ea47e704 | 444368094099289531610186 | 0x7a16ff8270133f063aab6c9977183d9e72835428 | false | 194 | 19087064 | 0x7a16ff8270133f063aab6c9977183d9e72835428 | 2024-01-25T23:59:35.000Z | 0x9cc434e7881fc40a0f637d6d65ea0ea086631d35a7715cfaf62ba49135cad513 | 8862754020073300401 | 177579613208856296103621 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.Controller_Liquidate_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Controller\_RemoveCollateral\_event
Collateral withdrawal events from Curve V1 lending markets on Ethereum, tracking user addresses and the amount of collateral removed from their positions. Used for analyzing deleveraging activity and position management behavior in Curve's lending protocol.
| 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_collateral_decrease` | `STRING` | Amount of collateral removed from the user's position. Integer value representing the decrease in collateral denominated in the smallest unit of the collateral token. |
| address | in\_user | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_collateral\_decrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 0x4e59541306910ad6dc1dac0ac9dfb29bd9f15c67 | 0x18dcf2d023dc3f33f0cbd3c9c20fac3df358725f | false | 217 | 18964148 | 2024-01-08T18:44:35.000Z | 0x123fef8f88d0ba8de29cb863abf4f2f8edbe8b2cdf292a01b4bcd7e9467fe8cd | 10000000 |
| 0x4e59541306910ad6dc1dac0ac9dfb29bd9f15c67 | 0x18dcf2d023dc3f33f0cbd3c9c20fac3df358725f | false | 296 | 18964165 | 2024-01-08T18:47:59.000Z | 0x0ba3810b2f974935e2627c0d19f829c6a10b935ae1c58668d1963dcc93662a66 | 10000000 |
| 0x4e59541306910ad6dc1dac0ac9dfb29bd9f15c67 | 0x99d4a3d36a615959d6e352fa78ee13ee6daa5cf4 | false | 125 | 18964543 | 2024-01-08T20:03:59.000Z | 0x41c47e6373fac770463ac4c6845a0d66cac9be38d46057d67d08b8c91bfec709 | 14500000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.Controller_RemoveCollateral_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Controller\_Repay\_event
Loan repayment events from Curve V1 lending markets on Ethereum, recording when users reduce their debt positions. Tracks repayment amounts, user addresses, and collateral changes for analyzing borrowing behavior and loan lifecycle management.
| 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_collateral_decrease` | `STRING` | Amount of collateral removed from the user's position. Integer value representing the decrease in collateral denominated in the smallest unit of the collateral token. |
| `in_loan_decrease` | `STRING` | Amount of debt repaid by the user, denominated in the loan token's smallest unit (wei). Typically non-zero while collateral\_decrease is zero, indicating debt reduction without collateral withdrawal. |
| address | in\_user | removed | log\_index | block\_number | block\_timestamp | in\_loan\_decrease | transaction\_hash | in\_collateral\_decrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ | ------------------------ |
| 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | 0x95af5a5eedc1c1eca33a78229260a7c582a1b997 | false | 30 | 18372163 | 2023-10-17T19:25:11.000Z | 5000000000000000000000 | 0xad76fe757bdf29275d4172434c7af9fc164f3bf0d03ad7d9170614a65d093cfa | 0 |
| 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | 0xa02d03e291556792ee1f99b818d9c936d29ee4a3 | false | 197 | 18368193 | 2023-10-17T06:05:35.000Z | 34000000000000000000 | 0x2c790156a20dbe1a76a00ab78204901599353399ae5a01c2aa90eb6058b6526d | 0 |
| 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | 0x8d877186de308712756e5a4e0342a3ec8ac6949f | false | 188 | 18368170 | 2023-10-17T06:00:47.000Z | 52000000000000000000 | 0x3cd2edca9cc162edd6a87a5fb8420bc7e3462ae10c5dfb00c2f1975668433035 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.Controller_Repay_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Controller\_SetBorrowingDiscounts\_event
*No description available.*
| Column | Type | Description |
| ------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_loan_discount` | `STRING` | - |
| `in_liquidation_discount` | `STRING` | Discount rate applied during liquidation of collateral. Numeric string representation in basis points or decimal format with 18 decimal precision. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.Controller_SetBorrowingDiscounts_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Controller\_SetMonetaryPolicy\_event
Event logs tracking monetary policy contract updates in Curve v1 lending markets on Ethereum. Records controller address changes to interest rate policy contracts, useful for analyzing protocol governance changes and rate mechanism updates.
| 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_monetary_policy` | `STRING` | Contract address of the monetary policy contract that governs interest rate calculations. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_monetary\_policy |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0xec0820efafc41d8943ee8de495fc9ba8495b15cf | false | 239 | 18051849 | 2023-09-02T22:38:35.000Z | 0xf0089301dde4a0da2ce300411c36d6d60583babd986b06d029be381b4390128e | 0x1e7d3bf98d3f8d8ce193236c3e0ec4b00e32daae |
| 0x4e59541306910ad6dc1dac0ac9dfb29bd9f15c67 | false | 176 | 17648033 | 2023-07-08T09:03:35.000Z | 0x58db7d5228e82fbeb7ec65478d8c1b7cf8188469c0c508eb20704ad796a6ce2a | 0xb8687d7dc9d8fa32fabde63e19b2dbc9bb8b2138 |
| 0xa920de414ea4ab66b97da1bfe9e6eca7d4219635 | false | 179 | 17648033 | 2023-07-08T09:03:35.000Z | 0x58db7d5228e82fbeb7ec65478d8c1b7cf8188469c0c508eb20704ad796a6ce2a | 0xbb3fda661149f6e45d829d5dd54a1608577c5fa1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.Controller_SetMonetaryPolicy_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Controller\_UserState\_event
User position snapshots from Curve v1 lending Controller contract on Ethereum, tracking collateral amounts, debt levels, liquidation discounts, and price band ranges (n1/n2) for analyzing borrower health and liquidation risk.
| 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_collateral` | `STRING` | Contract address of the collateral asset or vault. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debt` | `STRING` | Amount of debt outstanding in the protocol position or vault. Numeric string representation in smallest token denomination. |
| `in_n1` | `STRING` | Represents the lower band index of the user's collateral position in Curve's lending liquidation automated market maker (LLAMMA). Values range from 0 (no position) to higher integers indicating price band placement. |
| `in_n2` | `STRING` | Band index representing the upper boundary of the user's collateral position in Curve's lending liquidation automated market maker (LLAMM). Defines the highest price band where the user's collateral is deposited. |
| `in_liquidation_discount` | `STRING` | Discount rate applied during liquidation of collateral. Numeric string representation in basis points or decimal format with 18 decimal precision. |
| in\_n1 | in\_n2 | address | in\_debt | in\_user | removed | log\_index | block\_number | in\_collateral | block\_timestamp | transaction\_hash | in\_liquidation\_discount |
| ------ | ------ | ------------------------------------------ | ---------------------- | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 0 | 0 | 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | 0 | 0x9c89d9136c24f85faaa8e6d1086ce7347bd0d54a | false | 215 | 18062527 | 0 | 2023-09-04T10:30:23.000Z | 0x21348639d9eb4fc9823e57d2844574cd1a01ac5b1b94431955712224b96dc569 | 0 |
| 0 | 0 | 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | 0 | 0xa9dc91bb2433b7d6c8acb9bd703be90a07ddbb46 | false | 67 | 18062463 | 0 | 2023-09-04T10:17:23.000Z | 0xbc3f558ad45413b65889e1dca8e51694c9ea6c1cd82fbec94cc5446a1a7525e4 | 0 |
| 11 | 14 | 0x100daa78fc509db39ef7d04de0c1abd299f4c6ce | 8239286657069631396657 | 0x5a6fa86c409dfd2a2194b3f048912ab6ae80fe04 | false | 44 | 18061642 | 115792089237316195423570985008687907853269984665640564039457584007913129639935 | 2023-09-04T07:32:23.000Z | 0xf4ec392b8155df739369d725637bb306fdcb473c83b276dec231b70840ccc7b0 | 60000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.Controller_UserState_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ControllerFactory\_AddMarket\_event
Market creation events from Curve V1's lending market factory on Ethereum. Records deployment of new lending markets with associated AMM, controller, collateral token, and monetary policy contract addresses.
| 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_collateral` | `STRING` | Contract address of the collateral asset or vault. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_controller` | `STRING` | Contract address of the Controller contract managing this Curve lending market. Hex-encoded, 0x-prefixed 40-character string representing the controller component that handles borrowing positions and liquidations. |
| `in_amm` | `STRING` | Contract address of the automated market maker (AMM). Hex-encoded, 0x-prefixed, 42-character string. |
| `in_monetary_policy` | `STRING` | Contract address of the monetary policy contract that governs interest rate calculations. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_ix` | `STRING` | Market index identifier assigned sequentially when a new lending market is added to the Curve ControllerFactory. Increments with each AddMarket event, starting from '0'. |
| in\_ix | in\_amm | address | removed | log\_index | block\_number | in\_collateral | in\_controller | block\_timestamp | transaction\_hash | in\_monetary\_policy |
| ------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 4 | 0xfa96ad0a9e64261db86950e2da362f5572c5c6fd | 0xc9332fdcb1c491dcc683bae86fe3cb70360738bc | false | 285 | 18001224 | 0xac3e018457b222d93114458476f3e3416abbe38f | 0xec0820efafc41d8943ee8de495fc9ba8495b15cf | 2023-08-26T20:27:35.000Z | 0x2ede10a84f28647b5636a706ea03334399ba0ec2c77267681902e3180ae2d9b3 | 0xb8687d7dc9d8fa32fabde63e19b2dbc9bb8b2138 |
| 5 | 0xf9bd9da2427a50908c4c6d1599d8e62837c2bcb0 | 0xc9332fdcb1c491dcc683bae86fe3cb70360738bc | false | 300 | 18001227 | 0x18084fba666a33d37592fa2633fd49a74dd93a88 | 0x1c91da0223c763d2e0173243eadaa0a2ea47e704 | 2023-08-26T20:28:11.000Z | 0x147ccfac7d243d78ac8852d43c365be7d498b7aa18f6a3b0b1ade02ff55cdacd | 0xb8687d7dc9d8fa32fabde63e19b2dbc9bb8b2138 |
| 3 | 0x1681195c176239ac5e72d9aebacf5b2492e0c4ee | 0xc9332fdcb1c491dcc683bae86fe3cb70360738bc | false | 135 | 17562530 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xa920de414ea4ab66b97da1bfe9e6eca7d4219635 | 2023-06-26T08:51:59.000Z | 0x7ce7143aedf5e318e3bed653b730b9456eef67224a8dbcac59fe0872c0580a3a | 0x1e7d3bf98d3f8d8ce193236c3e0ec4b00e32daae |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.ControllerFactory_AddMarket_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CryptoFactory\_deploy\_pool\_function
Liquidity pool deployment transactions from Curve V1 CryptoFactory contract on Ethereum. Contains pool initialization parameters including token pairs, fee structures, amplification coefficients, and deployer addresses for analyzing Curve's permissionless pool creation activity.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `in__coins` | `ARRAY` | Array of token contract addresses being added to the Curve liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts. |
| `in_A` | `STRING` | Amplification coefficient parameter used in Curve's StableSwap invariant algorithm. String-encoded integer value that controls the concentration of liquidity around the target price. |
| `in_gamma` | `STRING` | Amplification coefficient gamma parameter for Curve's CryptoSwap pools, controlling price impact sensitivity. String-encoded numeric value, typically ranging from 100000000000000 to 145000000000000 in sampled pools. |
| `in_mid_fee` | `STRING` | Fee charged for trades near equilibrium price when pool is balanced. Denominated in basis points with precision factor (e.g., '5000000' = 0.5%). |
| `in_out_fee` | `STRING` | Fee charged when exiting the pool, denominated in basis points as a string-encoded integer. Typically set to 45000000 (4.5%) in Curve v2 CryptoFactory pools. |
| `in_allowed_extra_profit` | `STRING` | Maximum allowed additional profit threshold for Curve v2 pool rebalancing, expressed as a scaled integer with 18 decimals. Controls how much profit deviation is permitted before price oracle updates trigger, typically set to 2000000000000 (0.002 or 0.2%). |
| `in_fee_gamma` | `STRING` | Fee gamma parameter controlling how trading fees adjust based on pool imbalance in Curve's crypto pools. Denominated in basis points with 18 decimal precision (e.g., '5000000000000000' = 0.5%). |
| `in_adjustment_step` | `STRING` | Adjustment step parameter controlling the rate of price band movement in the Curve v2 pool's dynamic fee algorithm. Specified in wei-denominated units, typically around 5.5 trillion based on sample values. |
| `in_admin_fee` | `STRING` | Protocol admin fee parameter for the newly deployed pool, expressed in basis points with 10 decimal precision. Value of '5000000000' represents a 0.5% fee charged on trading fees. |
| `in_ma_half_time` | `STRING` | Moving average half-time parameter in seconds used for the deployed Curve pool's price oracle. Typically set to 600 seconds (10 minutes) for standard configurations. |
| `in_initial_price` | `STRING` | Initial price of the second token in the pool relative to the first token, expressed in wei (10^18 units). Specified at pool deployment to set the starting exchange rate for the Curve v2 crypto pool. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_A | value | status | gas\_used | in\_\_name | in\_gamma | in\_\_coins | out\_anon0 | signature | in\_\_symbol | in\_mid\_fee | in\_out\_fee | to\_address | block\_number | from\_address | in\_admin\_fee | in\_fee\_gamma | trace\_address | block\_timestamp | in\_ma\_half\_time | in\_initial\_price | transaction\_hash | in\_adjustment\_step | in\_allowed\_extra\_profit |
| ------- | --------- | ----- | ------ | --------- | ---------- | --------------- | -------------------------------------------------------------------------------------------- | ------------------------------------------ | ---------- | ------------ | ------------ | ------------ | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ---------------- | -------------- | ------------------------ | ------------------ | --------------------- | ------------------------------------------------------------------ | -------------------- | -------------------------- |
| 1231573 | 200000000 | 0 | true | 879695 | ibGBP/USDC | 100000000000000 | \["0x69681f8fde45345c3870bcd5eaf4a05a60e7d227","0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48"] | 0xacce4fe9ce2a6fe9af83e7cf321a3ff7675e0ab6 | 0xc955fa04 | ibGBPUSDC | 5000000 | 45000000 | 0xf18056bbd320e96a48e3fbf8bc061322531aac99 | 14389659 | 0x2d407ddb06311396fe14d4b49da5f0471447d45c | 5000000000 | 5000000000000000 | | 2022-03-15T06:51:40.000Z | 600 | 767431614360702200 | 0x3e2bd1c79383fbbea95e85b7d4da11cfdf375db95a1f3f201d18dd4aadbad486 | 5500000000000 | 10000000000 |
| 1231573 | 200000000 | 0 | true | 879695 | ibJPY/USDC | 100000000000000 | \["0x5555f75e3d5278082200fb451d1b6ba946d8e13b","0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48"] | 0xeb0265938c1190ab4e3e1f6583bc956df47c0f93 | 0xc955fa04 | ibJPYUSDC | 5000000 | 45000000 | 0xf18056bbd320e96a48e3fbf8bc061322531aac99 | 14389675 | 0x2d407ddb06311396fe14d4b49da5f0471447d45c | 5000000000 | 5000000000000000 | | 2022-03-15T06:55:43.000Z | 600 | 118350443355554630000 | 0x2a6133af80aca4dec1bc6d3b51e4c94402cefe0502ed6cfe86ac486cc80e4b50 | 5500000000000 | 10000000000 |
| 1231573 | 200000000 | 0 | true | 879695 | ibCHF/USDC | 100000000000000 | \["0x1cc481ce2bd2ec7bf67d1be64d4878b16078f309","0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48"] | 0x6df0d77f0496ce44e72d695943950d8641fca5cf | 0xc955fa04 | ibCHFUSDC | 5000000 | 45000000 | 0xf18056bbd320e96a48e3fbf8bc061322531aac99 | 14389640 | 0x2d407ddb06311396fe14d4b49da5f0471447d45c | 5000000000 | 5000000000000000 | | 2022-03-15T06:46:13.000Z | 600 | 940003081330100700 | 0x5adadc10e05e0f7e4f7f0e558457f96123d6873054f4d70b90e1d0798dc41a98 | 5500000000000 | 10000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CryptoFactory_deploy_pool_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CryptoSwapRegistry\_PoolAdded\_event
Pool registration events from Curve V1's CryptoSwap Registry contract on Ethereum, capturing when new liquidity pools are added to the registry. Useful for tracking Curve pool deployments and ecosystem growth over time.
| 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x9a32af1a11d9c937aea61a3790c2983257ea8bc0 | 0x98638facf9a3865cd033f36548713183f6996122 | false | 85 | 15753364 | 2022-10-15T11:58:11.000Z | 0xebd23e53e791b904534745ced09cd92d89d932f28b44f1ca95569b4837ad7d00 |
| 0x9a32af1a11d9c937aea61a3790c2983257ea8bc0 | 0xe84f5b1582ba325fdf9ce6b0c1f087ccfc924e54 | false | 48 | 15753366 | 2022-10-15T11:58:35.000Z | 0xa69acd66cb798e7faf0d4d6ad94d857a29ed4df984b4eb8db8ae97a84b557710 |
| 0x9a32af1a11d9c937aea61a3790c2983257ea8bc0 | 0x8301ae4fc9c624d1d396cbdaa1ed877821d7c511 | false | 109 | 15753359 | 2022-10-15T11:57:11.000Z | 0xe0c27d91659b6049bb541c8b994b41bd8e0722b35c6e2c3765d2166a897a91d6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CryptoSwapRegistry_PoolAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveFactory\_PlainPoolDeployed\_event
Pool deployment events from Curve v1 Factory contract on Ethereum, capturing creation of plain (non-metapool) liquidity pools with amplification parameter (A), fee configuration, token pairs, and deployer address for tracking factory-generated pool launches.
| 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_coins` | `ARRAY` | Array of token contract addresses included in the liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts. |
| `in_A` | `STRING` | Amplification coefficient parameter used in Curve's StableSwap invariant algorithm. String-encoded integer value that controls the concentration of liquidity around the target price. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_deployer` | `STRING` | Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_A | in\_fee | address | in\_pool | removed | in\_coins | log\_index | in\_deployer | block\_number | block\_timestamp | transaction\_hash |
| ----- | ------- | ------------------------------------------ | ------------------------------------------ | ------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 500 | 1000000 | 0x4f8846ae9380b90d2e71d5e3d042dff3e7ebb40d | 0x4dece678ceceb27446b35c672dc7d61f30bad69e | false | \["0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48","0xf939e0a03fb07f59a73314e73794be0e57ac1b4e","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 154 | 0x855cc906da8271dd53879929bd226711247d5f17 | 17258001 | 2023-05-14T12:07:47.000Z | 0x4b288a16fe2f1c556752478989d88ef6e7a2c9a0cd258a12b11b232a112dc279 |
| 500 | 1000000 | 0x4f8846ae9380b90d2e71d5e3d042dff3e7ebb40d | 0x390f3595bca2df7d23783dfd126427cceb997bf4 | false | \["0xdac17f958d2ee523a2206206994597c13d831ec7","0xf939e0a03fb07f59a73314e73794be0e57ac1b4e","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 127 | 0x855cc906da8271dd53879929bd226711247d5f17 | 17258004 | 2023-05-14T12:08:23.000Z | 0x40b25773bf8ea673434277d279af40a85b09072072e7004e9048a2ec0f0dd5a0 |
| 500 | 1000000 | 0x4f8846ae9380b90d2e71d5e3d042dff3e7ebb40d | 0xca978a0528116dda3cba9acd3e68bc6191ca53d0 | false | \["0x8e870d67f660d95d5be530380d0ec0bd388289e1","0xf939e0a03fb07f59a73314e73794be0e57ac1b4e","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 214 | 0x855cc906da8271dd53879929bd226711247d5f17 | 17258007 | 2023-05-14T12:08:59.000Z | 0xb1ac01010c3787d5b5a92145acbde0232715a5316497e4170b787f1892773f13 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveFactory_PlainPoolDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveStableswapFactoryNG\_BasePoolAdded\_event
BasePoolAdded events emitted by Curve's Stableswap Factory Next Generation (NG) contract when new base pools are registered. Used to track pool creation activity and identify available base pools for metapool deployments on Ethereum.
| 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_base_pool` | `STRING` | Contract address of the base pool used in the metapool architecture. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | in\_base\_pool | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | false | 379 | 18434389 | 0xae34574ac03a15cd58a92dc79de7b1a0800f1ce3 | 2023-10-26T12:27:11.000Z | 0x7888b1b7ad6a373286b64500554df73913484a0e831d04ac7b7b459cd1e2e7b0 |
| 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | false | 340 | 18433925 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 2023-10-26T10:53:59.000Z | 0xf176e92a25ad4f991ee9376614d8065b315b1bbc300a150b2884ac03891867dd |
| 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | false | 430 | 18434387 | 0xdcef968d416a41cdac0ed8702fac8128a64241a2 | 2023-10-26T12:26:47.000Z | 0xe1dca4c42829b6e312828faac570ae71dc79c6545eab9d6ee3e1c013846bb8e5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveStableswapFactoryNG_BasePoolAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveStableswapFactoryNG\_deploy\_metapool\_function
Metapool deployment function calls on Curve Finance's Stableswap Factory NG (Next Generation) contract on Ethereum. Records creation of new liquidity pools paired with existing base pools, capturing pool parameters like amplification coefficient (A), fee structure, and oracle configuration for analyzing Curve's pool ecosystem expansion.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__base_pool` | `STRING` | Contract address of the base pool used in the Curve metapool deployment. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `in__coin` | `STRING` | Contract address of the token being added to the Curve metapool. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__A` | `STRING` | Amplification coefficient parameter for the Curve pool being deployed. Numeric string representing the A parameter that controls the curve's shape and slippage characteristics. |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| `in__offpeg_fee_multiplier` | `STRING` | Fee multiplier applied when the pool's price deviates from peg, specified in basis points with 10 decimals (e.g., 20000000000 = 2x multiplier). Higher values increase swap fees during off-peg conditions to discourage arbitrage and stabilize the pool. |
| `in__ma_exp_time` | `STRING` | Moving average exponential time parameter for the metapool, controlling price smoothing behavior. Typically set to 866 seconds in standard deployments. |
| `in__implementation_idx` | `STRING` | Index identifying which pool implementation contract to use for deployment. Numeric string representing the implementation version selector. |
| `in__asset_type` | `INT64` | Asset type identifier for the metapool's token, where 0 represents standard ERC20 tokens and 3 represents rebasing tokens. Determines the pool's handling of balance calculations and yield accrual. |
| `in__method_id` | `STRING` | Implementation method identifier for the metapool contract being deployed. Always '0x00000000' in sample data, indicating the default implementation variant is used. |
| `in__oracle` | `STRING` | Oracle contract address for external price feeds used by the pool. Typically null address (0x00...00) when no oracle integration is configured for the metapool. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_\_A | value | status | in\_\_fee | gas\_used | in\_\_coin | in\_\_name | out\_anon0 | signature | in\_\_oracle | in\_\_symbol | to\_address | block\_number | from\_address | in\_\_base\_pool | in\_\_method\_id | trace\_address | in\_\_asset\_type | block\_timestamp | in\_\_ma\_exp\_time | transaction\_hash | in\_\_implementation\_idx | in\_\_offpeg\_fee\_multiplier |
| ------- | ------- | ----- | ------ | --------- | --------- | ------------------------------------------ | ---------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ---------------- | -------------- | ----------------- | ------------------------ | ------------------- | ------------------------------------------------------------------ | ------------------------- | ----------------------------- |
| 6873829 | 500 | 0 | true | 4000000 | 5244769 | 0xcfc5bd99915aaa815401c5a41a927ab7a38d29cf | thUSD | 0x91553bad9fbc8bd69ff5d5678cbf7d514d00de0b | 0xdf8c5d73 | 0x0000000000000000000000000000000000000000 | thUSD3CRV | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | 19608427 | 0xd818b9f7cb4090047d26c51e63c9cb1b5e12886a | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 0x00000000 | | 0 | 2024-04-08T03:59:11.000Z | 866 | 0x1ee39a16643a2d10b84fd563c462900481c9fcabe116cc8d81b6017d41e23fff | 0 | 20000000000 |
| 6876541 | 200 | 0 | true | 4000000 | 5246838 | 0x4d55a36902a6546a79ec4c9c315241de746d5fc3 | KUSD/3CRV | 0xb75848380f0fc17b43fc397c03a1738c0042eadc | 0xdf8c5d73 | 0x0000000000000000000000000000000000000000 | KUSD3CRV | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | 20398020 | 0xa2026e62bfd1f1a2d8b89a19f3fa0ba42b52f0bf | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 0x00000000 | | 0 | 2024-07-27T12:55:23.000Z | 866 | 0xd41803fa4e6ae69d0892e54c262b251409ba409ddf59a9bc0f14c05864a98524 | 0 | 20000000000 |
| 6779991 | 20000 | 0 | true | 1000000 | 5215378 | 0xc81b27ac184a631a0cbde20b51c734664b04d5b3 | 3crv+ | 0x29d9f16bb2d4033e0e621623a018a7f2ee3b8110 | 0xdf8c5d73 | 0x0000000000000000000000000000000000000000 | 3crv+ | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | 21954458 | 0x900f84590ccdbd2b3c64769b79e8181b6b8641f0 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 0x00000000 | | 0 | 2025-03-01T20:38:23.000Z | 866 | 0x7652aaa886c27dd5da17506ef4845067902abc1171a3ecaeac59e3cef43bb36b | 0 | 100000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveStableswapFactoryNG_deploy_metapool_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveStableswapFactoryNG\_deploy\_plain\_pool\_function
Deployment transactions for Curve V1 stableswap pools on Ethereum, capturing pool creation parameters including amplification coefficient (A), fee structure, token pairs, and oracle configurations. Used for tracking new pool launches and analyzing liquidity infrastructure expansion across stablecoin and wrapped asset pairs.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `in__coins` | `ARRAY` | Array of token contract addresses being added to the Curve liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts. |
| `in__A` | `STRING` | Amplification coefficient parameter for the Curve pool being deployed. Numeric string representing the A parameter that controls the curve's shape and slippage characteristics. |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| `in__offpeg_fee_multiplier` | `STRING` | Off-peg fee multiplier parameter for the Curve pool, controlling how much swap fees increase when the pool becomes imbalanced. Typically ranges from 20-100 billion (represented as strings), with higher values imposing greater penalties for swaps that worsen pool imbalance. |
| `in__ma_exp_time` | `STRING` | Moving average expiration time parameter in seconds for the pool's oracle. Typically set to 866 seconds (approximately 14 minutes) for standard Curve pool configurations. |
| `in__implementation_idx` | `STRING` | Index identifying which pool implementation contract to use for deployment. Numeric string representing the implementation version selector. |
| `in__asset_types` | `ARRAY` | Integer code representing the asset type for each token in the pool. Common values include 0 (standard ERC20), 1 (oracle-based), 2 (lending), and 3 (rebasing/interest-bearing tokens). |
| `in__method_ids` | `ARRAY` | Method identifiers for custom view functions on each token in the pool. Hex-encoded 4-byte function selectors, typically `0x00000000` when no custom oracle or rate method is specified. |
| `in__oracles` | `ARRAY` | Array of oracle contract addresses used for price feeds in the pool. Typically contains zero addresses (0x0) when no external oracles are needed, or valid Ethereum addresses for pools requiring off-chain price data. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_\_A | value | status | in\_\_fee | gas\_used | in\_\_name | in\_\_coins | out\_anon0 | signature | in\_\_symbol | to\_address | in\_\_oracles | block\_number | from\_address | trace\_address | in\_\_method\_ids | block\_timestamp | in\_\_asset\_types | in\_\_ma\_exp\_time | transaction\_hash | in\_\_implementation\_idx | in\_\_offpeg\_fee\_multiplier |
| ------- | ------- | ----- | ------ | --------- | --------- | ----------------- | -------------------------------------------------------------------------------------------- | ------------------------------------------ | ---------- | ------------ | ------------------------------------------ | -------------------------------------------------------------------------------------------- | ------------- | ------------------------------------------ | -------------- | ---------------------------- | ------------------------ | ------------------ | ------------------- | ------------------------------------------------------------------ | ------------------------- | ----------------------------- |
| 8077279 | 100 | 0 | true | 0 | 5341295 | mUSDrec/USDT | \["0x8166137a9e049897d10e7e4de73ee37fedc9d9b7","0xdac17f958d2ee523a2206206994597c13d831ec7"] | 0x5bcaa8a1216d8120a59489f7df4585e834c90eaf | 0x5bcd3d83 | mUSDrecX | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | \["0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 21738133 | 0xf6ea1b046522fe5a58124555b1acbc77fabdd7e5 | | \["0x00000000","0x00000000"] | 2025-01-30T15:05:11.000Z | \[2,0] | 866 | 0x742a37b8288854524a16fdf6029b4fc08e5a5b0b052dfe1667d7a7c9fed07cbb | 0 | 0 |
| 7113909 | 500 | 0 | true | 1000000 | 5427991 | Curvykin Skysaver | \["0x0655977feb2f289a4ab78af67bab0d17aab84367","0xa3931d71877c0e7a3148cb7eb4463524fec27fbd"] | 0xfd1627e3f3469c8392c8c3a261d8f0677586e5e1 | 0x5bcd3d83 | SkySaver | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | \["0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 21281208 | 0x7a16ff8270133f063aab6c9977183d9e72835428 | | \["0x00000000","0x00000000"] | 2024-11-27T19:35:23.000Z | \[3,3] | 866 | 0x2151b022bcc3ad42e5e81c4230a8bf656ca60ec887838d6933d55d4d5e8acb4d | 0 | 50000000000 |
| 8193665 | 200 | 0 | true | 4000000 | 5418274 | USD3/scrvUSD | \["0x0d86883faf4ffd7aeb116390af37746f45b6f378","0x0655977feb2f289a4ab78af67bab0d17aab84367"] | 0xe99810cd5adcd7b13455ae1be678b382d61f2d1e | 0x5bcd3d83 | USD3scrvUS | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | \["0xe808ec8755d2c31c5d1ffd7f50ab24a2ed466ad9","0x0000000000000000000000000000000000000000"] | 21281819 | 0xc090efad886f441846407bb434efa0be7039ad70 | | \["0x3ba0b9a9","0x00000000"] | 2024-11-27T21:38:47.000Z | \[1,3] | 866 | 0x5d0c7c5eca10c9321f3bde9b10cd5e00f07e9839fff09f0ecc6d4613040087a5 | 0 | 20000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveStableswapFactoryNG_deploy_plain_pool_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveStableswapFactoryNG\_LiquidityGaugeDeployed\_event
Liquidity gauge deployment events from Curve's Next Generation (NG) Stableswap Factory on Ethereum, recording when new gauges are created for liquidity pools. Links deployed gauge contracts to their associated pools for tracking CRV (Curve DAO Token) reward distribution eligibility and staking infrastructure.
| 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_gauge` | `STRING` | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_pool | removed | in\_gauge | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | 0x2e8baf908cb086e4a01382654a2663c8977c2c20 | false | 0x60c9ead2021bca9ffcf2c5a439c77ed1ac9301c2 | 300 | 20220304 | 2024-07-02T17:25:11.000Z | 0x9663b72e930db7382e5a842faa58532ac07499ec90b503a0b5fda568e507de52 |
| 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | 0x126331661101057c3a5879ac6af3f30cac6c66e2 | false | 0x1fbfcb3a807151ef6903a35e8ebd8e2db7aa8e04 | 202 | 20217385 | 2024-07-02T07:37:47.000Z | 0xb3159b472f9cd27cf7b96c45764a9bf4da09789b4fcec230ab7485d4a2db1dc2 |
| 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | 0x167478921b907422f8e88b43c4af2b8bea278d3a | false | 0x330cfd12e0e97b0adf46158d2a81e8bd2985c6cb | 84 | 19262786 | 2024-02-19T15:51:59.000Z | 0x66178bc1ffb72d2be32d43f97f08212f232d191540bb470098020abfc58f3eca |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveStableswapFactoryNG_LiquidityGaugeDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveStableswapFactoryNG\_MetaPoolDeployed\_event
MetaPool deployment events from Curve's Stableswap Factory NG (Next Generation) on Ethereum, recording new pool creation with amplification parameter, fee configuration, base pool pairing, and deployer address. Used to track Curve liquidity pool launches and analyze factory deployment patterns.
| 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_coin` | `STRING` | Contract address of the token used in the metapool deployment. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_base_pool` | `STRING` | Contract address of the base pool used in the metapool architecture. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_A` | `STRING` | Amplification coefficient parameter used in Curve's StableSwap invariant algorithm. String-encoded integer value that controls the concentration of liquidity around the target price. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_deployer` | `STRING` | Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_A | in\_fee | address | in\_coin | removed | log\_index | in\_deployer | block\_number | in\_base\_pool | block\_timestamp | transaction\_hash |
| ----- | ------- | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 500 | 1000000 | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | 0x0e573ce2736dd9637a0b21058352e1667925c7a8 | false | 235 | 0x2d12d0907a388811e3aa855a550f959501d303ee | 18586986 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 2023-11-16T20:58:11.000Z | 0xe810a5fa06a4968415ba3f2e00e640239c66dc5c65e0ff0887832a245d9cbfd4 |
| 500 | 1000000 | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | 0x0e573ce2736dd9637a0b21058352e1667925c7a8 | false | 239 | 0x2d12d0907a388811e3aa855a550f959501d303ee | 18586989 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 2023-11-16T20:58:47.000Z | 0x9936843700b0adac15ac6fac3d722f9df7be5252cfa1455367298be40c318ef1 |
| 500 | 1000000 | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | 0x0e573ce2736dd9637a0b21058352e1667925c7a8 | false | 72 | 0x2d12d0907a388811e3aa855a550f959501d303ee | 18547976 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 2023-11-11T10:04:59.000Z | 0xe7266478b0a0903737fcfd18d9980f5b505d59fb5b847bf2429fbbcd15b5fae3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveStableswapFactoryNG_MetaPoolDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveStableswapFactoryNG\_PlainPoolDeployed\_event
Pool deployment events from Curve Finance's Stableswap Factory NG (Next Generation) on Ethereum, capturing creation of new plain stablecoin liquidity pools with amplification coefficient (A), fee rates, token pairs, and deployer addresses for tracking protocol expansion.
| 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_coins` | `ARRAY` | Array of token contract addresses included in the liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts. |
| `in_A` | `STRING` | Amplification coefficient parameter used in Curve's StableSwap invariant algorithm. String-encoded integer value that controls the concentration of liquidity around the target price. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_deployer` | `STRING` | Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_A | in\_fee | address | removed | in\_coins | log\_index | in\_deployer | block\_number | block\_timestamp | transaction\_hash |
| ----- | -------- | ------------------------------------------ | ------- | -------------------------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 100 | 10000000 | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | false | \["0xf939e0a03fb07f59a73314e73794be0e57ac1b4e","0x677ddbd918637e5f2c79e164d402454de7da8619"] | 263 | 0x29aa2ed8712072e918632259780e587698ef58df | 20373046 | 2024-07-24T01:14:23.000Z | 0x9850db18e53c6decc8dfe92f9b14dec096ecaa5d46c798e7f966352ec6a81368 |
| 100 | 4000000 | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | false | \["0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b","0x8668a15b7b023dc77b372a740fcb8939e15257cf"] | 265 | 0x0ffe05c0efd48ea5cbf380594f8f97c328660328 | 20379393 | 2024-07-24T22:30:47.000Z | 0x82a4fa13ea2be9caae13851beb353ec6f2a135caaa337a5a23f57ae81a40b851 |
| 200 | 4000000 | 0x6a8cbed756804b16e05e741edabd5cb544ae21bf | false | \["0x6900057428c99fb373397d657beb40d92d8ac97f","0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48"] | 54 | 0x8b9c90edf20816342eb4704359899e471a2beb67 | 20377184 | 2024-07-24T15:05:47.000Z | 0x44fdff96b4f358bfa371f187970e93f515cd56769f2bdfde8466ac1122b6a394 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveStableswapFactoryNG_PlainPoolDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTricryptoFactory\_LiquidityGaugeDeployed\_event
Liquidity gauge deployment events from Curve's Tricrypto Factory on Ethereum, linking gauge contracts to their corresponding liquidity pools. Used for tracking CRV reward distribution infrastructure and identifying when new pools become eligible for incentives.
| 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_gauge` | `STRING` | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_pool | removed | in\_gauge | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | 0xdb6925ea42897ca786a045b252d95aa7370f44b4 | false | 0x331d6f25a382b4961a983d6ddc6974a48e51462c | 18 | 18380407 | 2023-10-18T23:06:23.000Z | 0x42e1e02793e6487227913e341f677f8b18395a37310aabc172cfd1f8660083e4 |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | 0xf7e009b8111c09a906d1d84938745b9edeedfdde | false | 0xdf19894056c736935c90fe08c54f1742e2593e62 | 949 | 20216663 | 2024-07-02T05:11:35.000Z | 0x4d61bb61b376883d309ff8a4950f0c47e8df62229470b48e2ae7eaa2ac89e059 |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | 0x1830c553dc76d3447b69b7b0dc19cf9e3c739c78 | false | 0x1ee8f8b504e99a0fcd3a32d38aa9968750a708ad | 74 | 19070832 | 2024-01-23T17:23:35.000Z | 0x4c3944c7522eb87d2c10101b6e81da8731e6970e421a9f4b30355fc31c786c19 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTricryptoFactory_LiquidityGaugeDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTricryptoFactory\_TricryptoPoolDeployed\_event
Pool deployment events from Curve's Tricrypto Factory contract on Ethereum, capturing three-asset liquidity pool creation with configuration parameters including coins, fees, amplification coefficients (A\_gamma), and price ranges. Used for tracking new Tricrypto pool launches and analyzing pool parameter settings across different token combinations.
| 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_name` | `STRING` | Name or label identifier for the entity being created, registered, or updated in the event. |
| `in_symbol` | `STRING` | Symbol of the token involved in the transaction or event. |
| `in_weth` | `STRING` | Contract address of the Wrapped ETH (WETH) token used in the swap or pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_coins` | `ARRAY` | Array of token contract addresses included in the liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts. |
| `in_math` | `STRING` | Contract address of the math implementation used by the liquidity pool. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_salt` | `STRING` | Cryptographic salt value used for deterministic address generation in contract deployment. 66-character hex string including 0x prefix. |
| `in_packed_precisions` | `STRING` | Encoded precision parameters for each token in the pool, stored as a packed integer. Determines decimal place adjustments when calculating amounts across tokens with different decimal representations. |
| `in_packed_A_gamma` | `STRING` | Packed encoding of the amplification coefficient (A) and gamma parameter used in Curve's cryptoswap invariant calculation. Numeric string representation of a bit-packed uint256 value containing both pool parameters. |
| `in_packed_fee_params` | `STRING` | Packed encoding of fee configuration parameters for the Curve pool. Numeric string representation of a bit-packed uint256 value containing multiple fee-related settings. |
| `in_packed_rebalancing_params` | `STRING` | Packed encoding of pool rebalancing configuration parameters for Curve's cryptoswap pools. Numeric string representation of a bit-packed uint256 value containing rebalancing thresholds and adjustment settings. |
| `in_packed_prices` | `STRING` | Packed encoding of initial price oracle values for tokens in the Curve pool. Numeric string representation of a bit-packed uint256 value containing multiple token price parameters. |
| `in_deployer` | `STRING` | Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_math | in\_name | in\_pool | in\_salt | in\_weth | removed | in\_coins | in\_symbol | log\_index | in\_deployer | block\_number | block\_timestamp | in\_packed\_prices | transaction\_hash | in\_packed\_A\_gamma | in\_packed\_fee\_params | in\_packed\_precisions | in\_packed\_rebalancing\_params |
| ------------------------------------------ | ------------------------------------------ | ---------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------- | ----------------------------------------------------------------------------------------------------------------------------------------- | -------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------- | ------------------------------------------------------------------ | --------------------------------------------- | ------------------------------------------------ | --------------------------------------------------- | --------------------------------------------------- |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | 0xcbff3004a20dbfe2731543aa38599a526e0fd6ee | TricryptoINV | 0x5426178799ee0a0181a89b4f57efddfab49941ec | 0xe91fe7fcabbd0b445881e823e9f568a08b90cadda81163b7b161cccd44c17dc2 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | false | \["0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48","0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2","0x41d5d79431a913c4ae7d69a668ecdfe5ff9dfb68"] | crvUSDCWETHINV | 167 | 0x2d12d0907a388811e3aa855a550f959501d303ee | 17591884 | 2023-06-30T11:46:11.000Z | 15652988878363169319315231941861337728864000000000000000000 | 0xf8a1b6c8abf5cb2a02ad4ceb44bfce204f764ffbd6822edf42bef3395a0b316d | 581076037942835227425498917514114728328226821 | 1020847100762815390943526144507091182848000000 | 340282366920938463463374607431786658200073709551617 | 680564733841876935965653810981216714752000000002596 |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | 0xcbff3004a20dbfe2731543aa38599a526e0fd6ee | Nico / Crazypool | 0x8804f8b1d3fb7b7dac8ae88d8508e5cd0ad5e06f | 0x142be3bd324b700d35bcab642e38dc9038d46b62b65be81627309933d2caa7aa | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | false | \["0x3845badade8e6dff049820680d1f14bd3903a5d0","0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48","0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"] | nico | 175 | 0x91ec641a3746693704054523c832167555789a39 | 19846799 | 2024-05-11T12:30:35.000Z | 2330593931041507536260652686300180480262146357000000000000000 | 0xd6b1ee53cdc13b42fcb20bee29ee094f182a2b30a1c26c0bb18560ff0e179d6f | 918763751816001535104965293564205198004045824 | 102084710076281539044546405451643678921600000000 | 340282385367682537172926223431768211457 | 34028236692093846348182135150547776307200000000865 |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | 0xcbff3004a20dbfe2731543aa38599a526e0fd6ee | TriBSN | 0x35b269fe0106d3645d9780c5aad97c8eb8041c40 | 0x8bf22ed727e0446e82cf781745b140ef39a2f593879bdf8fe31dd477d14d051c | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | false | \["0xf939e0a03fb07f59a73314e73794be0e57ac1b4e","0x3d1e5cf16077f349e999d6b21a4f646e83cd90c5","0x534d1f5e617e0f72a6b06a04aa599839af776a5e"] | TriBSN | 58 | 0x82a32ebd1b29202b7184941fa4948f56ad844740 | 18418943 | 2023-10-24T08:31:11.000Z | 1453207653195119738596012014657738912559406146168348547 | 0x1b14ad86a5c61afb0453a78a867ddd85da176d649304c4e3d14010bd8382791e | 918762390686533851351111440065775470931200000 | 1020846760480448470927399884817811331879788544 | 340282366920938463481821351505477763073 | 34028236692093846348182135150547776307200000000865 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTricryptoFactory_TricryptoPoolDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTricryptoFactory\_UpdateFeeReceiver\_event
Fee receiver address update events from Curve's Tricrypto Factory contract on Ethereum. Tracks changes to the protocol fee collection address for analyzing fee routing and governance actions.
| 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__old_fee_receiver` | `STRING` | Address of the previous fee receiver before the update. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_fee_receiver` | `STRING` | Address of the updated fee receiver for the Curve factory contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_new\_fee\_receiver | in\_\_old\_fee\_receiver |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | false | 405 | 20126767 | 2024-06-19T15:45:59.000Z | 0x898120aad145a2807088133b021be12f5daa9db12de8b7de596a0f5f3574918b | 0xa2bcd1a4efbd04b63cd03f5aff2561106ebcce00 | 0xecb456ea5365865ebab8a2661b0c503410e9b347 |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | false | 137 | 17371439 | 2023-05-30T11:26:47.000Z | 0xa83ae388e725df11b13e7441ab14cf0687c702b03c740520044cd3db60a199c0 | 0xecb456ea5365865ebab8a2661b0c503410e9b347 | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTricryptoFactory_UpdateFeeReceiver_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTricryptoFactory\_UpdateGaugeImplementation\_event
Gauge implementation upgrade events from Curve's Tricrypto Factory contract on Ethereum, recording when liquidity gauge smart contract logic is updated. Used for tracking factory configuration changes and gauge version history.
| 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__old_gauge_implementation` | `STRING` | Contract address of the previous gauge implementation before the update. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_gauge_implementation` | `STRING` | Contract address of the updated gauge implementation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_new\_gauge\_implementation | in\_\_old\_gauge\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | false | 207 | 17372657 | 2023-05-30T15:33:59.000Z | 0x0997b8ab4ae0e6883db4e53cae0cfb3d8a5437deaa0209dfc89d81505d0087f7 | 0x5fc124a161d888893529f67580ef94c2784e9233 | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTricryptoFactory_UpdateGaugeImplementation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTricryptoFactory\_UpdateMathImplementation\_event
Events tracking updates to the mathematical implementation contract used by Curve's Tricrypto factory on Ethereum. Useful for monitoring protocol upgrades and changes to AMM pricing logic across factory-deployed pools.
| Column | Type | Description |
| ----------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in__old_math_implementation` | `STRING` | Contract address of the previous math implementation contract before the update. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_math_implementation` | `STRING` | Contract address of the updated math implementation contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_new\_math\_implementation | in\_\_old\_math\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | false | 110 | 17371451 | 2023-05-30T11:29:23.000Z | 0xcc04affb1a7ccc5444fc3005433cec38d2da30b2b9cc42b16bdc9f36da386eb6 | 0xcbff3004a20dbfe2731543aa38599a526e0fd6ee | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTricryptoFactory_UpdateMathImplementation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTricryptoFactory\_UpdatePoolImplementation\_event
Factory contract upgrade events tracking changes to Curve Tricrypto pool implementation contracts on Ethereum. Records old and new implementation addresses with IDs for monitoring protocol upgrades and liquidity pool template versions.
| 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__implemention_id` | `STRING` | Identifier for the pool implementation version being updated in Curve factory contracts. String representation of a numeric value, ranging from simple integers to large numbers. |
| `in__old_pool_implementation` | `STRING` | Contract address of the previous pool implementation before the update in Curve factory contracts. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_pool_implementation` | `STRING` | Contract address of the updated pool implementation in Curve factory contracts. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_implemention\_id | in\_\_new\_pool\_implementation | in\_\_old\_pool\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------- | ------------------------------------------ | ------------------------------------------ |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | false | 147 | 17371443 | 2023-05-30T11:27:35.000Z | 0x5cec36cd09955b54a73a83e86fc04cae866fb7c7386ec5e5cfd3d4a535afa79a | 0 | 0x66442b0c5260b92caa9c234ecf2408cbf6b19a6f | 0x0000000000000000000000000000000000000000 |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | false | 205 | 23592231 | 2025-10-16T19:12:23.000Z | 0x9ca9ca318babd8a522fdd15875b058c1fd649109f5f4726ccc0943a3b1f7554a | 6789 | 0x1601f9c6640fe06e5928bb4451f99a015630faf0 | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTricryptoFactory_UpdatePoolImplementation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTricryptoFactory\_UpdateViewsImplementation\_event
Contract upgrade events from Curve's Tricrypto Factory on Ethereum, recording changes to the views implementation contract address. Used for tracking factory contract upgrades and identifying active implementation versions across different deployment periods.
| 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__old_views_implementation` | `STRING` | Contract address of the previous views implementation contract before the update. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_views_implementation` | `STRING` | Contract address of the updated views implementation contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_new\_views\_implementation | in\_\_old\_views\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x0c0e5f2ff0ff18a3be9b835635039256dc4b4963 | false | 200 | 17371447 | 2023-05-30T11:28:23.000Z | 0xfad322bdd7591c19c76fc657ce16187937389efd0e6712937567485ddf23ecdc | 0x064253915b8449fdefac2c4a74aa9fdf56691a31 | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTricryptoFactory_UpdateViewsImplementation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTwocryptoFactory\_LiquidityGaugeDeployed\_event
Liquidity gauge deployment events from Curve's Twocrypto Factory on Ethereum, linking pool addresses to their corresponding gauge contracts. Used for tracking CRV reward distribution infrastructure and analyzing when pools become eligible for emissions.
| 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_gauge` | `STRING` | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_pool | removed | in\_gauge | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | 0xb40fb68c2f3b7914369174869654c6905cfeefd5 | false | 0x4f8e4b95db4eefe416064afee01738ce74073632 | 246 | 20235602 | 2024-07-04T20:42:35.000Z | 0xf8b512e2eb11a5390f872f7842922ba9c84171c5806cf9b2f5732afcf31f0dd5 |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | 0x004c167d27ada24305b76d80762997fa6eb8d9b2 | false | 0x16a3a047fc1d388d5846a73acdb475b11228c299 | 242 | 19390616 | 2024-03-08T13:01:47.000Z | 0xadbe295b61aa8cf424acd3095f749d113201e8c06a41f4be0dc3f77ba3b601e3 |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | 0xde73e407efc75edbafc5bcd62ebb1e7a9b38ebcd | false | 0x36152aa234fcf97b5c14fc6d4893fc0da5328bd2 | 212 | 19763652 | 2024-04-29T21:29:47.000Z | 0xee3719c3cfc2269dce2a5c42ab0fd04d4fb1d12c48d36e92d7490886d6f6e545 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTwocryptoFactory_LiquidityGaugeDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTwocryptoFactory\_TwocryptoPoolDeployed\_event
Factory deployment events for Curve V2 crypto pools (two-token pairs) on Ethereum, capturing pool addresses, token pairs, initial parameters (A/gamma), fee settings, and deployer addresses for tracking new liquidity pool creation.
| 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_name` | `STRING` | Name or label identifier for the entity being created, registered, or updated in the event. |
| `in_symbol` | `STRING` | Symbol of the token involved in the transaction or event. |
| `in_coins` | `ARRAY` | Array of token contract addresses included in the liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts. |
| `in_math` | `STRING` | Contract address of the math implementation used by the liquidity pool. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_salt` | `STRING` | Cryptographic salt value used for deterministic address generation in contract deployment. 66-character hex string including 0x prefix. |
| `in_precisions` | `ARRAY` | Array of precision multipliers for each token in the pool, adjusting for different decimal places between assets. Values of '1' indicate no adjustment needed, while larger values like '1000000000000' normalize lower-decimal tokens (e.g., USDC) to 18 decimals. |
| `in_packed_A_gamma` | `STRING` | Packed encoding of the amplification coefficient (A) and gamma parameter used in Curve's cryptoswap invariant calculation. Numeric string representation of a bit-packed uint256 value containing both pool parameters. |
| `in_packed_fee_params` | `STRING` | Packed encoding of fee configuration parameters for the Curve pool. Numeric string representation of a bit-packed uint256 value containing multiple fee-related settings. |
| `in_packed_rebalancing_params` | `STRING` | Packed encoding of pool rebalancing configuration parameters for Curve's cryptoswap pools. Numeric string representation of a bit-packed uint256 value containing rebalancing thresholds and adjustment settings. |
| `in_packed_prices` | `STRING` | Packed encoding of initial price oracle values for tokens in the Curve pool. Numeric string representation of a bit-packed uint256 value containing multiple token price parameters. |
| `in_deployer` | `STRING` | Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_math | in\_name | in\_pool | in\_salt | removed | in\_coins | in\_symbol | log\_index | in\_deployer | block\_number | in\_precisions | block\_timestamp | in\_packed\_prices | transaction\_hash | in\_packed\_A\_gamma | in\_packed\_fee\_params | in\_packed\_rebalancing\_params |
| ------------------------------------------ | ------------------------------------------ | ------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------- | -------------------------------------------------------------------------------------------- | ---------- | ---------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ | ----------------------------------------------- | ---------------------------------------------- | --------------------------------------------------- |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | 0x2005995a71243be9fb995dab4742327dc76564df | THING/crvUSD | 0x3f105e0a641747c5401e9513b125e00a5f403556 | 0xb4408fcd740e4a351932a5696ac8062ad3f54119e0918ec025fc85c6dee7d6f8 | false | \["0xf939e0a03fb07f59a73314e73794be0e57ac1b4e","0x2c9084e65d046146d6cfc26bf45f5b80042b90eb"] | NPC CBDC | 175 | 0xccbf601eb2f5aa2d5d68b069610da6f1627d485d | 19458556 | \["1","1"] | 2024-03-18T01:56:47.000Z | 98306241614530 | 0xa14b9bd00922009c26085bf980fa3f473f087bda1885431de2eac3f47d7c82bf | 136112946768375385385349842972852284582400000 | 8847341539944400050877843276543133320576000000 | 680564733841876929619973849625130958848000000000600 |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | 0x2005995a71243be9fb995dab4742327dc76564df | rev USD3 | 0xde73e407efc75edbafc5bcd62ebb1e7a9b38ebcd | 0x79a602ec2a6b341c9e99459498094bc51dabc69fe60e507994f649b153e022bc | false | \["0x0d86883faf4ffd7aeb116390af37746f45b6f378","0x78da5799cf427fee11e9996982f4150ece7a99a7"] | USD3rgUSD | 344 | 0xc090efad886f441846407bb434efa0be7039ad70 | 19763634 | \["1","1"] | 2024-04-29T21:26:11.000Z | 1000000000000000000 | 0xd4ad7efdcc16d797dd3494ba02b377da4127fd5b1bd25089858b66e5a7e456ab | 13611294676837538538534984297272728458240000000 | 1531270651144223086599756657796982290432000000 | 3402823669209384736090838479720216002560000000866 |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | 0x2005995a71243be9fb995dab4742327dc76564df | BLOOM/ETH | 0x19d2b5ce188ca60790755204691e38102749297b | 0xc5569f27a952d47271c488c2401492e9c1378167f45db037c5cf878c408a92c6 | false | \["0x6c4a8973e6633da2da7187669479c27830c7b1c4","0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"] | BLOOM/ETH | 257 | 0x69ef68b9af567245e55c4a080136ce9c144648a4 | 19760031 | \["1","1"] | 2024-04-29T09:19:23.000Z | 105000000000000000000 | 0x61118d9903f8344e5971d1e7c781f76e855996408dac979d3a4971cefafa6587 | 136112946768375385385349842972852284582400000 | 8847341539944400050877843276543133320576000000 | 680564733841876929619973849625130958848000000000866 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTwocryptoFactory_TwocryptoPoolDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTwocryptoFactory\_UpdateFeeReceiver\_event
Event log capturing changes to fee receiver addresses in Curve's two-crypto factory pools on Ethereum. Tracks administrative updates showing old and new fee recipient addresses for protocol revenue collection analysis.
| Column | Type | Description |
| ---------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in__old_fee_receiver` | `STRING` | Address of the previous fee receiver before the update. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_fee_receiver` | `STRING` | Address of the updated fee receiver for the Curve factory contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_new\_fee\_receiver | in\_\_old\_fee\_receiver |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | false | 116 | 18867339 | 2023-12-26T03:58:47.000Z | 0x2bf9d9ffd2428ece30ea08d8b851595c0f188f4037844c8a08a202028ebbc687 | 0xecb456ea5365865ebab8a2661b0c503410e9b347 | 0x0000000000000000000000000000000000000000 |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | false | 402 | 20126767 | 2024-06-19T15:45:59.000Z | 0x898120aad145a2807088133b021be12f5daa9db12de8b7de596a0f5f3574918b | 0xa2bcd1a4efbd04b63cd03f5aff2561106ebcce00 | 0xecb456ea5365865ebab8a2661b0c503410e9b347 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTwocryptoFactory_UpdateFeeReceiver_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTwocryptoFactory\_UpdateGaugeImplementation\_event
Gauge implementation upgrade events from Curve's two-crypto factory contract on Ethereum, recording when liquidity gauge logic contracts are updated. Used for tracking governance changes to reward distribution mechanisms across Curve's crypto pool factories.
| 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__old_gauge_implementation` | `STRING` | Contract address of the previous gauge implementation before the update. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_gauge_implementation` | `STRING` | Contract address of the updated gauge implementation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_new\_gauge\_implementation | in\_\_old\_gauge\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | false | 211 | 18867348 | 2023-12-26T04:00:47.000Z | 0xe8031a93018c020d60447f71c79b2e579f951d3ea5671208658e6dbb874cc2ae | 0x38d9bda812da2c68dfc6ade85a7f7a54e77f8325 | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTwocryptoFactory_UpdateGaugeImplementation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTwocryptoFactory\_UpdateMathImplementation\_event
Upgrade events tracking changes to the mathematical implementation contract used by Curve v1 Twocrypto Factory pools on Ethereum. Records the old and new implementation addresses when the factory's pricing and liquidity calculation logic is updated.
| 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__old_math_implementation` | `STRING` | Contract address of the previous math implementation contract before the update. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_math_implementation` | `STRING` | Contract address of the updated math implementation contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_new\_math\_implementation | in\_\_old\_math\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | false | 522 | 18867341 | 2023-12-26T03:59:23.000Z | 0xd1a580589de51bcdfde4ffe6623281766c3aa30112b01e5c7bdfaea793a0efb4 | 0x2005995a71243be9fb995dab4742327dc76564df | 0x0000000000000000000000000000000000000000 |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | false | 302 | 20078169 | 2024-06-12T20:35:23.000Z | 0x66794d563f78b7d34755d04a6589611f3f649d82868a09a7187d6356fb5b8a49 | 0x1fd8af16dc4bebd950521308d55d0543b6cdf4a1 | 0x2005995a71243be9fb995dab4742327dc76564df |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTwocryptoFactory_UpdateMathImplementation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTwocryptoFactory\_UpdatePoolImplementation\_event
Protocol upgrade events from Curve's Twocrypto Factory contract on Ethereum, tracking changes to pool implementation addresses. Used for monitoring factory contract upgrades and pool template version transitions.
| 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__implemention_id` | `STRING` | Identifier for the pool implementation version being updated in Curve factory contracts. String representation of a numeric value, ranging from simple integers to large numbers. |
| `in__old_pool_implementation` | `STRING` | Contract address of the previous pool implementation before the update in Curve factory contracts. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_pool_implementation` | `STRING` | Contract address of the updated pool implementation in Curve factory contracts. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_implemention\_id | in\_\_new\_pool\_implementation | in\_\_old\_pool\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | false | 299 | 20078169 | 2024-06-12T20:35:23.000Z | 0x66794d563f78b7d34755d04a6589611f3f649d82868a09a7187d6356fb5b8a49 | 0 | 0x934791f7f391727db92bff94cd789c4623d14c52 | 0x04fd6bec7d45efa99a27d29fb94b55c56dd07223 |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | false | 271 | 18867340 | 2023-12-26T03:58:59.000Z | 0x3732e173451e1facefb6115e5416bb39053b571be15a098db01b5e386da632cb | 0 | 0x04fd6bec7d45efa99a27d29fb94b55c56dd07223 | 0x0000000000000000000000000000000000000000 |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | false | 772 | 23198614 | 2025-08-22T19:09:23.000Z | 0x42aa267ff346cc3c8b79f544ee4a8eb5bf0e1d52330fb6ed7a890f5ba4d274bd | 110827960954786879070795645317684308345156454977361180728234664032152099907574 | 0x986fafb173801d9f82a01d9ffd71f1e1c080d2c2 | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTwocryptoFactory_UpdatePoolImplementation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveTwocryptoFactory\_UpdateViewsImplementation\_event
Curve Twocrypto Factory contract events tracking updates to the views implementation address on Ethereum. Records the old and new implementation addresses when the factory's view functions are upgraded, useful for monitoring protocol governance and contract upgrade patterns.
| 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__old_views_implementation` | `STRING` | Contract address of the previous views implementation contract before the update. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__new_views_implementation` | `STRING` | Contract address of the updated views implementation contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_\_new\_views\_implementation | in\_\_old\_views\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x98ee851a00abee0d95d08cf4ca2bdce32aeaaf7f | false | 505 | 18867341 | 2023-12-26T03:59:23.000Z | 0xe1c87652f127e16cb65c3e07e05f5891b6ade5637a8a1b6f35a72abc2efa48c2 | 0x07cdebf81977e111b08c126defa07818d0045b80 | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.CurveTwocryptoFactory_UpdateViewsImplementation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gauge\_deposit\_reward\_token\_function
Reward token deposit function calls to Curve V1 liquidity gauge contracts on Ethereum, tracking incentive distributions to gauge stakers. Used for analyzing reward token emission schedules and liquidity mining program activity across Curve pools.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__reward_token` | `STRING` | Contract address of the reward token being deposited into the Curve gauge. Hex-encoded, 0x-prefixed 40-character Ethereum address representing tokens like CRV or other incentive tokens. |
| `in__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
| gas | value | status | gas\_used | signature | in\_\_amount | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_\_reward\_token | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ---------------------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 390015 | 0 | true | 62669 | 0x93f7aa67 | 5776526011904761904761 | 0x5ae854b098727a9f1603a1e21c50d52dc834d846 | 17818658 | 0x9af8fbba318adeacea010b8d7c0190d443ee1a85 | 2,1,0 | 2023-08-01T07:28:35.000Z | 0xa95c5ebb86e0de73b4fb8c47a45b792cfea28c23 | 0x6f72dde39a22665058a63f374036548b5c1e948ab546746be5dbed9fdc814a5e |
| 396347 | 0 | true | 62844 | 0x93f7aa67 | 5776526011904761904761 | 0x9af8fbba318adeacea010b8d7c0190d443ee1a85 | 17818658 | 0x07cd2e45386da2ff8f2db716e733b6f48511a118 | 2,1 | 2023-08-01T07:28:35.000Z | 0xa95c5ebb86e0de73b4fb8c47a45b792cfea28c23 | 0x6f72dde39a22665058a63f374036548b5c1e948ab546746be5dbed9fdc814a5e |
| 465628 | 0 | true | 69969 | 0x93f7aa67 | 8665286051587301587301 | 0x5ae854b098727a9f1603a1e21c50d52dc834d846 | 17818658 | 0xd90a01c487564ba6cef5c3870c1251aff0c49e53 | 2,0,0 | 2023-08-01T07:28:35.000Z | 0xa95c5ebb86e0de73b4fb8c47a45b792cfea28c23 | 0x6f72dde39a22665058a63f374036548b5c1e948ab546746be5dbed9fdc814a5e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.Gauge_deposit_reward_token_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ibAUD-sAUD\_TokenExchange\_event
Token swap events from the Curve V1 ibAUD-sAUD liquidity pool on Ethereum. Records exchanges between interest-bearing AUD (ibAUD) and synthetic AUD (sAUD) tokens with buyer addresses, token amounts, and pool identifiers for analyzing stablecoin trading and liquidity flows.
| 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_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | ---------------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
| 0x3f1b0278a9ee595635b61817630cc19de792f506 | false | 0xd7e630afcf128feb8b9071a8412914478c00c22a | 36 | 1 | 13574836 | 0 | 1634597373794667582458 | 2021-11-08T08:55:19.000Z | 1633130878893589003936 | 0xa1ede7ce4cd017281b72d53199c21545116749e5e3e05fc3a16a19abc0982747 |
| 0x3f1b0278a9ee595635b61817630cc19de792f506 | false | 0x39eac46a11d7f5111652fc9ebdfb5f8e737c2bb5 | 356 | 0 | 13986839 | 1 | 622392360716448839423 | 2022-01-11T22:05:17.000Z | 621064687488093494396 | 0x9ce55ae372ced22e23e1ba7693450d0e5501512cfe6c81fd0aa870e507c35dbc |
| 0x3f1b0278a9ee595635b61817630cc19de792f506 | false | 0x35793cc725a97a761f3418ff6fa11c70255969b7 | 94 | 0 | 17086515 | 1 | 2456147917250931981812 | 2023-04-20T08:24:23.000Z | 2590143259392225091112 | 0x90a309b78aaf8349b3f17038d47b4dacd9f9cd1045ce10f54563dfdf96b31501 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.ibAUD-sAUD_TokenExchange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ibCHF-sCHF\_TokenExchange\_event
Token swap events from the Curve V1 ibCHF-sCHF liquidity pool on Ethereum, tracking exchanges between interest-bearing CHF (ibCHF) and synthetic CHF (sCHF) stablecoins. Records buyer addresses, token amounts sold and bought, and pool token IDs for analyzing Swiss franc stablecoin trading activity.
| 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_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | ----------------------- | ------------------------ | ----------------------- | ------------------------------------------------------------------ |
| 0x9c2c8910f113181783c249d8f6aa41b51cde0f0c | false | 0x8eb080fe0045ffc44e2c1446c2a87cda010b8c23 | 48 | 0 | 14994680 | 1 | 18974185776335502875023 | 2022-06-20T04:41:27.000Z | 18519188832146233346619 | 0x49b4b87d06f68e5626dcc84d42110c103abca973b1c7837f8ea5e33a2a97d544 |
| 0x9c2c8910f113181783c249d8f6aa41b51cde0f0c | false | 0xe4000004000bd8006e00720000d27d1fa000d43e | 56 | 0 | 15473896 | 1 | 219319798019028584941 | 2022-09-04T21:09:41.000Z | 214090936254430414784 | 0x70c8ca139b1ca6c0364405b064e4f8bf232290aef5f6213db43e24d80c598229 |
| 0x9c2c8910f113181783c249d8f6aa41b51cde0f0c | false | 0x4bcd0d9bdc8f28664987b99cc73dc368c7dee1bd | 195 | 0 | 15818220 | 1 | 41839125850674403918633 | 2022-10-24T13:19:59.000Z | 39807284860257861916863 | 0xc5a7176964120210096a0fc5b20e4e3d97e5ab93dd21bdabec20e398b8baa614 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.ibCHF-sCHF_TokenExchange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ibEUR-sEURpool\_TokenExchange\_event
Token swap events from the Curve ibEUR-sEUR liquidity pool on Ethereum, recording exchanges between iron bank EUR (ibEUR) and synth EUR (sEUR) stablecoins. Captures trader addresses, token amounts sold and bought, and pool token IDs for analyzing EUR-pegged stablecoin trading volumes and price stability.
| 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_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | --------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
| 0x19b080fe1ffa0553469d20ca36219f17fcf03859 | false | 0x34ffe9469d518ecbaa8daed2683b0344c71f08e1 | 102 | 1 | 14203603 | 0 | 373533295535187018312 | 2022-02-14T09:52:16.000Z | 374416182281682509605 | 0x98d14e9620729539dce8f06424a7f0603e58919239821a63767eb85aac559335 |
| 0x19b080fe1ffa0553469d20ca36219f17fcf03859 | false | 0x34ffe9469d518ecbaa8daed2683b0344c71f08e1 | 49 | 0 | 14203578 | 1 | 381790215167649382376 | 2022-02-14T09:47:50.000Z | 380585290076781510384 | 0xe5bdf13324462018d9cc6bb35370a684b0e66b0a6bf0ee91b707fca73f6cb386 |
| 0x19b080fe1ffa0553469d20ca36219f17fcf03859 | false | 0x34ffe9469d518ecbaa8daed2683b0344c71f08e1 | 7 | 0 | 14203555 | 1 | 100000000000000000000 | 2022-02-14T09:40:49.000Z | 99684417151209873456 | 0xb552b62e3bf88fee53f99dfdd57de30bf78ebaf8181606adc63a6a10b48fa52a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.ibEUR-sEURpool_TokenExchange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ibGBP-sGBP\_TokenExchange\_event
Token swap events from the Curve V1 ibGBP-sGBP liquidity pool on Ethereum, recording exchanges between interest-bearing GBP (ibGBP) and synthetic GBP (sGBP) stablecoins. Contains swap direction, amounts, buyer addresses, and timestamps for analyzing GBP-pegged asset trading activity and pool utilization.
| 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_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | ------------------------- | ------------------------ | ------------------------- | ------------------------------------------------------------------ |
| 0xd6ac1cb9019137a896343da59dde6d097f710538 | false | 0x6b3d1a37b5c01901341f01f4975d31bc5e6c3d81 | 32 | 0 | 14085186 | 1 | 1114018916735225451304425 | 2022-01-27T03:12:05.000Z | 1114957855170005588403884 | 0x3637d6098788c1a6b7a7ff38975fb6f9ca04beb5397290ce6962361cc194f18f |
| 0xd6ac1cb9019137a896343da59dde6d097f710538 | false | 0x2d407ddb06311396fe14d4b49da5f0471447d45c | 189 | 0 | 14085355 | 1 | 150240756894006237460140 | 2022-01-27T03:50:26.000Z | 150268101789157044530368 | 0x55564bcf3178cf1103abda81ce6f75e378413f2d700f669cab4999129123de4f |
| 0xd6ac1cb9019137a896343da59dde6d097f710538 | false | 0xea25220caf98e0097fb8401d8a44e2d4f2cef093 | 497 | 0 | 14940140 | 1 | 30160029926638471390831 | 2022-06-10T19:21:05.000Z | 29837236671338687708916 | 0xfe0663387fe1fef60f9f820c8c2eea77601959980c13253b45d6113ed6c761b5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.ibGBP-sGBP_TokenExchange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ibJPY-sJPYpool\_TokenExchange\_event
Token swap events from Curve's ibJPY-sJPY liquidity pool on Ethereum, tracking exchanges between interest-bearing JPY (ibJPY) and synthetic JPY (sJPY) stablecoins. Records buyer addresses, token amounts, and swap direction for analyzing Japanese yen-pegged asset trading activity.
| 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_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | ------------------------- | ------------------------ | ------------------------- | ------------------------------------------------------------------ |
| 0x8818a9bb44fbf33502be7c15c500d0c783b73067 | false | 0x4bcd0d9bdc8f28664987b99cc73dc368c7dee1bd | 523 | 0 | 14740255 | 1 | 3186874402567629971018625 | 2022-05-09T04:15:56.000Z | 3183970247551631679178001 | 0x16512623f6339277a4411a12a71b003bc6965e7a0c20f935cc61fd5bb62efd2a |
| 0x8818a9bb44fbf33502be7c15c500d0c783b73067 | false | 0x39eac46a11d7f5111652fc9ebdfb5f8e737c2bb5 | 151 | 0 | 13895960 | 1 | 59639320919905354604904 | 2021-12-28T20:44:53.000Z | 59595818423053477574722 | 0x58498aac59e27bc980ab750e0d21f556a0caf3aa6da869e448ea307cc15af27c |
| 0x8818a9bb44fbf33502be7c15c500d0c783b73067 | false | 0xcfcce06af0ee209dfa340247199057fe619c98c9 | 50 | 1 | 14068579 | 0 | 1881983062000000000000000 | 2022-01-24T13:26:53.000Z | 1875593216713004630871738 | 0xf9f55bc20a9e638f92356f2f8d5cf0ad6797266489eaff1c3e6352c163e53583 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.ibJPY-sJPYpool_TokenExchange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ibKRW-sKRWpool\_TokenExchange\_event
Token swap events from the Curve Finance ibKRW-sKRW liquidity pool on Ethereum, capturing Korean won-pegged stablecoin exchanges with buyer addresses, token amounts, and pool coin identifiers. Used for analyzing trading activity and liquidity patterns in Curve's KRW stablecoin pool.
| 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_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | -------------------------- | ------------------------ | ---------------------------- | ------------------------------------------------------------------ |
| 0x8461a004b50d321cb22b7d034969ce6803911899 | false | 0x38abab9766e0b27d2912718a884292b8e7eb2803 | 127 | 1 | 14762203 | 0 | 64492192000000000000000000 | 2022-05-12T16:46:07.000Z | 74487868182782713261676550 | 0x30ef8c2c38c88515c8ee8e76e21a64badba9a1abe8088aebf0808b3d9848ceca |
| 0x8461a004b50d321cb22b7d034969ce6803911899 | false | 0x38abab9766e0b27d2912718a884292b8e7eb2803 | 40 | 1 | 14761509 | 0 | 64492192000000000000000000 | 2022-05-12T14:06:57.000Z | 478532264830501488287404522 | 0x41c405405bbdc558ec0a2c9259ac3a9a0e8975b2bccc5b16259f22946af9837c |
| 0x8461a004b50d321cb22b7d034969ce6803911899 | false | 0x38abab9766e0b27d2912718a884292b8e7eb2803 | 170 | 1 | 14760994 | 0 | 65782036391792489353464963 | 2022-05-12T12:06:36.000Z | 1357265155775749231617462231 | 0xaf8ad6bb1396cb6638856fbb13f516737dd025284f54fe97e0a5b072b2d359ed |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.ibKRW-sKRWpool_TokenExchange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LegacyMetaPoolFactory\_BasePoolAdded\_event
Event logs recording base pool registrations in Curve's legacy metapool factory contract on Ethereum. Tracks which base pools (like 3pool or sUSD) were added as underlying liquidity sources for metapool deployments, essential for analyzing Curve's factory architecture evolution.
| 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_base_pool` | `STRING` | Contract address of the base pool used in the metapool architecture. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_implementat` | `STRING` | Contract address of the metapool implementation template used when the base pool was added to the factory. This address serves as the blueprint for deploying new metapools that utilize the specified base pool. |
| address | removed | log\_index | block\_number | in\_base\_pool | in\_implementat | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x0959158b6040d32d04c301a72cbfd6b39e21c9ae | false | 113 | 11942431 | 0x7fc77b5c7614e1533320ea6ddc2eb61fa00a9714 | 0x2f956eee002b0debd468cf2e0490d1aec65e027f | 2021-02-27T23:47:10.000Z | 0x7fa4712893d81071e18b69011aeb501f0b75d2cf49b04a9ca463df4d90909ef1 |
| 0x0959158b6040d32d04c301a72cbfd6b39e21c9ae | false | 99 | 11942420 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 0x5f890841f657d90e081babdb532a05996af79fe6 | 2021-02-27T23:44:51.000Z | 0xa7290b6c021f2914b4f25436ecc956b2a2fec6c3ac6ff05ce78f5f0d6e1e32a4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LegacyMetaPoolFactory_BasePoolAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LegacyMetaPoolFactory\_deploy\_metapool\_function
Function call records for deploying new metapools via Curve's Legacy MetaPool Factory on Ethereum. Contains pool creation parameters including amplification coefficient (A), fee, base pool address, and newly created pool address for tracking Curve metapool deployments.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__base_pool` | `STRING` | Contract address of the base pool used in the Curve metapool deployment. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `in__coin` | `STRING` | Contract address of the token being added to the Curve metapool. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__A` | `STRING` | Amplification coefficient parameter for the Curve pool being deployed. Numeric string representing the A parameter that controls the curve's shape and slippage characteristics. |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_\_A | value | status | in\_\_fee | gas\_used | in\_\_coin | in\_\_name | out\_anon0 | signature | in\_\_symbol | to\_address | block\_number | from\_address | in\_\_base\_pool | trace\_address | block\_timestamp | transaction\_hash |
| ------- | ------- | ----- | ------ | --------- | --------- | ------------------------------------------ | ------------- | ------------------------------------------ | ---------- | ------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 1212643 | 10 | 0 | true | 4000000 | 808429 | 0x2a8e1e676ec238d8a992307b495b45b3feaa5e86 | Origin Dollar | 0x87650d7bbfc3a9f10587d7778206671719d9910d | 0xe339eb4f | OUSD | 0x0959158b6040d32d04c301a72cbfd6b39e21c9ae | 12860905 | 0x449e0b5564e0d141b3bc3829e74ffa0ea8c08ad5 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | | 2021-07-20T02:59:14.000Z | 0xa1b1ccff28654c042b9bb8edf7c204aee4766128e16d32133dc82485def71030 |
| 1201342 | 10 | 0 | true | 4000000 | 800895 | 0xdc59ac4fefa32293a95889dc396682858d52e5db | Bean | 0x3a70dfa7d2262988064a2d051dd47521e43c9bdd | 0xe339eb4f | BEAN | 0x0959158b6040d32d04c301a72cbfd6b39e21c9ae | 13954026 | 0x925753106fcdb6d2f30c3db295328a0a1c5fd1d1 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | | 2022-01-06T20:23:33.000Z | 0x6a93ab470e4348fa96dddbf6105315b7ab048ba09201e7082b6a3040d91dba10 |
| 1085731 | 100 | 0 | true | 4000000 | 723821 | 0x853d955acef822db058eb8505911ed77f175b99e | Frax | 0xd632f22692fac7611d2aa1c0d552930d43caed3b | 0xe339eb4f | FRAX | 0x0959158b6040d32d04c301a72cbfd6b39e21c9ae | 11968730 | 0x234d953a9404bf9dbc3b526271d440cd2870bcd2 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | | 2021-03-04T01:13:59.000Z | 0x1f2a0d4e1c1eca594bd7f27f9952480ccda422c3453e0c5074a63aa46a2ed628 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LegacyMetaPoolFactory_deploy_metapool_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingController\_Borrow\_event
Borrow events from Curve v1 lending markets on Ethereum, tracking loan and collateral increases for individual user positions. Used for analyzing lending activity, collateralization ratios, and borrower behavior across Curve's lending protocol.
| 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_collateral_increase` | `STRING` | Amount of collateral added to the user's position in the borrow event, denominated in the smallest unit of the collateral token (wei-equivalent). Can be zero when only loan amount increases without additional collateral being posted. |
| `in_loan_increase` | `STRING` | Amount by which the user's outstanding loan balance increased in this borrow transaction, denominated in the smallest unit of the loan token (e.g., wei for ETH-based loans). Can be zero when only collateral is added without taking additional debt. |
| address | in\_user | removed | log\_index | block\_number | block\_timestamp | in\_loan\_increase | transaction\_hash | in\_collateral\_increase |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 0x09dbdeb3b301a4753589ac6df8a178c7716ce16b | 0x038201e05d140124952e34e31665420489288338 | false | 270 | 19727645 | 2024-04-24T20:34:47.000Z | 100000000000000000000000 | 0xdbc3ff51cc1e8ee8c07a6d8a92c3d79f105a3f12155adcc81e8724fba057e6ed | 80000000000000000000000 |
| 0xeda215b7666936ded834f76f3fbc6f323295110a | 0x0059efca9d24bf579ee0314e7bc2569674aa42e2 | false | 136 | 19723992 | 2024-04-24T08:17:23.000Z | 0 | 0x93896067ef7b3d7eed2a77754044fcde8812753d65978352226e83798a16044c | 13079785040549847561725 |
| 0xeda215b7666936ded834f76f3fbc6f323295110a | 0x0059efca9d24bf579ee0314e7bc2569674aa42e2 | false | 103 | 19723983 | 2024-04-24T08:15:35.000Z | 6175700372370272104413 | 0xc1735ad921f55345fa37ba8dd842ef9d5120e0069f7d3ed626133292117e5591 | 22260942031267662387120 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LendingController_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingController\_CollectFees\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_new_supply` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LendingController_CollectFees_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingController\_Liquidate\_event
Liquidation events from Curve V1 lending markets on Ethereum, recording undercollateralized loan liquidations with debt amounts, collateral seized, and stablecoin received by liquidators. Used for analyzing liquidation activity, liquidator profitability, and loan health across Curve lending pools.
| Column | Type | Description |
| ------------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_liquidator` | `STRING` | Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_collateral_received` | `STRING` | Amount of collateral tokens received by the liquidator from the liquidated position, denominated in the collateral token's smallest unit (wei). This value can be zero when the liquidation is settled entirely in stablecoin. |
| `in_stablecoin_received` | `STRING` | Amount of stablecoin received by the liquidator as part of the liquidation, denominated in the smallest unit (wei-equivalent, 18 decimals). Represents the stablecoin portion of liquidation proceeds, which may be the full liquidation value when no collateral is received. |
| `in_debt` | `STRING` | Amount of debt outstanding in the protocol position or vault. Numeric string representation in smallest token denomination. |
| address | in\_debt | in\_user | removed | log\_index | block\_number | in\_liquidator | block\_timestamp | transaction\_hash | in\_collateral\_received | in\_stablecoin\_received |
| ------------------------------------------ | ------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------ |
| 0x1e0165dbd2019441ab7927c018701f3138114d71 | 156689334341117017683774 | 0x1a31c94f97c649bc2a8adbceb54d1f4a075be4b1 | false | 21 | 20462852 | 0x8c76a73693a52e8eb35fb0234e5ec74152540378 | 2024-08-05T14:06:11.000Z | 0xf177cb1f5da971f992a16d9aedeeac17d00397b2cfc3aadea7f73af4869c0713 | 60411446563712412684 | 12952612513655649128105 |
| 0x1e0165dbd2019441ab7927c018701f3138114d71 | 191206200271163921819274 | 0xb6a052a564e9203e273587a11743e56f96326a81 | false | 571 | 20462357 | 0xbabe61887f1de2713c6f97e567623453d3c79f67 | 2024-08-05T12:26:47.000Z | 0x3235c1baddf6ec7a1a8f25b4774f46447ac553dc1b0401ffb2ea978a53fa881a | 0 | 185582106856438475936376 |
| 0x23f5a668a9590130940ef55964ead9787976f2cc | 151471522941039540899146 | 0xf7401728edd23290d8099ed73f155101dcf8cc0c | false | 30 | 20458935 | 0x8c76a73693a52e8eb35fb0234e5ec74152540378 | 2024-08-05T00:59:35.000Z | 0x880c2b7af600b9ae431d1ad13ef1fc6a48cf1248eb52490c279d993ea07efa98 | 14170158472357172802 | 121334022674186742947093 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LendingController_Liquidate_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingController\_RemoveCollateral\_event
Collateral withdrawal events from Curve V1 lending markets on Ethereum, tracking user addresses, collateral amounts decreased (in wei), and controller contract addresses. Used for analyzing borrower deleveraging activity and collateral management patterns across Curve lending pools.
| Column | Type | Description |
| ------------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_collateral_decrease` | `STRING` | Amount of collateral removed from the user's position. Integer value representing the decrease in collateral denominated in the smallest unit of the collateral token. |
| address | in\_user | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_collateral\_decrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 0xaade9230aa9161880e13a38c83400d3d1995267b | 0xaae2957078351c5b2fa93774329ceba4f4270011 | false | 143 | 20237960 | 2024-07-05T04:36:47.000Z | 0xe887679237241d12514b2e7c94d707f408d12cc1cc6da06f18a99dc59ff5e1a1 | 200000000000000000 |
| 0xeda215b7666936ded834f76f3fbc6f323295110a | 0x7ee071e15c13f365836fd7e8f6dcd34e3f4eda88 | false | 462 | 20238992 | 2024-07-05T08:04:23.000Z | 0x46c9290e0a1318834a375f19e4cd899f65da16d4936b4a683cb6d5f7ca3b2d9d | 50000000000000000000000 |
| 0xeda215b7666936ded834f76f3fbc6f323295110a | 0x7ee071e15c13f365836fd7e8f6dcd34e3f4eda88 | false | 86 | 20239000 | 2024-07-05T08:05:59.000Z | 0xb0a302fa59c0645fcad7d12e18f76225fbfda3b0128156ac1662e9861c957d35 | 55000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LendingController_RemoveCollateral_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingController\_Repay\_event
Loan repayment events from Curve v1 lending markets on Ethereum, tracking debt reduction and collateral withdrawals by borrower address. Used for analyzing deleveraging activity and loan repayment patterns across Curve's lending controller contracts.
| 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_collateral_decrease` | `STRING` | Amount of collateral removed from the user's position. Integer value representing the decrease in collateral denominated in the smallest unit of the collateral token. |
| `in_loan_decrease` | `STRING` | Amount of loan debt repaid by the user in the transaction, denominated in the smallest unit of the borrowed token. Values are positive integers representing wei-equivalent amounts for the loan asset being reduced. |
| address | in\_user | removed | log\_index | block\_number | block\_timestamp | in\_loan\_decrease | transaction\_hash | in\_collateral\_decrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ | ------------------------ |
| 0xeda215b7666936ded834f76f3fbc6f323295110a | 0x7a16ff8270133f063aab6c9977183d9e72835428 | false | 238 | 19457011 | 2024-03-17T20:42:59.000Z | 7760979491218658850333 | 0xaf4b56ee2fbab387fb75afd60e6fb9ea9f335bbbdcfbfdb0c1c9b299be9a0f48 | 0 |
| 0xeda215b7666936ded834f76f3fbc6f323295110a | 0x7a16ff8270133f063aab6c9977183d9e72835428 | false | 481 | 19451132 | 2024-03-17T00:53:11.000Z | 2700157800149494997649 | 0xeac5ee00fdf8c5d75a7e2785f8257944f8d95ba0a77225df32cf881f346e7c9a | 0 |
| 0xeda215b7666936ded834f76f3fbc6f323295110a | 0xb56cc4efa8795d2a5ffccba30951364b15a15a6b | false | 165 | 19453082 | 2024-03-17T07:28:23.000Z | 1144324498044936973170 | 0x1f9cb3e77eeea4a8bf802ab228bb44131980a4fd019a343da5137dd7a84a9924 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LendingController_Repay_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingController\_SetBorrowingDiscounts\_event
*No description available.*
| Column | Type | Description |
| ------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_loan_discount` | `STRING` | - |
| `in_liquidation_discount` | `STRING` | Discount rate applied during liquidation of collateral. Numeric string representation in basis points or decimal format with 18 decimal precision. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LendingController_SetBorrowingDiscounts_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingController\_SetMonetaryPolicy\_event
Event logs capturing monetary policy contract updates for Curve v1 lending markets on Ethereum. Records when lending controllers change their interest rate policy modules, useful for tracking governance changes and rate mechanism evolution across different Curve lending pools.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_monetary_policy` | `STRING` | Contract address of the monetary policy contract that governs interest rate calculations. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_monetary\_policy |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x5756a035f276a8095a922931f224f4ed06149608 | false | 189 | 20086177 | 2024-06-13T23:29:47.000Z | 0xe8f7d79f27022ec8031d9b2bf65658d4e9d55658b3c8aa1c027e3da6f5ad9ede | 0xbc7507bea8d7bcb49f511cf59651b5114e6e7667 |
| 0x23f5a668a9590130940ef55964ead9787976f2cc | false | 260 | 20086180 | 2024-06-13T23:30:23.000Z | 0x10dd0e32c5c688a03aa880691f7351fd1e54790f1589d194663d67d030e07339 | 0x627bb157ebc0b77ad9f990dd2ad75878603abf08 |
| 0xb536fea3a01c95dd09932440ec802a75410139d6 | false | 348 | 20049735 | 2024-06-08T21:15:59.000Z | 0x88efb21bc50c7142321d8ac589a9b75dfe269e658c3593d0ed8edc21490584af | 0xf574cbebbd549273af82b42cd0230de9ea6efef7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LendingController_SetMonetaryPolicy_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingController\_UserState\_event
User position state changes in Curve v1 lending markets on Ethereum. Tracks collateral, debt, liquidation discount, and AMM band positions (n1/n2) for analyzing borrower health and liquidation risk.
| 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_collateral` | `STRING` | Contract address of the collateral asset or vault. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debt` | `STRING` | Amount of debt outstanding in the protocol position or vault. Numeric string representation in smallest token denomination. |
| `in_n1` | `STRING` | Starting price band index for the user's collateral position in the Curve lending automated market maker (AMM). Represents the lower bound of the liquidation range, where collateral begins conversion to debt token. |
| `in_n2` | `STRING` | Lower band index of the user's collateral position in Curve's Lending Controller AMM. Represents the ending band of the price range where collateral is deposited. |
| `in_liquidation_discount` | `STRING` | Discount rate applied during liquidation of collateral. Numeric string representation in basis points or decimal format with 18 decimal precision. |
| in\_n1 | in\_n2 | address | in\_debt | in\_user | removed | log\_index | block\_number | in\_collateral | block\_timestamp | transaction\_hash | in\_liquidation\_discount |
| ------ | ------ | ------------------------------------------ | ------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ----------------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 5 | 14 | 0x09dbdeb3b301a4753589ac6df8a178c7716ce16b | 80752379828016783392619 | 0x038201e05d140124952e34e31665420489288338 | false | 217 | 19986031 | 93000000000000000000000 | 2024-05-30T23:47:47.000Z | 0x398451b7670411d06f7529168d8cd470bebc8e4f9ff10a52a4f512486677fed1 | 300000000000000000 |
| 6 | 15 | 0xcad85b7fe52b1939dceebee9bcf0b2a5aa0ce617 | 50000000000000000000000 | 0x7aeedccd91e4470aad39faa7535faaa43dc9ea43 | false | 216 | 19979457 | 97844828 | 2024-05-30T01:42:59.000Z | 0x740d9dfd4b99541b8eb329b79fd6d398ef717df1d913a955b7520a93b4e2539b | 35000000000000004 |
| 13 | 16 | 0xaade9230aa9161880e13a38c83400d3d1995267b | 220034339855200830531102 | 0x7a955509f37bbe9c65dfba0d37d2212208241992 | false | 361 | 19981064 | 72517327668477255223 | 2024-05-30T07:06:23.000Z | 0xee99e6ca3bab81ae77fe88756e0a1a0eeddabc2a4890b1163274eea5f883e494 | 40000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.LendingController_UserState_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MetapoolFactory\_BasePoolAdded\_event
Events emitted when base pools are registered to Curve's Metapool Factory contract on Ethereum, tracking which base pools can be used for creating new metapools. Used for monitoring factory configuration changes and identifying available base pool options for liquidity providers.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_base_pool` | `STRING` | Contract address of the base pool used in the metapool architecture. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | in\_base\_pool | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | false | 26 | 15038268 | 0xdcef968d416a41cdac0ed8702fac8128a64241a2 | 2022-06-28T06:05:22.000Z | 0x7396aaa9548e8b67e85d9c39bac86becdd0f6bcb80d2f1764e0b8ade13cf33e6 |
| 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | false | 220 | 12904585 | 0x7fc77b5c7614e1533320ea6ddc2eb61fa00a9714 | 2021-07-26T22:55:31.000Z | 0xcb6be4a26a2c224a32bad4fc9ba88652be0235dc82d57bfac7248725421db5de |
| 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | false | 213 | 12904539 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 2021-07-26T22:46:43.000Z | 0xedfeb49642fb5c9f2220bbf3eddca5a3ef50a68713b8cdeceef602880ab7974f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.MetapoolFactory_BasePoolAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MetapoolFactory\_deploy\_metapool\_function
Metapool deployment events from Curve Finance's MetapoolFactory contract on Ethereum, capturing new pool creation with parameters including amplification coefficient (A), fees, base pool references, and token addresses. Used for tracking Curve pool launches and analyzing liquidity pool deployment patterns.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__base_pool` | `STRING` | Contract address of the base pool used in the Curve metapool deployment. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `in__coin` | `STRING` | Contract address of the token being added to the Curve metapool. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__A` | `STRING` | Amplification coefficient parameter for the Curve pool being deployed. Numeric string representing the A parameter that controls the curve's shape and slippage characteristics. |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_\_A | value | status | in\_\_fee | gas\_used | in\_\_coin | in\_\_name | out\_anon0 | signature | in\_\_symbol | to\_address | block\_number | from\_address | in\_\_base\_pool | trace\_address | block\_timestamp | transaction\_hash |
| ------- | ------- | ----- | ------ | --------- | --------- | ------------------------------------------ | ------------ | ------------------------------------------ | ---------- | ------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 1172301 | 200 | 0 | true | 4000000 | 781534 | 0xab5eb14c09d416f0ac63661e57edb7aecdb9befa | msUSD/FRAXBP | 0xc3b19502f8c02be75f3f77fd673503520deb51dd | 0xe339eb4f | msUSDFRAX | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 16371483 | 0x421af9abc87197a917b87f8d2b2d8b0213d47dbe | 0xdcef968d416a41cdac0ed8702fac8128a64241a2 | | 2023-01-09T19:58:11.000Z | 0xfbaf92625a9e9e626730b435128f66b76026db699f943faf035f4e8971933e86 |
| 830628 | 50 | 0 | true | 4000000 | 830628 | 0x238533e6674c798fe00cb21cfd127c002b5bfcf1 | US/3CRV | 0xe82805a9b880e6dc520b6f017537f7781d55217f | 0xe339eb4f | US | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 15763700 | 0x830bfab6ddab79f4ae6e845a2b30a28bc5b8cda4 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | | 2022-10-16T22:37:11.000Z | 0x0caf8287a39f5609b610f87d2549a90fd5d109b78741828c8575ed8c6ce1c338 |
| 762252 | 50 | 0 | true | 4000000 | 762252 | 0x1b78ba1d8c437c9699af08a8d4fb63af2930c310 | BLARG | 0xa77b5d170f3aec2f72ca06490a7b9383a70ae5eb | 0xe339eb4f | BLARG | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 15856909 | 0x830bfab6ddab79f4ae6e845a2b30a28bc5b8cda4 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | | 2022-10-29T23:11:23.000Z | 0x00f1d673d3d6e4bf0f95cc9db7d99504174cf1f3acbab65c19607e0f6c23b166 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.MetapoolFactory_deploy_metapool_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MetapoolFactory\_deploy\_metapool2\_function
Function calls to deploy new Curve metapools on Ethereum, capturing pool configuration parameters including amplification coefficient (A), fee rates, base pool references, and coin addresses. Used for analyzing Curve liquidity pool creation activity and factory deployment patterns.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__base_pool` | `STRING` | Contract address of the base pool used in the Curve metapool deployment. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `in__coin` | `STRING` | Contract address of the token being added to the Curve metapool. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__A` | `STRING` | Amplification coefficient parameter for the Curve pool being deployed. Numeric string representing the A parameter that controls the curve's shape and slippage characteristics. |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| `in__implementation_idx` | `STRING` | Index identifying which pool implementation contract to use for deployment. Numeric string representing the implementation version selector. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_\_A | value | status | in\_\_fee | gas\_used | in\_\_coin | in\_\_name | out\_anon0 | signature | in\_\_symbol | to\_address | block\_number | from\_address | in\_\_base\_pool | trace\_address | block\_timestamp | transaction\_hash | in\_\_implementation\_idx |
| ------- | ------- | ----- | ------ | --------- | --------- | ------------------------------------------ | ------------------------------------------------------------------ | ---------- | ---------- | ------------------------------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 8500000 | 800 | 0 | false | 4000000 | 24593 | 0x94a18d9fe00bab617fad8b49b11e9f1f64db6b36 | 0x334352562f6c76555344 | | 0xde7fe3bf | 0x334352566c76555344 | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 16550493 | 0x95622e85962bc154c76ab24e48fdf6cdaedad6e5 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | | 2023-02-03T19:57:47.000Z | 0x1cdd11d82b8f993d8b1ab3d89a4183934baa23da712b37aee6e9495e6bf2638a | 0 |
| 1239355 | 800 | 0 | false | 4000000 | 26124 | 0x94a18d9fe00bab617fad8b49b11e9f1f64db6b36 | 0x334352562f6c7655534400000000000000000000000000000000000000000000 | | 0xde7fe3bf | 0x334352566c765553440000000000000000000000000000000000000000000000 | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 16550470 | 0x95622e85962bc154c76ab24e48fdf6cdaedad6e5 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | | 2023-02-03T19:53:11.000Z | 0x213df51061db9f0f03527ca2344839d814ca20183cff732af48c71b6808d5aa0 | 0 |
| 28500 | 800 | 0 | false | 4000000 | 26124 | 0x94a18d9fe00bab617fad8b49b11e9f1f64db6b36 | 0x334352562f6c7655534400000000000000000000000000000000000000000000 | | 0xde7fe3bf | 0x334352566c765553440000000000000000000000000000000000000000000000 | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 16550441 | 0x67f45e3c37677ec76ffbaf4b7be73b9e937a611c | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | | 2023-02-03T19:47:23.000Z | 0xff8d02f4b323dd9e071429d2377d7e30707ffc5b35290921bdbdcf85d5ad4f6f | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.MetapoolFactory_deploy_metapool2_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MetapoolFactory\_deploy\_plain\_pool\_function
Factory deployment records for Curve V1 plain pools on Ethereum, capturing pool creation parameters including coin pairs, amplification coefficient (A), fees, and resulting pool addresses. Used for tracking liquidity pool launches and analyzing Curve protocol expansion.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `in__coins` | `ARRAY` | Array of token contract addresses being added to the Curve liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts. |
| `in__A` | `STRING` | Amplification coefficient parameter for the Curve pool being deployed. Numeric string representing the A parameter that controls the curve's shape and slippage characteristics. |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_\_A | value | status | in\_\_fee | gas\_used | in\_\_name | in\_\_coins | out\_anon0 | signature | in\_\_symbol | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------- | ------- | ----- | ------ | --------- | --------- | ------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ---------- | ------------ | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 1093363 | 50 | 0 | true | 30000000 | 728909 | CLever clevCVX-CVX | \["0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b","0xf05e58fcea29ab4da01a495140b349f8410ba904","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0x63a1ec86cd45425f1409fabe4c1cf8c5fd32a3b1 | 0xcd419bb5 | clevCVX | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 15707682 | 0x38a93e70b0d8343657f802c1c3fdb06ac8f8fe99 | | 2022-10-09T02:53:59.000Z | 0x43f5b134bb0c6df735bbb2a779e0ac087476b34a8550b43d1dc2939cfd6b58c7 |
| 842753 | 100 | 0 | true | 4000000 | 796141 | ibEUR/sEUR | \["0x96e61422b6a9ba0e068b6c5add4ffabc6a4aae27","0x57ab1ec28d129707052df4df418d58a2d46d5f51","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0x1f71f05cf491595652378fe94b7820344a551b8e | 0xcd419bb5 | ibEUR+sEUR | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 12913531 | 0xb424338eaa86953d82b5fabf042ce2eac544c043 | 0,0 | 2021-07-28T09:00:49.000Z | 0x024843f829ec485c27acb115f94d5374c19f14301ceb62353f79b772de74b871 |
| 1166443 | 50 | 0 | true | 30000000 | 777629 | TCLever test | \["0x1ee4de3cd1505ddb2e60c20651a4ab7ffabdc8f6","0x246be97fda42375c39e21377ad80d8290afdb994","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0xd0e24cb3e766581952dbf258b78e89c63a37f5fb | 0xcd419bb5 | tclevCVX | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 15721763 | 0x38a93e70b0d8343657f802c1c3fdb06ac8f8fe99 | | 2022-10-11T02:04:23.000Z | 0x6f9223d991fa3620d7295f5c7e96581bbbfcd6eb03054ebd85ed3b1d06472217 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.MetapoolFactory_deploy_plain_pool_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MetapoolFactory\_deploy\_plain\_pool2\_function
Plain pool deployment transactions from Curve's MetapoolFactory contract on Ethereum. Records pool creation parameters including amplification coefficient (A), fees, coin addresses, and resulting pool addresses for tracking new liquidity pool launches.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `in__coins` | `ARRAY` | Array of token contract addresses being added to the Curve liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts. |
| `in__A` | `STRING` | Amplification coefficient parameter for the Curve pool being deployed. Numeric string representing the A parameter that controls the curve's shape and slippage characteristics. |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| `in__asset_type` | `STRING` | Asset type identifier for the tokens in the pool, where values like '3' indicate specific Curve token standards (e.g., ERC-20, rebasing, or other asset categories). This parameter determines how the pool handles token accounting and pricing. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_\_A | value | status | in\_\_fee | gas\_used | in\_\_name | in\_\_coins | out\_anon0 | signature | in\_\_symbol | to\_address | block\_number | from\_address | trace\_address | in\_\_asset\_type | block\_timestamp | transaction\_hash |
| ------- | ------- | ----- | ------ | --------- | --------- | ------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ---------- | ------------ | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ----------------- | ------------------------ | ------------------------------------------------------------------ |
| 1172085 | 20 | 0 | true | 4000000 | 781390 | pitchFXS/FXS | \["0x11ebe21e9d7bf541a18e1e3ac94939018ce88f0b","0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0x0ad66fec8db84f8a3365ada04ab23ce607ac6e24 | 0x5c16487b | pitchFXS | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 16200379 | 0x092308e1dcdeca61bf1153dd92e15ed08e164982 | | 3 | 2022-12-16T22:56:47.000Z | 0xcf98501f3158251d2659c556f74e3429fbee4671d8b443269707550481f8d915 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.MetapoolFactory_deploy_plain_pool2_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MetapoolFactory\_deploy\_plain\_pool3\_function
Pool deployment transactions from Curve V1's MetapoolFactory contract on Ethereum. Captures the creation parameters (A parameter, fees, coins) and resulting pool addresses for analyzing factory-deployed liquidity pools and their configuration patterns.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `in__coins` | `ARRAY` | Array of token contract addresses being added to the Curve liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts. |
| `in__A` | `STRING` | Amplification coefficient parameter for the Curve pool being deployed. Numeric string representing the A parameter that controls the curve's shape and slippage characteristics. |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| `in__asset_type` | `STRING` | Asset type identifier for the pool being deployed, where 0 indicates standard tokens and higher values represent specialized asset types like LP tokens or other derivatives. Numeric string parameter passed to the MetapoolFactory contract during pool creation. |
| `in__implementation_idx` | `STRING` | Index identifying which pool implementation contract to use for deployment. Numeric string representing the implementation version selector. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_\_A | value | status | in\_\_fee | gas\_used | in\_\_name | in\_\_coins | out\_anon0 | signature | in\_\_symbol | to\_address | block\_number | from\_address | trace\_address | in\_\_asset\_type | block\_timestamp | transaction\_hash | in\_\_implementation\_idx |
| ------- | ------- | ----- | ------ | --------- | --------- | ------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ---------- | ------------ | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ----------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 923514 | 50 | 0 | true | 15000000 | 839559 | yCRV | \["0xd533a949740bb3306d119cc777fa900ba034cd52","0xfcc5c47be19d06bf83eb04298b026f81069ff65b","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0x99f5acc8ec2da2bc0771c32814eff52b712de1e5 | 0x52f2db69 | yCRV | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 16775458 | 0x0b634a8d61b09820e9f72f79cdcbc8a4d0aad26b | | 3 | 2023-03-07T09:12:23.000Z | 0x3d195146fab4ddd5096a4f0fb26740abe157961bba5ed0e45e68d7bdaa71dbc7 | 4 |
| 1101119 | 500 | 0 | true | 4000000 | 847015 | crvUSD/thUSD | \["0xa10a5e2d813a51374592d6ce440b149f01cf9a7d","0xf939e0a03fb07f59a73314e73794be0e57ac1b4e","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0xe547725ffe16b2fc61aa5adab5b2860ffda0008d | 0x52f2db69 | crvUSDthUS | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 18289708 | 0xd1196903054dd9e5a255764b6797cc95a4fb8a51 | | 0 | 2023-10-06T06:35:11.000Z | 0x7143c0f0e2cc9d40000aa6ba1e6fea33a8935cbcd73b135168e1336742be86b7 | 4 |
| 754456 | 40 | 0 | true | 29400000 | 754456 | Stax Frax/Temple xLP + LP | \["0xbcb8b7fc9197feda75c101fa69d3211b5a30dcd9","0x6021444f1706f15465bee85463bcc7d7cc17fc03","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0xdadfd00a2bbeb1abc4936b1644a3033e1b653228 | 0x52f2db69 | xFraxTplLP | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 14887899 | 0xb1e8ab0a81aadf632a653e46caeda1593d71d143 | | 3 | 2022-06-02T00:23:50.000Z | 0x279b75d00f40f8f15f7144dbd4baaf2eccb7bbb6110f13e493f1037d7a5cc5ec | 3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.MetapoolFactory_deploy_plain_pool3_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MetapoolFactory\_MetaPoolDeployed\_event
Curve Finance metapool deployment events on Ethereum, capturing when new liquidity pools are created through the factory contract with parameters including amplification coefficient (in\_A), fee rates, paired token addresses, and base pool references. Used for tracking pool creation activity and analyzing Curve's expanding ecosystem of stablecoin and pegged asset liquidity pools.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_coin` | `STRING` | Contract address of the token used in the metapool deployment. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_base_pool` | `STRING` | Contract address of the base pool used in the metapool architecture. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_A` | `STRING` | Amplification coefficient parameter used in Curve's StableSwap invariant algorithm. String-encoded integer value that controls the concentration of liquidity around the target price. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_deployer` | `STRING` | Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_A | in\_fee | address | in\_coin | removed | log\_index | in\_deployer | block\_number | in\_base\_pool | block\_timestamp | transaction\_hash |
| ----- | -------- | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 100 | 4000000 | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 0x7945b0a6674b175695e5d1d08ae1e6f13744abb0 | false | 219 | 0xab0c9bc6bcbaad9391c530f33f9294dec38ae189 | 14138164 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 2022-02-04T07:25:37.000Z | 0xdd26168ac8b02465ccd038040caf7d1b99a4e41db8675f6708f6b62468bba669 |
| 10 | 18000000 | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 0x8b921e618dd3fa5a199b0a8b7901f5530d74ef27 | false | 114 | 0x86c9df620fe941024beaf6e1bb36234f8c928b7b | 13393925 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 2021-10-10T23:46:11.000Z | 0x28594bc90429f6cc926fe2fadfc66ae68a38db1993f0980ff80ca709be7fea4f |
| 200 | 4000000 | 0xb9fc157394af804a3578134a6585c0dc9cc990d4 | 0xc22956c3cfec3ee9a9925abee044f05bc47f6632 | false | 279 | 0xc15dd9f11a885b8515ac64de9154d18ad7727bb0 | 15946543 | 0xdcef968d416a41cdac0ed8702fac8128a64241a2 | 2022-11-11T11:41:23.000Z | 0x477cf53afc9eabeea2d11efd9c96d5197acecc0269b44481402dd9399d121662 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.MetapoolFactory_MetaPoolDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### OneWayLendingFactory\_NewVault\_event
New vault deployment events from Curve v1's OneWayLendingFactory on Ethereum, capturing lending market creation with collateral token, borrowed token, controller, AMM (Automated Market Maker), oracle, and monetary policy addresses for tracking isolated lending pairs.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_collateral_token` | `STRING` | Contract address of the token accepted as collateral in this Curve lending vault. Hex-encoded Ethereum address identifying the ERC-20 token that borrowers deposit to secure their loans. |
| `in_borrowed_token` | `STRING` | Contract address of the token that can be borrowed from this Curve lending vault. Typically a stablecoin like crvUSD (0xf939e...) or wrapped ETH on Ethereum. |
| `in_vault` | `STRING` | Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_controller` | `STRING` | Contract address of the controller managing the lending market for this vault. The controller handles collateral deposits, loan origination, and liquidation logic for the Curve lending position. |
| `in_amm` | `STRING` | Contract address of the automated market maker (AMM). Hex-encoded, 0x-prefixed, 42-character string. |
| `in_price_oracle` | `STRING` | Contract address of the price oracle used to determine collateral valuations for this lending vault. This oracle provides real-time price feeds for calculating loan-to-value ratios and liquidation thresholds. |
| `in_monetary_policy` | `STRING` | Contract address of the monetary policy contract that governs interest rate calculations. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_id | in\_amm | address | removed | in\_vault | log\_index | block\_number | in\_controller | block\_timestamp | in\_price\_oracle | transaction\_hash | in\_borrowed\_token | in\_monetary\_policy | in\_collateral\_token |
| ------ | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 5 | 0x08ba6d7c10d1a7850ae938543bfbea7c0240f9cf | 0xea6876dde9e3467564acbee1ed5bac88783205e0 | false | 0x46196c004de85c7a75c8b1bb9d54afb0f8654a45 | 209 | 19468672 | 0xa5d9137d2a1ee912469d911a8e74b6c77503bac8 | 2024-03-19T12:03:47.000Z | 0x4f4b897871902d05cba110b8e892498f12a20443 | 0xd24aa77725acd470c95839a58d954e123a0ae5009689d3313329ef704dabae25 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xbdb065458d34db77d1fb2862d367edd8275f8352 | 0xf939e0a03fb07f59a73314e73794be0e57ac1b4e |
| 6 | 0xfcb53ed72dab68091aa6a2ab68b5116639ed8805 | 0xea6876dde9e3467564acbee1ed5bac88783205e0 | false | 0x99cff9dc26a44dc2496b4448ebe415b5e894bd30 | 260 | 19468701 | 0xe438658874b0acf4d81c24172e137f0ee00621b8 | 2024-03-19T12:09:35.000Z | 0x33a95b2121fd4ec89d9fa6c5fd21545270bc06a6 | 0x6e81d013cf84e128f805070f2bd279e868c14580e0a67685df8a1163a6b15133 | 0x18084fba666a33d37592fa2633fd49a74dd93a88 | 0x62cd08cadabf473315d8953995de0dc0928b7d3c | 0xf939e0a03fb07f59a73314e73794be0e57ac1b4e |
| 10 | 0xcd28cf8f7755f03967d27e128b38022b63919836 | 0xea6876dde9e3467564acbee1ed5bac88783205e0 | false | 0xff467c6e827ebbea64da1ab0425021e6c89fbe0d | 246 | 19801071 | 0x4f87158350c296955966059c50263f711ce0817c | 2024-05-05T02:59:47.000Z | 0xb08eb288c57a37bc82238168ad96e15975602cd9 | 0x3e98eb136312b49bda28069131cca2e2f6acd428c65c34a3672d81b92543f328 | 0xf939e0a03fb07f59a73314e73794be0e57ac1b4e | 0x2e478df674e25b2724b1ac9bcaba644943da359f | 0xd9a442856c234a39a81a089c06451ebaa4306a72 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.OneWayLendingFactory_NewVault_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### PoolRegistry\_PoolAdded\_event
Pool registration events from Curve v1's PoolRegistry contract on Ethereum, capturing when new liquidity pools are added to the registry. Used for tracking pool deployment history and registry coverage across the Curve protocol.
| 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_rate_method_id` | `STRING` | Method identifier for the rate calculation function used by the pool, represented as a 4-byte hex-encoded selector. Typically '0x00000000' when no custom rate method is specified. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_rate\_method\_id |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- |
| 0x90e00ace148ca3b23ac1bc8c240c2a7dd9c2d7f5 | 0xf253f83aca21aabd2a20553ae0bf7f65c755a07f | false | 301 | 16100183 | 2022-12-02T22:43:47.000Z | 0x2d7253c5616e865810fdd37876504f83249c6be62cfd21a60d9ff33238fcf500 | 0x00000000 |
| 0x90e00ace148ca3b23ac1bc8c240c2a7dd9c2d7f5 | 0xdcef968d416a41cdac0ed8702fac8128a64241a2 | false | 99 | 14967642 | 2022-06-15T13:08:03.000Z | 0xfb48b7ab14629aece9b6692497e5a1555548088d42eee96990097ca73fabf95f | 0x00000000 |
| 0x90e00ace148ca3b23ac1bc8c240c2a7dd9c2d7f5 | 0xae34574ac03a15cd58a92dc79de7b1a0800f1ce3 | false | 174 | 16832765 | 2023-03-15T10:40:11.000Z | 0x68d752589a7e0904cc2067f6b0433c0857a55b951e30b50930ecf53a771e9367 | 0x00000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.PoolRegistry_PoolAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_A\_function
Amplification coefficient (A parameter) query results from Curve V1 stablecoin pools on Ethereum, tracking the stability parameter that controls slippage in StableSwap AMM pools. Used for monitoring pool configuration changes and analyzing liquidity dynamics across Curve's stablecoin trading pairs.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 116992 | | true | 1917 | 200 | 0xf446c1d0 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 11285343 | 0x27b3d082f448976820f709b14bf03db98f6f2a0b | 5 | 2020-11-19T01:10:59.000Z | 0x418715c676c59412f70eca7dadf4bb4cf5a8617a56639da5eef2bcb99ac89ecf |
| 166809 | | true | 1917 | 200 | 0xf446c1d0 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 11287022 | 0x27b3d082f448976820f709b14bf03db98f6f2a0b | 0,2,0,4,1,1 | 2020-11-19T07:20:00.000Z | 0x3c96385b172486eb53443f1015b00a37e208f4b0b66b1cd1280d5919ef22e47f |
| 168879 | | true | 1917 | 200 | 0xf446c1d0 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 11285343 | 0x27b3d082f448976820f709b14bf03db98f6f2a0b | 0 | 2020-11-19T01:10:59.000Z | 0x418715c676c59412f70eca7dadf4bb4cf5a8617a56639da5eef2bcb99ac89ecf |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_A_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_AddLiquidity\_event
Liquidity deposit events from Curve V1 stablecoin pools on Ethereum, capturing token amounts added, provider addresses, fees charged, and resulting pool invariant and LP token supply. Used for analyzing liquidity provision patterns, fee generation, and pool composition changes over time.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token_amounts` | `ARRAY` | Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination. |
| `in_fees` | `ARRAY` | Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination. |
| `in_invariant` | `STRING` | Invariant value of the Curve pool after the liquidity operation. Numeric string representation in smallest token denomination. |
| `in_token_supply` | `STRING` | Total supply of liquidity pool tokens after the operation. Numeric string representation in smallest token denomination. |
| address | in\_fees | removed | log\_index | in\_provider | block\_number | in\_invariant | block\_timestamp | in\_token\_supply | in\_token\_amounts | transaction\_hash |
| ------------------------------------------ | ---------------------------------------------- | ------- | ---------- | ------------------------------------------ | ------------- | -------------------------- | ------------------------ | -------------------------- | -------------------------------- | ------------------------------------------------------------------ |
| 0xdc24316b9ae028f1497c275eb9192a3ea0f67022 | \["1993846047790112","2002659562017157"] | false | 333 | 0x0291eb432cb4a2613a7415018933e3db45bcd769 | 15622404 | 1253332782757677233561313 | 2022-09-27T04:47:35.000Z | 1191594512072606617315160 | \["18000000000000000000","0"] | 0x13e945812f3e32a0c3932c6ec52af76f1cd91cef64d57b8f7a7efca9f3663841 |
| 0xdc24316b9ae028f1497c275eb9192a3ea0f67022 | \["2126886690839557","2136293857418806"] | false | 239 | 0x0291eb432cb4a2613a7415018933e3db45bcd769 | 15622277 | 1253312702843590191937480 | 2022-09-27T04:21:47.000Z | 1191575453145086799427276 | \["19200000000000000000","0"] | 0x7c5b5c41c2749c88332a799c4a381c255eaadff65dac3c9e3190139bc63f7bb8 |
| 0x04b727c7e246ca70d496ecf52e6b6280f3c8077d | \["3443800491259715346","3441418787431116645"] | false | 123 | 0x08780fb7e580e492c1935bee4fa5920b94aa95da | 15622458 | 12764732864986214457332188 | 2022-09-27T04:58:23.000Z | 12745535400419281009430585 | \["0","34452685788316967288309"] | 0x12b131b5f569afca466c6be6039c386f0097ce4de4add3b7207bd19b3c234567 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_AddLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_balances\_function
Function call traces querying individual token balances within Curve V1 stablecoin pools on Ethereum. Returns the token amount for a specified pool position index, used for monitoring pool composition and calculating total value locked.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_arg0` | `STRING` | Index of the token in the Curve StablePool for which the balance is being queried. Typically '0' for the first token in the pool, with sequential integers for additional tokens. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | in\_arg0 | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | -------- | --------- | -------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 470178 | | true | 0 | 3615 | 90937557738649 | 0x4903b0d1 | 0xd51a44d3fae010294c616388b506acda1bfaae46 | 15241638 | 0xbeefbabeea323f07c59926295205d3b7a17e8638 | 0 | 2022-07-30T04:12:54.000Z | 0xf81d2b0477a397cdf905aa83d9b8dfc91d658692e010c82275fb7a1a68fb17f4 |
| 476208 | | true | 0 | 3615 | 90658024379759 | 0x4903b0d1 | 0xd51a44d3fae010294c616388b506acda1bfaae46 | 15243256 | 0xbeefbabeea323f07c59926295205d3b7a17e8638 | 0 | 2022-07-30T10:31:15.000Z | 0xd79b506c18b9dfbc972ca8ad94a09dd2ae4d039ef213a4b521693aa8a23ffcfd |
| 482664 | | true | 0 | 3615 | 91021529341506 | 0x4903b0d1 | 0xd51a44d3fae010294c616388b506acda1bfaae46 | 15242007 | 0xbeefbabeea323f07c59926295205d3b7a17e8638 | 0 | 2022-07-30T05:42:44.000Z | 0xe8d8d2a69a1cdf0c7ac6d5ae44e7592b425d35877b2b4e525685d6cadbbd77d8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_balances_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_remove\_liquidity\_one\_coin\_function
Single-asset liquidity removals from Curve V1 stablecoin pools on Ethereum, recording LP token burns and output token amounts. Used to analyze withdrawal patterns, slippage tolerance, and pool exit behavior from Curve's automated market maker (AMM) liquidity pools.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__burn_amount` | `STRING` | Amount of LP tokens being burned and removed from the liquidity pool. Specified in the pool's smallest denomination (wei-equivalent), representing the user's share of the pool being withdrawn. |
| `in_i` | `STRING` | Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value. |
| `in__min_received` | `STRING` | Minimum amount of the selected token that the user is willing to receive when burning LP tokens. Specified in the token's smallest unit (wei for ETH-like tokens) as slippage protection. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_i | value | status | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_\_burn\_amount | in\_\_min\_received | transaction\_hash |
| ------ | ----- | ----- | ------ | --------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ---------------------- | ---------------------- | ------------------------------------------------------------------ |
| 155386 | 0 | 0 | true | 85982 | 1000293552763183938 | 0x1a4d01d2 | 0xc4c319e2d4d66cca4464c0c2b32c9bd23ebe784e | 13311719 | 0xf872703f1c8f93fa186869bac83bac5a0c87c3c8 | | 2021-09-28T02:55:02.000Z | 1000000000000100000 | 998097299453723853 | 0x59d1a0ea0135fd79581a5e135d6bac6860474c7d9c2a7edd64c6cbe705c42a7f |
| 155420 | 0 | 0 | true | 86001 | 500679667213414432828 | 0x1a4d01d2 | 0xc4c319e2d4d66cca4464c0c2b32c9bd23ebe784e | 13313701 | 0xe954d86ced76843af8c3dd5ee355e79711ade218 | | 2021-09-28T10:23:30.000Z | 500609493444657419058 | 500079451828143606335 | 0xba5609408b29c8978b305fbe3869a60976113dce93a6ca250bf30bd42c120518 |
| 162329 | 1 | 0 | true | 89888 | 8063108850147201815242 | 0x1a4d01d2 | 0x9d0464996170c6b9e75eed71c68b99ddedf279e8 | 13316747 | 0x1424a2485d4f89c8d8d84b7809bd23995f2abd26 | | 2021-09-28T21:50:39.000Z | 8000000000000000000000 | 8040979559390809794273 | 0x0d1fbdaff2459464ccb86bdfd9205eb6b6a656eed99e5916ea0af623bc1e0284 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_remove_liquidity_one_coin_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_remove\_liquidity\_one\_coin2\_function
Curve V1 stableswap pool single-sided liquidity removal function calls on Ethereum, tracking LP token burns and received asset amounts by coin index. Used for analyzing withdrawal patterns, slippage tolerance settings, and liquidity provider exit behavior across Curve stable pools.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__burn_amount` | `STRING` | Amount of Curve LP tokens to burn when removing single-sided liquidity from the pool. Represented as a wei-denominated integer string (18 decimals) indicating the quantity of pool shares destroyed in the withdrawal. |
| `in_i` | `STRING` | Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value. |
| `in__min_received` | `STRING` | Minimum amount of the selected token the user will accept to receive from burning LP tokens. Set to '0' when user accepts any slippage, or contains minimum expected token amount in wei-denominated string format. |
| `in__receiver` | `STRING` | Address of the account receiving the tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_i | value | status | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | in\_\_receiver | trace\_address | block\_timestamp | in\_\_burn\_amount | in\_\_min\_received | transaction\_hash |
| ------ | ----- | ----- | ------ | --------- | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | -------------- | ------------------------ | ----------------------- | --------------------- | ------------------------------------------------------------------ |
| 282475 | 0 | 0 | true | 163412 | 481878082747610037628 | 0x081579a5 | 0xd632f22692fac7611d2aa1c0d552930d43caed3b | 22608627 | 0xa79828df1850e8a3a3064576f380d90aecdd3359 | 0x8e99d4ecb0690b81c7eb818e1903023620d46aff | 1 | 2025-06-01T08:21:23.000Z | 473371803968815414251 | 481733519322785754617 | 0x22692f5ffd0062d18d0c8db5aa214037982b628b6e678177706fbc61e2a2b6b6 |
| 396494 | 1 | 0 | true | 162959 | 57678180249874075644902 | 0x081579a5 | 0x5a6a4d54456819380173272a5e8e9b9904bdf41b | 22609993 | 0xa79828df1850e8a3a3064576f380d90aecdd3359 | 0xa79828df1850e8a3a3064576f380d90aecdd3359 | 1 | 2025-06-01T12:56:59.000Z | 58953848173968589847959 | 0 | 0x6071d377f56a181f2e43daa86423fb04fb6279df503fe85201636083903f53ab |
| 435880 | 1 | 0 | true | 164041 | 73410442632675884729 | 0x081579a5 | 0xd632f22692fac7611d2aa1c0d552930d43caed3b | 22607710 | 0xa79828df1850e8a3a3064576f380d90aecdd3359 | 0xa79828df1850e8a3a3064576f380d90aecdd3359 | 1 | 2025-06-01T05:16:47.000Z | 75011474974975011909 | 0 | 0x4aa9bcd3be4489cfb9508c4e47c3334e0f826d48a4440680f8b9a5445ec1e518 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_remove_liquidity_one_coin2_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_RemoveLiquidity\_event
Liquidity withdrawal events from Curve V1 stablecoin pools on Ethereum, capturing token amounts removed, LP token supply changes, and fee distributions. Used for tracking liquidity provider exit activity and pool composition changes over time.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token_amounts` | `ARRAY` | Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination. |
| `in_fees` | `ARRAY` | Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination. |
| `in_token_supply` | `STRING` | Total supply of liquidity pool tokens after the operation. Numeric string representation in smallest token denomination. |
| address | in\_fees | removed | log\_index | in\_provider | block\_number | block\_timestamp | in\_token\_supply | in\_token\_amounts | transaction\_hash |
| ------------------------------------------ | ---------- | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------- | ---------------------------------------------- | ------------------------------------------------------------------ |
| 0xdc24316b9ae028f1497c275eb9192a3ea0f67022 | \["0","0"] | false | 13 | 0x6ce4c28af7d2b5faf77d3571de723f47e863b3d6 | 12856375 | 2021-07-19T10:04:21.000Z | 924121021625419408633279 | \["295802323663933797","304527305060736576"] | 0xcc3cf96bb3beffa80dda0ab4cea37479265f15406bf416afe740ea0e4fd0118e |
| 0xdc24316b9ae028f1497c275eb9192a3ea0f67022 | \["0","0"] | false | 284 | 0x76e70f8ab5191cd2abd723d3d910966d3fdb10f4 | 12855448 | 2021-07-19T06:31:46.000Z | 924120101685639860152906 | \["5546813794631588522","5710593268202857414"] | 0xe46206c62c9925969435d42cf668deb4c7b0ccb1b7f13b44cfd815746988f23f |
| 0xf178c0b5bb7e7abf4e12a4838c7b7c5ba2c623c0 | \["0","0"] | false | 152 | 0x8ec4d8191cd6f68a8c2cc0fc12b2ac0e7e0825c5 | 12855284 | 2021-07-19T05:59:05.000Z | 7633066896492204279320349 | \["5504186305668248621","2719927079247761443"] | 0x64f6f84d46fd1c281e6d9f3c775cf5c3a8badf526a340ba1563eba29466b794f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_RemoveLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_RemoveLiquidityImbalance\_event
Imbalanced liquidity removal events from Curve V1 StableSwap pools on Ethereum, recording when liquidity providers withdraw non-proportional amounts of pool tokens with associated fees and pool state changes. Useful for analyzing liquidity provider behavior, fee impacts, and pool composition changes during asymmetric withdrawals.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token_amounts` | `ARRAY` | Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination. |
| `in_fees` | `ARRAY` | Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination. |
| `in_invariant` | `STRING` | Invariant value of the Curve pool after the liquidity operation. Numeric string representation in smallest token denomination. |
| `in_token_supply` | `STRING` | Total supply of liquidity pool tokens after the operation. Numeric string representation in smallest token denomination. |
| address | in\_fees | removed | log\_index | in\_provider | block\_number | in\_invariant | block\_timestamp | in\_token\_supply | in\_token\_amounts | transaction\_hash |
| ------------------------------------------ | -------------------------------------------------- | ------- | ---------- | ------------------------------------------ | ------------- | ---------------------------- | ------------------------ | ---------------------------- | ---------------------------------- | ------------------------------------------------------------------ |
| 0x5a6a4d54456819380173272a5e8e9b9904bdf41b | \["115573466243606772412","113324077164977514591"] | false | 300 | 0xa79828df1850e8a3a3064576f380d90aecdd3359 | 13739354 | 2364982717987643376520430681 | 2021-12-04T10:40:35.000Z | 2356960811878106433982335671 | \["0","981692439737826024703688"] | 0x5bb474f1a6cd38badd8d5b05f85b0034d5c391bdb128f462463b2917ead59779 |
| 0x5a6a4d54456819380173272a5e8e9b9904bdf41b | \["935755718979587749924","917536543520735603991"] | false | 64 | 0xa79828df1850e8a3a3064576f380d90aecdd3359 | 13738229 | 2366873322172219836724957711 | 2021-12-04T06:16:51.000Z | 2358875462294603980126241245 | \["0","7877463210760546487062536"] | 0x678dbd29c4112406d75d4ec64974bb09f06fd0937fe2113474090e020767adb4 |
| 0x5a6a4d54456819380173272a5e8e9b9904bdf41b | \["9322166975772501940","9140827790289616075"] | false | 299 | 0xa79828df1850e8a3a3064576f380d90aecdd3359 | 13738116 | 2379919138160008734433059144 | 2021-12-04T05:49:24.000Z | 2371883415999587704593613961 | \["0","79341290005410405022433"] | 0x7b172481c81a7249b39b3d5e49644118dfd0ac35a1139e5ebd5cabcee6b0d8ad |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_RemoveLiquidityImbalance_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_TokenExchange\_event
Token swap events from Curve V1 stablecoin pools on Ethereum, capturing traded amounts, pool tokens involved, and buyer addresses. Used for analyzing DEX trading volumes, pool utilization, and price impact across Curve's stable swap liquidity pools.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | --------------------- | ------------------------ | ------------------ | ------------------------------------------------------------------ |
| 0xd51a44d3fae010294c616388b506acda1bfaae46 | false | 0x000000000dfde7deaf24138722987c9a6991e2d4 | 18 | 1 | 14669176 | 0 | 768013800 | 2022-04-27T22:36:48.000Z | 300435257107 | 0x34d55d6746a9b8d08e2f0d127353c920e45d27fa6d733cd653f573e77f9015ef |
| 0xd51a44d3fae010294c616388b506acda1bfaae46 | false | 0x000000000dfde7deaf24138722987c9a6991e2d4 | 58 | 2 | 14666946 | 0 | 105828020000000000000 | 2022-04-27T14:15:19.000Z | 300492538635 | 0x937329f7c0ad89e57149fb2e29ce10dd38e279c1ef1989e3aa0183ce41ab8ec7 |
| 0xd51a44d3fae010294c616388b506acda1bfaae46 | false | 0x000000000dfde7deaf24138722987c9a6991e2d4 | 20 | 2 | 14665516 | 0 | 139420220000000000000 | 2022-04-27T08:50:16.000Z | 400429195655 | 0x2eae2b246999ab8485b1d40a1893a4159782dc8942753fd959d24662cc945817 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_TokenExchange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_TokenExchangeUnderlying\_event
Token swap events from Curve V1 StableSwap pools on Ethereum involving underlying assets rather than wrapped tokens. Used for tracking direct exchanges between base stablecoin assets and analyzing true liquidity flow in metapools.
| 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_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | --------- | ---------- | ------------ | ------------- | -------------- | ---------------- | ------------------------ | ------------------ | ------------------------------------------------------------------ |
| 0x06364f10b501e868329afbc005b3492902d6c763 | false | | 208 | | 14694509 | | | 2022-05-01T22:05:16.000Z | | 0xf43b345c8be2ad98820b662f3fabcf72913fce17311421ae45407d851a778f53 |
| 0x06364f10b501e868329afbc005b3492902d6c763 | false | | 154 | | 14692309 | | | 2022-05-01T13:45:42.000Z | | 0xa58d4ee322076873ae9d12e2cb6fe18473bca8460860fa05e6cf9a839d3c175b |
| 0x06364f10b501e868329afbc005b3492902d6c763 | false | | 42 | | 14691885 | | | 2022-05-01T12:12:50.000Z | | 0x7e592216f6132bc07f85a972530bca48efa7cf755bf0ec7f72b647a5eb8f2f6a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_TokenExchangeUnderlying_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePool\_TokenExchangeV2\_event
Token swap events from Curve V1 stablecoin pools on Ethereum, recording buyer address, tokens sold/bought amounts, and pool identifiers. Used for analyzing trading volume, price impact, and liquidity utilization across Curve's stable swap pairs.
| 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_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | ---------------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
| 0xb37d6c07482bc11cd28a1f11f1a6ad7b66dec933 | false | 0x0000000000036414940324055c43e75f56b7d016 | 50 | 0 | 16500917 | 1 | 1323310897512765248484 | 2023-01-27T21:45:23.000Z | 1316622686787432250216 | 0x2407cdcdcd92551e85d9e262274b5fef361fb456fd179276242accca0e437292 |
| 0xb37d6c07482bc11cd28a1f11f1a6ad7b66dec933 | false | 0x0000000000a84d1a9b0063a910315c7ffa9cd248 | 49 | 0 | 16500660 | 1 | 1292645482778957232774 | 2023-01-27T20:53:35.000Z | 1286167923419906248776 | 0xbf2bb5d92e9a9684b1eacb808ad0c57339cff88e1377b8c865108c3b34cdbe38 |
| 0xdcef968d416a41cdac0ed8702fac8128a64241a2 | false | 0x0000000000a84d1a9b0063a910315c7ffa9cd248 | 56 | 0 | 16494923 | 1 | 7038490405855898255910 | 2023-01-27T01:37:47.000Z | 7032807577 | 0xb92d91d25bdf4f83579f99d5ebab9802bbd8287e28738d268821c3dc5442bb00 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StablePool_TokenExchangeV2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StableRegistry\_PoolAdded\_event
Event logs capturing new stablecoin pool registrations in Curve V1's StableRegistry contract on Ethereum. Tracks when liquidity pools are added to the registry with their addresses and rate calculation methods for analyzing Curve's stableswap pool expansion.
| 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_rate_method_id` | `STRING` | Method identifier for retrieving exchange rates within the Curve pool, stored as a hex-encoded 4-byte function selector. Typically `0x00000000` indicates no custom rate method is used for this pool registration. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_rate\_method\_id |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- |
| 0x90e00ace148ca3b23ac1bc8c240c2a7dd9c2d7f5 | 0x4ca9b3063ec5866a4b82e437059d2c43d1be596f | false | 45 | 12196401 | 2021-04-08T02:10:31.000Z | 0x6882296660b32fa5b8285b2c3c436db6b80895b0e1e6a0469b16c186fc283077 | 0x00000000 |
| 0x90e00ace148ca3b23ac1bc8c240c2a7dd9c2d7f5 | 0xf178c0b5bb7e7abf4e12a4838c7b7c5ba2c623c0 | false | 254 | 12196644 | 2021-04-08T03:01:45.000Z | 0xeeb32176bfae9020273630085304936b0f91abe0a074e5247617474d488f1c6f | 0x00000000 |
| 0x90e00ace148ca3b23ac1bc8c240c2a7dd9c2d7f5 | 0x071c661b4deefb59e2a3ddb20db036821eee8f4b | false | 51 | 12198091 | 2021-04-08T08:31:34.000Z | 0xf42110fcfd535945f9abf5f5e948adaccd60d9cfd0afbb8ab3ce71b40793b232 | 0x00000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.StableRegistry_PoolAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TriCryptoPool\_AddLiquidity\_event
Liquidity deposit events from Curve Finance TriCrypto pools on Ethereum, capturing provider addresses, token amounts deposited across three assets, fees charged, and resulting LP token supply. Used for analyzing liquidity provision patterns and fee generation across multi-asset volatile pools.
| Column | Type | Description |
| ----------------------- | --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token_amounts` | `ARRAY` | Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_token_supply` | `STRING` | Total supply of liquidity pool tokens after the operation. Numeric string representation in smallest token denomination. |
| `in_packed_price_scale` | `STRING` | Encoded price scale value for the liquidity pool. String-encoded integer representing the packed internal price scaling factor used in pool calculations. |
| in\_fee | address | removed | log\_index | in\_provider | block\_number | block\_timestamp | in\_token\_supply | in\_token\_amounts | transaction\_hash | in\_packed\_price\_scale |
| ---------------- | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------ | --------------------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------- |
| 1966255658244589 | 0x2570f1bd5d2735314fc102eb12fc1afe9e6e7193 | false | 204 | 0x0dd16c537cdb346826203f3ab762030e7f20c78a | 19558198 | 2024-04-01T03:03:23.000Z | 698715629646980222708 | \["0","0","18501379772391778073"] | 0x123c903714fb83cf390d04bb091292a2a61f3c81c77ba69c264ed69ec1da8592 | 314719836476563129678469858732299425345750117951966466007 |
| 321706323720766 | 0x2889302a794da87fbf1d6db415c1492194663d13 | false | 57 | 0x99a58482bd75cbab83b27ec03ca68ff489b5788f | 19559316 | 2024-04-01T06:50:23.000Z | 6129951558815214998599 | \["0","0","73669686800605333"] | 0x1a263ea7ba0be0cf68402507bc20b6b9a2523f8115a129081594d23ff2390668 | 1414058964385364500580633376029836379933036456354365356749121 |
| 3305499505620780 | 0x4ebdf703948ddcea3b11f675b4d1fba9d2414a14 | false | 44 | 0x2686bc6a56d205010637ce1df124b20cb19e4054 | 19563999 | 2024-04-01T22:37:59.000Z | 334017436679489124744923 | \["0","72259302368909610","0"] | 0x0cbaaa979d21ae2548b9927e44e5627c444fbff4e12ace3d9d9d8668f31dd6ac | 220357339746976061124274087452185147059217215348264266178 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TriCryptoPool_AddLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TriCryptoPool\_RampAgamma\_event
Parameter change events for Curve TriCrypto pools on Ethereum tracking adjustments to amplification coefficient (A) and gamma values. Used for analyzing pool rebalancing operations and risk parameter updates over time.
| 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_initial_A` | `STRING` | Initial amplification coefficient (A parameter) for the Curve pool at the start of the ramping period. Numeric string representing the scaled integer value of the A parameter. |
| `in_future_A` | `STRING` | Target amplification coefficient (A parameter) for the Curve pool at the end of the ramping period. Numeric string representing the scaled integer value of the A parameter. |
| `in_initial_gamma` | `STRING` | Initial gamma parameter for the Curve pool at the start of the ramping period. Numeric string representing the scaled integer value of the gamma parameter. |
| `in_future_gamma` | `STRING` | Target gamma parameter for the Curve pool at the end of the ramping period. Numeric string representing the scaled integer value of the gamma parameter. |
| `in_initial_time` | `STRING` | Unix timestamp when the parameter ramping period starts for the Curve pool. Numeric string representing seconds since epoch. |
| `in_future_time` | `STRING` | Unix timestamp when the parameter ramping period ends for the Curve pool. Numeric string representing seconds since epoch. |
| address | removed | log\_index | in\_future\_A | block\_number | in\_initial\_A | in\_future\_time | block\_timestamp | in\_future\_gamma | in\_initial\_time | in\_initial\_gamma | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------- | -------------- | ---------------- | ------------------------ | ----------------- | ----------------- | ------------------ | ------------------------------------------------------------------ |
| 0xf5f5b97624542d72a9e06f04804bf81baa15e2b4 | false | 300 | 2700000 | 18130208 | 1707629 | 1695246106 | 2023-09-13T21:58:35.000Z | 43000000000000 | 1694642315 | 11809167828997 | 0x09b8ab209870f01e94a9ac50180b95c20896ca76b7cc3aebfb6b9ce59c721652 |
| 0x5426178799ee0a0181a89b4f57efddfab49941ec | false | 281 | 2700000 | 18042419 | 1707629 | 1693834970 | 2023-09-01T14:52:59.000Z | 1300000000000 | 1693579979 | 11809167828997 | 0x1f628a95e165a7d51991faf917b7b1b817321b8260043a019b182f90103945c4 |
| 0xf5f5b97624542d72a9e06f04804bf81baa15e2b4 | false | 368 | 540000 | 18989909 | 2700000 | 1705536862 | 2024-01-12T09:25:23.000Z | 80500000000000 | 1705051523 | 43000000000000 | 0x6e130842e4cf71ea38629892437ba8d889671845d48d0f300b26d5c15637f9e6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TriCryptoPool_RampAgamma_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TriCryptoPool\_RemoveLiquidity\_event
Liquidity removal events from Curve TriCrypto pools on Ethereum, recording withdrawn token amounts and LP (liquidity provider) token supply changes. Used for tracking pool exit behavior and liquidity depth changes across Curve's three-asset crypto pools.
| Column | Type | Description |
| ------------------ | --------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token_amounts` | `ARRAY` | Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination. |
| `in_token_supply` | `STRING` | Total supply of liquidity pool tokens after the operation. Numeric string representation in smallest token denomination. |
| address | removed | log\_index | in\_provider | block\_number | block\_timestamp | in\_token\_supply | in\_token\_amounts | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ----------------------- | ----------------------------------------------------- | ------------------------------------------------------------------ |
| 0xf5f5b97624542d72a9e06f04804bf81baa15e2b4 | false | 117 | 0xbdfa4f4492dd7b7cf211209c4791af8d52bf5c50 | 17432363 | 2023-06-08T01:33:23.000Z | 13865334129387940070947 | \["257276393283","981495688","141149701957436744614"] | 0x8889a8ee80c1a3591eb7166f00f1effde7381e267140f73480d73420fc7d07e0 |
| 0xf5f5b97624542d72a9e06f04804bf81baa15e2b4 | false | 148 | 0x873525b1b479431bd713d59897218bfdc341c0cf | 17432349 | 2023-06-08T01:30:35.000Z | 14574334129387940070947 | \["37267328023","142172864","20445996525696546655"] | 0xb5009624995b2f7f70f6ac1ecf4d1b017cf1040aeffd60880092eaae7c84de05 |
| 0x7f86bf177dd4f3494b841a37e810a34dd56c829b | false | 180 | 0x23727b54163f63cffdd8b7769e0ecb13df253b4e | 19503568 | 2024-03-24T09:38:59.000Z | 18710114921370030040771 | \["85559344388","130464918","25277030237314327040"] | 0x99baf660ba902cdc451115f41e64353c481877693eb6d5f5c49b5d5808cdd681 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TriCryptoPool_RemoveLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TriCryptoPool\_RemoveLiquidityOne\_event
Single-asset liquidity withdrawals from Curve TriCrypto pools on Ethereum, capturing events where liquidity providers remove LP tokens in exchange for one specific coin from the pool. Records include withdrawn coin amount, LP token burned, fees paid, and pool price scale for analyzing liquidity provider behavior and imbalanced withdrawal patterns.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token_amount` | `STRING` | Amount of liquidity pool tokens involved in the operation. String-encoded integer in smallest token denomination (wei). |
| `in_coin_index` | `STRING` | Index of the coin being withdrawn from the liquidity pool. String-encoded integer representing the position of the coin in the pool's token array. |
| `in_coin_amount` | `STRING` | Amount of coin withdrawn from the liquidity pool. String-encoded integer in smallest token denomination (wei). |
| `in_approx_fee` | `STRING` | Approximate fee charged for the liquidity operation. String-encoded integer in smallest token denomination (wei). |
| `in_packed_price_scale` | `STRING` | Encoded price scale value for the liquidity pool. String-encoded integer representing the packed internal price scaling factor used in pool calculations. |
| address | removed | log\_index | in\_provider | block\_number | in\_approx\_fee | in\_coin\_index | in\_coin\_amount | block\_timestamp | in\_token\_amount | transaction\_hash | in\_packed\_price\_scale |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ----------------- | --------------- | -------------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------- |
| 0x2570f1bd5d2735314fc102eb12fc1afe9e6e7193 | false | 182 | 0x5cc9400ffb4da168cf271e912f589462c3a00d1f | 19414629 | 1076856724559016 | 0 | 4315335645420407203 | 2024-03-11T21:47:59.000Z | 1498500000000000000 | 0xac28d007af9cef7b3792bf20881458594315a5bfc5f1156b301d7cb096bce9ee | 315307821769549467076610476931916371659293103889422576412 |
| 0x4ebdf703948ddcea3b11f675b4d1fba9d2414a14 | false | 46 | 0x99b95c60b2d68db15dffb11a71076a31ccaf1487 | 19411080 | 40757680329177382 | 1 | 23958266565195041827 | 2024-03-11T09:52:35.000Z | 2100000000000000000000 | 0xfe055942550b8ed05f0080038ed0a1d67c2ec14465046da56d8a84136974d4f6 | 279258388880041626170696817492961117952249204254283127771 |
| 0x7f86bf177dd4f3494b841a37e810a34dd56c829b | false | 436 | 0xa1ae28aaaec5b01eadb37d97304164a3be161d06 | 19410736 | 2383 | 1 | 3312026 | 2024-03-11T08:43:11.000Z | 1191411283254422604 | 0xd2a0356a82cd6d1dcfc9303c166f6c671daba3c8939ea4729cf14441caa216d9 | 1323071301334186677757284288028896090992101185970264611296318 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TriCryptoPool_RemoveLiquidityOne_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TriCryptoPool\_TokenExchange\_event
Token swap events from Curve Finance's TriCrypto pools on Ethereum, capturing trades between stablecoins and crypto assets (USDT, WBTC, WETH). Contains exchange amounts, fees, token IDs, buyer addresses, and dynamic pricing data for analyzing pool liquidity and trading patterns.
| 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_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_packed_price_scale` | `STRING` | Encoded price scale value for the liquidity pool. String-encoded integer representing the packed internal price scaling factor used in pool calculations. |
| in\_fee | address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash | in\_packed\_price\_scale |
| --------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | ---------------------- | ------------------------ | ----------------------- | ------------------------------------------------------------------ | -------------------------------------------------------- |
| 120849561272996432081 | 0x86bf09acb47ab31686be413d614e9ded3666a1d3 | false | 0xe37e799d5077682fa0a244d46e5649f71457bd09 | 158 | 0 | 18627160 | 2 | 1520911372953474484684 | 2023-11-22T12:04:59.000Z | 20324757208001229446693 | 0x780e1eee0d8463ea88471c278b5123fe5123d4c5bff3a5e2f89a54bc5e0fce51 | 24444591442034648162975368862534873514562199829040873875 |
| 280398169941311561565 | 0x86bf09acb47ab31686be413d614e9ded3666a1d3 | false | 0xe37e799d5077682fa0a244d46e5649f71457bd09 | 101 | 0 | 18630074 | 2 | 2997863299787139974794 | 2023-11-22T21:51:11.000Z | 38051173199380247263116 | 0xb016b314766eee562b755bd9ba5cf0c8295a6e325b426c0f5dcefdf0bfd895bb | 24705435044806456265589543823829458680205623008103013938 |
| 3488989405574626 | 0x954313005c56b555bdc41b84d6c63b69049d7847 | false | 0x00000000009e50a7ddb7a7b0e2ee6604fd120e49 | 341 | 0 | 18626204 | 1 | 2875235036443806088540 | 2023-11-22T08:51:23.000Z | 1443685339416918980 | 0xe4677628a3c3aa806ebfc75d5d68a9a368589d25c30d40dbbdd39b2a76335b9e | 99266212294154381318076293902921987891456048489841877437 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TriCryptoPool_TokenExchange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TwoCryptoPool\_AddLiquidity\_event
Liquidity deposit events from Curve v1 two-asset pools on Ethereum, capturing provider addresses, token amounts supplied, LP token minting, and associated fees. Used for tracking liquidity provider positions and pool composition changes over time.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token_amounts` | `ARRAY` | Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_token_supply` | `STRING` | Total supply of liquidity pool tokens after the operation. Numeric string representation in smallest token denomination. |
| in\_fee | address | removed | log\_index | in\_provider | block\_number | block\_timestamp | in\_token\_supply | in\_token\_amounts | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ----------------- | --------------------------------------------------- | ------------------------------------------------------------------ |
| 0 | 0xdad60c5b748306ba5a0c9a3c3482a8d1153dad2a | false | 296 | 0xac3203d77823496e421aa7e88cdc2f6c387d6182 | 14531658 | 2022-04-06T09:55:34.000Z | 0 | \["100000000000000000000","100000000"] | 0x316ab41e168c033efdaf091247df343e9b65d9870db12cea11f04ee6e8d5ddaf |
| 0 | 0x782115c863a05abf8795df377d89aad1aadf4dfa | false | 102 | 0xb27dc5f8286f063f11491c8f349053cb37718bea | 14535380 | 2022-04-06T23:48:53.000Z | 0 | \["65400000000000000","100000000000000"] | 0x7ff433b76f968739791f9a6e51d6feccc5c9ca1071330233f25a4efea2a5d6df |
| 0 | 0x7472764c28f843ba246f294c44de9456911a3454 | false | 61 | 0xb3fe63fa04ec5d65316fc1ffbd5dd32f3813cea8 | 14534633 | 2022-04-06T21:03:09.000Z | 0 | \["130000000000000000","3988117000000000000000000"] | 0x883ccc2b0be089db9b374a3e93f19841cd1acbd155a1ae93b1922357baf13b0c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TwoCryptoPool_AddLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TwoCryptoPool\_balances\_function
Token balance query results from Curve V1 TwoCrypto pools on Ethereum, showing individual asset reserves by pool position index. Used for tracking pool composition, liquidity depth, and reserve ratios over time.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_arg0` | `STRING` | Input parameter specifying the token index in the Curve TwoCrypto pool (0, 1, or 2). Used to query the balance of a specific token in the pool via the balances function call. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | in\_arg0 | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | -------- | --------- | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 460395 | | false | 1 | 3615 | 67243734358 | 0x4903b0d1 | 0xd51a44d3fae010294c616388b506acda1bfaae46 | 18629630 | 0x40745803c2faa8e8402e2ae935933d07ca8f355c | 0,1,0,3 | 2023-11-22T20:21:59.000Z | 0x31b79413efc6643ee3a2cda21b0dcb8f42b77d9cc00a0f47b290110ccdda8dbe |
| 456565 | | false | 2 | 3615 | 12073825672309533715147 | 0x4903b0d1 | 0xd51a44d3fae010294c616388b506acda1bfaae46 | 18629630 | 0x40745803c2faa8e8402e2ae935933d07ca8f355c | 0,1,0,4 | 2023-11-22T20:21:59.000Z | 0x31b79413efc6643ee3a2cda21b0dcb8f42b77d9cc00a0f47b290110ccdda8dbe |
| 464224 | | false | 0 | 3615 | 25172135156349 | 0x4903b0d1 | 0xd51a44d3fae010294c616388b506acda1bfaae46 | 18629630 | 0x40745803c2faa8e8402e2ae935933d07ca8f355c | 0,1,0,2 | 2023-11-22T20:21:59.000Z | 0x31b79413efc6643ee3a2cda21b0dcb8f42b77d9cc00a0f47b290110ccdda8dbe |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TwoCryptoPool_balances_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TwoCryptoPool\_RampAgamma\_event
Parameter change events for Curve v1 TwoCrypto pools on Ethereum, recording adjustments to the amplification coefficient (A) and gamma values that control pool behavior. Used to track liquidity curve modifications and pool rebalancing operations.
| 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_initial_A` | `STRING` | Initial amplification coefficient (A parameter) for the Curve pool at the start of the ramping period. Numeric string representing the scaled integer value of the A parameter. |
| `in_future_A` | `STRING` | Target amplification coefficient (A parameter) for the Curve pool at the end of the ramping period. Numeric string representing the scaled integer value of the A parameter. |
| `in_initial_gamma` | `STRING` | Initial gamma parameter for the Curve pool at the start of the ramping period. Numeric string representing the scaled integer value of the gamma parameter. |
| `in_future_gamma` | `STRING` | Target gamma parameter for the Curve pool at the end of the ramping period. Numeric string representing the scaled integer value of the gamma parameter. |
| `in_initial_time` | `STRING` | Unix timestamp when the parameter ramping period starts for the Curve pool. Numeric string representing seconds since epoch. |
| `in_future_time` | `STRING` | Unix timestamp when the parameter ramping period ends for the Curve pool. Numeric string representing seconds since epoch. |
| address | removed | log\_index | in\_future\_A | block\_number | in\_initial\_A | in\_future\_time | block\_timestamp | in\_future\_gamma | in\_initial\_time | in\_initial\_gamma | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------- | -------------- | ---------------- | ------------------------ | ----------------- | ----------------- | ------------------ | ------------------------------------------------------------------ |
| 0x0d89f4583a6b5eceb76551d573ad49cd435f6064 | false | 350 | 3000000000 | 20799050 | 890000000 | 1727345139 | 2024-09-21T12:48:11.000Z | 10999999999999999 | 1726922891 | 1100000000000000 | 0xafb5ad3e158229d83dbb1a298e18ae7a8e9ee269de4bd3395b0e93470a5da56b |
| 0xd51a44d3fae010294c616388b506acda1bfaae46 | false | 143 | 54000 | 12934239 | 54000 | 1627836772 | 2021-07-31T15:53:54.000Z | 280000000000000 | 1627746834 | 350000000000000 | 0x24828db5dd46f8204a39fea176b055b5ba8d6d646d235fe9851154f5a5f3b1a2 |
| 0x98a7f18d4e56cfe84e3d081b40001b3d5bd3eb8b | false | 269 | 20000000 | 16513662 | 200000000 | 1675614388 | 2023-01-29T16:27:23.000Z | 100000000000000 | 1675009643 | 100000000000000 | 0x2dee213ba1e54de4caedb8bf7b60eb64671579457aac3cdf58c0361e910905fb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TwoCryptoPool_RampAgamma_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TwoCryptoPool\_RemoveLiquidity\_event
Liquidity removal events from Curve V1 TwoCrypto pools on Ethereum, capturing withdrawn token amounts, LP token supply, and provider addresses. Used to analyze liquidity provider withdrawals and pool composition changes over time.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token_amounts` | `ARRAY` | Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination. |
| `in_token_supply` | `STRING` | Total supply of liquidity pool tokens after the operation. Numeric string representation in smallest token denomination. |
| address | removed | log\_index | in\_provider | block\_number | block\_timestamp | in\_token\_supply | in\_token\_amounts | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ---------------------- | --------------------------------------- | ------------------------------------------------------------------ |
| 0x7fb53345f1b21ab5d9510adb38f7d3590be6364b | false | 275 | 0x838690f7d76382424afd8fa84d6339bdbb5583de | 22729923 | 2025-06-18T07:38:11.000Z | 3293007242750025843050 | \["476542850768219","800547356146080"] | 0xa54ef6abaab26ebb7d3db16bc884dddc599ea38d9a48d79af340ae73791326c3 |
| 0x7fb53345f1b21ab5d9510adb38f7d3590be6364b | false | 444 | 0x838690f7d76382424afd8fa84d6339bdbb5583de | 22731331 | 2025-06-18T12:20:47.000Z | 3302232154145538388417 | \["843339638677929","1416730248700029"] | 0x7df97ef65abb43a7ea6af9bfc849c7f88d63caf986e6444f00cb044398c671a7 |
| 0x7fb53345f1b21ab5d9510adb38f7d3590be6364b | false | 97 | 0x838690f7d76382424afd8fa84d6339bdbb5583de | 22730209 | 2025-06-18T08:35:47.000Z | 3293007242760983151938 | \["410237981575510","689161390687032"] | 0x14ee90a05aa851827c070ac97a60b1126974066f88f5d6877c6687c5bf0ae8d9 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TwoCryptoPool_RemoveLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TwoCryptoPool\_RemoveLiquidityOne\_event
Single-sided liquidity removal events from Curve V1 TwoCrypto pools on Ethereum, recording LP token burns and the specific token withdrawn. Used for analyzing liquidity provider exit patterns and pool composition changes.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token_amount` | `STRING` | Amount of liquidity pool tokens involved in the operation. String-encoded integer in smallest token denomination (wei). |
| `in_coin_index` | `STRING` | Index of the coin being withdrawn from the liquidity pool. String-encoded integer representing the position of the coin in the pool's token array. |
| `in_coin_amount` | `STRING` | Amount of coin withdrawn from the liquidity pool. String-encoded integer in smallest token denomination (wei). |
| address | removed | log\_index | in\_provider | block\_number | in\_coin\_index | in\_coin\_amount | block\_timestamp | in\_token\_amount | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | --------------- | ------------------ | ------------------------ | ------------------- | ------------------------------------------------------------------ |
| 0xb576491f1e6e5e62f1d8f26062ee822b40b0e0d4 | false | 234 | 0xe7073fe7673f549c6b14b63412f0f2388a770b8a | 15729312 | 0 | 172179932904686574 | 2022-10-12T03:21:47.000Z | 1265655044515399296 | 0x4c9e23a88f1fca29a0bfc99e10b1eb731c70f46d6e8746be26b7163d9ab7fe77 |
| 0x21410232b484136404911780bc32756d5d1a9fa9 | false | 137 | 0x004a476b5b76738e34c86c7144554b9d34402f13 | 15729976 | 0 | 766145716717999582 | 2022-10-12T05:35:35.000Z | 1396290751654146186 | 0xe013b5bdb36b6b22e7b835e9eac3d21d6b5d1b1b54ee35f5c2d3b07d6e3532e2 |
| 0xc26b89a667578ec7b3f11b2f98d6fd15c07c54ba | false | 127 | 0x004a476b5b76738e34c86c7144554b9d34402f13 | 15729976 | 0 | 455620195422845639 | 2022-10-12T05:35:35.000Z | 91597037105475924 | 0xe013b5bdb36b6b22e7b835e9eac3d21d6b5d1b1b54ee35f5c2d3b07d6e3532e2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TwoCryptoPool_RemoveLiquidityOne_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TwoCryptoPool\_TokenExchange\_event
Token swap events from Curve V1 TwoCrypto pools on Ethereum, capturing exchange details including sold/bought token IDs, amounts, buyer addresses, and pool contracts. Used for analyzing liquidity provision, trading volume, and price discovery in Curve's two-asset crypto pools.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sold_id` | `STRING` | Index of the token sold in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_sold` | `STRING` | Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| `in_bought_id` | `STRING` | Index of the token purchased in the exchange transaction within the pool's token array. String-encoded integer identifier. |
| `in_tokens_bought` | `STRING` | Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token. |
| address | removed | in\_buyer | log\_index | in\_sold\_id | block\_number | in\_bought\_id | in\_tokens\_sold | block\_timestamp | in\_tokens\_bought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | -------------- | ------------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
| 0x8301ae4fc9c624d1d396cbdaa1ed877821d7c511 | false | 0x0cb43ef0a6b2bd454fa5222c519184dafb1bf0c2 | 276 | 0 | 13997971 | 1 | 3000000000000000000 | 2022-01-13T15:23:14.000Z | 2025200929217146139079 | 0xfa62865d30c6b3648678c53b185d4d4566543064263a6fc5dc80f9afcc7136a0 |
| 0xb576491f1e6e5e62f1d8f26062ee822b40b0e0d4 | false | 0x1424a2485d4f89c8d8d84b7809bd23995f2abd26 | 149 | 0 | 13999156 | 1 | 80000000000000000 | 2022-01-13T19:57:00.000Z | 5944560070420901344 | 0x1b9f42b9039ce08ccc48bf615d89e5a291fb0e99fac58edbd0dc91dcda2b739f |
| 0xb576491f1e6e5e62f1d8f26062ee822b40b0e0d4 | false | 0x1424a2485d4f89c8d8d84b7809bd23995f2abd26 | 137 | 0 | 13999100 | 1 | 1430000000000000000 | 2022-01-13T19:45:10.000Z | 106156093492155621900 | 0xaaa46000320fc51b84306305ba10da25b0a2aaf0258295c182eb2b2cc9207968 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.curve_v1_ethereum.TwoCryptoPool_TokenExchange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***