ipor_v1_ethereum

Tables

JosephDai_Redeem_event

Redemption events from IPOR v1 protocol’s JosephDai vault on Ethereum, tracking when users withdraw DAI by burning ipToken shares with exchange rates and fees. Used for analyzing vault liquidity flows and redemption patterns.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in 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

in_to	address	in_from	removed	log_index	block_number	in_redeemFee	in_timestamp	in_assetAmount	block_timestamp	in_exchangeRate	in_redeemAmount	in_ipTokenAmount	transaction_hash
0x46e6f25d092ad9048a3c2bf09a8ea02fa15f0d05	0x086d4daab14741b195dee65aff050ba184b65045	0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	171	16808404	7583656624838552033	1678580999	1516731324967710406650	2023-03-12T00:29:59.000Z	1046021603426007177	1509147668342871854617	1450000000000000000000	0x348da927314b45d4e39f955f4daf0062d0961faffcbd7f12d884bcd65f00c119
0x5d488cc1e19d19debcfaa17bec2d525616e06a82	0x086d4daab14741b195dee65aff050ba184b65045	0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	296	16812387	114626264734872813530	1678629455	22925252946974562705906	2023-03-12T13:57:35.000Z	1046039339614583133	22810626682239689892376	21916243566347564554940	0x53ad5c3a8c699c98f536407801bd80d40f77dcdb359d5a9bcc7d15866f27884b
0x0328c8b74fc29943b1c6be6cba3f94119366e9b7	0x086d4daab14741b195dee65aff050ba184b65045	0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	196	16809181	75349497231581898487	1678590503	15069899446316379697360	2023-03-12T03:08:23.000Z	1046024679490552781	14994549949084797798873	14406829725715361740540	0xd5f315489d9b421040f4c9e776fa07b9e65201b8f8875390e4285ce425098d35

Example Query

Query with partition filter

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

JosephUsdc_Redeem_event

USDC redemption events from IPOR Protocol’s Joseph vault on Ethereum, tracking conversions from ipToken (interest-bearing position tokens) back to USDC with exchange rates and fees. Used for analyzing vault withdrawals, fee structures, and liquidity provider exits from IPOR’s interest rate derivatives protocol.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in 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

in_to	address	in_from	removed	log_index	block_number	in_redeemFee	in_timestamp	in_assetAmount	block_timestamp	in_exchangeRate	in_redeemAmount	in_ipTokenAmount	transaction_hash
0x6f0d30ee2bc8d381eefc23d5149fc9eee268321b	0xc52569b5a349a7055e9192dbdd271f1bd8133277	0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	142	16320235	5055000191964286523	1672676303	1011000038392857304694	2023-01-02T16:18:23.000Z	1033614234166566843	1005945038000000000000	978121241923546050311	0xf3aea52f58464600b3a133732d921b8c02ea084d8e00ae4500f2a2a38575e24c
0xdb0267ee1c6692d09edd8e654da3f76eb845a1f4	0xc52569b5a349a7055e9192dbdd271f1bd8133277	0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	236	16319011	5017619870451967745	1672661555	1003523974090393549012	2023-01-02T12:12:35.000Z	1033584409009994672	998506354000000000000	970916323178293567722	0xbe41d731ba5ed650a0ce6e709dac1be4b2413f8de6c0e66445e9038f27f09722
0xeae2d1cfaa84e5cc175b4913dc866f6cb7306681	0xc52569b5a349a7055e9192dbdd271f1bd8133277	0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	167	16318458	1185254005266624635	1672654895	237050801053324926960	2023-01-02T10:21:35.000Z	1033577306187978524	235865547000000000000	229349850885959835994	0xadb8cd47044a4a7b9b39c33d04eba468b229aae21a6e8b2e7add485ca6250c15

Example Query

Query with partition filter

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

JosephUsdt_Redeem_event

Redemption events from IPOR Protocol v1’s JosephUsdt pool on Ethereum, tracking withdrawals of ipToken (interest-bearing tokens) for underlying USDT with exchange rates, fees, and amounts. Used for analyzing liquidity provider exits and yield-bearing token redemption patterns.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in 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

in_to	address	in_from	removed	log_index	block_number	in_redeemFee	in_timestamp	in_assetAmount	block_timestamp	in_exchangeRate	in_redeemAmount	in_ipTokenAmount	transaction_hash
0x4a4037e53306f284cf214b733e9a54d6a5939818	0x33c5a44fd6e76fc2b50a9187cfeac336a74324ac	0x28bc58e600ef718b9e97d294098abecb8c96b687	false	38	17037872	9109041588504051647	1681379927	1821808317700810329321	2023-04-13T09:58:47.000Z	1051819227157729174	1812699276000000000000	1732054587577542723413	0x04b65a6c53814b581b5f450219d80f2636dfe99d6ec6826e52a8ea362edd466b
0x87839e0378c62d8962c76726cfdd932a97ef626a	0x33c5a44fd6e76fc2b50a9187cfeac336a74324ac	0x28bc58e600ef718b9e97d294098abecb8c96b687	false	14	17038806	341848161513205356100	1681392407	68369632302641071220000	2023-04-13T13:26:47.000Z	1051840496963708788	68027784141000000000000	65000000000000000000000	0x4bc21bca634f79ffb3a17df9cad0889067141d525a25426e70a2f3fa1a1d1de2
0xa827150caaebabcb696b9b44d16c2367dd03828b	0x33c5a44fd6e76fc2b50a9187cfeac336a74324ac	0x28bc58e600ef718b9e97d294098abecb8c96b687	false	159	17037040	2506129790312929305194	1681368731	501225958062585861038770	2023-04-13T06:52:11.000Z	1051523245284398521	498719828272000000000000	476666550464153171503682	0xd508de952dec670a658d3ad0706ccfd1a5c5522ab9661f9f4d600b946ceef7cd

Example Query

Query with partition filter

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

MiltonDai_CloseSwap_event

Interest rate swap closure events from IPOR protocol’s DAI market (MiltonDai) on Ethereum. Tracks swap settlements including profit/loss transfers to buyers, liquidation amounts, and protocol fees for analyzing position outcomes and liquidation 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_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).
`in_incomeFeeValue`	`STRING`	Protocol fee collected from closing this swap position, denominated in the asset token’s smallest unit. Values typically range from sub-DAI amounts to tens of DAI (18 decimal precision).

