> ## 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_arbitrum > Tables in tt-contracts.meanfinance_v2_arbitrum ## 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. | 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 | | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | | 0x65625425ef808b123e005051c9cc023eabf05cf0 | false | 0xd22a58f79e9481d1a88e00c343885a588b34b68b | 0xeaa03169250b53b6ebf2f219b8ef9915d14df305 | 0 | 32793382 | 2022-10-26T16:04:03.000Z | 0x771f32bbdd3f90c319d19bee2327b25165a56487762ac2397190bca4fb20980d | | 0x65625425ef808b123e005051c9cc023eabf05cf0 | false | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 0x8fd68006d23df27fc36d3e3eda1fdcc4f0baa8c6 | 0 | 32792045 | 2022-10-26T15:58:09.000Z | 0xb121c23434f1c54fd4ba1cac0eac97dfd7a68f1ffa20332494c0b5b061417acd | | 0x65625425ef808b123e005051c9cc023eabf05cf0 | false | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x4b6e42407db855fb101b9d39e084e36c90a52652 | 0 | 32791671 | 2022-10-26T15:56:33.000Z | 0xcac81276adfeb751d3de8b289c8d689dbc7e61e66cfdbe05aa9adfa5c90299c1 | **Query with partition filter** ```sql theme={null} 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. | 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 | 0x59c5c9045374693b384bc023fdca4685c7ec1a9e | 22 | \["0","0","0","0"] | 182180230 | 2024-02-19T01:36:38.000Z | 0x87aa35e4d0f51da4d787e7473c5790570ffb6ace8ca7abb49da225fbf5d1e382 | 0xa9cffe466ba8a72707d1104de239c9ab477e2493 | 0xa9cffe466ba8a72707d1104de239c9ab477e2493 | \{"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"}]} | | 6000 | 0xa5adc5484f9997fbf7d405b9aa62a7d88883c345 | false | 0x59c5c9045374693b384bc023fdca4685c7ec1a9e | 97 | \["0","0","0","0","0","0","0","0"] | 182179389 | 2024-02-19T01:32:53.000Z | 0xd08b8d4e79103ccf29077fae0180f19e0a999eb47ca4eea3901a18a76155667a | 0xa9cffe466ba8a72707d1104de239c9ab477e2493 | 0xa9cffe466ba8a72707d1104de239c9ab477e2493 | \{"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"}]} | | 6000 | 0xa5adc5484f9997fbf7d405b9aa62a7d88883c345 | false | 0x59c5c9045374693b384bc023fdca4685c7ec1a9e | 120 | \["0","0","0","0","0","0","0","0","0","0","0","0","0","0"] | 182178975 | 2024-02-19T01:31:01.000Z | 0xfff220f5e30eeff64b788437da05421e219098333f3c72928319c9790048bbb0 | 0xa9cffe466ba8a72707d1104de239c9ab477e2493 | 0xa9cffe466ba8a72707d1104de239c9ab477e2493 | \{"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** ```sql theme={null} SELECT * FROM `tt-contracts.meanfinance_v2_arbitrum.DCAHub_Swapped_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` ***