curve_v1_ethereum - Token Terminal Docs

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_user	removed	log_index	block_number	block_timestamp	in_loan_decrease	transaction_hash
0x100daa78fc509db39ef7d04de0c1abd299f4c6ce	0x95af5a5eedc1c1eca33a78229260a7c582a1b997	false	30	18372163	2023-10-17T19:25:11.000Z	5000000000000000000000	0xad76fe757bdf29275d4172434c7af9fc164f3bf0d03ad7d9170614a65d093cfa
0x100daa78fc509db39ef7d04de0c1abd299f4c6ce	0xa02d03e291556792ee1f99b818d9c936d29ee4a3	false	197	18368193	2023-10-17T06:05:35.000Z	34000000000000000000	0x2c790156a20dbe1a76a00ab78204901599353399ae5a01c2aa90eb6058b6526d
0x100daa78fc509db39ef7d04de0c1abd299f4c6ce	0x8d877186de308712756e5a4e0342a3ec8ac6949f	false	188	18368170	2023-10-17T06:00:47.000Z	52000000000000000000	0x3cd2edca9cc162edd6a87a5fb8420bc7e3462ae10c5dfb00c2f1975668433035

Example Query

Query with partition filter

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.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_monetary_policy`	`STRING`	Contract address of the monetary policy contract that governs interest rate calculations. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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<STRING>`	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.

Sample Data