Sample Data

address	removed	in_asset	in_swapId	log_index	block_number	in_liquidator	block_timestamp	transaction_hash	in_closeTimestamp	in_incomeFeeValue	in_transferredToBuyer	in_transferredToLiquidator
0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	0x6b175474e89094c44da98b954eedeac495271d0f	213	4	16825642	0x000000000000df8c944e775bde7af50300999283	2023-03-14T10:38:11.000Z	0x8b8328e9696f86f24e701b420f617117b33be398bf785d936c81b2970e42b409	1678790291	9806876665126417468	3565261889986137757207	25000000000000000000
0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	0x6b175474e89094c44da98b954eedeac495271d0f	214	17	16825645	0x000000000000df8c944e775bde7af50300999283	2023-03-14T10:38:47.000Z	0xce9ca6e9811bfb7a9c5bc28a88c411ebeb52e9858dd959ad81cfcbb0237105ae	1678790327	18641542550831342792	3459525168551092512672	25000000000000000000
0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	0x6b175474e89094c44da98b954eedeac495271d0f	46	258	15738007	0xfd9f45f118f0a6aaa0eb1491576e79e6899c4e35	2022-10-13T08:29:23.000Z	0x5bfd1d77f3ad18c913327eb670ed8a66aac732e4fcd70817ac390b4975198a64	1665649763	3773323825159488466	4313148033238316584314	0

Example Query

Query with partition filter

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

MiltonDai_OpenSwap_event

Interest rate swap opening records from IPOR protocol v1’s DAI market on Ethereum. Contains collateral amounts, fixed/floating rate terms, and pricing indicators for analyzing derivative position creation and market conditions.

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_money`	`STRUCT<totalAmount STRING, collateral STRING, notional STRING, openingFeeLPAmount STRING, openingFeeTreasuryAmount STRING, iporPublicationFee STRING, liquidationDepositAmount STRING>`	Financial breakdown of the swap transaction, including notional amount, collateral, fees, and total amount paid. All monetary values are denominated in the smallest unit of the asset (e.g., wei for DAI).
`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_money	in_swapId	log_index	block_number	in_direction	in_indicator	block_timestamp	in_endTimestamp	in_openTimestamp	transaction_hash
0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	0x6b175474e89094c44da98b954eedeac495271d0f	0xa95c4294cfdbcfad59f7a936f580873019fde52e	{“notional”:“2230722772277227722772000”,“collateral”:“2230722772277227722772”,“totalAmount”:“2288030000000000000000”,“iporPublicationFee”:“10000000000000000000”,“openingFeeLPAmount”:“22307227722772277228”,“liquidationDepositAmount”:“25000000000000000000”,“openingFeeTreasuryAmount”:“0”}	85	117	16022884	1	{“ibtPrice”:“1004506888880331402”,“ibtQuantity”:“2220714259873012662643482”,“iporIndexValue”:“17439204113919571”,“fixedInterestRate”:“17273371714278169”}	2022-11-22T03:32:23.000Z	1671507143	1669087943	0x157835e41466966d4b63512260e6daa8bb528456d25288e4f54bcf4047080b8a
0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	0x6b175474e89094c44da98b954eedeac495271d0f	0xc150ef33f7cd780c4771342879f70b719b755ebd	{“notional”:“3404029702970297029703000”,“collateral”:“3404029702970297029703”,“totalAmount”:“3473070000000000000000”,“iporPublicationFee”:“10000000000000000000”,“openingFeeLPAmount”:“34040297029702970297”,“liquidationDepositAmount”:“25000000000000000000”,“openingFeeTreasuryAmount”:“0”}	32	93	15537306	1	{“ibtPrice”:“1001336020638385623”,“ibtQuantity”:“3399487916953304863593933”,“iporIndexValue”:“20328449614261452”,“fixedInterestRate”:“16844389446056598”}	2022-09-15T06:22:08.000Z	1665642128	1663222928	0x2449fb9f0d42524b0213c5f7377c29c3c04b7ba874032fb7bff406b28862eba3
0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	0x6b175474e89094c44da98b954eedeac495271d0f	0xa95c4294cfdbcfad59f7a936f580873019fde52e	{“notional”:“2563821782178217821782000”,“collateral”:“2563821782178217821782”,“totalAmount”:“2624460000000000000000”,“iporPublicationFee”:“10000000000000000000”,“openingFeeLPAmount”:“25638217821782178218”,“liquidationDepositAmount”:“25000000000000000000”,“openingFeeTreasuryAmount”:“0”}	33	186	15537308	1	{“ibtPrice”:“1001336042555156516”,“ibtQuantity”:“2560400977513994782924568”,“iporIndexValue”:“20328449614261452”,“fixedInterestRate”:“16844389446056598”}	2022-09-15T06:22:42.000Z	1665642162	1663222962	0x83828216847d2f05a818e3abbb52a7fd45c879a988ae1d41e7fad119c933002e

Example Query

Query with partition filter

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

MiltonStorageDAI_addLiquidity_function

