idex_v3_polygon

Tables

Exchange_Deposited_event

Deposit events from IDEX v3 decentralized exchange on Polygon, tracking user wallet deposits with asset details, quantities in pips (smallest denomination), and resulting exchange balances. Used for analyzing deposit flows, liquidity changes, and user funding patterns across USDC, MATIC, and liquidity pool tokens.

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_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_wallet`	`STRING`	Wallet address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_assetAddress`	`STRING`	Contract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_assetSymbol`	`STRING`	Token symbol of the deposited asset (e.g., USDC, MATIC, ILP-MATIC-ETH). Human-readable identifier corresponding to the asset deposited into the IDEX v3 exchange contract.
`in_quantityInPips`	`STRING`	Deposited amount denominated in pips, IDEX’s internal precision unit for representing token quantities. Pips are typically converted to standard token units by dividing by 10^8, as shown in the relationship between quantity and balance fields.
`in_newExchangeBalanceInPips`	`STRING`	Updated user balance on the IDEX exchange denominated in pips (smallest unit of precision) after this deposit was processed. Pips are IDEX’s internal accounting unit, typically requiring conversion to standard asset units for analysis.
`in_newExchangeBalanceInAssetUnits`	`STRING`	User’s updated balance in the IDEX V3 exchange after this deposit, denominated in the asset’s base units (e.g., wei for MATIC, smallest token unit for ERC-20s). This value reflects the total holdings after the deposit transaction completes.

Sample Data

address	removed	in_index	in_wallet	log_index	block_number	in_assetSymbol	block_timestamp	in_assetAddress	transaction_hash	in_quantityInPips	in_newExchangeBalanceInPips	in_newExchangeBalanceInAssetUnits
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	188867	0xc1103f8c1678025785e965bdb7c938f3781e3ee1	109	49834156	MATIC	2023-11-12T01:04:36.000Z	0x0000000000000000000000000000000000000000	0xdb020ea8d08a1a645d352159a25f21deb8e4fab0e6c3a57b960ea2cedb31b8e2	22000000000	22000000000	220000000000000000000
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	188874	0x9f7f741a27258ea3ac4dcc201cb9cb4edac0b3c3	87	49839886	ILP-MATIC-ETH	2023-11-12T04:30:36.000Z	0x14ece8839bcb4946cc99c3a01e69575969039c1f	0xb90fe2d1fa44ada755eaef1194d01ba2d480057efc6d2e92b11d965ee65db0d6	160407708	160407708	1604077080000000000
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	188875	0x4efe127e2975cf2703d74261298c72b6193a8270	225	49843853	USDC	2023-11-12T06:51:21.000Z	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x4e68c70465c3c9a8aefa6ec49a5b77dd728b850f68bf08dbef9e1b02f56a982a	11417424600	43136043777	431360437

Example Query

Query with partition filter

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

Exchange_HybridTradeExecuted_event

Trade execution records from IDEX v3 hybrid exchange on Polygon, combining automated market maker (AMM) pool fills and order book matches with buyer/seller wallets and quantities denominated in pips (smallest price increments). Used for analyzing hybrid liquidity model performance and order routing behavior across pool versus order book 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.
`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_buyWallet`	`STRING`	Wallet address of the buyer in this hybrid trade execution on IDEX v3. Hex-encoded, 0x-prefixed 40-character string representing the Polygon address receiving the base asset.
`in_sellWallet`	`STRING`	Wallet address of the seller in the hybrid trade executed on IDEX v3. Hex-encoded, 0x-prefixed 40-character Polygon address that disposed of the base asset.
`in_baseAssetSymbol`	`STRING`	Trading pair base asset symbol (e.g., IDEX, MAI), representing the asset being bought or sold. Typically represents the token or cryptocurrency in the numerator of the trading pair.
`in_quoteAssetSymbol`	`STRING`	Token symbol of the quote asset in the trading pair (e.g., USDC). Represents the denominating currency used to price the base asset in hybrid trades on IDEX v3.
`in_orderBookBaseQuantityInPips`	`STRING`	Quantity of the base asset (e.g., IDEX, MAI) filled from the order book portion of the hybrid trade, denominated in pips (minimum price increments). This represents the order book liquidity component, separate from the pool-sourced liquidity in the same trade.
`in_orderBookQuoteQuantityInPips`	`STRING`	Quote asset quantity filled via the order book component of the hybrid trade, denominated in pips (smallest divisible units). Pips represent the atomic unit for the quote currency in IDEX’s decimal representation system.
`in_poolBaseQuantityInPips`	`STRING`	Base asset quantity executed from the liquidity pool portion of the hybrid trade, denominated in pips (smallest divisible units). Values typically represent the majority of trade volume when pool liquidity is used alongside the order book.
`in_poolQuoteQuantityInPips`	`STRING`	Quote asset quantity filled from the liquidity pool component of the hybrid trade, denominated in pips (smallest unit). This represents the USDC or other quote token amount traded through the pool portion, as distinct from the order book fill.
`in_totalBaseQuantityInPips`	`STRING`	Total base asset quantity traded in pips, combining both order book and pool liquidity sources. Pips are the smallest indivisible unit of the token, typically representing wei-equivalent precision.
`in_totalQuoteQuantityInPips`	`STRING`	Total quote asset quantity traded in pips (smallest divisible unit), combining both order book and liquidity pool execution amounts. Represents the complete quote side of the hybrid trade execution.
`in_takerSide`	`INT64`	Side of the trade taken by the taker (aggressor) in the hybrid order execution, where 0 indicates a buy. This field identifies which party initiated the market order that triggered the trade execution.

Sample Data

address	removed	log_index	block_number	in_buyWallet	in_sellWallet	block_timestamp	transaction_hash	in_baseAssetSymbol	in_quoteAssetSymbol	in_poolBaseQuantityInPips	in_poolQuoteQuantityInPips	in_totalBaseQuantityInPips	in_totalQuoteQuantityInPips	in_orderBookBaseQuantityInPips	in_orderBookQuoteQuantityInPips
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	138	51353926	0x00e30641876e3d644d2c3ea4ab66eff207871ddd	0x6aa7ee5b0e557d50382a6d18b5e5f0c7eecbffb4	2023-12-20T15:51:16.000Z	0xd2714b217d6235d49de8b9b61a39404d7c911b670a80b31adac96936dbab7e98	IDEX	USDC	4551059998	260641401	4551060000	260641402	2	1
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	172	51351740	0x00e30641876e3d644d2c3ea4ab66eff207871ddd	0x6aa7ee5b0e557d50382a6d18b5e5f0c7eecbffb4	2023-12-20T14:30:32.000Z	0x7d11c09060846e516e36dfaefad49cf631795a227a97f2d3b902bd5964a9176e	IDEX	USDC	499999999994	28614266962	500000000000	28614266963	6	1
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	465	51351729	0x00e30641876e3d644d2c3ea4ab66eff207871ddd	0x6aa7ee5b0e557d50382a6d18b5e5f0c7eecbffb4	2023-12-20T14:30:10.000Z	0x1c937f8493a15ed227c21a61e16bfc823ddd481c8a022adb0db713d043d34003	IDEX	USDC	499999999989	28560004855	500000000000	28560004856	11	1

Example Query

Query with partition filter

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

Exchange_OrderBookTradeExecuted_event

Trade execution events from IDEX v3 decentralized exchange on Polygon. Records order book fills with buy/sell wallet addresses, trading pair symbols, quantities in pips (smallest price increments), and taker side identification for analyzing DEX trading 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_buyWallet`	`STRING`	Wallet address of the buyer in this order book trade execution on IDEX v3. Hex-encoded, 0x-prefixed 40-character Polygon address receiving the base asset.
`in_sellWallet`	`STRING`	Wallet address of the seller in this trade execution on IDEX v3. Hex-encoded, 0x-prefixed 40-character Polygon address that sold the base asset.
`in_baseAssetSymbol`	`STRING`	Trading pair base asset symbol for IDEX v3 order execution on Polygon. Represents the asset being bought or sold, commonly major tokens like ETH or WBTC.
`in_quoteAssetSymbol`	`STRING`	Quote asset symbol in the trading pair being exchanged on IDEX v3. Represents the pricing currency (e.g., USDC) against which the base asset is valued.
`in_baseQuantityInPips`	`STRING`	Quantity of the base asset (first token in the trading pair) traded in pips, IDEX’s smallest unit of precision. Multiply by the asset’s pip precision factor to get the human-readable amount.
`in_quoteQuantityInPips`	`STRING`	Quantity of the quote asset (e.g., USDC) traded in the order, denominated in pips (smallest divisible unit). Pips represent fractional token amounts; actual quantity equals this value divided by the token’s decimal precision.
`in_takerSide`	`INT64`	Side of the trade initiated by the taker, where 0 indicates a buy (taker buying base asset) and 1 indicates a sell. This field identifies which party initiated the order book match.