gas	in_A	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	block_timestamp	in_ma_half_time	in_initial_price	transaction_hash	in_adjustment_step	in_allowed_extra_profit
1231573	200000000	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	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	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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_base_pool`	`STRING`	Contract address of the base pool used in the metapool architecture. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	in__A	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	block_timestamp	in__ma_exp_time	transaction_hash	in__offpeg_fee_multiplier
6873829	500	true	4000000	5244769	0xcfc5bd99915aaa815401c5a41a927ab7a38d29cf	thUSD	0x91553bad9fbc8bd69ff5d5678cbf7d514d00de0b	0xdf8c5d73	0x0000000000000000000000000000000000000000	thUSD3CRV	0x6a8cbed756804b16e05e741edabd5cb544ae21bf	19608427	0xd818b9f7cb4090047d26c51e63c9cb1b5e12886a	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	0x00000000	2024-04-08T03:59:11.000Z	866	0x1ee39a16643a2d10b84fd563c462900481c9fcabe116cc8d81b6017d41e23fff	20000000000
6876541	200	true	4000000	5246838	0x4d55a36902a6546a79ec4c9c315241de746d5fc3	KUSD/3CRV	0xb75848380f0fc17b43fc397c03a1738c0042eadc	0xdf8c5d73	0x0000000000000000000000000000000000000000	KUSD3CRV	0x6a8cbed756804b16e05e741edabd5cb544ae21bf	20398020	0xa2026e62bfd1f1a2d8b89a19f3fa0ba42b52f0bf	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	0x00000000	2024-07-27T12:55:23.000Z	866	0xd41803fa4e6ae69d0892e54c262b251409ba409ddf59a9bc0f14c05864a98524	20000000000
6779991	20000	true	1000000	5215378	0xc81b27ac184a631a0cbde20b51c734664b04d5b3	3crv+	0x29d9f16bb2d4033e0e621623a018a7f2ee3b8110	0xdf8c5d73	0x0000000000000000000000000000000000000000	3crv+	0x6a8cbed756804b16e05e741edabd5cb544ae21bf	21954458	0x900f84590ccdbd2b3c64769b79e8181b6b8641f0	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	0x00000000	2025-03-01T20:38:23.000Z	866	0x7652aaa886c27dd5da17506ef4845067902abc1171a3ecaeac59e3cef43bb36b	100000000000

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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<STRING>`	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<INT64>`	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<STRING>`	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<STRING>`	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.

Sample Data

gas	in__A	status	in__fee	gas_used	in__name	in__coins	out_anon0	signature	in__symbol	to_address	in__oracles	block_number	from_address	in__method_ids	block_timestamp	in__asset_types	in__ma_exp_time	transaction_hash	in__offpeg_fee_multiplier
8077279	100	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
7113909	500	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	50000000000
8193665	200	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	20000000000

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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).

Sample Data

gas	status	gas_used	signature	in__amount	to_address	block_number	from_address	trace_address	block_timestamp	in__reward_token	transaction_hash
390015	true	62669	0x93f7aa67	5776526011904761904761	0x5ae854b098727a9f1603a1e21c50d52dc834d846	17818658	0x9af8fbba318adeacea010b8d7c0190d443ee1a85	2,1,0	2023-08-01T07:28:35.000Z	0xa95c5ebb86e0de73b4fb8c47a45b792cfea28c23	0x6f72dde39a22665058a63f374036548b5c1e948ab546746be5dbed9fdc814a5e
396347	true	62844	0x93f7aa67	5776526011904761904761	0x9af8fbba318adeacea010b8d7c0190d443ee1a85	17818658	0x07cd2e45386da2ff8f2db716e733b6f48511a118	2,1	2023-08-01T07:28:35.000Z	0xa95c5ebb86e0de73b4fb8c47a45b792cfea28c23	0x6f72dde39a22665058a63f374036548b5c1e948ab546746be5dbed9fdc814a5e
465628	true	69969	0x93f7aa67	8665286051587301587301	0x5ae854b098727a9f1603a1e21c50d52dc834d846	17818658	0xd90a01c487564ba6cef5c3870c1251aff0c49e53	2,0,0	2023-08-01T07:28:35.000Z	0xa95c5ebb86e0de73b4fb8c47a45b792cfea28c23	0x6f72dde39a22665058a63f374036548b5c1e948ab546746be5dbed9fdc814a5e

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	in_buyer	log_index	block_number	in_bought_id	in_tokens_sold	block_timestamp	in_tokens_bought	transaction_hash
0x9c2c8910f113181783c249d8f6aa41b51cde0f0c	false	0x8eb080fe0045ffc44e2c1446c2a87cda010b8c23	48	14994680	1	18974185776335502875023	2022-06-20T04:41:27.000Z	18519188832146233346619	0x49b4b87d06f68e5626dcc84d42110c103abca973b1c7837f8ea5e33a2a97d544
0x9c2c8910f113181783c249d8f6aa41b51cde0f0c	false	0xe4000004000bd8006e00720000d27d1fa000d43e	56	15473896	1	219319798019028584941	2022-09-04T21:09:41.000Z	214090936254430414784	0x70c8ca139b1ca6c0364405b064e4f8bf232290aef5f6213db43e24d80c598229
0x9c2c8910f113181783c249d8f6aa41b51cde0f0c	false	0x4bcd0d9bdc8f28664987b99cc73dc368c7dee1bd	195	15818220	1	41839125850674403918633	2022-10-24T13:19:59.000Z	39807284860257861916863	0xc5a7176964120210096a0fc5b20e4e3d97e5ab93dd21bdabec20e398b8baa614

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	in_buyer	log_index	block_number	in_bought_id	in_tokens_sold	block_timestamp	in_tokens_bought	transaction_hash
0xd6ac1cb9019137a896343da59dde6d097f710538	false	0x6b3d1a37b5c01901341f01f4975d31bc5e6c3d81	32	14085186	1	1114018916735225451304425	2022-01-27T03:12:05.000Z	1114957855170005588403884	0x3637d6098788c1a6b7a7ff38975fb6f9ca04beb5397290ce6962361cc194f18f
0xd6ac1cb9019137a896343da59dde6d097f710538	false	0x2d407ddb06311396fe14d4b49da5f0471447d45c	189	14085355	1	150240756894006237460140	2022-01-27T03:50:26.000Z	150268101789157044530368	0x55564bcf3178cf1103abda81ce6f75e378413f2d700f669cab4999129123de4f
0xd6ac1cb9019137a896343da59dde6d097f710538	false	0xea25220caf98e0097fb8401d8a44e2d4f2cef093	497	14940140	1	30160029926638471390831	2022-06-10T19:21:05.000Z	29837236671338687708916	0xfe0663387fe1fef60f9f820c8c2eea77601959980c13253b45d6113ed6c761b5

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	in_buyer	log_index	in_sold_id	block_number	in_tokens_sold	block_timestamp	in_tokens_bought	transaction_hash
0x8461a004b50d321cb22b7d034969ce6803911899	false	0x38abab9766e0b27d2912718a884292b8e7eb2803	127	1	14762203	64492192000000000000000000	2022-05-12T16:46:07.000Z	74487868182782713261676550	0x30ef8c2c38c88515c8ee8e76e21a64badba9a1abe8088aebf0808b3d9848ceca
0x8461a004b50d321cb22b7d034969ce6803911899	false	0x38abab9766e0b27d2912718a884292b8e7eb2803	40	1	14761509	64492192000000000000000000	2022-05-12T14:06:57.000Z	478532264830501488287404522	0x41c405405bbdc558ec0a2c9259ac3a9a0e8975b2bccc5b16259f22946af9837c
0x8461a004b50d321cb22b7d034969ce6803911899	false	0x38abab9766e0b27d2912718a884292b8e7eb2803	170	1	14760994	65782036391792489353464963	2022-05-12T12:06:36.000Z	1357265155775749231617462231	0xaf8ad6bb1396cb6638856fbb13f516737dd025284f54fe97e0a5b072b2d359ed

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	in__A	status	in__fee	gas_used	in__coin	in__name	out_anon0	signature	in__symbol	to_address	block_number	from_address	in__base_pool	block_timestamp	transaction_hash
1212643	10	true	4000000	808429	0x2a8e1e676ec238d8a992307b495b45b3feaa5e86	Origin Dollar	0x87650d7bbfc3a9f10587d7778206671719d9910d	0xe339eb4f	OUSD	0x0959158b6040d32d04c301a72cbfd6b39e21c9ae	12860905	0x449e0b5564e0d141b3bc3829e74ffa0ea8c08ad5	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	2021-07-20T02:59:14.000Z	0xa1b1ccff28654c042b9bb8edf7c204aee4766128e16d32133dc82485def71030
1201342	10	true	4000000	800895	0xdc59ac4fefa32293a95889dc396682858d52e5db	Bean	0x3a70dfa7d2262988064a2d051dd47521e43c9bdd	0xe339eb4f	BEAN	0x0959158b6040d32d04c301a72cbfd6b39e21c9ae	13954026	0x925753106fcdb6d2f30c3db295328a0a1c5fd1d1	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	2022-01-06T20:23:33.000Z	0x6a93ab470e4348fa96dddbf6105315b7ab048ba09201e7082b6a3040d91dba10
1085731	100	true	4000000	723821	0x853d955acef822db058eb8505911ed77f175b99e	Frax	0xd632f22692fac7611d2aa1c0d552930d43caed3b	0xe339eb4f	FRAX	0x0959158b6040d32d04c301a72cbfd6b39e21c9ae	11968730	0x234d953a9404bf9dbc3b526271d440cd2870bcd2	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	2021-03-04T01:13:59.000Z	0x1f2a0d4e1c1eca594bd7f27f9952480ccda422c3453e0c5074a63aa46a2ed628

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_user	removed	log_index	block_number	block_timestamp	in_loan_decrease	transaction_hash
0xeda215b7666936ded834f76f3fbc6f323295110a	0x7a16ff8270133f063aab6c9977183d9e72835428	false	238	19457011	2024-03-17T20:42:59.000Z	7760979491218658850333	0xaf4b56ee2fbab387fb75afd60e6fb9ea9f335bbbdcfbfdb0c1c9b299be9a0f48
0xeda215b7666936ded834f76f3fbc6f323295110a	0x7a16ff8270133f063aab6c9977183d9e72835428	false	481	19451132	2024-03-17T00:53:11.000Z	2700157800149494997649	0xeac5ee00fdf8c5d75a7e2785f8257944f8d95ba0a77225df32cf881f346e7c9a
0xeda215b7666936ded834f76f3fbc6f323295110a	0xb56cc4efa8795d2a5ffccba30951364b15a15a6b	false	165	19453082	2024-03-17T07:28:23.000Z	1144324498044936973170	0x1f9cb3e77eeea4a8bf802ab228bb44131980a4fd019a343da5137dd7a84a9924

Example Query

Query with partition filter

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.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_monetary_policy`	`STRING`	Contract address of the monetary policy contract that governs interest rate calculations. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_base_pool`	`STRING`	Contract address of the base pool used in the metapool architecture. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	in__A	status	in__fee	gas_used	in__coin	in__name	out_anon0	signature	in__symbol	to_address	block_number	from_address	in__base_pool	block_timestamp	transaction_hash
1172301	200	true	4000000	781534	0xab5eb14c09d416f0ac63661e57edb7aecdb9befa	msUSD/FRAXBP	0xc3b19502f8c02be75f3f77fd673503520deb51dd	0xe339eb4f	msUSDFRAX	0xb9fc157394af804a3578134a6585c0dc9cc990d4	16371483	0x421af9abc87197a917b87f8d2b2d8b0213d47dbe	0xdcef968d416a41cdac0ed8702fac8128a64241a2	2023-01-09T19:58:11.000Z	0xfbaf92625a9e9e626730b435128f66b76026db699f943faf035f4e8971933e86
830628	50	true	4000000	830628	0x238533e6674c798fe00cb21cfd127c002b5bfcf1	US/3CRV	0xe82805a9b880e6dc520b6f017537f7781d55217f	0xe339eb4f	US	0xb9fc157394af804a3578134a6585c0dc9cc990d4	15763700	0x830bfab6ddab79f4ae6e845a2b30a28bc5b8cda4	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	2022-10-16T22:37:11.000Z	0x0caf8287a39f5609b610f87d2549a90fd5d109b78741828c8575ed8c6ce1c338
762252	50	true	4000000	762252	0x1b78ba1d8c437c9699af08a8d4fb63af2930c310	BLARG	0xa77b5d170f3aec2f72ca06490a7b9383a70ae5eb	0xe339eb4f	BLARG	0xb9fc157394af804a3578134a6585c0dc9cc990d4	15856909	0x830bfab6ddab79f4ae6e845a2b30a28bc5b8cda4	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	2022-10-29T23:11:23.000Z	0x00f1d673d3d6e4bf0f95cc9db7d99504174cf1f3acbab65c19607e0f6c23b166

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	in__A	status	in__fee	gas_used	in__coin	in__name	signature	in__symbol	to_address	block_number	from_address	in__base_pool	block_timestamp	transaction_hash
8500000	800	false	4000000	24593	0x94a18d9fe00bab617fad8b49b11e9f1f64db6b36	0x334352562f6c76555344	0xde7fe3bf	0x334352566c76555344	0xb9fc157394af804a3578134a6585c0dc9cc990d4	16550493	0x95622e85962bc154c76ab24e48fdf6cdaedad6e5	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	2023-02-03T19:57:47.000Z	0x1cdd11d82b8f993d8b1ab3d89a4183934baa23da712b37aee6e9495e6bf2638a
1239355	800	false	4000000	26124	0x94a18d9fe00bab617fad8b49b11e9f1f64db6b36	0x334352562f6c7655534400000000000000000000000000000000000000000000	0xde7fe3bf	0x334352566c765553440000000000000000000000000000000000000000000000	0xb9fc157394af804a3578134a6585c0dc9cc990d4	16550470	0x95622e85962bc154c76ab24e48fdf6cdaedad6e5	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	2023-02-03T19:53:11.000Z	0x213df51061db9f0f03527ca2344839d814ca20183cff732af48c71b6808d5aa0
28500	800	false	4000000	26124	0x94a18d9fe00bab617fad8b49b11e9f1f64db6b36	0x334352562f6c7655534400000000000000000000000000000000000000000000	0xde7fe3bf	0x334352566c765553440000000000000000000000000000000000000000000000	0xb9fc157394af804a3578134a6585c0dc9cc990d4	16550441	0x67f45e3c37677ec76ffbaf4b7be73b9e937a611c	0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	2023-02-03T19:47:23.000Z	0xff8d02f4b323dd9e071429d2377d7e30707ffc5b35290921bdbdcf85d5ad4f6f

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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<STRING>`	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.