Liquidity provision transactions to IPOR Protocol’s DAI pool on Ethereum, capturing deposit amounts and pool configuration limits. Contains account addresses, DAI amounts deposited, and maximum contribution parameters for analyzing liquidity provider 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_assetAmount`	`STRING`	Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.
`in_cfgMaxLiquidityPoolBalance`	`STRING`	Maximum total DAI liquidity allowed in the IPOR protocol pool, specified in wei. This configuration parameter acts as a protocol-wide cap on total pool size.
`in_cfgMaxLpAccountContribution`	`STRING`	Maximum DAI amount (in wei) that a single liquidity provider account is permitted to contribute to the IPOR Milton pool. This configuration parameter serves as a per-account deposit cap to prevent concentration risk.

Sample Data

gas	status	gas_used	signature	in_account	to_address	block_number	from_address	trace_address	in_assetAmount	block_timestamp	transaction_hash	in_cfgMaxLiquidityPoolBalance	in_cfgMaxLpAccountContribution
94454	true	12250	0x1ece366a	0x36c48e7b0d92cb0eaeb7754e21494dcb832635e0	0xb99f2a02c0851efdd417bd6935d2efcd23c56e61	16836795	0x086d4daab14741b195dee65aff050ba184b65045	0,3	8973671628052642528236	2023-03-16T00:16:59.000Z	0xa44bb1bbb4d555bdd65e9d9a5d99fbc3ae7022ca952ca8332b1c30db063efa2a	20000000000000000000000000	500000000000000000000000
1799610	true	12250	0x1ece366a	0x14975679e5f87c25fa2c54958e735a79b5b93043	0xb99f2a02c0851efdd417bd6935d2efcd23c56e61	16839615	0x086d4daab14741b195dee65aff050ba184b65045	0,3	111295861164866745492345	2023-03-16T09:47:11.000Z	0x331009c0e39880f0ba9c6298391e5517d77300671b95f7d26b8b28a417f9ad49	20000000000000000000000000	500000000000000000000000
427870	true	29350	0x1ece366a	0x1fa536059a9a833f8ed3b3b9f7c357c5a331cd80	0xb99f2a02c0851efdd417bd6935d2efcd23c56e61	16836830	0x086d4daab14741b195dee65aff050ba184b65045	0,3	311475445641250000000000	2023-03-16T00:24:11.000Z	0x60c91cc92a6fe788d6a67c4e48be10704ac55c6e14efce9401f79e661bec560c	20000000000000000000000000	500000000000000000000000

Example Query

Query with partition filter

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

MiltonStorageDAI_subtractLiquidity_function

DAI liquidity withdrawal function calls from IPOR Protocol v1’s Milton Storage contract on Ethereum. Tracks asset amounts removed from the protocol’s DAI liquidity pool with transaction-level execution details.

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_assetAmount`	`STRING`	Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	in_assetAmount	block_timestamp	transaction_hash
53352	true	6284	0x596e4fcd	0xb99f2a02c0851efdd417bd6935d2efcd23c56e61	16683419	0x086d4daab14741b195dee65aff050ba184b65045	0,6	16942157724241154266491	2023-02-22T10:33:23.000Z	0x236f331036ae98cb4e9dc54f659998b0277ea8dda384c416ed2d588f012e919d
53351	true	6284	0x596e4fcd	0xb99f2a02c0851efdd417bd6935d2efcd23c56e61	16683698	0x086d4daab14741b195dee65aff050ba184b65045	0,6	1610377083595868857099	2023-02-22T11:30:35.000Z	0x9dca838b70eb667ae9a39c50d1433d4bdb7101daac213db04139b227e2bdb717
71867	true	6284	0x596e4fcd	0xb99f2a02c0851efdd417bd6935d2efcd23c56e61	16681659	0x086d4daab14741b195dee65aff050ba184b65045	0,6	520214775583684330404	2023-02-22T04:37:11.000Z	0xb31074ab34dc900b47632d031b37bc3066a209d485a900eb1a968dc548ed1ba8

Example Query

Query with partition filter

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

MiltonStorageUSDC_addLiquidity_function

Liquidity provision transactions for IPOR protocol’s USDC pool on Ethereum, capturing deposit amounts and pool configuration limits. Used for tracking liquidity provider contributions and analyzing pool growth dynamics.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_assetAmount`	`STRING`	Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.
`in_cfgMaxLiquidityPoolBalance`	`STRING`	Maximum total liquidity allowed in the IPOR USDC pool, specified in wei (smallest unit). This configuration parameter acts as a cap on total pool deposits and remains constant at 3M USDC initially, later increased to 20M USDC.
`in_cfgMaxLpAccountContribution`	`STRING`	Maximum amount an individual liquidity provider account is allowed to contribute to the IPOR USDC pool, specified in wei. This configuration parameter sets the per-account deposit cap to prevent concentration risk.

Sample Data

gas	status	gas_used	signature	in_account	to_address	block_number	from_address	trace_address	in_assetAmount	block_timestamp	transaction_hash	in_cfgMaxLiquidityPoolBalance	in_cfgMaxLpAccountContribution
128892	true	29388	0x1ece366a	0x250302de8c3a0443dffc8e25f5d5d276ff5cde7f	0xb3d1c1ab4d30800162da40eb18b3024154924ba5	16133216	0xc52569b5a349a7055e9192dbdd271f1bd8133277	0,3	2000000000000000000	2022-12-07T13:46:59.000Z	0xb3333555e50234a7ec2dd496aed39ce49aeee0c2a2fdced90b0f31f0101cd073	3000000000000000000000000	50000000000000000000000
128893	true	29388	0x1ece366a	0x2a59229fcb4c91fed9315d3864c86b29ffe6a4f0	0xb3d1c1ab4d30800162da40eb18b3024154924ba5	16134692	0xc52569b5a349a7055e9192dbdd271f1bd8133277	0,3	50000000000000000000	2022-12-07T18:43:35.000Z	0x6a8ff773d0167ec45dc422c6ad9434fd5f8aa89e23caa242a5e0c4adba938869	3000000000000000000000000	50000000000000000000000
128892	true	29388	0x1ece366a	0x60dd91585629806b59c5f330e8c4d542a3be7fc9	0xb3d1c1ab4d30800162da40eb18b3024154924ba5	16131111	0xc52569b5a349a7055e9192dbdd271f1bd8133277	0,3	400000000000000000000	2022-12-07T06:36:35.000Z	0x65ad2fa286689ed3815990b20d0af669a1d2b53268d9a89ba7d9e5e52a873c1b	3000000000000000000000000	50000000000000000000000

Example Query

Query with partition filter

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

MiltonStorageUSDC_subtractLiquidity_function

IPOR v1 protocol liquidity removal transactions for USDC storage contract on Ethereum. Tracks subtractLiquidity function calls with asset amounts withdrawn, useful for analyzing liquidity provider withdrawal patterns and pool dynamics.

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_assetAmount`	`STRING`	Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	in_assetAmount	block_timestamp	transaction_hash
73528	true	6284	0x596e4fcd	0xb3d1c1ab4d30800162da40eb18b3024154924ba5	15652787	0xc52569b5a349a7055e9192dbdd271f1bd8133277	0,6	298757509000000000000	2022-10-01T10:42:59.000Z	0xfb694f916d3673253f883c37d7d56212487a11ab1a8f2a962f02fe9c983f8b56
73700	true	6284	0x596e4fcd	0xb3d1c1ab4d30800162da40eb18b3024154924ba5	16023481	0xc52569b5a349a7055e9192dbdd271f1bd8133277	0,6	101861013000000000000	2022-11-22T05:32:11.000Z	0xda69610790992007bd2bce6394e58edb7ff1ce32c15d4f65ab7ef7d11eb481aa
69640	true	6284	0x596e4fcd	0xb3d1c1ab4d30800162da40eb18b3024154924ba5	16024910	0xc52569b5a349a7055e9192dbdd271f1bd8133277	0,6	4985994000000000000	2022-11-22T10:19:35.000Z	0x937a7aaa7466ff8a676482d83eb9c7dc9777121fcb0368cbf27864b04439be45