Sample Data

address	removed	log_index	block_number	in_buyWallet	in_sellWallet	block_timestamp	transaction_hash	in_baseAssetSymbol	in_quoteAssetSymbol	in_baseQuantityInPips	in_quoteQuantityInPips
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	453	49716786	0x5ea871c4af2ad0a4c00bd0bd47eff77ece1c6eaf	0xb0bd465be3d6d8340435066382ab4389e86f3540	2023-11-09T02:33:36.000Z	0x3de90dd5f69e870bbfb17844ec281b43026b6061062e0bff9034cd91e1495d82	ETH	USDC	1097358	2076980461
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	155	49717446	0x5ea871c4af2ad0a4c00bd0bd47eff77ece1c6eaf	0xb0bd465be3d6d8340435066382ab4389e86f3540	2023-11-09T02:57:46.000Z	0x83606f8f5c768bda03341e96ec73bebd7ae89b77d86ee0b27e9b3b5ee435850f	ETH	USDC	1273685	2410716337
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	177	49717773	0x5ea871c4af2ad0a4c00bd0bd47eff77ece1c6eaf	0xb0bd465be3d6d8340435066382ab4389e86f3540	2023-11-09T03:09:20.000Z	0xf0c8652218cee6394a5f27ab28320478078125b92c6f056d3ee663ab7810e018	ETH	USDC	1273209	2409815407

