okutrade_v3_xdc

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	block_number	in_tickSpacing	block_timestamp	transaction_hash
3000	0xcb2436774c3e191c85056d248ef4260ce5f27a9d	0x1e5aec37f6df6653c3342df75edd92beb3fb9846	false	0x2a8e898b6242355c290e1f4fc966b8788729a4d4	0x951857744785e80e2de051c32ee7b25f9c458c42	87604064	60	2025-04-18T21:03:52.000Z	0xa76c95da89dd156e78c4dc363f4d99259203f44a72861f36e92ab011d93fd8f0
500	0xcb2436774c3e191c85056d248ef4260ce5f27a9d	0x129d60b8b7f67ad9c97609bbb9143201331ac431	false	0x2a8e898b6242355c290e1f4fc966b8788729a4d4	0xcda5b77e2e2268d9e09c874c1b9a4c3f07b37555	90365314	10	2025-06-26T16:09:11.000Z	0x629d87dc81de9b02354d0fbb199c3616316ba74aeb023b1f2cb55340d0b0e1ff
500	0xcb2436774c3e191c85056d248ef4260ce5f27a9d	0xf57b6ef687e5bf6ac05572780d4e079be5ec2ce2	false	0x2a8e898b6242355c290e1f4fc966b8788729a4d4	0xcc0587aebda397146cc828b445db130a94486e74	90365488	10	2025-06-26T16:15:23.000Z	0xd019ebb2f63d776ecc1107f43867b0f3a311b8f1daccd409728cc80a972532eb

Example Query

