Skip to main content

Tables

AaveV3ERC4626Factory_CreateERC4626_event

ERC-4626 vault creation events from Mean Finance’s Aave V3 vault factory on Arbitrum, mapping underlying assets to their corresponding tokenized vault addresses. Used for tracking vault deployments and identifying which assets have been wrapped into yield-bearing ERC-4626 vaults backed by Aave V3.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_vaultSTRINGContract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_assetin_vaultlog_indexblock_numberblock_timestamptransaction_hash
0x65625425ef808b123e005051c9cc023eabf05cf0false0xd22a58f79e9481d1a88e00c343885a588b34b68b0xeaa03169250b53b6ebf2f219b8ef9915d14df3050327933822022-10-26T16:04:03.000Z0x771f32bbdd3f90c319d19bee2327b25165a56487762ac2397190bca4fb20980d
0x65625425ef808b123e005051c9cc023eabf05cf0false0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb90x8fd68006d23df27fc36d3e3eda1fdcc4f0baa8c60327920452022-10-26T15:58:09.000Z0xb121c23434f1c54fd4ba1cac0eac97dfd7a68f1ffa20332494c0b5b061417acd
0x65625425ef808b123e005051c9cc023eabf05cf0false0x82af49447d8a07e3bd95bd0d56f35241523fbab10x4b6e42407db855fb101b9d39e084e36c90a526520327916712022-10-26T15:56:33.000Z0xcac81276adfeb751d3de8b289c8d689dbc7e61e66cfdbe05aa9adfa5c90299c1
Query with partition filter
SELECT *
FROM `tt-contracts.meanfinance_v2_arbitrum.AaveV3ERC4626Factory_CreateERC4626_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardRecipientSTRINGAddress designated to receive rewards generated from the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_callbackHandlerSTRINGContract address designated to handle callback functions during swap execution. Hex-encoded, 0x-prefixed, 42-character string.
in_swapInformationSTRUCT<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_borrowedARRAY<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_feeSTRINGFee 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_feeaddressremovedin_senderlog_indexin_borrowedblock_numberblock_timestamptransaction_hashin_callbackHandlerin_rewardRecipientin_swapInformation
60000xa5adc5484f9997fbf7d405b9aa62a7d88883c345false0x59c5c9045374693b384bc023fdca4685c7ec1a9e22[“0”,“0”,“0”,“0”]1821802302024-02-19T01:36:38.000Z0x87aa35e4d0f51da4d787e7473c5790570ffb6ace8ca7abb49da225fbf5d1e3820xa9cffe466ba8a72707d1104de239c9ab477e24930xa9cffe466ba8a72707d1104de239c9ab477e2493{“pairs”:[{“tokenA”:“0x6694340fc020c5e6b96567843da2df01b2ce1eb6”,“tokenB”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“ratioAToB”:“343715570153893934”,“ratioBToA”:“2909382311520725430”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“500000000000000000”},{“tokenA”:“0xda10009cbd5d07dd0cecc66161fc93d7c9000da1”,“tokenB”:“0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a”,“ratioAToB”:“20857379111239979”,“ratioBToA”:“47944662398215842122”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“4000000000000000000”,“totalAmountToSwapTokenB”:“0”}],“tokens”:[{“token”:“0x6694340fc020c5e6b96567843da2df01b2ce1eb6”,“reward”:“0”,“toProvide”:“1448145045559441083”,“platformFee”:“2182036733640544”},{“token”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“reward”:“500000000000000000”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0xda10009cbd5d07dd0cecc66161fc93d7c9000da1”,“reward”:“4000000000000000000”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a”,“reward”:“0”,“toProvide”:“83054083620957596”,“platformFee”:“125144274667439”}]}
60000xa5adc5484f9997fbf7d405b9aa62a7d88883c345false0x59c5c9045374693b384bc023fdca4685c7ec1a9e97[“0”,“0”,“0”,“0”,“0”,“0”,“0”,“0”]1821793892024-02-19T01:32:53.000Z0xd08b8d4e79103ccf29077fae0180f19e0a999eb47ca4eea3901a18a76155667a0xa9cffe466ba8a72707d1104de239c9ab477e24930xa9cffe466ba8a72707d1104de239c9ab477e2493{“pairs”:[{“tokenA”:“0x0669cec75e88f721efbe7d78d1783786a2f36bfe”,“tokenB”:“0x2285b7dc4426c29ed488c65c72a9feaadb44c7ae”,“ratioAToB”:“19207383”,“ratioBToA”:“52063311311545161”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“30737604”},{“tokenA”:“0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8”,“tokenB”:“0x2285b7dc4426c29ed488c65c72a9feaadb44c7ae”,“ratioAToB”:“2829800”,“ratioBToA”:“353381770495875700”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“4844366”},{“tokenA”:“0x13ad51ed4f1b7e9dc168d8a00cb3f4ddd85efa60”,“tokenB”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“ratioAToB”:“3287185”,“ratioBToA”:“304211583962050369”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“5833333”},{“tokenA”:“0x5979d7b546e38e414f7e9822514be443a4800529”,“tokenB”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“ratioAToB”:“1157096868305626600”,“ratioBToA”:“864231878411641979”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“1928571428571428”},{“tokenA”:“0x5979d7b546e38e414f7e9822514be443a4800529”,“tokenB”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“ratioAToB”:“3318001537”,“ratioBToA”:“301386237705716”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“2500000”},{“tokenA”:“0x5979d7b546e38e414f7e9822514be443a4800529”,“tokenB”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“ratioAToB”:“3317300336”,“ratioBToA”:“301449943803557”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“5000000”}],“tokens”:[{“token”:“0x0669cec75e88f721efbe7d78d1783786a2f36bfe”,“reward”:“0”,“toProvide”:“1593100089515892306”,“platformFee”:“2400452169034493”},{“token”:“0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8”,“reward”:“0”,“toProvide”:“1704207036156978277”,“platformFee”:“2567865951015035”},{“token”:“0x13ad51ed4f1b7e9dc168d8a00cb3f4ddd85efa60”,“reward”:“0”,“toProvide”:“1766581918085412719”,“platformFee”:“2661851207562148”},{“token”:“0x2285b7dc4426c29ed488c65c72a9feaadb44c7ae”,“reward”:“35581970”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0x5979d7b546e38e414f7e9822514be443a4800529”,“reward”:“0”,“toProvide”:“3909774704649973”,“platformFee”:“5891172332471”},{“token”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“reward”:“1928571428571428”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“reward”:“8333333”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“reward”:“5000000”,“toProvide”:“0”,“platformFee”:“0”}]}
60000xa5adc5484f9997fbf7d405b9aa62a7d88883c345false0x59c5c9045374693b384bc023fdca4685c7ec1a9e120[“0”,“0”,“0”,“0”,“0”,“0”,“0”,“0”,“0”,“0”,“0”,“0”,“0”,“0”]1821789752024-02-19T01:31:01.000Z0xfff220f5e30eeff64b788437da05421e219098333f3c72928319c9790048bbb00xa9cffe466ba8a72707d1104de239c9ab477e24930xa9cffe466ba8a72707d1104de239c9ab477e2493{“pairs”:[{“tokenA”:“0x2285b7dc4426c29ed488c65c72a9feaadb44c7ae”,“tokenB”:“0x4b6e42407db855fb101b9d39e084e36c90a52652”,“ratioAToB”:“347475496146153”,“ratioBToA”:“2877900776”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“35225962”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0x2285b7dc4426c29ed488c65c72a9feaadb44c7ae”,“tokenB”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“ratioAToB”:“518040769808583935”,“ratioBToA”:“1930350”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“9614344”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0x2285b7dc4426c29ed488c65c72a9feaadb44c7ae”,“tokenB”:“0x9ca453e4585d1acde7bd13f7da2294cfaaec4376”,“ratioAToB”:“1602”,“ratioBToA”:“62391665110”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“64219080”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“tokenB”:“0x8fd68006d23df27fc36d3e3eda1fdcc4f0baa8c6”,“ratioAToB”:“36778227289”,“ratioBToA”:“2719”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“5960159”},{“tokenA”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“tokenB”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“ratioAToB”:“52110474205”,“ratioBToA”:“1919”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“244907359”},{“tokenA”:“0x30303a134e1850f1eda2e36dad15d052402131a7”,“tokenB”:“0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8”,“ratioAToB”:“667144566062459”,“ratioBToA”:“1498925496616243210135”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“4397428327776300729”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0x3082cc23568ea640225c2467653db90e9250aaa0”,“tokenB”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“ratioAToB”:“112130389111847”,“ratioBToA”:“8918188975537396747181”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“1250000000000000”},{“tokenA”:“0x3082cc23568ea640225c2467653db90e9250aaa0”,“tokenB”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“ratioAToB”:“321289”,“ratioBToA”:“3112455204034812153”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“24973728”},{“tokenA”:“0x4b6e42407db855fb101b9d39e084e36c90a52652”,“tokenB”:“0x8fd68006d23df27fc36d3e3eda1fdcc4f0baa8c6”,“ratioAToB”:“2127557354”,“ratioBToA”:“470022581433003”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“37017319”},{“tokenA”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“tokenB”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“ratioAToB”:“1417292014103319295193”,“ratioBToA”:“705570898621532”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“371428571428571”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“tokenB”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“ratioAToB”:“2865322837”,“ratioBToA”:“349000813121619”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“166052598”},{“tokenA”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“tokenB”:“0xda10009cbd5d07dd0cecc66161fc93d7c9000da1”,“ratioAToB”:“2865856397901648598750”,“ratioBToA”:“348935836677717”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“5020591270371753273”},{“tokenA”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“tokenB”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“ratioAToB”:“2864717301”,“ratioBToA”:“349074583842261”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“5977561”},{“tokenA”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“tokenB”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“ratioAToB”:“2865322837”,“ratioBToA”:“349000813121619”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“2333333”},{“tokenA”:“0x8fd68006d23df27fc36d3e3eda1fdcc4f0baa8c6”,“tokenB”:“0x9ca453e4585d1acde7bd13f7da2294cfaaec4376”,“ratioAToB”:“2168”,“ratioBToA”:“46124508509”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“42569645”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0x8fd68006d23df27fc36d3e3eda1fdcc4f0baa8c6”,“tokenB”:“0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8”,“ratioAToB”:“450058000684768”,“ratioBToA”:“2221935836”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“5034227”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“tokenB”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“ratioAToB”:“2021688”,“ratioBToA”:“494636065352835897”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“31669618”},{“tokenA”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“tokenB”:“0xda10009cbd5d07dd0cecc66161fc93d7c9000da1”,“ratioAToB”:“2022064873987729114”,“ratioBToA”:“494543974757789345”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“1250000000000000000”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“tokenB”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“ratioAToB”:“2021688”,“ratioBToA”:“494636065352835897”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“1366666”},{“tokenA”:“0x9ca453e4585d1acde7bd13f7da2294cfaaec4376”,“tokenB”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“ratioAToB”:“65402223675”,“ratioBToA”:“1529”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“9193136”},{“tokenA”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“tokenB”:“0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8”,“ratioAToB”:“317684265907578”,“ratioBToA”:“3147779438”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“62359802”,“totalAmountToSwapTokenB”:“0”},{“tokenA”:“0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8”,“tokenB”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“ratioAToB”:“3147779438”,“ratioBToA”:“317684265822087”,“intervalsInSwap”:“0x40”,“totalAmountToSwapTokenA”:“0”,“totalAmountToSwapTokenB”:“3604778”}],“tokens”:[{“token”:“0x2285b7dc4426c29ed488c65c72a9feaadb44c7ae”,“reward”:“109059386”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“reward”:“0”,“toProvide”:“483996”,“platformFee”:“729”},{“token”:“0x30303a134e1850f1eda2e36dad15d052402131a7”,“reward”:“4397428327776300729”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0x3082cc23568ea640225c2467653db90e9250aaa0”,“reward”:“0”,“toProvide”:“88477397840634374762”,“platformFee”:“133316018845757470”},{“token”:“0x4b6e42407db855fb101b9d39e084e36c90a52652”,“reward”:“0”,“toProvide”:“29505758352226701”,“platformFee”:“44458701685926”},{“token”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“reward”:“0”,“toProvide”:“60702153224302369”,“platformFee”:“93907958506877”},{“token”:“0x8fd68006d23df27fc36d3e3eda1fdcc4f0baa8c6”,“reward”:“90581350”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“reward”:“0”,“toProvide”:“20499666525688759921”,“platformFee”:“32771973670048357”},{“token”:“0x9ca453e4585d1acde7bd13f7da2294cfaaec4376”,“reward”:“0”,“toProvide”:“208285”,“platformFee”:“313”},{“token”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“reward”:“514182513”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0xda10009cbd5d07dd0cecc66161fc93d7c9000da1”,“reward”:“2504384292803272856”,“toProvide”:“0”,“platformFee”:“3791371638726992”},{“token”:“0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8”,“reward”:“0”,“toProvide”:“26037624768269245”,“platformFee”:“39232985587547”},{“token”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“reward”:“5977561”,“toProvide”:“0”,“platformFee”:“0”},{“token”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“reward”:“32278505”,“toProvide”:“0”,“platformFee”:“0”}]}
Query with partition filter
SELECT *
FROM `tt-contracts.meanfinance_v2_arbitrum.DCAHub_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100