> ## Documentation Index > Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # meanfinance_v2_optimism > Tables in tt-contracts.meanfinance_v2_optimism ## Tables ### AaveV3ERC4626Factory\_CreateERC4626\_event ERC4626 vault creation events from Mean Finance's Aave V3 factory contract on Optimism, mapping underlying assets to their corresponding tokenized vault addresses. Used for tracking vault deployments and identifying asset-vault relationships in the Mean Finance ecosystem. | 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. | | address | removed | in\_asset | in\_vault | log\_index | block\_number | block\_timestamp | transaction\_hash | | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | | 0xffd70dfac9fdedc2054860aafe7ea0b13d03c1a7 | false | 0x1f32b1c2345538c0c6f582fcb022739c4a194ebb | 0xd81cba2ce0c4c2a9d0db16529ee1d1bc532d8c53 | 0 | 81137867 | 2023-03-15T15:22:27.000Z | 0x2c1c5d3a10d6671d2ace1b8ed4b3cb115d8632edc6d7634bd0b5a38de87c09bb | | 0xffd70dfac9fdedc2054860aafe7ea0b13d03c1a7 | false | 0x4200000000000000000000000000000000000042 | 0x348a1213fa28a43855e5bb103bdfd7f357543626 | 0 | 81139851 | 2023-03-15T15:29:28.000Z | 0x8b812235a5a5d3e8b4848fc9231b5c5ebc2699e469607dc5117bf87e19628a89 | | 0xffd70dfac9fdedc2054860aafe7ea0b13d03c1a7 | false | 0x7f5c764cbc14f9669b88837ca1490cca17c31607 | 0xfe7296c374d996d09e2ffe533eeb85d1896e1b14 | 0 | 25789684 | 2022-09-27T16:21:56.000Z | 0x89d77a0482b710adb212e21e9ae5467d98bbf3b6bc123679e0114b32058dbdab | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.meanfinance_v2_optimism.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. | 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>, pairs ARRAY>>` | 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` | 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. | | 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 | 249 | \["0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"] | 73760507 | 2023-02-12T00:00:41.000Z | 0x48bf09650d7e42a80904a03d3150aa061afff72d141110d938439f2f4f4a3eb3 | 0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d | 0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d | \{"pairs":\[\{"tokenA":"0x217d47011b23bb961eb6d93ca9945b7501a5bb11","tokenB":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","ratioAToB":"688676","ratioBToA":"1452061343452720495","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"694429986"},\{"tokenA":"0x296f55f8fb28e498b858d0bcda06d955b2cb3f97","tokenB":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","ratioAToB":"711215","ratioBToA":"1406044323330119046","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"6959142"},\{"tokenA":"0x2e3d870790dc77a83dd1d18184acc7439a53f475","tokenB":"0x4200000000000000000000000000000000000006","ratioAToB":"650092546410019","ratioBToA":"1538242524887049736107","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"191396896508"},\{"tokenA":"0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6","tokenB":"0x4200000000000000000000000000000000000006","ratioAToB":"4550022915456960","ratioBToA":"219779112892570945782","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"10000000000000"},\{"tokenA":"0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6","tokenB":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","ratioAToB":"7012130","ratioBToA":"142610000000000000","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"1000000"},\{"tokenA":"0x4200000000000000000000000000000000000006","tokenB":"0x4200000000000000000000000000000000000042","ratioAToB":"618400080385852341026","ratioBToA":"1617076115798768","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"32364463929582163","totalAmountToSwapTokenB":"29164182527739844306"},\{"tokenA":"0x4200000000000000000000000000000000000006","tokenB":"0x50c5725949a6f0c72e6c4a641f24049a917db0cb","ratioAToB":"9626176597427497139502","ratioBToA":"103883404784745","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"1666666666666666","totalAmountToSwapTokenB":"0"},\{"tokenA":"0x4200000000000000000000000000000000000006","tokenB":"0x68f180fcce6836688e9084f035309e29bf0a2095","ratioAToB":"7039103","ratioBToA":"14206353730720689487","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"714285714285714","totalAmountToSwapTokenB":"0"},\{"tokenA":"0x4200000000000000000000000000000000000006","tokenB":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","ratioAToB":"1538603679","ratioBToA":"649939951100346","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"8976685701967788","totalAmountToSwapTokenB":"1470274746"},\{"tokenA":"0x4200000000000000000000000000000000000006","tokenB":"0x8700daec35af8ff88c16bdf0418774cb3d7599b4","ratioAToB":"628901764139256966728","ratioBToA":"1590073453472729","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"1666666666666666","totalAmountToSwapTokenB":"0"},\{"tokenA":"0x4200000000000000000000000000000000000006","tokenB":"0x94b008aa00579c1307b0ef2c499ad98a8ce58e58","ratioAToB":"1538379410","ratioBToA":"650034700841568","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"28417458"},\{"tokenA":"0x4200000000000000000000000000000000000006","tokenB":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","ratioAToB":"1535060758","ratioBToA":"651440012507485","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"1443715467"},\{"tokenA":"0x4200000000000000000000000000000000000042","tokenB":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","ratioAToB":"2488044","ratioBToA":"401922000000000000","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"85265910409576190475","totalAmountToSwapTokenB":"33102756"},\{"tokenA":"0x4200000000000000000000000000000000000042","tokenB":"0x8700daec35af8ff88c16bdf0418774cb3d7599b4","ratioAToB":"1016982021973302701","ratioBToA":"983301551446945337","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"33719146399245561063","totalAmountToSwapTokenB":"0"},\{"tokenA":"0x4200000000000000000000000000000000000042","tokenB":"0xdfc636088b4f73f6bda2e9c31e7ffebf4e3646e9","ratioAToB":"1609669545208951","ratioBToA":"621245523950190382090","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"333333333333333333","totalAmountToSwapTokenB":"6639527213479256"},\{"tokenA":"0x4200000000000000000000000000000000000042","tokenB":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","ratioAToB":"2482313","ratioBToA":"402850000000000000","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"31986420260941397860","totalAmountToSwapTokenB":"91794961"},\{"tokenA":"0x4a29af8683ffc6259beccfd583134a0d13be535c","tokenB":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","ratioAToB":"1000531","ratioBToA":"999468606300078952","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"332806"},\{"tokenA":"0x4f8424ba880b109c31ce8c5eefc4b82b8897eec0","tokenB":"0xdfc636088b4f73f6bda2e9c31e7ffebf4e3646e9","ratioAToB":"17683440942965951595","ratioBToA":"5655008","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"33288734349437"},\{"tokenA":"0x4f8424ba880b109c31ce8c5eefc4b82b8897eec0","tokenB":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","ratioAToB":"27793218454","ratioBToA":"3598","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"144535800"},\{"tokenA":"0x58ffcdac112d0c0f7b6ac38fb15d178b83663249","tokenB":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","ratioAToB":"1006776","ratioBToA":"993269","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"33269267"},\{"tokenA":"0x68f180fcce6836688e9084f035309e29bf0a2095","tokenB":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","ratioAToB":"22222222222","ratioBToA":"4500","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"24710","totalAmountToSwapTokenB":"61987633"},\{"tokenA":"0x68f180fcce6836688e9084f035309e29bf0a2095","tokenB":"0xdfc636088b4f73f6bda2e9c31e7ffebf4e3646e9","ratioAToB":"14141287298352313769","ratioBToA":"7071492","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"30319","totalAmountToSwapTokenB":"0"},\{"tokenA":"0x6fd9d7ad17242c41f7131d257212c54a0e816691","tokenB":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","ratioAToB":"6484243","ratioBToA":"154220000000000000","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"3325051"},\{"tokenA":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","tokenB":"0x8700daec35af8ff88c16bdf0418774cb3d7599b4","ratioAToB":"408748526461562106","ratioBToA":"2446492","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"2000000","totalAmountToSwapTokenB":"0"},\{"tokenA":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","tokenB":"0x94b008aa00579c1307b0ef2c499ad98a8ce58e58","ratioAToB":"999855","ratioBToA":"1000145","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"2000000","totalAmountToSwapTokenB":"3141492"},\{"tokenA":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","tokenB":"0xdfc636088b4f73f6bda2e9c31e7ffebf4e3646e9","ratioAToB":"646963080833118","ratioBToA":"1545683254","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"401459686","totalAmountToSwapTokenB":"0"},\{"tokenA":"0x8127ce8a7055e2e99c94aee6e20ffc2bdb3770a8","tokenB":"0xdfc636088b4f73f6bda2e9c31e7ffebf4e3646e9","ratioAToB":"4530928888706178","ratioBToA":"220705295660809471471","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"49902661481200"},\{"tokenA":"0x8127ce8a7055e2e99c94aee6e20ffc2bdb3770a8","tokenB":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","ratioAToB":"6998688","ratioBToA":"142883915198486812","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"9185292"},\{"tokenA":"0x8700daec35af8ff88c16bdf0418774cb3d7599b4","tokenB":"0xdfc636088b4f73f6bda2e9c31e7ffebf4e3646e9","ratioAToB":"1582790561120861","ratioBToA":"631795529088728464778","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"6364635725842136"},\{"tokenA":"0x8700daec35af8ff88c16bdf0418774cb3d7599b4","tokenB":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","ratioAToB":"2440863","ratioBToA":"409691000000000000","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"1617159"},\{"tokenA":"0xdfc636088b4f73f6bda2e9c31e7ffebf4e3646e9","tokenB":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","ratioAToB":"1542124032","ratioBToA":"648456271426574","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"3651875817268095","totalAmountToSwapTokenB":"1495532516"}],"tokens":\[\{"token":"0x217d47011b23bb961eb6d93ca9945b7501a5bb11","reward":"0","toProvide":"1003817341182191322522","platformFee":"1512532407607520827"},\{"token":"0x296f55f8fb28e498b858d0bcda06d955b2cb3f97","reward":"0","toProvide":"9740830224878644367","platformFee":"14677293156522316"},\{"token":"0x2e3d870790dc77a83dd1d18184acc7439a53f475","reward":"0","toProvide":"293089978535982","platformFee":"441622268010"},\{"token":"0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6","reward":"0","toProvide":"144156156068845544","platformFee":"217211686693388"},\{"token":"0x4200000000000000000000000000000000000006","reward":"0","toProvide":"1907490667036639149","platformFee":"2942576032816732"},\{"token":"0x4200000000000000000000000000000000000042","reward":"106380608139909681386","toProvide":"0","platformFee":"111634934391150144"},\{"token":"0x4a29af8683ffc6259beccfd583134a0d13be535c","reward":"0","toProvide":"331132317817856708","platformFee":"498943723482456"},\{"token":"0x4f8424ba880b109c31ce8c5eefc4b82b8897eec0","reward":"0","toProvide":"517888","platformFee":"780"},\{"token":"0x50c5725949a6f0c72e6c4a641f24049a917db0cb","reward":"0","toProvide":"15971431337898449282","platformFee":"24065441493568733"},\{"token":"0x58ffcdac112d0c0f7b6ac38fb15d178b83663249","reward":"0","toProvide":"32896627","platformFee":"49567"},\{"token":"0x68f180fcce6836688e9084f035309e29bf0a2095","reward":"0","toProvide":"227665","platformFee":"425"},\{"token":"0x6fd9d7ad17242c41f7131d257212c54a0e816691","reward":"0","toProvide":"510481813076510000","platformFee":"769184047830000"},\{"token":"0x7f5c764cbc14f9669b88837ca1490cca17c31607","reward":"1748574711","toProvide":"0","platformFee":"351884"},\{"token":"0x8127ce8a7055e2e99c94aee6e20ffc2bdb3770a8","reward":"0","toProvide":"1317488765665948722","platformFee":"1985166397286713"},\{"token":"0x8700daec35af8ff88c16bdf0418774cb3d7599b4","reward":"0","toProvide":"40657331204849463823","platformFee":"61261674341812351"},\{"token":"0x94b008aa00579c1307b0ef2c499ad98a8ce58e58","reward":"29568239","toProvide":"0","platformFee":"2999"},\{"token":"0xdfc636088b4f73f6bda2e9c31e7ffebf4e3646e9","reward":"0","toProvide":"1212047322770873116","platformFee":"1851511631727714"},\{"token":"0xfe7296c374d996d09e2ffe533eeb85d1896e1b14","reward":"3829763946","toProvide":"0","platformFee":"127547"}]} | | 6000 | 0xa5adc5484f9997fbf7d405b9aa62a7d88883c345 | false | 0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d | 11 | \["0","0"] | 73860003 | 2023-02-12T12:35:25.000Z | 0xa5ca320ff98dfb2d3c8f0fb9ac5d4066492d85f51d25d627bb84274c05afe36e | 0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d | 0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d | \{"pairs":\[\{"tokenA":"0x4200000000000000000000000000000000000042","tokenB":"0x94b008aa00579c1307b0ef2c499ad98a8ce58e58","ratioAToB":"2516090","ratioBToA":"397442000000000000","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"1666666"}],"tokens":\[\{"token":"0x4200000000000000000000000000000000000042","reward":"0","toProvide":"659422254564326000","platformFee":"993604602558000"},\{"token":"0x94b008aa00579c1307b0ef2c499ad98a8ce58e58","reward":"1666666","toProvide":"0","platformFee":"0"}]} | | 6000 | 0xa5adc5484f9997fbf7d405b9aa62a7d88883c345 | false | 0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d | 19 | \["0","0"] | 73899562 | 2023-02-12T16:25:15.000Z | 0x333e4002630c9f2c426f93622021d9d8e0a4cab7f0287d4b23e3639a1785c1c8 | 0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d | 0x775d4d8c4751bae18ebdba4ebaa46a1ff54d0c9d | \{"pairs":\[\{"tokenA":"0x4200000000000000000000000000000000000042","tokenB":"0x58ffcdac112d0c0f7b6ac38fb15d178b83663249","ratioAToB":"2433528","ratioBToA":"410926000000000000","intervalsInSwap":"0x40","totalAmountToSwapTokenA":"0","totalAmountToSwapTokenB":"8635294"}],"tokens":\[\{"token":"0x4200000000000000000000000000000000000042","reward":"0","toProvide":"3532498721543902000","platformFee":"5322700233366000"},\{"token":"0x58ffcdac112d0c0f7b6ac38fb15d178b83663249","reward":"8635294","toProvide":"0","platformFee":"0"}]} | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.meanfinance_v2_optimism.DCAHub_Swapped_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` ***