meanfinance_v2_bsc

Tables

BeefyWrapperFactory_ProxyCreated_event

Proxy creation events from Mean Finance’s Beefy wrapper factory contract on BNB Smart Chain. Tracks deployment of new wrapper proxy contracts that integrate Beefy vault positions into Mean Finance’s DCA (Dollar Cost Averaging) 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_proxy`	`STRING`	Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_proxy	log_index	block_number	block_timestamp	transaction_hash
0x85b792c67cee281064eb7a3af0fe2a76e9a7849e	false	0x02d7eea2c017479ad319a0f24d6ad7a07f701d9d	189	28960510	2023-06-09T20:51:12.000Z	0xc4a8f35fd975296f0b6208f1b97d1a66f35f398b78b62b29d58a61a0d9623f59
0x85b792c67cee281064eb7a3af0fe2a76e9a7849e	false	0x353699126117ba6ed8f5d5928dfa797564e99e40	122	28960533	2023-06-09T20:52:21.000Z	0xe7b4bc02a1c797192f573035ee161388e3dd1e0c57328c099bfa7971f1ca8238
0x85b792c67cee281064eb7a3af0fe2a76e9a7849e	false	0x1f2ae034a096f8e3faf8216d3843075474558773	104	28960444	2023-06-09T20:47:54.000Z	0x2b6218b18b443fbe92b3bafd1d83ebc17036f49eb8c4311c273edf406954cb71

Example Query

Query with partition filter

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

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	0xeeae844d04ee45c37636d8db8c9482200177dc93	453	[“0”,“0”,“0”,“0”]	29050562	2023-06-13T00:03:28.000Z	0x5b206a265816d8fac2a03c8f0b07042b13f3afc6a74b3c2612a3ac723d67acc7	0x3fa18d0cbaf4c9d5078e758b3deade077ca525cb	0x3fa18d0cbaf4c9d5078e758b3deade077ca525cb	{“pairs”:[{“tokenA”:“0x55d398326f99059ff775485246999027b3197955”,“tokenB”:“0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c”,“ratioAToB”:“4336178176370813”,“ratioBToA”:“230617829647617300939”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“3012500000000000000”,“totalAmountToSwapTokenB”:“3625000000000000”},{“tokenA”:“0x55d398326f99059ff775485246999027b3197955”,“tokenB”:“0xcc42724c6683b7e57334c4e856f4c9965ed682bd”,“ratioAToB”:“1555148908917658754”,“ratioBToA”:“643025239747602523”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“1428571428571428571”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“tokenB”:“0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c”,“ratioAToB”:“4317416457991538”,“ratioBToA”:“231619999999999992690”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“6965277777777777”}],“tokens”:[{“token”:“0x55d398326f99059ff775485246999027b3197955”,“reward”:“3608843749444942612”,“toProvide”:“0”,“platformFee”:“1253984448708919”},{“token”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“reward”:“0”,“toProvide”:“1606037799513888658”,“platformFee”:“2419946458333332”},{“token”:“0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c”,“reward”:“0”,“toProvide”:“2413676663135870”,“platformFee”:“19594105134475”},{“token”:“0xcc42724c6683b7e57334c4e856f4c9965ed682bd”,“reward”:“0”,“toProvide”:“2211643912610756128”,“platformFee”:“3332461947680697”}]}
6000	0xa5adc5484f9997fbf7d405b9aa62a7d88883c345	false	0x14e9f27375ef0fb0e3f2d1957989245884bedb78	14	[“0”,“0”]	29050603	2023-06-13T00:05:39.000Z	0xdb8f69f3f4362ecac54c691a6c24ac730355a196ea2d8cd9a85c8ca1e20fb2a7	0x3fa18d0cbaf4c9d5078e758b3deade077ca525cb	0x3fa18d0cbaf4c9d5078e758b3deade077ca525cb	{“pairs”:[{“tokenA”:“0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82”,“tokenB”:“0xe9e7cea3dedca5984780bafc599bd69add087d56”,“ratioAToB”:“1346129877986195100”,“ratioBToA”:“742870369608017311”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“1155724970643999404”}],“tokens”:[{“token”:“0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82”,“reward”:“0”,“toProvide”:“854690343845038942”,“platformFee”:“1287830754161284”},{“token”:“0xe9e7cea3dedca5984780bafc599bd69add087d56”,“reward”:“1155724970643999404”,“toProvide”:“0”,“platformFee”:“0”}]}
6000	0xa5adc5484f9997fbf7d405b9aa62a7d88883c345	false	0xeeae844d04ee45c37636d8db8c9482200177dc93	277	[“0”,“0”]	29050650	2023-06-13T00:08:10.000Z	0xbb79cabc06f97a1500896cdaf41efd3ff2aeecfb0cf25ca50c3c202993526dae	0x3fa18d0cbaf4c9d5078e758b3deade077ca525cb	0x3fa18d0cbaf4c9d5078e758b3deade077ca525cb	{“pairs”:[{“tokenA”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“tokenB”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“ratioAToB”:“1743384162248200018464”,“ratioBToA”:“573597042840196”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“1016666666666666666”}],“tokens”:[{“token”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“reward”:“0”,“toProvide”:“580532787083206”,“platformFee”:“874735490331”},{“token”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“reward”:“1016666666666666666”,“toProvide”:“0”,“platformFee”:“0”}]}

Example Query

Query with partition filter

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

VenusERC4626Factory_CreateERC4626_event

ERC4626 vault creation events from Mean Finance’s Venus protocol integration on BNB Smart Chain, recording each new tokenized vault wrapper deployment with its underlying asset address. Used for tracking vault deployment history and mapping vault-to-asset relationships in the Mean Finance DeFi ecosystem.

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
0x95233d36317fbb3f989369f76532239db0c9f35f	false	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	0xc492ea9b5d9e3f4188a6c57f5f146dbfa37ac6d6	188	29305570	2023-06-21T21:14:01.000Z	0xf2d810fe12e48b9dcc0fb43f1a3438e22e5b3a61a9031144a1cc63ff43d97125
0x95233d36317fbb3f989369f76532239db0c9f35f	false	0xf8a0bf9cf54bb92f17374d9e9a321e6a111a51bd	0x61d3fbabf6d7b310573ecc5331969d84a3f3c78f	180	29305570	2023-06-21T21:14:01.000Z	0x6eaccd2d1b9a96e12fec1b7593a24f9ce3b3c4dd1048964696fbb02fab2c069e
0x95233d36317fbb3f989369f76532239db0c9f35f	false	0x8ff795a6f4d97e7887c79bea79aba5cc76444adf	0x8e58d175ee3a2be5a1b7c6ebdc4bd9ca082d76bc	178	29305570	2023-06-21T21:14:01.000Z	0x241e78984183428a4eaf62cf041eaad82f0118a37bc80f5e9c0ee0be319b3ea1

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BeefyWrapperFactory_ProxyCreated_event

DCAHub_Swapped_event

VenusERC4626Factory_CreateERC4626_event

​Tables

​BeefyWrapperFactory_ProxyCreated_event

​DCAHub_Swapped_event

​VenusERC4626Factory_CreateERC4626_event

Tables

BeefyWrapperFactory_ProxyCreated_event

DCAHub_Swapped_event

VenusERC4626Factory_CreateERC4626_event