Example Query

Query with partition filter

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

MiltonStorageUSDT_addLiquidity_function

Liquidity deposit transactions for IPOR Protocol’s USDT pool on Ethereum, capturing deposit amounts, account addresses, and pool balance configuration limits. Used for analyzing liquidity provider behavior and pool growth dynamics in IPOR’s interest rate derivatives market.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_assetAmount`	`STRING`	Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.
`in_cfgMaxLiquidityPoolBalance`	`STRING`	Maximum allowed total balance for the IPOR USDT liquidity pool, specified as input parameter to the add liquidity function. Value is in wei (18 decimals), typically set to 20M USDT based on sample data.
`in_cfgMaxLpAccountContribution`	`STRING`	Maximum USDT amount (in wei, 6 decimals) a single liquidity provider account can contribute to the IPOR v1 pool. This configuration parameter acts as a per-account deposit cap to limit concentration risk.

Sample Data

gas	status	gas_used	signature	in_account	to_address	block_number	from_address	trace_address	in_assetAmount	block_timestamp	transaction_hash	in_cfgMaxLiquidityPoolBalance	in_cfgMaxLpAccountContribution
486185	true	12250	0x1ece366a	0x475cc2876e1fdb6462247275c3da8d29639c92d0	0x364f116352eb95033d73822ba81257b8c1f5b1ce	16799826	0x33c5a44fd6e76fc2b50a9187cfeac336a74324ac	0,3	83922316877000000000000	2023-03-10T19:33:59.000Z	0x8c7abc9e16b98250a1d38bfff67f09d6a13376e5531e1b461b30474fb060a3c9	20000000000000000000000000	500000000000000000000000
122933	true	29350	0x1ece366a	0xb957dccaa1ccfb1eb78b495b499801d591d8a403	0x364f116352eb95033d73822ba81257b8c1f5b1ce	16799514	0x33c5a44fd6e76fc2b50a9187cfeac336a74324ac	0,3	3509171062000000000000	2023-03-10T18:30:47.000Z	0xf79d7cf67de56d638c4f83ebb1ea35dcf5d7657d060fda15433697f80575b7b4	20000000000000000000000000	500000000000000000000000
122934	true	29350	0x1ece366a	0xfccbbe08538662d3f9f76a293575f9a6604129c5	0x364f116352eb95033d73822ba81257b8c1f5b1ce	16800163	0x33c5a44fd6e76fc2b50a9187cfeac336a74324ac	0,3	4651172914000000000000	2023-03-10T20:41:35.000Z	0x5abf270fb4f4d507f1efd85dceca807a10998988a265a602dde7af306cf90bc2	20000000000000000000000000	500000000000000000000000

Example Query

Query with partition filter

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

MiltonStorageUSDT_subtractLiquidity_function

IPOR (Interest Protocol On-chain Rate) v1 liquidity withdrawal function calls for USDT pools on Ethereum. Tracks amounts removed from the MiltonStorage contract for analyzing liquidity provider redemptions and pool capacity 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_assetAmount`	`STRING`	Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	in_assetAmount	block_timestamp	transaction_hash
70054	true	6284	0x596e4fcd	0x364f116352eb95033d73822ba81257b8c1f5b1ce	16168879	0x33c5a44fd6e76fc2b50a9187cfeac336a74324ac	0,6	205586905000000000000	2022-12-12T13:18:59.000Z	0x62c8fdd76d1ee2e4f8074d6cd2b2f4791f82c9948abbbd8c54f279ffc6c7f90d
70054	true	6284	0x596e4fcd	0x364f116352eb95033d73822ba81257b8c1f5b1ce	16168922	0x33c5a44fd6e76fc2b50a9187cfeac336a74324ac	0,6	1001971122000000000000	2022-12-12T13:27:47.000Z	0xc8cce98f003ee2e1b75786b879413433e573886e282eebb092445e8b8c89298f
88569	true	6284	0x596e4fcd	0x364f116352eb95033d73822ba81257b8c1f5b1ce	16168897	0x33c5a44fd6e76fc2b50a9187cfeac336a74324ac	0,6	1352095864000000000000	2022-12-12T13:22:47.000Z	0x17a1e0265d8f6d4a708800e2ff68fcb4a034473169d24dcacd0ac59714f0ebb1

Example Query

Query with partition filter

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

MiltonUsdc_CloseSwap_event

Interest rate swap closure events from IPOR Protocol’s Milton USDC vault on Ethereum. Tracks swap settlements with fee distributions, payout amounts to buyers and liquidators, and swap identifiers for analyzing derivative position lifecycles.

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).
`in_incomeFeeValue`	`STRING`	Income fee collected by the protocol upon swap closure, denominated in the smallest unit of the asset (wei for tokens with 18 decimals). Values range from hundreds of thousands to tens of quadrillions of wei, representing protocol revenue from the closed swap position.

Sample Data

