meanfinance_v2_ethereum

Tables

DCAHub_Swapped_event

DCA (Dollar-Cost Averaging) swap execution events emitted by Mean Finance DCAHub contracts. Contains swap parameters including token pairs, exchange ratios, amounts swapped, fees charged, and reward distributions for automated recurring trades.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardRecipient`	`STRING`	Address designated to receive rewards generated from the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_callbackHandler`	`STRING`	Contract address designated to handle callback functions during swap execution. Hex-encoded, 0x-prefixed, 42-character string.
`in_swapInformation`	`STRUCT<tokens ARRAY<STRUCT<token STRING, reward STRING, toProvide STRING, platformFee STRING>>, pairs ARRAY<STRUCT<tokenA STRING, tokenB STRING, totalAmountToSwapTokenA STRING, totalAmountToSwapTokenB STRING, ratioAToB STRING, ratioBToA STRING, intervalsInSwap STRING>>>`	Structured swap execution data containing token and trading pair information. Includes two arrays: tokens (with contract addresses, rewards, amounts to provide, and platform fees) and pairs (with token addresses, swap amounts, exchange ratios, and interval identifiers).
`in_borrowed`	`ARRAY<STRING>`	Array of amounts borrowed for each token in the swap. String-encoded integer values representing borrowed quantities in the smallest unit of each respective token, indexed to match the tokens array in the swap information structure.
`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.

Sample Data

in_fee	address	removed	in_sender	log_index	in_borrowed	block_number	block_timestamp	transaction_hash	in_callbackHandler	in_rewardRecipient	in_swapInformation
6000	0xa5adc5484f9997fbf7d405b9aa62a7d88883c345	false	0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d	66	[“0”,“0”]	16451469	2023-01-21T00:02:23.000Z	0x3fdd917dd7f0887a9455674864dd92c0247f40d0c71f8354788f1c9e25a730eb	0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d	0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d	{“pairs”:[{“tokenA”:“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“tokenB”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“ratioAToB”:“22727272727”,“ratioBToA”:“4400”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“100000000”}],“tokens”:[{“token”:“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“reward”:“0”,“toProvide”:“438020”,“platformFee”:“660”},{“token”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“reward”:“100000000”,“toProvide”:“0”,“platformFee”:“0”}]}
6000	0xa5adc5484f9997fbf7d405b9aa62a7d88883c345	false	0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d	62	[“0”,“0”]	16451536	2023-01-21T00:15:47.000Z	0x91e97aa7c2a8b880c1fcc42786f2cbec227dc2bac89091c279496415a5d8e161	0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d	0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d	{“pairs”:[{“tokenA”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“tokenB”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“ratioAToB”:“605876318199024”,“ratioBToA”:“1650501876311182234670”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“7655266753139110198776”,“totalAmountToSwapTokenB”:“0”}],“tokens”:[{“token”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“reward”:“7655266753139110198776”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“reward”:“0”,“toProvide”:“4617273183464815896”,“platformFee”:“6957217252834981”}]}
6000	0xa5adc5484f9997fbf7d405b9aa62a7d88883c345	false	0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d	384	[“0”,“0”]	16451504	2023-01-21T00:09:23.000Z	0xa80092c17c9f5c4a30d1835eae87af64384a81b0676bc1257b370a3b6c15a25b	0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d	0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d	{“pairs”:[{“tokenA”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“tokenB”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“ratioAToB”:“602027510296068”,“ratioBToA”:“1661053661”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“377336959”,“totalAmountToSwapTokenB”:“7142857142857142”}],“tokens”:[{“token”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“reward”:“365525681”,“toProvide”:“0”,“platformFee”:“17797”},{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“reward”:“0”,“toProvide”:“219002120291739779”,“platformFee”:“340750844954189”}]}

Example Query

Query with partition filter

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

EulerERC4626Factory_CreateERC4626_event

ERC4626 vault creation events from Mean Finance’s Euler integration on Ethereum, recording when new tokenized vaults are deployed for specific underlying assets. Used to track vault deployment history and map vault addresses to their underlying tokens (DAI, WBTC, USDC, WETH).

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_vault	log_index	block_number	block_timestamp	transaction_hash
0x1e8020cfb10b6a6a9b5f06e3abae140f7de541e1	false	0x6b175474e89094c44da98b954eedeac495271d0f	0x4169df1b7820702f566cc10938da51f6f597d264	204	15580629	2022-09-21T08:36:59.000Z	0xaf27d84034171ba78f06d66466fef174245aab5e85cba101960dc30b4ba91a15
0x1e8020cfb10b6a6a9b5f06e3abae140f7de541e1	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0x60897720aa966452e8706e74296b018990aec527	198	15499207	2022-09-08T22:34:33.000Z	0xa6f0382c9820ae890774b27348d9d60b5721c302cd7702a2f774a863e0dba991
0x1e8020cfb10b6a6a9b5f06e3abae140f7de541e1	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x2dbfea3103b35a94c66aaba25b7bc5a6edb433f2	195	16045179	2022-11-25T06:21:47.000Z	0xfedc2bd052cdf52c3e2fe4b67b0daff002c4c9c6f0748c3c151b5ec32b3dda6f

Example Query

Query with partition filter

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

StakeableEulerERC4626Factory_CreateERC4626_event

ERC4626 vault creation events from Mean Finance’s Euler-integrated factory contract on Ethereum, capturing newly deployed tokenized vaults with their underlying assets. Used to track vault deployments and identify available yield-bearing wrapper contracts for DeFi integration 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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_vault	log_index	block_number	block_timestamp	transaction_hash
0x27d54d93c8f89988e20fc8ffd911218bac44a0f6	false	0x5f98805a4e8be255a32880fdec7f6728c6568ba0	0xb95e6eee428902c234855990e18a632fa34407dc	253	16722336	2023-02-27T21:54:11.000Z	0x1d210184c6d906019765ae3fc26ceafddb8bf1d34ca64cfab100b706eb947f97
0x27d54d93c8f89988e20fc8ffd911218bac44a0f6	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0x7c6d161b367ec0605260628c37b8dd778446256b	140	16784422	2023-03-08T15:26:59.000Z	0x507476e52c07fd5b1fc2799b51a92e63e55eb5f41c2aad4244ead7f187622525
0x27d54d93c8f89988e20fc8ffd911218bac44a0f6	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x48e345cb84895eab4db4c44ff9b619ca0be671d9	97	16241125	2022-12-22T15:25:35.000Z	0x0547eed9d3551e7f0da7fac267100c1654a4fe5cf9aacb310af19a60b822980c

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

DCAHub_Swapped_event

EulerERC4626Factory_CreateERC4626_event

StakeableEulerERC4626Factory_CreateERC4626_event

​Tables

​DCAHub_Swapped_event

​EulerERC4626Factory_CreateERC4626_event

​StakeableEulerERC4626Factory_CreateERC4626_event

Tables

DCAHub_Swapped_event

EulerERC4626Factory_CreateERC4626_event

StakeableEulerERC4626Factory_CreateERC4626_event