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).

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<totalAmount STRING, collateral STRING, notional STRING, openingFeeLPAmount STRING, openingFeeTreasuryAmount STRING, iporPublicationFee STRING, liquidationDepositAmount STRING>`	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<iporIndexValue STRING, ibtPrice STRING, ibtQuantity STRING, fixedInterestRate STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<totalAmount STRING, collateral STRING, notional STRING, openingFeeLPAmount STRING, openingFeeTreasuryAmount STRING, iporPublicationFee STRING, liquidationDepositAmount STRING>`	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<iporIndexValue STRING, ibtPrice STRING, ibtQuantity STRING, fixedInterestRate STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<inputAssetTotalAmount STRING, assetTotalAmount STRING, collateral STRING, notional STRING, openingFeeLPAmount STRING, openingFeeTreasuryAmount STRING, iporPublicationFee STRING, liquidationDepositAmount STRING>`	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<iporIndexValue STRING, ibtPrice STRING, ibtQuantity STRING, fixedInterestRate STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_lpTokens`	`ARRAY<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_depositedAmount
1735546	true	181613	0xb6b55f25	0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	16515413	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	128574427578900549632232	0,7,0,0,0,6	2023-01-29T22:18:47.000Z	0xbdfee1720a51b66013ed070ca6a9de0a67d4285770803df6a3f71872791a84bd	128574427578900549632232
251106	true	179972	0xb6b55f25	0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	16570440	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	2249089940232933467764621	0,7,0,0,0,6	2023-02-06T14:47:59.000Z	0x471a439207355b1c16cc311fa8d441c4e4eeeb0154bcf2658d5bc21179c213bf	2249089940232933467764621
555665	true	222839	0xb6b55f25	0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	17864271	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	5158206381220220562330133	0,2,0,0,0,6	2023-08-07T16:33:47.000Z	0xac1b38155beaa93212ab5724ebf3ef11ee0cd376352808f60535c110093ba93f	5158206381220220562330133

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_withdrawnAmount
329427	true	190774	0x2e1a7d4d	0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	17616309	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	95205493413622636445503	0,5,0,0,0,6	2023-07-03T22:08:47.000Z	0x8ca79c9279b377be55b0e58c1d6f2319376c3a800bc684305027d6f0c506182e	95205493413622636445503
329422	true	190774	0x2e1a7d4d	0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	17362501	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	461690934003227468297576	0,5,0,0,0,6	2023-05-29T05:14:23.000Z	0xf7d7b986acc2dacf7334926c885f2e7af49b731ccc24f6c4f2e753bc84cf89b8	461690934003227468297576
825742	true	190851	0x2e1a7d4d	0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	17785582	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	223132342664645109441869	0,5,0,0,0,6	2023-07-27T16:25:35.000Z	0xe5e7b90b4d77079f4fd7a00f5550de6e2d67e0c88c2caa21eb8e9a2b37dd0376	223132342664645109441869

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_depositedAmount
276676	true	200382	0xb6b55f25	0x77fcae921e3df22810c5a1ac1d33f2586bba028f	16596292	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	469664647967950000252593	0,7,0,0,0,6	2023-02-10T05:33:23.000Z	0x4b5ae82105540bcdd798ddac49fcae2c89f5110deb78f44dbf653ffb6c8fe4f2	469664647968000000000000
835988	true	200382	0xb6b55f25	0x77fcae921e3df22810c5a1ac1d33f2586bba028f	17359478	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	18585483823652979763626	0,7,0,0,0,6	2023-05-28T19:04:23.000Z	0xb4adacc10ceaed8e42e422c3b6403f27da38450038cf6b97d2083013c11da412	18585483824000000000000
276677	true	200382	0xb6b55f25	0x77fcae921e3df22810c5a1ac1d33f2586bba028f	16590971	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	412283397288449999794006	0,7,0,0,0,6	2023-02-09T11:43:11.000Z	0x8f6368ba0de9e134ee51b5098db49f62d5086b390ed0576b8a1f636d77346d16	412283397288000000000000

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_withdrawnAmount
348780	true	200938	0x2e1a7d4d	0x77fcae921e3df22810c5a1ac1d33f2586bba028f	16984496	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	103289697381385748371951	0,5,0,0,0,6	2023-04-05T19:01:11.000Z	0xb2bb219f46bc497dca0c55ce6f0035b30e3a02ac741f5092697902769fc3470a	103289697381000000000000
348782	true	200938	0x2e1a7d4d	0x77fcae921e3df22810c5a1ac1d33f2586bba028f	16784893	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	458624997663650000024140	0,5,0,0,0,6	2023-03-08T17:02:47.000Z	0xffc2cc639327754ed593efa7d19220ce3ed56be704131e0f5f7ee7ace504b4ad	458624997664000000000000
348782	true	200938	0x2e1a7d4d	0x77fcae921e3df22810c5a1ac1d33f2586bba028f	16781578	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	192109069719799999761135	0,5,0,0,0,6	2023-03-08T05:51:59.000Z	0xaf374a60d54fee352735944bec97ce9f66dc4a4d27ab286a593afd2010e563ba	192109069720000000000000

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_depositedAmount
264593	true	189310	0xb6b55f25	0x58703da5295794ed4e82323fcce7371272c5127d	17613869	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	297562307224406570494329	0,7,0,0,0,6	2023-07-03T13:55:59.000Z	0xaac189ab745a5c5e25475782f54c48c623444fe40261a27556b8783f72ef947f	297562307224000000000000
1814922	true	189233	0xb6b55f25	0x58703da5295794ed4e82323fcce7371272c5127d	16774066	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	462747924869600000177216	0,7,0,0,0,6	2023-03-07T04:31:11.000Z	0x4e8be3d53962c4dbfb76a3297d58227aaa5d26bf403d5936b4e10b27f9bb41e3	462747924870000000000000
1120836	true	252417	0xb6b55f25	0x58703da5295794ed4e82323fcce7371272c5127d	15918492	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	26775931779200000000000	0,0,2,0,0,0,6	2022-11-07T13:37:47.000Z	0x15afb434e70f636eaee3c28fa970abf70340d5bd51652cba2998e8b6931bf37c	26775931779000000000000

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_withdrawnAmount
389426	true	201946	0x2e1a7d4d	0x58703da5295794ed4e82323fcce7371272c5127d	16612760	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	81632872680050000126122	0,5,0,0,0,6	2023-02-12T12:44:11.000Z	0x3240425b691809d08385e2ada329d2617a520a084d3c22ea4f99c2d455436172	81632872680000000000000
330334	true	201946	0x2e1a7d4d	0x58703da5295794ed4e82323fcce7371272c5127d	17634202	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	269022408741097177202310	0,5,0,0,0,6	2023-07-06T10:25:47.000Z	0xba666914b32854ff673a6c4b356424aa74573cdc65de102723978484e0bbcc95	269022408741000000000000
347780	true	202000	0x2e1a7d4d	0x58703da5295794ed4e82323fcce7371272c5127d	16542146	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	247797234470499999741899	0,5,0,0,0,6	2023-02-02T15:56:11.000Z	0xa10a8b150fd2bd13fece62f3b83607090f16de9650d433b90772fe481181b0f1	247797234470000000000000

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_depositedAmount
203590	true	134627	0xb6b55f25	0x87cef19aca214d12082e201e6130432df39fc774	16836830	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	292096780047689390464876	0,7,0,0,0,6	2023-03-16T00:24:11.000Z	0x60c91cc92a6fe788d6a67c4e48be10704ac55c6e14efce9401f79e661bec560c	292096780047689390464876
1507391	true	134627	0xb6b55f25	0x87cef19aca214d12082e201e6130432df39fc774	16839615	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	105728470355559802927995	0,7,0,0,0,6	2023-03-16T09:47:11.000Z	0x331009c0e39880f0ba9c6298391e5517d77300671b95f7d26b8b28a417f9ad49	105728470355559802927995
255716	true	127627	0xb6b55f25	0x87cef19aca214d12082e201e6130432df39fc774	17037514	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	129081266398970519690663	2,0,4,0,7,0,0,0,6	2023-04-13T08:37:59.000Z	0x33da9fc8e51943abec2090834658eb685c2c5a6fde58daed5ca23468d97c8036	129081266398970519690663

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_withdrawnAmount
648811	true	160129	0x2e1a7d4d	0x87cef19aca214d12082e201e6130432df39fc774	17178942	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	494634799147687873908218	0,5,0,0,0,6	2023-05-03T08:13:11.000Z	0xc29a6b0fd1436ef7e8a795433f2883f6e670fd7ef203431535db0b0e66af26ca	494635924283472870643035
679966	true	160129	0x2e1a7d4d	0x87cef19aca214d12082e201e6130432df39fc774	17093849	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	126343097565309635777801	0,5,0,0,0,6	2023-04-21T09:21:59.000Z	0x7a2a5749eb8094c8146494dffbd3d5b6c084df8fc34fe1590ba26d813b54da31	126343233767393281563193
299155	true	160129	0x2e1a7d4d	0x87cef19aca214d12082e201e6130432df39fc774	17088037	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	120720080019615231631557	0,5,0,0,0,6	2023-04-20T13:35:11.000Z	0x604a030343345120e62e9093bf0aecf9c1a14d28d9b4e28db2573a1aa44ca05b	120720211499071964830154

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_depositedAmount
259901	true	186349	0xb6b55f25	0xe5257cf3bd0efd397227981fe7bbd55c7582f526	16791585	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	93490099888349999767817	0,7,0,0,0,6	2023-03-09T15:37:47.000Z	0xe25295e061162b03805de15b6414d6674e2d3a5980927c14feb795f037b9a87e	93490099888000000000000
464431	true	155940	0xb6b55f25	0xe5257cf3bd0efd397227981fe7bbd55c7582f526	17864580	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	5154603270042400000000000	0,2,0,0,0,6	2023-08-07T17:35:59.000Z	0xd71f46f0dff2c8b6ca26f3d541d34adf5552df31400e8f17c35132542e8240ee	5154603270042000000000000
433448	true	149133	0xb6b55f25	0xe5257cf3bd0efd397227981fe7bbd55c7582f526	18597165	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	87430195492077658934573	0,0,9,0,0,0,5	2023-11-18T07:11:11.000Z	0x18fc2ed9cd4832a01dd4579a0a9af1b6f755fc49731e65345d51f3f7fce1207c	87430195492000000000000

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_withdrawnAmount
346685	false	2935	0x2e1a7d4d	0xe5257cf3bd0efd397227981fe7bbd55c7582f526	19571156	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260		0,0,7,0,0,0,5	2024-04-02T22:44:23.000Z	0xd5f77c47d526c13362ecb50ee1ac3c90dfb2c3d63eaa0465d2f478386f076456
323416	false	2935	0x2e1a7d4d	0xe5257cf3bd0efd397227981fe7bbd55c7582f526	20848553	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260		0,0,7,0,0,0,5	2024-09-28T10:31:47.000Z	0x8e6a6ec5a4755adeda8b2ccc4d9ac75981e1d91790da36c11538dbb82f21cf79
491021	true	164264	0x2e1a7d4d	0xe5257cf3bd0efd397227981fe7bbd55c7582f526	18335937	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	91854795118797647194205	0,0,7,0,0,0,4	2023-10-12T17:50:59.000Z	0x886f0bfde0c6b74355244237e58f46b7b618ee63e20df45bb618a17282146cc3	91855473286000000000000

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_depositedAmount
203014	true	134172	0xb6b55f25	0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1	17022869	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	74558106839150521597618	0,7,0,0,0,6	2023-04-11T05:44:47.000Z	0x9fbf0f742c1de85795906da317c0ce75ef83891eca7f1d2c88f7b26d71ac8162	74558106839000000000000
433034	true	147328	0xb6b55f25	0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1	18983209	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	23335882775293933103703	0,0,9,0,0,0,5	2024-01-11T10:52:23.000Z	0xc7ae0ce1e08c295184f37d0b7d02e7cdd5cd672fa169063eca5a0a801bd1cb17	23335882775000000000000
1595713	true	134172	0xb6b55f25	0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1	16992246	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	118253004822505167287217	0,7,0,0,0,6	2023-04-06T21:37:11.000Z	0xc1d6ba749f470b0b351781f5c9d7ef4825fc26cabd40e7c0d7f9fd9b617c74a0	118253004823000000000000

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_withdrawnAmount
294421	true	165747	0x2e1a7d4d	0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1	16959376	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	76761675950522514888272	0,5,0,0,0,6	2023-04-02T05:35:11.000Z	0xb47c701fc4c2c491e10f653ba2b28c125ba8f5dceda2b55866d9d08ec038ea94	76761832509000000000000
320278	true	106497	0x2e1a7d4d	0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1	19442187	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	293078928375	0,0,7,0,0,0,5	2024-03-15T18:39:59.000Z	0x38ba1776358eb0b01cd349f4940257ceb32bd797fb4a482bcb95e62119683169	0
692310	true	112497	0x2e1a7d4d	0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1	19651843	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	869289177200	0,0,7,0,0,0,4	2024-04-14T05:59:11.000Z	0xf5515b773be7c2af7e46ed866819980ad9c2db50f982962767c9032b8ebe16ed	0

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_depositedAmount
513950	true	228157	0xb6b55f25	0xc26be51e50a358ec6d366147d78ab94e9597239c	19411116	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	2161808082218983062175595	0,0,2,0,0,0,9	2024-03-11T09:59:47.000Z	0x24defb13af24b601d8b63d5ee35f47c3559e876f40675bbbf637f3a360aeee08	2161808082218983062175595
515006	true	193555	0xb6b55f25	0xc26be51e50a358ec6d366147d78ab94e9597239c	18376707	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	83664590456200485498767	0,0,9,0,0,0,7	2023-10-18T10:40:35.000Z	0x284aa0dab638060564fc15a325ea7c530597eba71d0e6d5947c54c9fbb5ed86d	83664590456200485498767
542197	true	211229	0xb6b55f25	0xc26be51e50a358ec6d366147d78ab94e9597239c	18376758	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	71249760026719543598625	0,0,9,0,0,0,7	2023-10-18T10:50:59.000Z	0x8a59c94c6b86b428551762d5fd14257e783a2090f5d4f7ef2890bcab163c25c9	71249760026719543598625

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_wadAmount	trace_address	block_timestamp	transaction_hash	out_withdrawnAmount
484010	true	151199	0x2e1a7d4d	0xc26be51e50a358ec6d366147d78ab94e9597239c	19175921	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	461654004490872609006409	0,0,7,0,0,0,6	2024-02-07T11:08:35.000Z	0x4fda14721b580cb25a8ce3c8de49bebf0844f9ae42bf276282077102ff9dd394	461654004490872609006409
449757	true	150798	0x2e1a7d4d	0xc26be51e50a358ec6d366147d78ab94e9597239c	18696070	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	413592440860799677982064	0,0,7,0,0,0,6	2023-12-02T03:35:47.000Z	0x0debe86b2b1507e8d09ba682ab8b005115ebfda1b10378fa002c9c27d8ae06af	413592440860799677982064
477667	true	149995	0x2e1a7d4d	0xc26be51e50a358ec6d366147d78ab94e9597239c	18698256	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	66098812711867509825025	0,0,7,0,0,0,6	2023-12-02T10:55:11.000Z	0x76d2b5d67a4023368657e1f7264b7a61fdc1af0c0d83455a9122abef9d0f2695	66098812711867509825025

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

IporProtocolRouter_CloseSwap_event

IporProtocolRouter_OpenSwap_event

IporProtocolRouter_Redeem_event

IporProtocolRouter_RedeemStEth_event

IporProtocolRouter_SwapUnwind_event

IporProtocolRouter2_OpenSwap_event

IporProtocolRouterV2_OpenSwap_event

LiquidityMining_Claimed_event

StrategyAaveDai_deposit_function

StrategyAaveDai_withdraw_function

StrategyAaveUsdc_deposit_function

StrategyAaveUsdc_withdraw_function

StrategyAaveUsdt_deposit_function

StrategyAaveUsdt_withdraw_function

StrategyCompoundDai_deposit_function

StrategyCompoundDai_withdraw_function

StrategyCompoundUsdc_deposit_function

StrategyCompoundUsdc_withdraw_function

StrategyCompoundUsdt_deposit_function

StrategyCompoundUsdt_withdraw_function

StrategyMakerDaoDai_deposit_function

StrategyMakerDaoDai_withdraw_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​IporProtocolRouter_CloseSwap_event

​IporProtocolRouter_OpenSwap_event

​IporProtocolRouter_Redeem_event

​IporProtocolRouter_RedeemStEth_event

​IporProtocolRouter_SwapUnwind_event

​IporProtocolRouter2_OpenSwap_event

​IporProtocolRouterV2_OpenSwap_event

​LiquidityMining_Claimed_event

​StrategyAaveDai_deposit_function

​StrategyAaveDai_withdraw_function

​StrategyAaveUsdc_deposit_function

​StrategyAaveUsdc_withdraw_function

​StrategyAaveUsdt_deposit_function

​StrategyAaveUsdt_withdraw_function

​StrategyCompoundDai_deposit_function

​StrategyCompoundDai_withdraw_function

​StrategyCompoundUsdc_deposit_function

​StrategyCompoundUsdc_withdraw_function

​StrategyCompoundUsdt_deposit_function

​StrategyCompoundUsdt_withdraw_function

​StrategyMakerDaoDai_deposit_function

​StrategyMakerDaoDai_withdraw_function

Tables

IporProtocolRouter_CloseSwap_event

IporProtocolRouter_OpenSwap_event

IporProtocolRouter_Redeem_event

IporProtocolRouter_RedeemStEth_event

IporProtocolRouter_SwapUnwind_event

IporProtocolRouter2_OpenSwap_event

IporProtocolRouterV2_OpenSwap_event

LiquidityMining_Claimed_event

StrategyAaveDai_deposit_function

StrategyAaveDai_withdraw_function

StrategyAaveUsdc_deposit_function

StrategyAaveUsdc_withdraw_function

StrategyAaveUsdt_deposit_function

StrategyAaveUsdt_withdraw_function

StrategyCompoundDai_deposit_function

StrategyCompoundDai_withdraw_function

StrategyCompoundUsdc_deposit_function

StrategyCompoundUsdc_withdraw_function

StrategyCompoundUsdt_deposit_function

StrategyCompoundUsdt_withdraw_function

StrategyMakerDaoDai_deposit_function

StrategyMakerDaoDai_withdraw_function