address	removed	in_asset	in_swapId	log_index	block_number	in_liquidator	block_timestamp	transaction_hash	in_closeTimestamp	in_incomeFeeValue	in_transferredToBuyer	in_transferredToLiquidator
0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	110	68	16063621	0x0e113904cb1d53cabb324927dffae2f8f6705111	2022-11-27T20:10:59.000Z	0x6f393922ca81ee19b841e3c0cb1d7b9cec2daeb9a15c7d85f5d700904dd17460	1669579859	53696604183094228	500483269000000000000	25000000000000000000
0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	57	367	15690253	0xfd9f45f118f0a6aaa0eb1491576e79e6899c4e35	2022-10-06T16:28:59.000Z	0x5e97ec08ba0cac2e4ee820495aa82af6a1cd627bac05b1e1e3b6d80afacab66e	1665073739	22938321501345513289	5415785102000000000000	0
0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	32	591	15515191	0x57d621d02992672b80154243d54353b66e4483ae	2022-09-11T13:54:45.000Z	0xc9b201c668fef66519038bea8b4a74ee67235e4ffbc89b55685559f77bfafe9d	1662904485	1261912575007638278	2448499686000000000000	0

Example Query

Query with partition filter

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

MiltonUsdc_OpenSwap_event

Interest rate swap opening events from IPOR Protocol v1 on Ethereum using USDC collateral. Records pay-fixed/receive-floating position entries with notional amounts, collateral, fixed rates, and IPOR index values for analyzing DeFi interest rate derivatives 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_money`	`STRUCT<totalAmount STRING, collateral STRING, notional STRING, openingFeeLPAmount STRING, openingFeeTreasuryAmount STRING, iporPublicationFee STRING, liquidationDepositAmount STRING>`	Financial breakdown of the swap transaction including notional amount, collateral posted, and various fees (publication, liquidity provider, liquidation deposit, and treasury). All amounts denominated in the asset’s smallest unit (typically 18 decimals for tokens).
`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_money	in_swapId	log_index	block_number	in_indicator	block_timestamp	in_endTimestamp	in_openTimestamp	transaction_hash
0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x3858f2718eceaaff646b8f971be38d3e201ef1d6	{“notional”:“5000000000000000000000”,“collateral”:“500000000000000000000”,“totalAmount”:“540000000000000000000”,“iporPublicationFee”:“10000000000000000000”,“openingFeeLPAmount”:“5000000000000000000”,“liquidationDepositAmount”:“25000000000000000000”,“openingFeeTreasuryAmount”:“0”}	133	122	15984144	{“ibtPrice”:“1003221518713370217”,“ibtQuantity”:“4983944130716505119814”,“iporIndexValue”:“13621688414941372”,“fixedInterestRate”:“16518554783569112”}	2022-11-16T17:42:35.000Z	1671039755	1668620555	0xcc737ed5cba5af37f2beffc31b036d25a5cc2a44f739e0cc945e5219bcf99d6b
0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x6fc72314958b1713b5db16a9240f6dc01eb353f7	{“notional”:“20000000000000000000000000”,“collateral”:“20000000000000000000000”,“totalAmount”:“20235000000000000000000”,“iporPublicationFee”:“10000000000000000000”,“openingFeeLPAmount”:“200000000000000000000”,“liquidationDepositAmount”:“25000000000000000000”,“openingFeeTreasuryAmount”:“0”}	132	515	15982800	{“ibtPrice”:“1003214439928218488”,“ibtQuantity”:“19935917191773107132640822”,“iporIndexValue”:“13727134719187736”,“fixedInterestRate”:“16746395636649091”}	2022-11-16T13:11:11.000Z	1671023471	1668604271	0x7cf7714b2e63053b1a6ce1aaaf0b030e51312d29b4704a6af749e0063def4921
0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x96900ee60c4e20f61d5b08c5608c52a1cd9c18ff	{“notional”:“3000000000000000000000000”,“collateral”:“6000000000000000000000”,“totalAmount”:“6095000000000000000000”,“iporPublicationFee”:“10000000000000000000”,“openingFeeLPAmount”:“60000000000000000000”,“liquidationDepositAmount”:“25000000000000000000”,“openingFeeTreasuryAmount”:“0”}	1210	280	16875728	{“ibtPrice”:“1010377833994629554”,“ibtQuantity”:“2969186277710785423434365”,“iporIndexValue”:“23530253720706585”,“fixedInterestRate”:“24986223130490943”}	2023-03-21T11:30:47.000Z	1681817447	1679398247	0x83a8d74b7339666a885389bdb186ab8ff21f75e0b28df60f592f2207e91697a5

Example Query

Query with partition filter

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

MiltonUsdt_CloseSwap_event

