Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
in_walletSTRINGWallet address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
in_assetAddressSTRINGContract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetSymbolSTRINGToken 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_quantityInPipsSTRINGDeposited 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_newExchangeBalanceInPipsSTRINGUpdated 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_newExchangeBalanceInAssetUnitsSTRINGUser’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.
addressremovedin_indexin_walletlog_indexblock_numberin_assetSymbolblock_timestampin_assetAddresstransaction_hashin_quantityInPipsin_newExchangeBalanceInPipsin_newExchangeBalanceInAssetUnits
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false1888670xc1103f8c1678025785e965bdb7c938f3781e3ee110949834156MATIC2023-11-12T01:04:36.000Z0x00000000000000000000000000000000000000000xdb020ea8d08a1a645d352159a25f21deb8e4fab0e6c3a57b960ea2cedb31b8e22200000000022000000000220000000000000000000
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false1888740x9f7f741a27258ea3ac4dcc201cb9cb4edac0b3c38749839886ILP-MATIC-ETH2023-11-12T04:30:36.000Z0x14ece8839bcb4946cc99c3a01e69575969039c1f0xb90fe2d1fa44ada755eaef1194d01ba2d480057efc6d2e92b11d965ee65db0d61604077081604077081604077080000000000
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false1888750x4efe127e2975cf2703d74261298c72b6193a827022549843853USDC2023-11-12T06:51:21.000Z0x2791bca1f2de4661ed88a30c99a7a9449aa841740x4e68c70465c3c9a8aefa6ec49a5b77dd728b850f68bf08dbef9e1b02f56a982a1141742460043136043777431360437
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_buyWalletSTRINGWallet 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_sellWalletSTRINGWallet 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_baseAssetSymbolSTRINGTrading 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_quoteAssetSymbolSTRINGToken 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_orderBookBaseQuantityInPipsSTRINGQuantity 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_orderBookQuoteQuantityInPipsSTRINGQuote 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_poolBaseQuantityInPipsSTRINGBase 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_poolQuoteQuantityInPipsSTRINGQuote 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_totalBaseQuantityInPipsSTRINGTotal 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_totalQuoteQuantityInPipsSTRINGTotal 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_takerSideINT64Side 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.
addressremovedlog_indexblock_numberin_buyWalletin_takerSidein_sellWalletblock_timestamptransaction_hashin_baseAssetSymbolin_quoteAssetSymbolin_poolBaseQuantityInPipsin_poolQuoteQuantityInPipsin_totalBaseQuantityInPipsin_totalQuoteQuantityInPipsin_orderBookBaseQuantityInPipsin_orderBookQuoteQuantityInPips
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false138513539260x00e30641876e3d644d2c3ea4ab66eff207871ddd00x6aa7ee5b0e557d50382a6d18b5e5f0c7eecbffb42023-12-20T15:51:16.000Z0xd2714b217d6235d49de8b9b61a39404d7c911b670a80b31adac96936dbab7e98IDEXUSDC4551059998260641401455106000026064140221
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false172513517400x00e30641876e3d644d2c3ea4ab66eff207871ddd00x6aa7ee5b0e557d50382a6d18b5e5f0c7eecbffb42023-12-20T14:30:32.000Z0x7d11c09060846e516e36dfaefad49cf631795a227a97f2d3b902bd5964a9176eIDEXUSDC499999999994286142669625000000000002861426696361
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false465513517290x00e30641876e3d644d2c3ea4ab66eff207871ddd00x6aa7ee5b0e557d50382a6d18b5e5f0c7eecbffb42023-12-20T14:30:10.000Z0x1c937f8493a15ed227c21a61e16bfc823ddd481c8a022adb0db713d043d34003IDEXUSDC4999999999892856000485550000000000028560004856111
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_buyWalletSTRINGWallet 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_sellWalletSTRINGWallet 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_baseAssetSymbolSTRINGTrading 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_quoteAssetSymbolSTRINGQuote 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_baseQuantityInPipsSTRINGQuantity 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_quoteQuantityInPipsSTRINGQuantity 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_takerSideINT64Side 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.
addressremovedlog_indexblock_numberin_buyWalletin_takerSidein_sellWalletblock_timestamptransaction_hashin_baseAssetSymbolin_quoteAssetSymbolin_baseQuantityInPipsin_quoteQuantityInPips
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false453497167860x5ea871c4af2ad0a4c00bd0bd47eff77ece1c6eaf00xb0bd465be3d6d8340435066382ab4389e86f35402023-11-09T02:33:36.000Z0x3de90dd5f69e870bbfb17844ec281b43026b6061062e0bff9034cd91e1495d82ETHUSDC10973582076980461
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false155497174460x5ea871c4af2ad0a4c00bd0bd47eff77ece1c6eaf00xb0bd465be3d6d8340435066382ab4389e86f35402023-11-09T02:57:46.000Z0x83606f8f5c768bda03341e96ec73bebd7ae89b77d86ee0b27e9b3b5ee435850fETHUSDC12736852410716337
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false177497177730x5ea871c4af2ad0a4c00bd0bd47eff77ece1c6eaf00xb0bd465be3d6d8340435066382ab4389e86f35402023-11-09T03:09:20.000Z0xf0c8652218cee6394a5f27ab28320478078125b92c6f056d3ee663ab7810e018ETHUSDC12732092409815407
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_walletSTRINGWallet address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
in_baseAssetSymbolSTRINGToken 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_quoteAssetSymbolSTRINGTicker 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_baseQuantityInPipsSTRINGQuantity 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_quoteQuantityInPipsSTRINGQuote 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_takerSideINT64Indicates 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.
addressremovedin_walletlog_indexblock_numberin_takerSideblock_timestamptransaction_hashin_baseAssetSymbolin_quoteAssetSymbolin_baseQuantityInPipsin_quoteQuantityInPips
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false0x1a2cdbc7a8c75b8bf91170a0b74dfb4b2a4af6ad24275594302023-05-16T01:19:09.000Z0xd1945cbc014d0d021ca23eeac9b0627e08861124097f78267ec98cc636a1af0cIDEXETH24258115746111349204
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false0x1a2cdbc7a8c75b8bf91170a0b74dfb4b2a4af6ad14276598302023-05-16T07:17:22.000Z0xd3d8234c2c3dd68b39b772b630290574ec2d3de2ff00083aadcdbfe20cfeebc7IDEXETH1780393890028371249
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false0x1a2cdbc7a8c75b8bf91170a0b74dfb4b2a4af6ad64279267702023-05-16T23:08:55.000Z0x9daf6542df703d4f195e15bdc33fb893c035399c995b9d0d80c9f88a637c8511IDEXUSDC76648876922862587007292
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_walletSTRINGWallet address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
in_assetAddressSTRINGContract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetSymbolSTRINGToken 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_quantityInPipsSTRINGWithdrawn 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_newExchangeBalanceInPipsSTRINGRemaining 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_newExchangeBalanceInAssetUnitsSTRINGUpdated 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.
addressremovedin_walletlog_indexblock_numberin_assetSymbolblock_timestampin_assetAddresstransaction_hashin_quantityInPipsin_newExchangeBalanceInPipsin_newExchangeBalanceInAssetUnits
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false0x4efe127e2975cf2703d74261298c72b6193a827013049629398MATIC2023-11-06T22:23:23.000Z0x00000000000000000000000000000000000000000x8b8958262d5aba91400dd926cd6e064c01f4863c8ac3d82eed0ff36fe1eb8ef45348402093880000000000
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false0x4efe127e2975cf2703d74261298c72b6193a827010449594129MATIC2023-11-06T01:10:06.000Z0x00000000000000000000000000000000000000000xc2540e0c8f16b2bf6173fcb18addbaa755fc98fa98dac0c6dd27296b37fd17785519259546880000000000
0x3253a7e75539edaeb1db608ce6ef9aa1ac9126b6false0x4efe127e2975cf2703d74261298c72b6193a827018649624694SYN2023-11-06T19:35:52.000Z0xf8f9efc0db77d8881500bb06ff5d6abc3070e6950x61a5a47ee6446c6a1bca8f3bac0143faf133ca18650a810783a98faf245aa8e06731262237550000000000
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