Example Query

Query with partition filter

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

Exchange_PoolTradeExecuted_event

Executed trades from IDEX v3 liquidity pools on Polygon, recording base/quote asset pairs, quantities in pips (smallest decimal units), wallet addresses, and taker side indicators. Used for analyzing DEX trading activity, volume patterns, and liquidity pool utilization across IDEX 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_wallet`	`STRING`	Wallet address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_baseAssetSymbol`	`STRING`	Token symbol for the base asset in the trading pair (e.g., IDEX, ETH). The base asset is the token being bought or sold, with quantity measured in pips.
`in_quoteAssetSymbol`	`STRING`	Ticker symbol of the quote asset in the trading pair (the asset being traded for). Examples include ETH and USDC representing the denominating currency in IDEX liquidity pool trades.
`in_baseQuantityInPips`	`STRING`	Quantity of the base asset traded in pips, IDEX’s smallest unit of measurement where actual quantity equals pips divided by 10^8. String format to preserve precision for large integer values.
`in_quoteQuantityInPips`	`STRING`	Quote asset quantity involved in the trade, denominated in pips (smallest divisible unit). Pips represent the token amount scaled by its decimals (e.g., 1 USDC = 1000000 pips for 6 decimals).
`in_takerSide`	`INT64`	Indicates which side of the trading pair the taker order is on, where 0 represents buy and 1 represents sell. This value determines whether the taker is buying the base asset or selling it in the liquidity pool trade.

Sample Data