Interest rate swap closure events from IPOR Protocol’s Milton USDT market on Ethereum. Records swap settlements with position transfers, liquidator payouts, and protocol fee distributions for tracking derivative position lifecycle and profitability 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.
`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).
`in_incomeFeeValue`	`STRING`	Fee income generated by the protocol from closing this swap, denominated in the smallest unit of the asset. Represented as a string to preserve precision for large wei-denominated values.

Sample Data

address	removed	in_asset	in_swapId	log_index	block_number	in_liquidator	block_timestamp	transaction_hash	in_closeTimestamp	in_incomeFeeValue	in_transferredToBuyer	in_transferredToLiquidator
0x28bc58e600ef718b9e97d294098abecb8c96b687	false	0xdac17f958d2ee523a2206206994597c13d831ec7	55	317	15847404	0xa3aeb9ac7e2174e684e5142cf6075cba85278665	2022-10-28T15:17:35.000Z	0x52d89f0ee5855497deb86341a6a5a177ea25cb2aff7ac34376069d75aa2bdae0	1666970255	3754404976022066	525209981000000000000	0
0x28bc58e600ef718b9e97d294098abecb8c96b687	false	0xdac17f958d2ee523a2206206994597c13d831ec7	227	310	16584586	0x6fc72314958b1713b5db16a9240f6dc01eb353f7	2023-02-08T14:14:35.000Z	0x169f7e8ce423a50f0bbd9794734448cbf39c15fbf41ec0a99f8872ae31b2085d	1675865675	251993159852363381471	27292938439000000000000	0
0x28bc58e600ef718b9e97d294098abecb8c96b687	false	0xdac17f958d2ee523a2206206994597c13d831ec7	211	49	16582376	0x6c63a4df7551472145c6bb35bbe91d291129cd45	2023-02-08T06:49:23.000Z	0x4420809334ea4aebde65623eb46ba1aa670905194099ae0ad14051658d2b52ec	1675838963	38308173108804124637	1258991380000000000000	25000000000000000000

Example Query

Query with partition filter

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

MiltonUsdt_OpenSwap_event

Interest rate swap opening events from IPOR Protocol v1 for USDT on Ethereum. Records swap positions with collateral, notional amounts, fixed rates, and interest-bearing token (IBT) pricing data for tracking position entries and fee calculations.

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_money`	`STRUCT<totalAmount STRING, collateral STRING, notional STRING, openingFeeLPAmount STRING, openingFeeTreasuryAmount STRING, iporPublicationFee STRING, liquidationDepositAmount STRING>`	Financial breakdown of the swap transaction including collateral, fees, and notional amounts in wei. Nested record contains fields like notional amount, collateral posted, total payment, IPOR publication fee, LP opening fee, liquidation deposit, and treasury fee.
`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_money	in_swapId	log_index	block_number	in_direction	in_indicator	block_timestamp	in_endTimestamp	in_openTimestamp	transaction_hash
0x28bc58e600ef718b9e97d294098abecb8c96b687	false	0xdac17f958d2ee523a2206206994597c13d831ec7	0xfd9f45f118f0a6aaa0eb1491576e79e6899c4e35	{“notional”:“605891089108910891089000”,“collateral”:“1211782178217821782178”,“totalAmount”:“1258900000000000000000”,“iporPublicationFee”:“10000000000000000000”,“openingFeeLPAmount”:“12117821782178217822”,“liquidationDepositAmount”:“25000000000000000000”,“openingFeeTreasuryAmount”:“0”}	365	300	17377426	1	{“ibtPrice”:“1026328261448314430”,“ibtQuantity”:“590348246139009177707609”,“iporIndexValue”:“30325727078094152”,“fixedInterestRate”:“29599704586540605”}	2023-05-31T07:38:59.000Z	1687937939	1685518739	0x5f8153fb6e3fddd49a431263e6ee82f038f052a04eaf14f2724c65ecb67f7204
0x28bc58e600ef718b9e97d294098abecb8c96b687	false	0xdac17f958d2ee523a2206206994597c13d831ec7	0xb9d7d776583959678929c404212a4ea8ac5743af	{“notional”:“150000000000000000000000”,“collateral”:“500000000000000000000”,“totalAmount”:“540000000000000000000”,“iporPublicationFee”:“10000000000000000000”,“openingFeeLPAmount”:“5000000000000000000”,“liquidationDepositAmount”:“25000000000000000000”,“openingFeeTreasuryAmount”:“0”}	195	134	16296493	1	{“ibtPrice”:“1009751797898949690”,“ibtQuantity”:“148551357187096745030680”,“iporIndexValue”:“26670054492963201”,“fixedInterestRate”:“25722609050778528”}	2022-12-30T08:48:11.000Z	1674809291	1672390091	0x33248170b89d7167daf28cf69cf639f322e5a87ef301a046f1dfb2dc63301214
0x28bc58e600ef718b9e97d294098abecb8c96b687	false	0xdac17f958d2ee523a2206206994597c13d831ec7	0x0c8ee7dbf8cb1d980c107d3df6357deac7dbe9ef	{“notional”:“1000000000000000000000000”,“collateral”:“1000000000000000000000”,“totalAmount”:“1045000000000000000000”,“iporPublicationFee”:“10000000000000000000”,“openingFeeLPAmount”:“10000000000000000000”,“liquidationDepositAmount”:“25000000000000000000”,“openingFeeTreasuryAmount”:“0”}	198	132	16310723	0	{“ibtPrice”:“1009895272082385396”,“ibtQuantity”:“990201684911365583726299”,“iporIndexValue”:“26380101573998449”,“fixedInterestRate”:“26440876824183643”}	2023-01-01T08:28:11.000Z	1674980891	1672561691	0x1520d360e9d8a6650ee1b8e0dbad219488bf38cc6b46bcc4dfa21d0507f56f38

Example Query

Query with partition filter

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

PowerToken_RewardsReceived_event

Reward distribution events from IPOR protocol’s PowerToken staking contract on Ethereum, tracking token amounts received by staker accounts. Used for analyzing staking reward payouts and participant behavior in IPOR’s governance token system.

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_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	block_number	block_timestamp	in_rewardsAmount	transaction_hash
0xd72915b95c37ae1b16b926f85ad61cca6395409f	false	286	0x0abe45318412e3279d89e12fb8c1435a6072c6e4	17967794	2023-08-22T04:13:23.000Z	64355328877665652	0x4a4bdd5b160677ab21e7f921af9f79572302a743c44c89ec899351b2876febeb
0xd72915b95c37ae1b16b926f85ad61cca6395409f	false	361	0x0abe45318412e3279d89e12fb8c1435a6072c6e4	17967789	2023-08-22T04:12:23.000Z	999053509744738728470	0xe8ab624e7a3369ff3eab8bc4ba06af62bbb28d8e91646a2cbd1ef81d15c73ce4
0xd72915b95c37ae1b16b926f85ad61cca6395409f	false	285	0x40bf6afea1cffdf9c228c2624c9b3ae2c08972a1	17971733	2023-08-22T17:26:35.000Z	21853320208953622	0x5916e37fe6f18b028562ca786953f61375bedb3ec242f8df1a766570cc1ff517

Example Query

Query with partition filter

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

StanleyDai_Deposit_event

DAI stablecoin deposit events from IPOR Protocol’s StanleyDai vault on Ethereum, tracking depositor addresses, deposit amounts, exchange rates, and resulting interest-bearing token (ipToken) amounts for yield strategy 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.
`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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_ivTokenAmount`	`STRING`	Amount of IP tokens (ipTokens) received or redeemed in the operation. Numeric string representation with 18 decimal places of precision.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_timestamp	block_timestamp	in_exchangeRate	in_ivTokenAmount	transaction_hash
0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	68949499090295084618411	184	17625749	1688536655	2023-07-05T05:57:35.000Z	1011231206214971442	68183713740769915831338	0xb0cec79a5bb085484c1b1fd05fa25b4d7a29c1113b70d8c87d05c18cffa88425
0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	468868281949141865305598	254	16789628	1678352531	2023-03-09T09:02:11.000Z	1004638737169829623	466703367690152891564193	0xaa74357697967f837b6285ab8f63234a152adf9f9bf2aca315e16c84982f9a4e
0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	false	21991485341300821592511	460	16692416	1677171311	2023-02-23T16:55:11.000Z	1004041233449536984	21902970324979299303317	0x899373c49f6027999f6e1a17b0bc8ccd8acef313d097e629aa788a98d60f945e

Example Query

Query with partition filter

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

StanleyDai_Withdraw_event

Withdrawal events from IPOR Protocol’s StanleyDai vault on Ethereum, tracking DAI redemptions with interest-bearing vault token (ivToken) burns and exchange rates. Used to analyze liquidity provider exits and vault performance over time.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_ivTokenAmount`	`STRING`	Amount of IP tokens (ipTokens) received or redeemed in the operation. Numeric string representation with 18 decimal places of precision.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_timestamp	block_timestamp	in_exchangeRate	in_ivTokenAmount	transaction_hash
0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	0x87cef19aca214d12082e201e6130432df39fc774	false	52983695853783884428438	30	17278132	1684311575	2023-05-17T08:19:35.000Z	1007768107702738374	52575285374492620127917	0xdc5100cd86241cebe2cc32ea157c0bda5f7119358ad42f5c329d57772b7f6bea
0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	0x87cef19aca214d12082e201e6130432df39fc774	false	142365683576792701877225	358	17279152	1684324007	2023-05-17T11:46:47.000Z	1007778780536249681	141266800141434239531706	0x31f2c55ff8cf5295ebe2eb5529b8483cb5a6206e49a491dda9c03191183c71a5
0xed7d74aa7eb1f12f83da36dfac1de2257b4e7523	0xa6ac8b6af789319a1db994e25760eb86f796e2b0	0x526d0047725d48bbc6e24c7b82a3e47c1af1f62f	false	95205493413622636445503	214	17616309	1688422127	2023-07-03T22:08:47.000Z	1011046136034480725	94165330364682534709439	0x8ca79c9279b377be55b0e58c1d6f2319376c3a800bc684305027d6f0c506182e