Query with partition filter

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

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL 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.
`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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_amount	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x29f804974da123e8e48acb107be76b9f2ce1b408	false	0x5102aa3d15d7e43cebcbfcac7bf44afcdbeedb20	233011600699108848	0	0	499715645	95778288	-305100	-304920	2025-11-08T08:53:08.000Z	0xc573a80447b5c0bb401fa7617c67e2607ea64800b2bc86f1afca392baee48ed9
0x29f804974da123e8e48acb107be76b9f2ce1b408	false	0x5102aa3d15d7e43cebcbfcac7bf44afcdbeedb20	231457935626331201	1	3198001549939448773954	313742188	95783736	-305100	-304920	2025-11-08T11:58:52.000Z	0x1381709c773c407cf67d720328c5e3b0ce21994f5a9b3407428daa46d9482923
0x29f804974da123e8e48acb107be76b9f2ce1b408	false	0x5102aa3d15d7e43cebcbfcac7bf44afcdbeedb20	232513036485541799	0	8728523597730784171988	0	95779303	-304980	-304800	2025-11-08T09:27:26.000Z	0xcd041702b4f527597d303d9f7ebc958304056f5d159da5c22111705b28421b2c

Example Query

Query with partition filter

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

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	log_index	in_amount0	in_amount1	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xd68fdf3cbe9f48422a15899318dd5cb921f92037	false	0x5102aa3d15d7e43cebcbfcac7bf44afcdbeedb20	3	858861159290578742	137980945	95490955	0x5102aa3d15d7e43cebcbfcac7bf44afcdbeedb20	-227760	-227580	2025-11-01T10:17:40.000Z	0x4ec390abb65b8f67b1b92b4db0438770271eff3bec040ab643f0981de69baeeb
0xd68fdf3cbe9f48422a15899318dd5cb921f92037	false	0x5102aa3d15d7e43cebcbfcac7bf44afcdbeedb20	2	0	750419959	95509769	0x5102aa3d15d7e43cebcbfcac7bf44afcdbeedb20	-227760	-227580	2025-11-01T21:08:57.000Z	0x5672f860c5ba04ce4c44744b8d20452037a8025de21c3a2194ddae1d49ccb0c3
0x29f804974da123e8e48acb107be76b9f2ce1b408	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	4	32598378281094785661443	4266457787	95485221	0xfdcf247879e81a6efb963b25af85ffbc19b99b85	-304560	-304500	2025-11-01T06:59:48.000Z	0xc5ba560c00c1147cb11ad3950433b9b3567ee3200cff4ea8c84668e8c89a6014

Example Query

Query with partition filter

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

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_paid0	in_sender	log_index	in_amount0	block_number	in_recipient	block_timestamp	transaction_hash
0x1521da257864a86218556cbdde051bb90d6b1069	false	2261	0xac541896626f68133338d464f6d1847a9062502b	12	4521412	90106232	0xaee656c55fb22dd77ba1708dd387e93eefa6005c	2025-06-19T22:20:52.000Z	0xce467295db253188db475485299102fa595f7e14088cf336b9d5b3ac673e0681
0x1521da257864a86218556cbdde051bb90d6b1069	false	1680	0xac541896626f68133338d464f6d1847a9062502b	13	3359012	90071407	0xaee656c55fb22dd77ba1708dd387e93eefa6005c	2025-06-19T00:32:04.000Z	0x3e2e3c1fb0f5c0574ffe59c561f77f1f777f9c3cd459edad0cb2ab7b4fb25cd2
0x1521da257864a86218556cbdde051bb90d6b1069	false	1801	0xac541896626f68133338d464f6d1847a9062502b	12	3601552	91237714	0xaee656c55fb22dd77ba1708dd387e93eefa6005c	2025-07-18T12:28:21.000Z	0x7aa5f0d61a4bd1ae31a5f2b8f2e234238ab267b8cd5991a87535749cce5256eb

Example Query

Query with partition filter

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

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_amount	in_sender	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x97bb50ace84058254df2e2f6482f5549e80b7267	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	675713048211785	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	2	0	2000000	89845578	-304440	-304200	2025-06-13T05:15:48.000Z	0x2fdd39a3fefd02be9d490f6f12a2dab4131d85836b39e5328a3abce3cdce831d
0x97bb50ace84058254df2e2f6482f5549e80b7267	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	727189793374718	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	3	2476413940172630567	2000000	89846345	-304440	-304200	2025-06-13T05:43:27.000Z	0x9329ce0c5d8f2ab06e61b21043da14102256818dbaf8fdb9b436cdfb1087549a
0x31e64be639a2b0f4f51332780e70b04d2cb2a02e	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	675713048211785	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	1	0	2000000	89845625	-304440	-304200	2025-06-13T05:17:26.000Z	0xe957f469e9142855d9cb5f52849903aa38ebc2017af99736ee4660dfb4df318d

Example Query

Query with partition filter

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

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	in_sqrtPriceX96	transaction_hash
0x1e5aec37f6df6653c3342df75edd92beb3fb9846	303812	false	0x6c68c5ba9a2998325f3b9e6658eda130c3ab874f	44	54532	-850754491039005365	87646317	131669911192964	0x6c68c5ba9a2998325f3b9e6658eda130c3ab874f	2025-04-19T21:32:23.000Z	313152112949333021070814212106220601	0x1629877c745c76440e5ad4c9a13f875f9cb752efbde2ec4206e552571a416d4d
0x1e5aec37f6df6653c3342df75edd92beb3fb9846	302856	false	0x6ee0d4f8008a3e3a16b50e82c1af7f5738e15e4a	7	133281	-1893943567457475231	87611840	131669911192964	0xb590714449fdf44034c47febbf4c130f5fb7ff5e	2025-04-19T01:32:39.000Z	298541231559377133966269046550199449	0x162d9b62f157f8154302794b3becf1a1bc18287913efaf2087886ab1352bdbea
0x1e5aec37f6df6653c3342df75edd92beb3fb9846	302796	false	0x6ee0d4f8008a3e3a16b50e82c1af7f5738e15e4a	7	106252	-1499567902922292383	87629906	131669911192964	0xb590714449fdf44034c47febbf4c130f5fb7ff5e	2025-04-19T12:05:07.000Z	297638914481485380580128190293039658	0x71d9ace04b9bb3b8b3755ae7fcdb1a7484e3d0c43bae9a317c50525f3798b41e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event