> ## 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.
# ipor_v2_ethereum
> Tables in tt-contracts.ipor_v2_ethereum
## Tables
### IporProtocolRouter\_CloseSwap\_event
Interest rate swap closure events from IPOR Protocol on Ethereum, recording settlement amounts distributed to swap buyers and liquidators. Used for analyzing swap performance, liquidation activity, and protocol settlement flows across different underlying assets (DAI, USDT, USDC).
| 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_swapId` | `STRING` | Unique identifier for the swap or offer within the protocol. Numeric string representation without leading zeros. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_closeTimestamp` | `STRING` | Unix timestamp when the swap position was closed. Numeric string representation in seconds since epoch. |
| `in_liquidator` | `STRING` | Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_transferredToBuyer` | `STRING` | Amount of tokens transferred to the swap buyer upon position closure. Numeric string representation in smallest token units (wei for ERC-20 tokens). |
| `in_transferredToLiquidator` | `STRING` | Amount of tokens transferred to the liquidator upon swap position closure. Numeric string representation in smallest token units (wei for ERC-20 tokens). |
| address | removed | in\_asset | in\_swapId | log\_index | block\_number | in\_liquidator | block\_timestamp | transaction\_hash | in\_closeTimestamp | in\_transferredToBuyer | in\_transferredToLiquidator |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ | ---------------------- | --------------------------- |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0x6b175474e89094c44da98b954eedeac495271d0f | 334 | 65 | 18833077 | 0x907ae230e3e6c15831ab52db1abb684bd2b5c49f | 2023-12-21T08:33:11.000Z | 0x745b247710e2d91d8d262a10912f464b0d7b7b90af30f225147f025915bf3b11 | 1703147591 | 1545232938462429016541 | 25000000000000000000 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0x6b175474e89094c44da98b954eedeac495271d0f | 322 | 111 | 18426676 | 0x907ae230e3e6c15831ab52db1abb684bd2b5c49f | 2023-10-25T10:32:23.000Z | 0xd8bcfb1457d898e153ca4373960c20af359ab29c2db137f3fc672ad90e425ea8 | 1698229943 | 2465423245707300125588 | 25000000000000000000 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0x6b175474e89094c44da98b954eedeac495271d0f | 321 | 113 | 18426676 | 0x907ae230e3e6c15831ab52db1abb684bd2b5c49f | 2023-10-25T10:32:23.000Z | 0xd8bcfb1457d898e153ca4373960c20af359ab29c2db137f3fc672ad90e425ea8 | 1698229943 | 943454010231461292495 | 25000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.IporProtocolRouter_CloseSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### IporProtocolRouter\_OpenSwap\_event
Interest rate swap opening events from IPOR Protocol on Ethereum. Records fixed-to-floating rate derivative positions with collateral, notional amounts, and fixed rate terms for analyzing DeFi interest rate hedging activity.
| 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_swapId` | `STRING` | Unique identifier for the swap or offer within the protocol. Numeric string representation without leading zeros. |
| `in_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_direction` | `INT64` | Direction indicator for the swap or market position. Integer value where 0 represents one side of the position and 1 represents the opposite side. |
| `in_amounts` | `STRUCT` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| `in_openTimestamp` | `STRING` | Unix timestamp when the swap position was opened. Integer value in seconds since epoch. |
| `in_endTimestamp` | `STRING` | Unix timestamp representing the maturity or expiration time of the swap position. Integer value in seconds since epoch. |
| `in_indicator` | `STRUCT` | Composite structure containing swap pricing and quantity metrics at the time of opening. Includes IPOR index value, IBT (Interest Bearing Token) price, IBT quantity, and fixed interest rate, all as string-encoded integers with 18 decimal precision. |
| address | removed | in\_asset | in\_buyer | in\_swapId | log\_index | in\_amounts | block\_number | in\_direction | in\_indicator | block\_timestamp | in\_endTimestamp | in\_openTimestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x57d621d02992672b80154243d54353b66e4483ae | 1294 | 217 | \{"notional":"702531362822697176862056","collateral":"1656913591562965039769","totalAmount":"1718860000000000000000","iporPublicationFee":"10000000000000000000","openingFeeLPAmount":"13473204218517480115","liquidationDepositAmount":"25000000000000000000","openingFeeTreasuryAmount":"13473204218517480116"} | 18377034 | 1 | \{"ibtPrice":"1032207783529184444","ibtQuantity":"680610410067532629164313","iporIndexValue":"34750664614680723","fixedInterestRate":"31926664614680723"} | 2023-10-18T11:47:23.000Z | 1700048843 | 1697629643 | 0x6ac9de4ecc4783c090ec684d608d9bbe69e1cc9a0fcb963aaa7474c503181a2c |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0x6b175474e89094c44da98b954eedeac495271d0f | 0xfd9f45f118f0a6aaa0eb1491576e79e6899c4e35 | 336 | 278 | \{"notional":"535740524193548387053500","collateral":"1071481048387096774107","totalAmount":"1127030000000000000000","iporPublicationFee":"10000000000000000000","openingFeeLPAmount":"10274475806451612946","liquidationDepositAmount":"25000000000000000000","openingFeeTreasuryAmount":"10274475806451612947"} | 18718873 | 1 | \{"ibtPrice":"1037451413875129066","ibtQuantity":"516400591900905936094583","iporIndexValue":"49455311885789125","fixedInterestRate":"46603578939363016"} | 2023-12-05T08:11:59.000Z | 1704183119 | 1701763919 | 0x5b5442256f4b27c52e5caf86d117ba19cf00952a0508c28544d6148b7951b5b6 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0xa6584b95ea4e9018b1f377dad99448ec478a150f | 392 | 209 | \{"notional":"599999999879194630904750","collateral":"2399999999516778523619","totalAmount":"2484315068000000000000","iporPublicationFee":"10000000000000000000","openingFeeLPAmount":"24657534241610738190","liquidationDepositAmount":"25000000000000000000","openingFeeTreasuryAmount":"24657534241610738191"} | 18669512 | 0 | \{"ibtPrice":"1050966829325875034","ibtQuantity":"570902889736353070284407","iporIndexValue":"39491662528542441","fixedInterestRate":"57084031883917704"} | 2023-11-28T10:25:11.000Z | 1706351111 | 1701167111 | 0xc8fca19403db33e73128bc141360940e49c2a42ce6c382a77142804092445b57 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.IporProtocolRouter_OpenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### IporProtocolRouter\_Redeem\_event
Redemption events from IPOR Protocol v2 on Ethereum recording when users burn ipTokens to withdraw underlying assets. Contains redemption amounts, fees, exchange rates, and AMM treasury addresses for analyzing liquidity withdrawal activity.
| 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_ammTreasury` | `STRING` | Address of the IPOR Automated Market Maker (AMM) treasury contract holding the pooled assets for this redemption. Always present as a hex-encoded Ethereum address. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_beneficiary` | `STRING` | Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_exchangeRate` | `STRING` | Exchange rate between IP tokens and underlying asset tokens at the time of the operation. Integer value with 18 decimal places of precision. |
| `in_assetAmount` | `STRING` | Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit. |
| `in_ipTokenAmount` | `STRING` | Amount of IP (Interest Protocol) tokens burned or redeemed in the operation. Integer value representing token quantity in smallest unit with 18 decimal places of precision. |
| `in_redeemFee` | `STRING` | Fee charged for redeeming IP tokens from the lending pool. Integer value representing fee amount in smallest unit with 18 decimal places of precision. |
| `in_redeemAmount` | `STRING` | Amount of underlying asset tokens withdrawn from the lending pool during redemption. |
| address | in\_from | removed | log\_index | block\_number | in\_redeemFee | in\_ammTreasury | in\_assetAmount | in\_beneficiary | block\_timestamp | in\_exchangeRate | in\_redeemAmount | in\_ipTokenAmount | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ---------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------ | ------------------------ | ------------------- | ------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | 0x8aa25ef2c43f0afc214ed7263b6abd189dc18594 | false | 84 | 18584434 | 975805020951164280163 | 0x137000352b4ed784e8fa8815d225c713ab2e7dc9 | 195161004190232856032500 | 0x8aa25ef2c43f0afc214ed7263b6abd189dc18594 | 2023-11-16T12:25:47.000Z | 1074606654617562102 | 194185199169000000000000 | 181611572338241292587204 | 0x7dd962e2e431cf96ced82e62bd27596613c152c9faa52ecca7ce7fc038006f73 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | 0x76cade925ea2f5515f09e43cf38b86b80638490d | false | 191 | 18584292 | 1821977009839313579340 | 0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523 | 364395401967862715868065 | 0x76cade925ea2f5515f09e43cf38b86b80638490d | 2023-11-16T11:57:23.000Z | 1077247801779549326 | 362573424958023402288725 | 338265161800194138412024 | 0xc87189ea6ad1b5e846e9a8fb865f97f42b5f87bd64664f95810b458979e6cf16 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | 0x475cc2876e1fdb6462247275c3da8d29639c92d0 | false | 133 | 18877445 | 50129478477728859614 | 0x28bc58e600ef718b9e97d294098abecb8c96b687 | 10025895695545771922800 | 0x475cc2876e1fdb6462247275c3da8d29639c92d0 | 2023-12-27T13:59:11.000Z | 1089771271254975209 | 9975766217000000000000 | 9200000000000000000000 | 0x573f15a5fa6d0a5e6a8969f385a43a15a7abaa5b37d4781bd6bdc4235c694f0f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.IporProtocolRouter_Redeem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### IporProtocolRouter\_RedeemStEth\_event
Staked ETH (stETH) redemption events from IPOR Protocol v2 on Ethereum, capturing withdrawals where users burn ipTokens to receive stETH at a specific exchange rate. Used for analyzing liquidity pool exits, redemption patterns, and stETH-denominated yield strategy performance.
| 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_ammTreasuryEth` | `STRING` | Contract address of the IPOR AMM (Automated Market Maker) treasury managing ETH liquidity on Ethereum. This treasury address receives or holds the underlying ETH assets during stETH redemption operations. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_beneficiary` | `STRING` | Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_exchangeRate` | `STRING` | Exchange rate between IP tokens and underlying asset tokens at the time of the operation. Integer value with 18 decimal places of precision. |
| `in_amountStEth` | `STRING` | Amount of stETH (Lido Staked Ether) tokens redeemed from the IPOR protocol, denominated in wei (18 decimals). Represents the total stETH withdrawn before accounting for exchange rate conversions or fees. |
| `in_redeemedAmountStEth` | `STRING` | Amount of stETH (Lido Staked Ether) tokens actually redeemed and returned to the beneficiary, denominated in wei (10^-18 stETH). This value may differ slightly from `in_amountStEth` due to exchange rate conversions and protocol fees. |
| `in_ipTokenAmount` | `STRING` | Amount of IP (Interest Protocol) tokens burned or redeemed in the operation. Integer value representing token quantity in smallest unit with 18 decimal places of precision. |
| address | in\_from | removed | log\_index | block\_number | in\_amountStEth | in\_beneficiary | block\_timestamp | in\_exchangeRate | in\_ipTokenAmount | transaction\_hash | in\_ammTreasuryEth | in\_redeemedAmountStEth |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | -------------------- | ------------------------------------------ | ------------------------ | ------------------- | -------------------- | ------------------------------------------------------------------ | ------------------------------------------ | ----------------------- |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | 0x4b003868bbd5add0d1251553b829e58ba3cdcd3c | false | 167 | 18376461 | 1300000000000000000 | 0x4b003868bbd5add0d1251553b829e58ba3cdcd3c | 2023-10-18T09:50:59.000Z | 1000660479036240902 | 1299141943980899364 | 0xb97d1df6d65780fa319b7e92bb7980fb8048a63c5ec09367614b1a52281c4418 | 0x63395edaf74a80aa1155db7cd9bba976a88dee4e | 1293500000000000000 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | 0x523b27014b865c4d8f3dac9c6e3b1bad13d22b87 | false | 351 | 18592387 | 20089633642900538220 | 0x523b27014b865c4d8f3dac9c6e3b1bad13d22b87 | 2023-11-17T15:07:47.000Z | 1004481682145026911 | 20000000000000000000 | 0xaf37d0a85636a7b2d2d3807e34ddbbf0c34aed42dfe94c05e0d7ed01655783ff | 0x63395edaf74a80aa1155db7cd9bba976a88dee4e | 19989185474686035529 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | 0x5919b3d42bd84e816533c2dd6a7dff7d02303e87 | false | 67 | 18886577 | 24722976943940109339 | 0x5919b3d42bd84e816533c2dd6a7dff7d02303e87 | 2023-12-28T20:47:47.000Z | 1006257632772482715 | 24569231714369548771 | 0x6723828262763b8e00934d17ff8e802a8c9788ffbedfa3a8c5657950e801ac00 | 0x63395edaf74a80aa1155db7cd9bba976a88dee4e | 24599362059220408792 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.IporProtocolRouter_RedeemStEth_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### IporProtocolRouter\_SwapUnwind\_event
Swap closure events from IPOR Protocol v2 interest rate derivatives on Ethereum, capturing position unwinding with PnL (profit and loss), unwind amounts, and fee distributions to liquidity providers and treasury. Used for analyzing trader exit behavior and protocol fee revenue across stETH and USDC markets.
| 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_swapId` | `STRING` | Unique identifier for the swap or offer within the protocol. Numeric string representation without leading zeros. |
| `in_swapPnlValueToDate` | `STRING` | Profit and loss (PnL) of the swap position at the time of unwinding, denominated in the underlying asset's smallest unit. Negative values indicate losses, positive values indicate gains on the swap. |
| `in_swapUnwindAmount` | `STRING` | Net profit or loss amount realized when closing the swap position, denominated in the asset's smallest unit. Negative values indicate losses, while positive values indicate gains from unwinding the position. |
| `in_unwindFeeLPAmount` | `STRING` | Fee amount paid to liquidity providers (LPs) when unwinding the swap position, denominated in the asset's smallest unit. Always paired with an equal treasury fee and deducted from the unwind settlement amount. |
| `in_unwindFeeTreasuryAmount` | `STRING` | Portion of the unwind fee allocated to the IPOR protocol treasury, denominated in the smallest unit of the asset. Always equals in\_unwindFeeLPAmount, representing the treasury's share of fees collected when unwinding a swap position. |
| address | removed | in\_asset | in\_swapId | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_swapUnwindAmount | in\_unwindFeeLPAmount | in\_swapPnlValueToDate | in\_unwindFeeTreasuryAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | --------------------- | ---------------------- | --------------------------- |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 3 | 398 | 18838568 | 2023-12-22T02:59:35.000Z | 0x798826e4d0a2523466946a50756aba6e926611dfb00e5c0b6f60cac4d71bec88 | -12649142703025910 | 2083975456621004 | -4556205859389867 | 2083975456621005 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 17 | 257 | 18982799 | 2024-01-11T09:29:47.000Z | 0xd98a58894b481ab5fdaf56e7fa2eec31b5b8caf97c27f230a00103af2b7b74a7 | -125282211697398078 | 8173319892473118 | -14908162321937868 | 8173319892473119 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 16 | 201 | 18885395 | 2023-12-28T16:48:47.000Z | 0x9afed6628023179ee2e645b120d81a4d752b8433f840dfe8a3c7b492a07b8044 | 120230345560970508 | 22857305936073059 | -10417847724667827 | 22857305936073060 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.IporProtocolRouter_SwapUnwind_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### IporProtocolRouter2\_OpenSwap\_event
Interest rate swap opening events from IPOR Protocol v2 on Ethereum, capturing swap initiation with collateral, notional amounts, fixed rates, and settlement timestamps for tracking leveraged interest rate positions.
| 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_swapId` | `STRING` | Unique identifier for the swap or offer within the protocol. Numeric string representation without leading zeros. |
| `in_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_direction` | `INT64` | Direction indicator for the swap or market position. Integer value where 0 represents one side of the position and 1 represents the opposite side. |
| `in_amounts` | `STRUCT` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| `in_openTimestamp` | `STRING` | Unix timestamp when the swap position was opened. Integer value in seconds since epoch. |
| `in_endTimestamp` | `STRING` | Unix timestamp representing the maturity or expiration time of the swap position. Integer value in seconds since epoch. |
| `in_indicator` | `STRUCT` | Composite structure containing swap pricing and quantity metrics at the time of opening. Includes IPOR index value, IBT (Interest Bearing Token) price, IBT quantity, and fixed interest rate, all as string-encoded integers with 18 decimal precision. |
| address | removed | in\_asset | in\_buyer | in\_swapId | log\_index | in\_amounts | block\_number | in\_direction | in\_indicator | block\_timestamp | in\_endTimestamp | in\_openTimestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------- | ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x8f3c386d236f910ae0a8c7f549f3586661093512 | 1299 | 273 | \{"notional":"1234999999993358715475294","collateral":"2499999999986556104201","totalAmount":"2582369863000000000000","iporPublicationFee":"10000000000000000000","openingFeeLPAmount":"23684931506721947899","liquidationDepositAmount":"25000000000000000000","openingFeeTreasuryAmount":"23684931506721947900"} | 18469258 | 1 | \{"ibtPrice":"1034318456024894682","ibtQuantity":"1194022975032008800596301","iporIndexValue":"42493796098355051","fixedInterestRate":"42809796098355051"} | 2023-10-31T09:35:59.000Z | 1701164159 | 1698744959 | 0x851771acdcf539ffee5a75e65daf636164d6db29b899dfc15b613f0410734c34 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0x6b175474e89094c44da98b954eedeac495271d0f | 0x00b737026e8ea1e21ec41390c0dd9f4d279dffc6 | 330 | 175 | \{"notional":"443000000000000000095245","collateral":"1000000000000000000215","totalAmount":"1051991780821917808219","iporPublicationFee":"10000000000000000000","openingFeeLPAmount":"8495890410958904002","liquidationDepositAmount":"25000000000000000000","openingFeeTreasuryAmount":"8495890410958904002"} | 18519139 | 1 | \{"ibtPrice":"1033445266809978131","ibtQuantity":"428663243451145817466339","iporIndexValue":"51410895216338168","fixedInterestRate":"41342165939276434"} | 2023-11-07T09:19:35.000Z | 1701767975 | 1699348775 | 0x886c20c749ae31dff4e08c55b29d7b4f974e47423441ad090cd8e3d8efce3d61 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x96900ee60c4e20f61d5b08c5608c52a1cd9c18ff | 1301 | 198 | \{"notional":"1300000000147849462261000","collateral":"2600000000295698924522","totalAmount":"2684863014000000000000","iporPublicationFee":"10000000000000000000","openingFeeLPAmount":"24931506852150537739","liquidationDepositAmount":"25000000000000000000","openingFeeTreasuryAmount":"24931506852150537739"} | 18519100 | 1 | \{"ibtPrice":"1035592053121796138","ibtQuantity":"1255320563950828488657596","iporIndexValue":"64964226091549013","fixedInterestRate":"50000000000000000"} | 2023-11-07T09:11:47.000Z | 1701767507 | 1699348307 | 0x1fa9dddd909ca78bcb3dff8751fbbd9cc84a27ff1cb3d3a18673ee78bbeabf78 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.IporProtocolRouter2_OpenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### IporProtocolRouterV2\_OpenSwap\_event
Interest rate swap opening events from IPOR Protocol v2 on Ethereum, capturing fixed-rate positions with collateral, notional amounts, and execution parameters for stETH (Lido Staked ETH) interest rate derivatives.
| 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_swapId` | `STRING` | Unique identifier for the swap or offer within the protocol. Numeric string representation without leading zeros. |
| `in_buyer` | `STRING` | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_inputAsset` | `STRING` | Asset address used for the swap input, which may differ from the underlying swap asset. Commonly set to 0xeeee...eeee for native ETH or the actual token contract address for ERC-20 tokens. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_direction` | `INT64` | Direction indicator for the swap or market position. Integer value where 0 represents one side of the position and 1 represents the opposite side. |
| `in_amounts` | `STRUCT` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| `in_openTimestamp` | `STRING` | Unix timestamp when the swap position was opened. Integer value in seconds since epoch. |
| `in_endTimestamp` | `STRING` | Unix timestamp representing the maturity or expiration time of the swap position. Integer value in seconds since epoch. |
| `in_indicator` | `STRUCT` | Composite structure containing swap pricing and quantity metrics at the time of opening. Includes IPOR index value, IBT (Interest Bearing Token) price, IBT quantity, and fixed interest rate, all as string-encoded integers with 18 decimal precision. |
| address | removed | in\_asset | in\_buyer | in\_swapId | log\_index | in\_amounts | block\_number | in\_direction | in\_indicator | in\_inputAsset | block\_timestamp | in\_endTimestamp | in\_openTimestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------ | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 0xe0437191b5c2507a2a2c18b86f4a17f5e2bb4d29 | 18 | 139 | \{"notional":"419455645161290322500","collateral":"838911290322580645","assetTotalAmount":"870000000000000000","iporPublicationFee":"5000000000000000","openingFeeLPAmount":"8044354838709677","inputAssetTotalAmount":"870000000000000000","liquidationDepositAmount":"10000000000000000","openingFeeTreasuryAmount":"8044354838709678"} | 18885462 | 1 | \{"ibtPrice":"1151789359371963233","ibtQuantity":"364177392114480997166","iporIndexValue":"39696872642182255","fixedInterestRate":"38196872642182255"} | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 2023-12-28T17:02:23.000Z | 1706202143 | 1703782943 | 0xa436385bb2905c1868a3952fbb1bc3bd0c8907b3356cb8701fc8ac89e3d666f9 |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 0xfd9f45f118f0a6aaa0eb1491576e79e6899c4e35 | 25 | 205 | \{"notional":"649999999999999999500","collateral":"1299999999999999999","assetTotalAmount":"1339931506849315068","iporPublicationFee":"5000000000000000","openingFeeLPAmount":"12465753424657534","inputAssetTotalAmount":"1339931506849315068","liquidationDepositAmount":"10000000000000000","openingFeeTreasuryAmount":"12465753424657535"} | 18982787 | 1 | \{"ibtPrice":"1153337865492780368","ibtQuantity":"563581600368490503927","iporIndexValue":"39726516580660201","fixedInterestRate":"32686974833820735"} | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 2024-01-11T09:27:23.000Z | 1707384443 | 1704965243 | 0x83aadd15d9d8b85cf4fc013d705c83f3ebce541b5e45468343cec0c9bf85057a |
| 0x16d104009964e694761c0bf09d7be49b7e3c26fd | false | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 0xfd9f45f118f0a6aaa0eb1491576e79e6899c4e35 | 26 | 250 | \{"notional":"1145427631578947368500","collateral":"2290855263157894737","assetTotalAmount":"2400000000000000000","iporPublicationFee":"5000000000000000","openingFeeLPAmount":"47072368421052631","inputAssetTotalAmount":"2400000000000000000","liquidationDepositAmount":"10000000000000000","openingFeeTreasuryAmount":"47072368421052632"} | 18983847 | 0 | \{"ibtPrice":"1153356451568551810","ibtQuantity":"993125438385660100625","iporIndexValue":"39584897721137214","fixedInterestRate":"36922692033793032"} | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 2024-01-11T13:01:11.000Z | 1710162071 | 1704978071 | 0x4ec6a8f823dddd99735cbc31b2430c707446c3e3ea82e94a11038f9feb8e4fd8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.IporProtocolRouterV2_OpenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityMining\_Claimed\_event
Liquidity mining reward claim events from IPOR v2 protocol on Ethereum, recording when users claim accrued rewards for providing liquidity across multiple LP token pools. Contains account addresses, LP token identifiers, and reward amounts in wei for analyzing liquidity provider incentive distributions.
| 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_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_lpTokens` | `ARRAY` | Array of liquidity pool (LP) token contract addresses for which the user is claiming mining rewards. Typically contains one to four EVM addresses representing different liquidity pools in the IPOR protocol. |
| `in_rewardsAmount` | `STRING` | Amount of rewards being distributed or received. String-encoded integer representing the token quantity in its smallest denomination. |
| address | removed | log\_index | in\_account | in\_lpTokens | block\_number | block\_timestamp | in\_rewardsAmount | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
| 0xcc3fc4c9ba7f8b8aa433bc586d390a70560ff366 | false | 243 | 0xbedfa3e446485df7cd14d5fdc2baf54dbf848731 | \["0x7c0e72f431fd69560d951e4c04a4de3657621a88"] | 18741635 | 2023-12-08T12:47:23.000Z | 5636620690206887927493 | 0x76b0b971dc9cb27972a87d8476080a3ca0a2e6064a5775e8e818c8cb0e9d8249 |
| 0xcc3fc4c9ba7f8b8aa433bc586d390a70560ff366 | false | 176 | 0x28ed3e1f4581a263dadcc6855295b985323c1400 | \["0x7c0e72f431fd69560d951e4c04a4de3657621a88","0x8537b194bff354c4738e9f3c81d67e3371dadaf8","0xc40431b6c510aeb45fbb5e21e40d49f12b0c1f0c"] | 18741082 | 2023-12-08T10:55:59.000Z | 309653779804194689646 | 0x79cd9b761a9d265fbeee8b387192a97e3b6614b629959e6da6f5959bb1dba6a2 |
| 0xcc3fc4c9ba7f8b8aa433bc586d390a70560ff366 | false | 175 | 0xfa8a4ad4473cbe8a61552e4b05e58db71050110c | \["0x7c0e72f431fd69560d951e4c04a4de3657621a88","0x9bd2177027edee300dc9f1fb88f24db6e5e1edc6","0x8537b194bff354c4738e9f3c81d67e3371dadaf8","0xc40431b6c510aeb45fbb5e21e40d49f12b0c1f0c"] | 18742641 | 2023-12-08T16:09:59.000Z | 1055442918327550981822 | 0x2d3e88bf5b500ffe11b6cf3d1e1672f85ff521e82bed318547422960d3a9ad7f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.LiquidityMining_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyAaveDai\_deposit\_function
DAI deposit function calls to IPOR Protocol's Aave strategy contract on Ethereum, recording deposited amounts in WAD format (18 decimals). Used for tracking liquidity provision flows into the protocol's Aave V2 yield-generating strategy.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_depositedAmount` | `STRING` | Amount of tokens successfully deposited into the strategy contract. String representation of an integer in WAD format. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_depositedAmount |
| ------- | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 1735546 | 0 | true | 181613 | 0xb6b55f25 | 0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f | 16515413 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 128574427578900549632232 | 0,7,0,0,0,6 | 2023-01-29T22:18:47.000Z | 0xbdfee1720a51b66013ed070ca6a9de0a67d4285770803df6a3f71872791a84bd | 128574427578900549632232 |
| 251106 | 0 | true | 179972 | 0xb6b55f25 | 0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f | 16570440 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 2249089940232933467764621 | 0,7,0,0,0,6 | 2023-02-06T14:47:59.000Z | 0x471a439207355b1c16cc311fa8d441c4e4eeeb0154bcf2658d5bc21179c213bf | 2249089940232933467764621 |
| 555665 | 0 | true | 222839 | 0xb6b55f25 | 0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f | 17864271 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 5158206381220220562330133 | 0,2,0,0,0,6 | 2023-08-07T16:33:47.000Z | 0xac1b38155beaa93212ab5724ebf3ef11ee0cd376352808f60535c110093ba93f | 5158206381220220562330133 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyAaveDai_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyAaveDai\_withdraw\_function
DAI withdrawal transactions from IPOR Protocol's Aave strategy vault on Ethereum, tracking withdrawal amounts in WAD format (18 decimals). Used for analyzing vault outflows and user redemption patterns from the protocol's Aave-based yield strategy.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_withdrawnAmount` | `STRING` | Token amount actually withdrawn from the strategy. String representation of an integer in the same WAD format scaling as the input amount. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_withdrawnAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 329427 | 0 | true | 190774 | 0x2e1a7d4d | 0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f | 17616309 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 95205493413622636445503 | 0,5,0,0,0,6 | 2023-07-03T22:08:47.000Z | 0x8ca79c9279b377be55b0e58c1d6f2319376c3a800bc684305027d6f0c506182e | 95205493413622636445503 |
| 329422 | 0 | true | 190774 | 0x2e1a7d4d | 0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f | 17362501 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 461690934003227468297576 | 0,5,0,0,0,6 | 2023-05-29T05:14:23.000Z | 0xf7d7b986acc2dacf7334926c885f2e7af49b731ccc24f6c4f2e753bc84cf89b8 | 461690934003227468297576 |
| 825742 | 0 | true | 190851 | 0x2e1a7d4d | 0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f | 17785582 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 223132342664645109441869 | 0,5,0,0,0,6 | 2023-07-27T16:25:35.000Z | 0xe5e7b90b4d77079f4fd7a00f5550de6e2d67e0c88c2caa21eb8e9a2b37dd0376 | 223132342664645109441869 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyAaveDai_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyAaveUsdc\_deposit\_function
USDC deposit function calls to IPOR's Aave strategy contract on Ethereum, recording input amounts and resulting deposited amounts in wei-denominated values. Used for tracking liquidity provisioning into Aave through IPOR's yield-bearing strategy vault.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_depositedAmount` | `STRING` | Amount of tokens successfully deposited into the strategy contract. String representation of an integer in WAD format. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_depositedAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 276676 | 0 | true | 200382 | 0xb6b55f25 | 0x77fcae921e3df22810c5a1ac1d33f2586bba028f | 16596292 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 469664647967950000252593 | 0,7,0,0,0,6 | 2023-02-10T05:33:23.000Z | 0x4b5ae82105540bcdd798ddac49fcae2c89f5110deb78f44dbf653ffb6c8fe4f2 | 469664647968000000000000 |
| 835988 | 0 | true | 200382 | 0xb6b55f25 | 0x77fcae921e3df22810c5a1ac1d33f2586bba028f | 17359478 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 18585483823652979763626 | 0,7,0,0,0,6 | 2023-05-28T19:04:23.000Z | 0xb4adacc10ceaed8e42e422c3b6403f27da38450038cf6b97d2083013c11da412 | 18585483824000000000000 |
| 276677 | 0 | true | 200382 | 0xb6b55f25 | 0x77fcae921e3df22810c5a1ac1d33f2586bba028f | 16590971 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 412283397288449999794006 | 0,7,0,0,0,6 | 2023-02-09T11:43:11.000Z | 0x8f6368ba0de9e134ee51b5098db49f62d5086b390ed0576b8a1f636d77346d16 | 412283397288000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyAaveUsdc_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyAaveUsdc\_withdraw\_function
Withdrawal transaction records from IPOR Protocol v2's Aave USDC strategy contract on Ethereum, capturing input amounts in WAD format (18 decimals) and actual withdrawn USDC amounts. Used for tracking strategy liquidity removals and analyzing withdrawal patterns from the Aave integration.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_withdrawnAmount` | `STRING` | Token amount actually withdrawn from the strategy. String representation of an integer in the same WAD format scaling as the input amount. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_withdrawnAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 348780 | 0 | true | 200938 | 0x2e1a7d4d | 0x77fcae921e3df22810c5a1ac1d33f2586bba028f | 16984496 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 103289697381385748371951 | 0,5,0,0,0,6 | 2023-04-05T19:01:11.000Z | 0xb2bb219f46bc497dca0c55ce6f0035b30e3a02ac741f5092697902769fc3470a | 103289697381000000000000 |
| 348782 | 0 | true | 200938 | 0x2e1a7d4d | 0x77fcae921e3df22810c5a1ac1d33f2586bba028f | 16784893 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 458624997663650000024140 | 0,5,0,0,0,6 | 2023-03-08T17:02:47.000Z | 0xffc2cc639327754ed593efa7d19220ce3ed56be704131e0f5f7ee7ace504b4ad | 458624997664000000000000 |
| 348782 | 0 | true | 200938 | 0x2e1a7d4d | 0x77fcae921e3df22810c5a1ac1d33f2586bba028f | 16781578 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 192109069719799999761135 | 0,5,0,0,0,6 | 2023-03-08T05:51:59.000Z | 0xaf374a60d54fee352735944bec97ce9f66dc4a4d27ab286a593afd2010e563ba | 192109069720000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyAaveUsdc_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyAaveUsdt\_deposit\_function
USDT deposit transactions into IPOR v2's Aave strategy contract on Ethereum, tracking input amounts and actual deposited amounts to the Aave lending protocol. Used for analyzing capital deployment and yield strategy execution.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_depositedAmount` | `STRING` | Amount of tokens successfully deposited into the strategy contract. String representation of an integer in WAD format. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_depositedAmount |
| ------- | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 264593 | 0 | true | 189310 | 0xb6b55f25 | 0x58703da5295794ed4e82323fcce7371272c5127d | 17613869 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 297562307224406570494329 | 0,7,0,0,0,6 | 2023-07-03T13:55:59.000Z | 0xaac189ab745a5c5e25475782f54c48c623444fe40261a27556b8783f72ef947f | 297562307224000000000000 |
| 1814922 | 0 | true | 189233 | 0xb6b55f25 | 0x58703da5295794ed4e82323fcce7371272c5127d | 16774066 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 462747924869600000177216 | 0,7,0,0,0,6 | 2023-03-07T04:31:11.000Z | 0x4e8be3d53962c4dbfb76a3297d58227aaa5d26bf403d5936b4e10b27f9bb41e3 | 462747924870000000000000 |
| 1120836 | 0 | true | 252417 | 0xb6b55f25 | 0x58703da5295794ed4e82323fcce7371272c5127d | 15918492 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 26775931779200000000000 | 0,0,2,0,0,0,6 | 2022-11-07T13:37:47.000Z | 0x15afb434e70f636eaee3c28fa970abf70340d5bd51652cba2998e8b6931bf37c | 26775931779000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyAaveUsdt_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyAaveUsdt\_withdraw\_function
Withdrawal function calls from IPOR Protocol's Aave USDT strategy contract on Ethereum, capturing input amounts and actual withdrawn USDT amounts in wei. Used for tracking liquidity removals and strategy rebalancing activity.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_withdrawnAmount` | `STRING` | Token amount actually withdrawn from the strategy. String representation of an integer in the same WAD format scaling as the input amount. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_withdrawnAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 389426 | 0 | true | 201946 | 0x2e1a7d4d | 0x58703da5295794ed4e82323fcce7371272c5127d | 16612760 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 81632872680050000126122 | 0,5,0,0,0,6 | 2023-02-12T12:44:11.000Z | 0x3240425b691809d08385e2ada329d2617a520a084d3c22ea4f99c2d455436172 | 81632872680000000000000 |
| 330334 | 0 | true | 201946 | 0x2e1a7d4d | 0x58703da5295794ed4e82323fcce7371272c5127d | 17634202 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 269022408741097177202310 | 0,5,0,0,0,6 | 2023-07-06T10:25:47.000Z | 0xba666914b32854ff673a6c4b356424aa74573cdc65de102723978484e0bbcc95 | 269022408741000000000000 |
| 347780 | 0 | true | 202000 | 0x2e1a7d4d | 0x58703da5295794ed4e82323fcce7371272c5127d | 16542146 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 247797234470499999741899 | 0,5,0,0,0,6 | 2023-02-02T15:56:11.000Z | 0xa10a8b150fd2bd13fece62f3b83607090f16de9650d433b90772fe481181b0f1 | 247797234470000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyAaveUsdt_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyCompoundDai\_deposit\_function
DAI deposit transactions into IPOR Protocol v2's Compound strategy contract on Ethereum. Tracks deposit amounts in wei and corresponding output values for analyzing yield strategy fund flows.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_depositedAmount` | `STRING` | Amount of tokens successfully deposited into the strategy contract. String representation of an integer in WAD format. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_depositedAmount |
| ------- | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ----------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 203590 | 0 | true | 134627 | 0xb6b55f25 | 0x87cef19aca214d12082e201e6130432df39fc774 | 16836830 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 292096780047689390464876 | 0,7,0,0,0,6 | 2023-03-16T00:24:11.000Z | 0x60c91cc92a6fe788d6a67c4e48be10704ac55c6e14efce9401f79e661bec560c | 292096780047689390464876 |
| 1507391 | 0 | true | 134627 | 0xb6b55f25 | 0x87cef19aca214d12082e201e6130432df39fc774 | 16839615 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 105728470355559802927995 | 0,7,0,0,0,6 | 2023-03-16T09:47:11.000Z | 0x331009c0e39880f0ba9c6298391e5517d77300671b95f7d26b8b28a417f9ad49 | 105728470355559802927995 |
| 255716 | 0 | true | 127627 | 0xb6b55f25 | 0x87cef19aca214d12082e201e6130432df39fc774 | 17037514 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 129081266398970519690663 | 2,0,4,0,7,0,0,0,6 | 2023-04-13T08:37:59.000Z | 0x33da9fc8e51943abec2090834658eb685c2c5a6fde58daed5ca23468d97c8036 | 129081266398970519690663 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyCompoundDai_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyCompoundDai\_withdraw\_function
DAI withdrawal function calls from IPOR Protocol v2's Compound strategy contract on Ethereum. Tracks redemptions from the yield-generating strategy with WAD-denominated input amounts and actual withdrawn DAI amounts for liquidity monitoring.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_withdrawnAmount` | `STRING` | Token amount actually withdrawn from the strategy. String representation of an integer in the same WAD format scaling as the input amount. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_withdrawnAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 648811 | 0 | true | 160129 | 0x2e1a7d4d | 0x87cef19aca214d12082e201e6130432df39fc774 | 17178942 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 494634799147687873908218 | 0,5,0,0,0,6 | 2023-05-03T08:13:11.000Z | 0xc29a6b0fd1436ef7e8a795433f2883f6e670fd7ef203431535db0b0e66af26ca | 494635924283472870643035 |
| 679966 | 0 | true | 160129 | 0x2e1a7d4d | 0x87cef19aca214d12082e201e6130432df39fc774 | 17093849 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 126343097565309635777801 | 0,5,0,0,0,6 | 2023-04-21T09:21:59.000Z | 0x7a2a5749eb8094c8146494dffbd3d5b6c084df8fc34fe1590ba26d813b54da31 | 126343233767393281563193 |
| 299155 | 0 | true | 160129 | 0x2e1a7d4d | 0x87cef19aca214d12082e201e6130432df39fc774 | 17088037 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 120720080019615231631557 | 0,5,0,0,0,6 | 2023-04-20T13:35:11.000Z | 0x604a030343345120e62e9093bf0aecf9c1a14d28d9b4e28db2573a1aa44ca05b | 120720211499071964830154 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyCompoundDai_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyCompoundUsdc\_deposit\_function
Deposit function calls to IPOR Protocol's Compound USDC strategy contract on Ethereum, recording USDC amounts deposited into the yield-earning strategy. Tracks deposit execution with input amounts (WAD format, 18 decimals) and actual deposited amounts for reconciliation and strategy performance analysis.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_depositedAmount` | `STRING` | Amount of tokens successfully deposited into the strategy contract. String representation of an integer in WAD format. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_depositedAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 259901 | 0 | true | 186349 | 0xb6b55f25 | 0xe5257cf3bd0efd397227981fe7bbd55c7582f526 | 16791585 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 93490099888349999767817 | 0,7,0,0,0,6 | 2023-03-09T15:37:47.000Z | 0xe25295e061162b03805de15b6414d6674e2d3a5980927c14feb795f037b9a87e | 93490099888000000000000 |
| 464431 | 0 | true | 155940 | 0xb6b55f25 | 0xe5257cf3bd0efd397227981fe7bbd55c7582f526 | 17864580 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 5154603270042400000000000 | 0,2,0,0,0,6 | 2023-08-07T17:35:59.000Z | 0xd71f46f0dff2c8b6ca26f3d541d34adf5552df31400e8f17c35132542e8240ee | 5154603270042000000000000 |
| 433448 | 0 | true | 149133 | 0xb6b55f25 | 0xe5257cf3bd0efd397227981fe7bbd55c7582f526 | 18597165 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 87430195492077658934573 | 0,0,9,0,0,0,5 | 2023-11-18T07:11:11.000Z | 0x18fc2ed9cd4832a01dd4579a0a9af1b6f755fc49731e65345d51f3f7fce1207c | 87430195492000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyCompoundUsdc_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyCompoundUsdc\_withdraw\_function
Withdrawal function calls from IPOR Protocol v2's Compound USDC yield strategy contract on Ethereum, tracking requested amounts in WAD format (18 decimals) and actual withdrawn USDC amounts. Used for analyzing strategy liquidity withdrawals and redemption patterns from Compound lending positions.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_withdrawnAmount` | `STRING` | Token amount actually withdrawn from the strategy. String representation of an integer in the same WAD format scaling as the input amount. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_withdrawnAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ----------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ----------------------- |
| 346685 | 0 | false | 2935 | 0x2e1a7d4d | 0xe5257cf3bd0efd397227981fe7bbd55c7582f526 | 19571156 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | | 0,0,7,0,0,0,5 | 2024-04-02T22:44:23.000Z | 0xd5f77c47d526c13362ecb50ee1ac3c90dfb2c3d63eaa0465d2f478386f076456 | |
| 323416 | 0 | false | 2935 | 0x2e1a7d4d | 0xe5257cf3bd0efd397227981fe7bbd55c7582f526 | 20848553 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | | 0,0,7,0,0,0,5 | 2024-09-28T10:31:47.000Z | 0x8e6a6ec5a4755adeda8b2ccc4d9ac75981e1d91790da36c11538dbb82f21cf79 | |
| 491021 | 0 | true | 164264 | 0x2e1a7d4d | 0xe5257cf3bd0efd397227981fe7bbd55c7582f526 | 18335937 | 0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260 | 91854795118797647194205 | 0,0,7,0,0,0,4 | 2023-10-12T17:50:59.000Z | 0x886f0bfde0c6b74355244237e58f46b7b618ee63e20df45bb618a17282146cc3 | 91855473286000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyCompoundUsdc_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyCompoundUsdt\_deposit\_function
USDT deposit function calls to IPOR's Compound strategy contract on Ethereum, recording deposit amounts in WAD format (18 decimals) and actual deposited amounts. Used for tracking liquidity provider deposits into the Compound-based yield strategy.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_depositedAmount` | `STRING` | Amount of tokens successfully deposited into the strategy contract. String representation of an integer in WAD format. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_depositedAmount |
| ------- | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 203014 | 0 | true | 134172 | 0xb6b55f25 | 0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1 | 17022869 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 74558106839150521597618 | 0,7,0,0,0,6 | 2023-04-11T05:44:47.000Z | 0x9fbf0f742c1de85795906da317c0ce75ef83891eca7f1d2c88f7b26d71ac8162 | 74558106839000000000000 |
| 433034 | 0 | true | 147328 | 0xb6b55f25 | 0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1 | 18983209 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 23335882775293933103703 | 0,0,9,0,0,0,5 | 2024-01-11T10:52:23.000Z | 0xc7ae0ce1e08c295184f37d0b7d02e7cdd5cd672fa169063eca5a0a801bd1cb17 | 23335882775000000000000 |
| 1595713 | 0 | true | 134172 | 0xb6b55f25 | 0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1 | 16992246 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 118253004822505167287217 | 0,7,0,0,0,6 | 2023-04-06T21:37:11.000Z | 0xc1d6ba749f470b0b351781f5c9d7ef4825fc26cabd40e7c0d7f9fd9b617c74a0 | 118253004823000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyCompoundUsdt_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyCompoundUsdt\_withdraw\_function
USDT withdrawal function calls from IPOR Protocol's Compound strategy contract on Ethereum. Tracks withdrawal amounts in WAD format (18 decimals) and actual USDT amounts received, useful for analyzing liquidity management and strategy position changes.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_withdrawnAmount` | `STRING` | Token amount actually withdrawn from the strategy. String representation of an integer in the same WAD format scaling as the input amount. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_withdrawnAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ----------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ----------------------- |
| 294421 | 0 | true | 165747 | 0x2e1a7d4d | 0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1 | 16959376 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 76761675950522514888272 | 0,5,0,0,0,6 | 2023-04-02T05:35:11.000Z | 0xb47c701fc4c2c491e10f653ba2b28c125ba8f5dceda2b55866d9d08ec038ea94 | 76761832509000000000000 |
| 320278 | 0 | true | 106497 | 0x2e1a7d4d | 0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1 | 19442187 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 293078928375 | 0,0,7,0,0,0,5 | 2024-03-15T18:39:59.000Z | 0x38ba1776358eb0b01cd349f4940257ceb32bd797fb4a482bcb95e62119683169 | 0 |
| 692310 | 0 | true | 112497 | 0x2e1a7d4d | 0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1 | 19651843 | 0x8e679c1d67af0cd4b314896856f09ece9e64d6b5 | 869289177200 | 0,0,7,0,0,0,4 | 2024-04-14T05:59:11.000Z | 0xf5515b773be7c2af7e46ed866819980ad9c2db50f982962767c9032b8ebe16ed | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyCompoundUsdt_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyMakerDaoDai\_deposit\_function
DAI deposit transactions into IPOR Protocol's MakerDAO strategy contract on Ethereum. Tracks deposit amounts in WAD format (18 decimals) for analyzing liquidity provisioning to the yield-bearing DAI strategy.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_depositedAmount` | `STRING` | Amount of tokens successfully deposited into the strategy contract. String representation of an integer in WAD format. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_depositedAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 513950 | 0 | true | 228157 | 0xb6b55f25 | 0xc26be51e50a358ec6d366147d78ab94e9597239c | 19411116 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 2161808082218983062175595 | 0,0,2,0,0,0,9 | 2024-03-11T09:59:47.000Z | 0x24defb13af24b601d8b63d5ee35f47c3559e876f40675bbbf637f3a360aeee08 | 2161808082218983062175595 |
| 515006 | 0 | true | 193555 | 0xb6b55f25 | 0xc26be51e50a358ec6d366147d78ab94e9597239c | 18376707 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 83664590456200485498767 | 0,0,9,0,0,0,7 | 2023-10-18T10:40:35.000Z | 0x284aa0dab638060564fc15a325ea7c530597eba71d0e6d5947c54c9fbb5ed86d | 83664590456200485498767 |
| 542197 | 0 | true | 211229 | 0xb6b55f25 | 0xc26be51e50a358ec6d366147d78ab94e9597239c | 18376758 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 71249760026719543598625 | 0,0,9,0,0,0,7 | 2023-10-18T10:50:59.000Z | 0x8a59c94c6b86b428551762d5fd14257e783a2090f5d4f7ef2890bcab163c25c9 | 71249760026719543598625 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyMakerDaoDai_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StrategyMakerDaoDai\_withdraw\_function
Withdrawal function calls from IPOR v2's MakerDAO DAI strategy contract on Ethereum, capturing DAI amounts removed from the protocol's yield-generating positions. Used for analyzing liquidity management and capital allocation patterns in IPOR's DeFi strategy layer.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_wadAmount` | `STRING` | Token amount in WAD (Wei After Decimals) format. String representation of an integer scaled by 10^18 for 18-decimal tokens or 10^6 for 6-decimal tokens. |
| `out_withdrawnAmount` | `STRING` | Token amount actually withdrawn from the strategy. String representation of an integer in the same WAD format scaling as the input amount. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_wadAmount | trace\_address | block\_timestamp | transaction\_hash | out\_withdrawnAmount |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 484010 | 0 | true | 151199 | 0x2e1a7d4d | 0xc26be51e50a358ec6d366147d78ab94e9597239c | 19175921 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 461654004490872609006409 | 0,0,7,0,0,0,6 | 2024-02-07T11:08:35.000Z | 0x4fda14721b580cb25a8ce3c8de49bebf0844f9ae42bf276282077102ff9dd394 | 461654004490872609006409 |
| 449757 | 0 | true | 150798 | 0x2e1a7d4d | 0xc26be51e50a358ec6d366147d78ab94e9597239c | 18696070 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 413592440860799677982064 | 0,0,7,0,0,0,6 | 2023-12-02T03:35:47.000Z | 0x0debe86b2b1507e8d09ba682ab8b005115ebfda1b10378fa002c9c27d8ae06af | 413592440860799677982064 |
| 477667 | 0 | true | 149995 | 0x2e1a7d4d | 0xc26be51e50a358ec6d366147d78ab94e9597239c | 18698256 | 0xa6ac8b6af789319a1db994e25760eb86f796e2b0 | 66098812711867509825025 | 0,0,7,0,0,0,6 | 2023-12-02T10:55:11.000Z | 0x76d2b5d67a4023368657e1f7264b7a61fdc1af0c0d83455a9122abef9d0f2695 | 66098812711867509825025 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ipor_v2_ethereum.StrategyMakerDaoDai_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***