address	removed	in_wallet	log_index	block_number	block_timestamp	transaction_hash	in_baseAssetSymbol	in_quoteAssetSymbol	in_baseQuantityInPips	in_quoteQuantityInPips
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	0x1a2cdbc7a8c75b8bf91170a0b74dfb4b2a4af6ad	2	42755943	2023-05-16T01:19:09.000Z	0xd1945cbc014d0d021ca23eeac9b0627e08861124097f78267ec98cc636a1af0c	IDEX	ETH	242581157461	11349204
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	0x1a2cdbc7a8c75b8bf91170a0b74dfb4b2a4af6ad	1	42765983	2023-05-16T07:17:22.000Z	0xd3d8234c2c3dd68b39b772b630290574ec2d3de2ff00083aadcdbfe20cfeebc7	IDEX	ETH	178039389002	8371249
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	0x1a2cdbc7a8c75b8bf91170a0b74dfb4b2a4af6ad	6	42792677	2023-05-16T23:08:55.000Z	0x9daf6542df703d4f195e15bdc33fb893c035399c995b9d0d80c9f88a637c8511	IDEX	USDC	766488769228	62587007292

Example Query

Query with partition filter

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

Exchange_Withdrawn_event

Withdrawal events from IDEX v3 decentralized exchange on Polygon, tracking when users remove assets from the exchange contract with quantities in pips (smallest price unit) and resulting balances. Used for analyzing user withdrawal patterns and exchange 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_wallet`	`STRING`	Wallet address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_assetAddress`	`STRING`	Contract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_assetSymbol`	`STRING`	Token symbol of the asset being withdrawn from the IDEX v3 exchange (e.g., MATIC, USDC, ETH). Human-readable ticker representing the withdrawn cryptocurrency or token.
`in_quantityInPips`	`STRING`	Withdrawn amount expressed in pips, IDEX’s smallest unit of precision (typically 8 decimals for most tokens). Divide by 100000000 to convert to standard token units shown in in_assetSymbol.
`in_newExchangeBalanceInPips`	`STRING`	Remaining balance in the exchange contract for this asset after the withdrawal, denominated in pips (smallest unit used by IDEX v3). String-encoded integer that is zero when wallet fully withdraws their position.
`in_newExchangeBalanceInAssetUnits`	`STRING`	Updated balance of the user’s account on IDEX exchange after withdrawal, denominated in the asset’s standard units. Always zero in sample data, suggesting full withdrawals where users remove their entire balance from the exchange.

Sample Data

address	removed	in_wallet	log_index	block_number	in_assetSymbol	block_timestamp	in_assetAddress	transaction_hash	in_quantityInPips	in_newExchangeBalanceInPips	in_newExchangeBalanceInAssetUnits
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	0x4efe127e2975cf2703d74261298c72b6193a8270	130	49629398	MATIC	2023-11-06T22:23:23.000Z	0x0000000000000000000000000000000000000000	0x8b8958262d5aba91400dd926cd6e064c01f4863c8ac3d82eed0ff36fe1eb8ef4	5348402093	8	80000000000
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	0x4efe127e2975cf2703d74261298c72b6193a8270	104	49594129	MATIC	2023-11-06T01:10:06.000Z	0x0000000000000000000000000000000000000000	0xc2540e0c8f16b2bf6173fcb18addbaa755fc98fa98dac0c6dd27296b37fd1778	5519259546	8	80000000000
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6	false	0x4efe127e2975cf2703d74261298c72b6193a8270	186	49624694	SYN	2023-11-06T19:35:52.000Z	0xf8f9efc0db77d8881500bb06ff5d6abc3070e695	0x61a5a47ee6446c6a1bca8f3bac0143faf133ca18650a810783a98faf245aa8e0	6731262237	5	50000000000

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Exchange_Deposited_event

Exchange_HybridTradeExecuted_event

Exchange_OrderBookTradeExecuted_event

Exchange_PoolTradeExecuted_event

Exchange_Withdrawn_event

​Tables

​Exchange_Deposited_event

​Exchange_HybridTradeExecuted_event

​Exchange_OrderBookTradeExecuted_event

​Exchange_PoolTradeExecuted_event

​Exchange_Withdrawn_event

Tables

Exchange_Deposited_event

Exchange_HybridTradeExecuted_event

Exchange_OrderBookTradeExecuted_event

Exchange_PoolTradeExecuted_event

Exchange_Withdrawn_event