Sample Data

gas	in__A	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	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	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	true	30000000	777629	TCLever test	[“0x1ee4de3cd1505ddb2e60c20651a4ab7ffabdc8f6”,“0x246be97fda42375c39e21377ad80d8290afdb994”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0xd0e24cb3e766581952dbf258b78e89c63a37f5fb	0xcd419bb5	tclevCVX	0xb9fc157394af804a3578134a6585c0dc9cc990d4	15721763	0x38a93e70b0d8343657f802c1c3fdb06ac8f8fe99		2022-10-11T02:04:23.000Z	0x6f9223d991fa3620d7295f5c7e96581bbbfcd6eb03054ebd85ed3b1d06472217

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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<STRING>`	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.

Sample Data

gas	in__A	status	in__fee	gas_used	in__name	in__coins	out_anon0	signature	in__symbol	to_address	block_number	from_address	in__asset_type	block_timestamp	transaction_hash	in__implementation_idx
923514	50	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	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	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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination.
`in_fees`	`ARRAY<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	out_anon0	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
470178	true	3615	90937557738649	0x4903b0d1	0xd51a44d3fae010294c616388b506acda1bfaae46	15241638	0xbeefbabeea323f07c59926295205d3b7a17e8638	2022-07-30T04:12:54.000Z	0xf81d2b0477a397cdf905aa83d9b8dfc91d658692e010c82275fb7a1a68fb17f4
476208	true	3615	90658024379759	0x4903b0d1	0xd51a44d3fae010294c616388b506acda1bfaae46	15243256	0xbeefbabeea323f07c59926295205d3b7a17e8638	2022-07-30T10:31:15.000Z	0xd79b506c18b9dfbc972ca8ad94a09dd2ae4d039ef213a4b521693aa8a23ffcfd
482664	true	3615	91021529341506	0x4903b0d1	0xd51a44d3fae010294c616388b506acda1bfaae46	15242007	0xbeefbabeea323f07c59926295205d3b7a17e8638	2022-07-30T05:42:44.000Z	0xe8d8d2a69a1cdf0c7ac6d5ae44e7592b425d35877b2b4e525685d6cadbbd77d8

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	in_i	status	gas_used	out_anon0	signature	to_address	block_number	from_address	block_timestamp	in__burn_amount	in__min_received	transaction_hash
155386	0	true	85982	1000293552763183938	0x1a4d01d2	0xc4c319e2d4d66cca4464c0c2b32c9bd23ebe784e	13311719	0xf872703f1c8f93fa186869bac83bac5a0c87c3c8	2021-09-28T02:55:02.000Z	1000000000000100000	998097299453723853	0x59d1a0ea0135fd79581a5e135d6bac6860474c7d9c2a7edd64c6cbe705c42a7f
155420	0	true	86001	500679667213414432828	0x1a4d01d2	0xc4c319e2d4d66cca4464c0c2b32c9bd23ebe784e	13313701	0xe954d86ced76843af8c3dd5ee355e79711ade218	2021-09-28T10:23:30.000Z	500609493444657419058	500079451828143606335	0xba5609408b29c8978b305fbe3869a60976113dce93a6ca250bf30bd42c120518
162329	1	true	89888	8063108850147201815242	0x1a4d01d2	0x9d0464996170c6b9e75eed71c68b99ddedf279e8	13316747	0x1424a2485d4f89c8d8d84b7809bd23995f2abd26	2021-09-28T21:50:39.000Z	8000000000000000000000	8040979559390809794273	0x0d1fbdaff2459464ccb86bdfd9205eb6b6a656eed99e5916ea0af623bc1e0284

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	in_i	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	true	163412	481878082747610037628	0x081579a5	0xd632f22692fac7611d2aa1c0d552930d43caed3b	22608627	0xa79828df1850e8a3a3064576f380d90aecdd3359	0x8e99d4ecb0690b81c7eb818e1903023620d46aff	1	2025-06-01T08:21:23.000Z	473371803968815414251	481733519322785754617	0x22692f5ffd0062d18d0c8db5aa214037982b628b6e678177706fbc61e2a2b6b6
396494	1	true	162959	57678180249874075644902	0x081579a5	0x5a6a4d54456819380173272a5e8e9b9904bdf41b	22609993	0xa79828df1850e8a3a3064576f380d90aecdd3359	0xa79828df1850e8a3a3064576f380d90aecdd3359	1	2025-06-01T12:56:59.000Z	58953848173968589847959	0	0x6071d377f56a181f2e43daa86423fb04fb6279df503fe85201636083903f53ab
435880	1	true	164041	73410442632675884729	0x081579a5	0xd632f22692fac7611d2aa1c0d552930d43caed3b	22607710	0xa79828df1850e8a3a3064576f380d90aecdd3359	0xa79828df1850e8a3a3064576f380d90aecdd3359	1	2025-06-01T05:16:47.000Z	75011474974975011909	0	0x4aa9bcd3be4489cfb9508c4e47c3334e0f826d48a4440680f8b9a5445ec1e518

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination.
`in_fees`	`ARRAY<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the liquidity operation. Numeric string representations in smallest token denomination.
`in_fees`	`ARRAY<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	in_buyer	log_index	in_sold_id	block_number	in_tokens_sold	block_timestamp	in_tokens_bought	transaction_hash
0xd51a44d3fae010294c616388b506acda1bfaae46	false	0x000000000dfde7deaf24138722987c9a6991e2d4	18	1	14669176	768013800	2022-04-27T22:36:48.000Z	300435257107	0x34d55d6746a9b8d08e2f0d127353c920e45d27fa6d733cd653f573e77f9015ef
0xd51a44d3fae010294c616388b506acda1bfaae46	false	0x000000000dfde7deaf24138722987c9a6991e2d4	58	2	14666946	105828020000000000000	2022-04-27T14:15:19.000Z	300492538635	0x937329f7c0ad89e57149fb2e29ce10dd38e279c1ef1989e3aa0183ce41ab8ec7
0xd51a44d3fae010294c616388b506acda1bfaae46	false	0x000000000dfde7deaf24138722987c9a6991e2d4	20	2	14665516	139420220000000000000	2022-04-27T08:50:16.000Z	400429195655	0x2eae2b246999ab8485b1d40a1893a4159782dc8942753fd959d24662cc945817

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	in_buyer	log_index	block_number	in_bought_id	in_tokens_sold	block_timestamp	in_tokens_bought	transaction_hash
0xb37d6c07482bc11cd28a1f11f1a6ad7b66dec933	false	0x0000000000036414940324055c43e75f56b7d016	50	16500917	1	1323310897512765248484	2023-01-27T21:45:23.000Z	1316622686787432250216	0x2407cdcdcd92551e85d9e262274b5fef361fb456fd179276242accca0e437292
0xb37d6c07482bc11cd28a1f11f1a6ad7b66dec933	false	0x0000000000a84d1a9b0063a910315c7ffa9cd248	49	16500660	1	1292645482778957232774	2023-01-27T20:53:35.000Z	1286167923419906248776	0xbf2bb5d92e9a9684b1eacb808ad0c57339cff88e1377b8c865108c3b34cdbe38
0xdcef968d416a41cdac0ed8702fac8128a64241a2	false	0x0000000000a84d1a9b0063a910315c7ffa9cd248	56	16494923	1	7038490405855898255910	2023-01-27T01:37:47.000Z	7032807577	0xb92d91d25bdf4f83579f99d5ebab9802bbd8287e28738d268821c3dc5442bb00

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

in_fee	address	removed	in_buyer	log_index	block_number	in_bought_id	in_tokens_sold	block_timestamp	in_tokens_bought	transaction_hash	in_packed_price_scale
120849561272996432081	0x86bf09acb47ab31686be413d614e9ded3666a1d3	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	158	18627160	2	1520911372953474484684	2023-11-22T12:04:59.000Z	20324757208001229446693	0x780e1eee0d8463ea88471c278b5123fe5123d4c5bff3a5e2f89a54bc5e0fce51	24444591442034648162975368862534873514562199829040873875
280398169941311561565	0x86bf09acb47ab31686be413d614e9ded3666a1d3	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	101	18630074	2	2997863299787139974794	2023-11-22T21:51:11.000Z	38051173199380247263116	0xb016b314766eee562b755bd9ba5cf0c8295a6e325b426c0f5dcefdf0bfd895bb	24705435044806456265589543823829458680205623008103013938
3488989405574626	0x954313005c56b555bdc41b84d6c63b69049d7847	false	0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	341	18626204	1	2875235036443806088540	2023-11-22T08:51:23.000Z	1443685339416918980	0xe4677628a3c3aa806ebfc75d5d68a9a368589d25c30d40dbbdd39b2a76335b9e	99266212294154381318076293902921987891456048489841877437

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	log_index	in_provider	block_number	block_timestamp	in_token_amounts	transaction_hash
0xdad60c5b748306ba5a0c9a3c3482a8d1153dad2a	false	296	0xac3203d77823496e421aa7e88cdc2f6c387d6182	14531658	2022-04-06T09:55:34.000Z	[“100000000000000000000”,“100000000”]	0x316ab41e168c033efdaf091247df343e9b65d9870db12cea11f04ee6e8d5ddaf
0x782115c863a05abf8795df377d89aad1aadf4dfa	false	102	0xb27dc5f8286f063f11491c8f349053cb37718bea	14535380	2022-04-06T23:48:53.000Z	[“65400000000000000”,“100000000000000”]	0x7ff433b76f968739791f9a6e51d6feccc5c9ca1071330233f25a4efea2a5d6df
0x7472764c28f843ba246f294c44de9456911a3454	false	61	0xb3fe63fa04ec5d65316fc1ffbd5dd32f3813cea8	14534633	2022-04-06T21:03:09.000Z	[“130000000000000000”,“3988117000000000000000000”]	0x883ccc2b0be089db9b374a3e93f19841cd1acbd155a1ae93b1922357baf13b0c

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	log_index	in_provider	block_number	in_coin_amount	block_timestamp	in_token_amount	transaction_hash
0xb576491f1e6e5e62f1d8f26062ee822b40b0e0d4	false	234	0xe7073fe7673f549c6b14b63412f0f2388a770b8a	15729312	172179932904686574	2022-10-12T03:21:47.000Z	1265655044515399296	0x4c9e23a88f1fca29a0bfc99e10b1eb731c70f46d6e8746be26b7163d9ab7fe77
0x21410232b484136404911780bc32756d5d1a9fa9	false	137	0x004a476b5b76738e34c86c7144554b9d34402f13	15729976	766145716717999582	2022-10-12T05:35:35.000Z	1396290751654146186	0xe013b5bdb36b6b22e7b835e9eac3d21d6b5d1b1b54ee35f5c2d3b07d6e3532e2
0xc26b89a667578ec7b3f11b2f98d6fd15c07c54ba	false	127	0x004a476b5b76738e34c86c7144554b9d34402f13	15729976	455620195422845639	2022-10-12T05:35:35.000Z	91597037105475924	0xe013b5bdb36b6b22e7b835e9eac3d21d6b5d1b1b54ee35f5c2d3b07d6e3532e2

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	in_buyer	log_index	block_number	in_bought_id	in_tokens_sold	block_timestamp	in_tokens_bought	transaction_hash
0x8301ae4fc9c624d1d396cbdaa1ed877821d7c511	false	0x0cb43ef0a6b2bd454fa5222c519184dafb1bf0c2	276	13997971	1	3000000000000000000	2022-01-13T15:23:14.000Z	2025200929217146139079	0xfa62865d30c6b3648678c53b185d4d4566543064263a6fc5dc80f9afcc7136a0
0xb576491f1e6e5e62f1d8f26062ee822b40b0e0d4	false	0x1424a2485d4f89c8d8d84b7809bd23995f2abd26	149	13999156	1	80000000000000000	2022-01-13T19:57:00.000Z	5944560070420901344	0x1b9f42b9039ce08ccc48bf615d89e5a291fb0e99fac58edbd0dc91dcda2b739f
0xb576491f1e6e5e62f1d8f26062ee822b40b0e0d4	false	0x1424a2485d4f89c8d8d84b7809bd23995f2abd26	137	13999100	1	1430000000000000000	2022-01-13T19:45:10.000Z	106156093492155621900	0xaaa46000320fc51b84306305ba10da25b0a2aaf0258295c182eb2b2cc9207968

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​BasePoolRegistry_BasePoolAdded_event

​Controller_Borrow_event

​Controller_CollectFees_event

​Controller_Liquidate_event

​Controller_RemoveCollateral_event

​Controller_Repay_event

​Controller_SetBorrowingDiscounts_event

​Controller_SetMonetaryPolicy_event

​Controller_UserState_event

​ControllerFactory_AddMarket_event

​CryptoFactory_deploy_pool_function

​CryptoSwapRegistry_PoolAdded_event

​CurveFactory_PlainPoolDeployed_event

​CurveStableswapFactoryNG_BasePoolAdded_event

​CurveStableswapFactoryNG_deploy_metapool_function

​CurveStableswapFactoryNG_deploy_plain_pool_function

​CurveStableswapFactoryNG_LiquidityGaugeDeployed_event

​CurveStableswapFactoryNG_MetaPoolDeployed_event

​CurveStableswapFactoryNG_PlainPoolDeployed_event

​CurveTricryptoFactory_LiquidityGaugeDeployed_event

​CurveTricryptoFactory_TricryptoPoolDeployed_event

​CurveTricryptoFactory_UpdateFeeReceiver_event

​CurveTricryptoFactory_UpdateGaugeImplementation_event

​CurveTricryptoFactory_UpdateMathImplementation_event

​CurveTricryptoFactory_UpdatePoolImplementation_event

​CurveTricryptoFactory_UpdateViewsImplementation_event

​CurveTwocryptoFactory_LiquidityGaugeDeployed_event

​CurveTwocryptoFactory_TwocryptoPoolDeployed_event

​CurveTwocryptoFactory_UpdateFeeReceiver_event

​CurveTwocryptoFactory_UpdateGaugeImplementation_event

​CurveTwocryptoFactory_UpdateMathImplementation_event

​CurveTwocryptoFactory_UpdatePoolImplementation_event

​CurveTwocryptoFactory_UpdateViewsImplementation_event

​Gauge_deposit_reward_token_function

​ibAUD-sAUD_TokenExchange_event

​ibCHF-sCHF_TokenExchange_event

​ibEUR-sEURpool_TokenExchange_event

​ibGBP-sGBP_TokenExchange_event

​ibJPY-sJPYpool_TokenExchange_event

​ibKRW-sKRWpool_TokenExchange_event

​LegacyMetaPoolFactory_BasePoolAdded_event

​LegacyMetaPoolFactory_deploy_metapool_function

​LendingController_Borrow_event

​LendingController_CollectFees_event

​LendingController_Liquidate_event

​LendingController_RemoveCollateral_event

​LendingController_Repay_event

​LendingController_SetBorrowingDiscounts_event

​LendingController_SetMonetaryPolicy_event

​LendingController_UserState_event

​MetapoolFactory_BasePoolAdded_event

​MetapoolFactory_deploy_metapool_function

​MetapoolFactory_deploy_metapool2_function

​MetapoolFactory_deploy_plain_pool_function

​MetapoolFactory_deploy_plain_pool2_function

​MetapoolFactory_deploy_plain_pool3_function

​MetapoolFactory_MetaPoolDeployed_event

​OneWayLendingFactory_NewVault_event

​PoolRegistry_PoolAdded_event

​StablePool_A_function

​StablePool_AddLiquidity_event

​StablePool_balances_function

​StablePool_remove_liquidity_one_coin_function

​StablePool_remove_liquidity_one_coin2_function

​StablePool_RemoveLiquidity_event

​StablePool_RemoveLiquidityImbalance_event

​StablePool_TokenExchange_event

​StablePool_TokenExchangeUnderlying_event

​StablePool_TokenExchangeV2_event

​StableRegistry_PoolAdded_event

​TriCryptoPool_AddLiquidity_event

​TriCryptoPool_RampAgamma_event

​TriCryptoPool_RemoveLiquidity_event

​TriCryptoPool_RemoveLiquidityOne_event

​TriCryptoPool_TokenExchange_event

Tables

BasePoolRegistry_BasePoolAdded_event

Controller_Borrow_event

Controller_CollectFees_event

Controller_Liquidate_event

Controller_RemoveCollateral_event

Controller_Repay_event

Controller_SetBorrowingDiscounts_event

Controller_SetMonetaryPolicy_event

Controller_UserState_event

ControllerFactory_AddMarket_event

CryptoFactory_deploy_pool_function

CryptoSwapRegistry_PoolAdded_event

CurveFactory_PlainPoolDeployed_event

CurveStableswapFactoryNG_BasePoolAdded_event

CurveStableswapFactoryNG_deploy_metapool_function

CurveStableswapFactoryNG_deploy_plain_pool_function

CurveStableswapFactoryNG_LiquidityGaugeDeployed_event

CurveStableswapFactoryNG_MetaPoolDeployed_event

CurveStableswapFactoryNG_PlainPoolDeployed_event

CurveTricryptoFactory_LiquidityGaugeDeployed_event

CurveTricryptoFactory_TricryptoPoolDeployed_event

CurveTricryptoFactory_UpdateFeeReceiver_event

CurveTricryptoFactory_UpdateGaugeImplementation_event

CurveTricryptoFactory_UpdateMathImplementation_event

CurveTricryptoFactory_UpdatePoolImplementation_event

CurveTricryptoFactory_UpdateViewsImplementation_event

CurveTwocryptoFactory_LiquidityGaugeDeployed_event

CurveTwocryptoFactory_TwocryptoPoolDeployed_event

CurveTwocryptoFactory_UpdateFeeReceiver_event

CurveTwocryptoFactory_UpdateGaugeImplementation_event

CurveTwocryptoFactory_UpdateMathImplementation_event

CurveTwocryptoFactory_UpdatePoolImplementation_event

CurveTwocryptoFactory_UpdateViewsImplementation_event

Gauge_deposit_reward_token_function

ibAUD-sAUD_TokenExchange_event

ibCHF-sCHF_TokenExchange_event

ibEUR-sEURpool_TokenExchange_event

ibGBP-sGBP_TokenExchange_event

ibJPY-sJPYpool_TokenExchange_event

ibKRW-sKRWpool_TokenExchange_event

LegacyMetaPoolFactory_BasePoolAdded_event

LegacyMetaPoolFactory_deploy_metapool_function

LendingController_Borrow_event

LendingController_CollectFees_event

LendingController_Liquidate_event

LendingController_RemoveCollateral_event

LendingController_Repay_event

LendingController_SetBorrowingDiscounts_event

LendingController_SetMonetaryPolicy_event

LendingController_UserState_event

MetapoolFactory_BasePoolAdded_event

MetapoolFactory_deploy_metapool_function

MetapoolFactory_deploy_metapool2_function

MetapoolFactory_deploy_plain_pool_function

MetapoolFactory_deploy_plain_pool2_function

MetapoolFactory_deploy_plain_pool3_function

MetapoolFactory_MetaPoolDeployed_event

OneWayLendingFactory_NewVault_event

PoolRegistry_PoolAdded_event

StablePool_A_function

StablePool_AddLiquidity_event

StablePool_balances_function

StablePool_remove_liquidity_one_coin_function

StablePool_remove_liquidity_one_coin2_function

StablePool_RemoveLiquidity_event

StablePool_RemoveLiquidityImbalance_event

StablePool_TokenExchange_event

StablePool_TokenExchangeUnderlying_event

StablePool_TokenExchangeV2_event

StableRegistry_PoolAdded_event

TriCryptoPool_AddLiquidity_event

TriCryptoPool_RampAgamma_event

TriCryptoPool_RemoveLiquidity_event

TriCryptoPool_RemoveLiquidityOne_event

TriCryptoPool_TokenExchange_event

TwoCryptoPool_AddLiquidity_event

TwoCryptoPool_balances_function

TwoCryptoPool_RampAgamma_event

TwoCryptoPool_RemoveLiquidity_event