Example Query

Query with partition filter

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

StanleyUsdc_Deposit_event

USDC deposit events from IPOR Protocol’s Stanley vault on Ethereum, recording user contributions with deposit amounts, exchange rates, and ivToken (interest-bearing vault token) quantities minted. Used for analyzing liquidity provision patterns and vault share valuations over time.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_ivTokenAmount`	`STRING`	Amount of IP tokens (ipTokens) received or redeemed in the operation. Numeric string representation with 18 decimal places of precision.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_timestamp	block_timestamp	in_exchangeRate	in_ivTokenAmount	transaction_hash
0x77fcae921e3df22810c5a1ac1d33f2586bba028f	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	193243628808000000000000	230	16620590	1676300375	2023-02-13T14:59:35.000Z	1003698302925647109	192531588670291176158200	0x095566d8c48a05c7bed873ef9b83d0e3bf86a1f0784eba0c8b22a407a7be01c9
0x77fcae921e3df22810c5a1ac1d33f2586bba028f	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	99747590673000000000000	429	16619830	1676291195	2023-02-13T12:26:35.000Z	1003691445942065007	99380732072919969552229	0xf17e8f2a61b72aab4ee1223fa8084ebb255cd4d1fd3eb10e08e5862a975e792d
0x77fcae921e3df22810c5a1ac1d33f2586bba028f	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	0x137000352b4ed784e8fa8815d225c713ab2e7dc9	false	176812927717000000000000	326	16617072	1676257955	2023-02-13T03:12:35.000Z	1003671191138612169	176166187969005102796881	0x0ad523f4ce92dd4081f6bc41b3aa8eb980215d8326ef27d86864157f5fbbf8ff

Example Query

Query with partition filter

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

StanleyUsdc_Withdraw_event

Withdrawal events from IPOR Protocol v1’s Stanley USDC vault on Ethereum, capturing liquidity provider exits with USDC amounts, ivToken (interest-bearing vault token) quantities, and exchange rates. Used for analyzing vault redemption activity and tracking liquidity 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.
`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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_ivTokenAmount`	`STRING`	Amount of IP tokens (ipTokens) received or redeemed in the operation. Numeric string representation with 18 decimal places of precision.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_timestamp	block_timestamp	in_exchangeRate	in_ivTokenAmount	transaction_hash
0x137000352b4ed784e8fa8815d225c713ab2e7dc9	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	0x77fcae921e3df22810c5a1ac1d33f2586bba028f	false	134850265854000000000000	168	16945295	1680242795	2023-03-31T06:06:35.000Z	1006102942004245624	134032274655082908363019	0xc945b50901dc68772fd421efcb9aa092da9e94888f5cff73601ce10bc63ae671
0x137000352b4ed784e8fa8815d225c713ab2e7dc9	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	0x77fcae921e3df22810c5a1ac1d33f2586bba028f	false	524732444177000000000000	194	16801842	1678501283	2023-03-11T02:21:23.000Z	1005030810330131291	522105828780151056967282	0x41810cb4f495a9e74ba1d1d775eb986c55f6c5e2679740825f7bee317040d3c9
0x137000352b4ed784e8fa8815d225c713ab2e7dc9	0x7aa7b0b738c2570c2f9f892cb7ca5bb89b9bf260	0x77fcae921e3df22810c5a1ac1d33f2586bba028f	false	69431685124000000000000	195	16803191	1678517699	2023-03-11T06:54:59.000Z	1005045503612434072	69083125962398480440103	0x0ecce6d03d3cf08e7ff9604eccc358970afb6de5e9bc2a7388a0d0bcb9ec3038

Example Query

Query with partition filter

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

StanleyUsdt_Deposit_event

USDT deposit events into IPOR Protocol v1’s Stanley vault on Ethereum, recording amounts deposited, interest-bearing token (ipToken) amounts minted, and exchange rates. Used for tracking liquidity provisioning and vault share valuations over time.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_ivTokenAmount`	`STRING`	Amount of IP tokens (ipTokens) received or redeemed in the operation. Numeric string representation with 18 decimal places of precision.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_timestamp	block_timestamp	in_exchangeRate	in_ivTokenAmount	transaction_hash
0x58703da5295794ed4e82323fcce7371272c5127d	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	0x28bc58e600ef718b9e97d294098abecb8c96b687	false	193001487457000000000000	450	16469635	1674478475	2023-01-23T12:54:35.000Z	1006086379561798117	191833913446936814776808	0xf47ebdd09f3831810cfd094ce740304e5b29ee398c52efa8961f1713a3b44649
0x58703da5295794ed4e82323fcce7371272c5127d	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	0x28bc58e600ef718b9e97d294098abecb8c96b687	false	88924489957000000000000	163	16949144	1680289511	2023-03-31T19:05:11.000Z	1014832374088885189	87624806054478943963462	0x79e453ad06008672346e35fb5f7544489ec412b558bba93c16bbd3774cdf1ec9
0x58703da5295794ed4e82323fcce7371272c5127d	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	0x28bc58e600ef718b9e97d294098abecb8c96b687	false	194316112147000000000000	412	16945347	1680243419	2023-03-31T06:16:59.000Z	1014804935347814080	191481244698933117239879	0xa685a39b90c412a5eeba47ea0a7da08891c19fc3abb25c59168ee4dc609586ad

Example Query

Query with partition filter

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

StanleyUsdt_Withdraw_event

Withdrawal events from IPOR Protocol’s Stanley USDT vault on Ethereum, tracking user redemptions of interest-bearing vault tokens (ivTokens) for underlying USDT with exchange rates. Used for analyzing vault outflows, redemption patterns, and share-to-asset conversion rates over time.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_ivTokenAmount`	`STRING`	Amount of IP tokens (ipTokens) received or redeemed in the operation. Numeric string representation with 18 decimal places of precision.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_timestamp	block_timestamp	in_exchangeRate	in_ivTokenAmount	transaction_hash
0x28bc58e600ef718b9e97d294098abecb8c96b687	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1	false	59821849821000000000000	278	17783870	1690454447	2023-07-27T10:40:47.000Z	1023206259874765520	58465093663834548474265	0xe2513027454c348993db2159d07ffcf0bb5ae89b419c55a7785d8f308d6dff33
0x28bc58e600ef718b9e97d294098abecb8c96b687	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	0xe4cd9aa68be5b5276573e24fa7a0007da29ab5b1	false	7837450091000000000000	236	17291012	1684468487	2023-05-19T03:54:47.000Z	1017925164640398890	7699436425435779343328	0xe6788ce192c5f1c6af1901400dc6b9053b942efe2ebd96a287a32bfb2ffa0f61
0x28bc58e600ef718b9e97d294098abecb8c96b687	0x8e679c1d67af0cd4b314896856f09ece9e64d6b5	0x58703da5295794ed4e82323fcce7371272c5127d	false	151812252891000000000000	78	17294641	1684512755	2023-05-19T16:12:35.000Z	1017957659143332118	149134152611768193435264	0x35361b42290b6b1097827bfb11cf3879773cc69b7bd233d9c64fe3d30ce62373

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

JosephDai_Redeem_event

JosephUsdc_Redeem_event

JosephUsdt_Redeem_event

MiltonDai_CloseSwap_event

MiltonDai_OpenSwap_event

MiltonStorageDAI_addLiquidity_function

MiltonStorageDAI_subtractLiquidity_function

MiltonStorageUSDC_addLiquidity_function

MiltonStorageUSDC_subtractLiquidity_function

MiltonStorageUSDT_addLiquidity_function

MiltonStorageUSDT_subtractLiquidity_function

MiltonUsdc_CloseSwap_event

MiltonUsdc_OpenSwap_event

MiltonUsdt_CloseSwap_event

MiltonUsdt_OpenSwap_event

PowerToken_RewardsReceived_event

StanleyDai_Deposit_event

StanleyDai_Withdraw_event

StanleyUsdc_Deposit_event

StanleyUsdc_Withdraw_event

StanleyUsdt_Deposit_event

StanleyUsdt_Withdraw_event

​Tables

​JosephDai_Redeem_event

​JosephUsdc_Redeem_event

​JosephUsdt_Redeem_event

​MiltonDai_CloseSwap_event

​MiltonDai_OpenSwap_event

​MiltonStorageDAI_addLiquidity_function

​MiltonStorageDAI_subtractLiquidity_function

​MiltonStorageUSDC_addLiquidity_function

​MiltonStorageUSDC_subtractLiquidity_function

​MiltonStorageUSDT_addLiquidity_function

​MiltonStorageUSDT_subtractLiquidity_function

​MiltonUsdc_CloseSwap_event

​MiltonUsdc_OpenSwap_event

​MiltonUsdt_CloseSwap_event

​MiltonUsdt_OpenSwap_event

​PowerToken_RewardsReceived_event

​StanleyDai_Deposit_event

​StanleyDai_Withdraw_event

​StanleyUsdc_Deposit_event

​StanleyUsdc_Withdraw_event

​StanleyUsdt_Deposit_event

​StanleyUsdt_Withdraw_event

Tables

JosephDai_Redeem_event

JosephUsdc_Redeem_event

JosephUsdt_Redeem_event

MiltonDai_CloseSwap_event

MiltonDai_OpenSwap_event

MiltonStorageDAI_addLiquidity_function

MiltonStorageDAI_subtractLiquidity_function

MiltonStorageUSDC_addLiquidity_function

MiltonStorageUSDC_subtractLiquidity_function

MiltonStorageUSDT_addLiquidity_function

MiltonStorageUSDT_subtractLiquidity_function

MiltonUsdc_CloseSwap_event

MiltonUsdc_OpenSwap_event

MiltonUsdt_CloseSwap_event

MiltonUsdt_OpenSwap_event

PowerToken_RewardsReceived_event

StanleyDai_Deposit_event

StanleyDai_Withdraw_event

StanleyUsdc_Deposit_event

StanleyUsdc_Withdraw_event

StanleyUsdt_Deposit_event

StanleyUsdt_Withdraw_event