xdc_v2_xdc

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x347d14b13a68457186b2450bb2a6c2fd7b38352f	0xe57398ab32d8659c5d900efb91fffe316dc4720f	false	428	0x1c6755e144d54529723b05a2e28a2d440b625fdd	0x951857744785e80e2de051c32ee7b25f9c458c42	1	72999260	2024-03-25T09:10:10.000Z	0xf48a7fa0521ff02e28c172586ec07575e65164e43683adc18f5341b537c4819f
0x347d14b13a68457186b2450bb2a6c2fd7b38352f	0xa7d665ed6acd1ab36d818ed2ddbdfe002e17d759	false	549	0x2a8e898b6242355c290e1f4fc966b8788729a4d4	0x68c5cf92c678d96cbf1de180a0c86d0be6b93942	0	89173823	2025-05-27T18:24:33.000Z	0x6ab59cca1bbc9e6f27dfa941ddaf338fe9ed210beddd7d444eec508bb1ce49d1
0x347d14b13a68457186b2450bb2a6c2fd7b38352f	0xc727a543b1156911fcc48602a8fb9fec0c02de90	false	276	0x3b90e6f862368621987b6d8da28b1b6aeb04ebbe	0x951857744785e80e2de051c32ee7b25f9c458c42	2	56920280	2023-02-18T01:44:27.000Z	0x0fb3c9b26114e2088e58ef4f63ebdaaf0b672b8a523cc9bf971d3f3c48c8f6a7

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) pools.

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_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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xf9c5e4f6e627201ab2d6fb6391239738cf4bdcf9	0x2f9423c785734f27b5cad494948e98c4e4e8a4e0	false	0xf9c5e4f6e627201ab2d6fb6391239738cf4bdcf9	8	163507537300095656623	4461425	56498839	2023-02-07T17:39:56.000Z	0x9966727d798b8a8d32c249aeebe2ce2be2d2362a81f61c591b5657098ed957c6
0xf9c5e4f6e627201ab2d6fb6391239738cf4bdcf9	0xcd2de857ea736c11cda62d2dc69fef7a8947e222	false	0xf9c5e4f6e627201ab2d6fb6391239738cf4bdcf9	8	1635513585117648636892958	55566156417149008206647	56493555	2023-02-07T14:28:26.000Z	0x930a9c6465629e35519d62f5ec93bf2721f1ddd51a0c18e4dee5a524acdbb814
0xf9c5e4f6e627201ab2d6fb6391239738cf4bdcf9	0xeccf20ec789d99357439647f43777a1b0bfa0e8a	false	0xf9c5e4f6e627201ab2d6fb6391239738cf4bdcf9	8	8169335423912227209144	140993646526698115494	56493615	2023-02-07T14:30:48.000Z	0x835af65181668edc8d690e2c5fe4351304c01f1ccc89e17a6bb3192a8ff84b87

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

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_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_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xeccf20ec789d99357439647f43777a1b0bfa0e8a	false	0xf9c5e4f6e627201ab2d6fb6391239738cf4bdcf9	7	53345461648612736005092	1998711924153440689171	48698849	2022-08-07T08:18:45.000Z	0x2e2866d19247913303da1a0be0de9ac4df7ff697f1448a13736515e9b9c1ca80
0xeccf20ec789d99357439647f43777a1b0bfa0e8a	false	0xf9c5e4f6e627201ab2d6fb6391239738cf4bdcf9	9	82000000000000000000000	3050656173983193439012	48715652	2022-08-07T17:42:49.000Z	0x2a58dbbfce4e25c088019eab19f1ae6f2495a48148ceb45ccae87afae70dea3f
0xeccf20ec789d99357439647f43777a1b0bfa0e8a	false	0xf9c5e4f6e627201ab2d6fb6391239738cf4bdcf9	9	70397598784220090588502	2646730045570104811260	48701553	2022-08-07T09:49:44.000Z	0xd2ba3febc56588c927b73202704df7b849ce94fad41b4b3c1b754f524149d76d

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash
0x2540e2d4ea223d841d7532c1e702490e51763f93	0x031654e5d23a355d664b1b42d516aef5feb92cf6	false	0x69dc8e2d95c3281a643810fb5624b26da8610da4	5	52548518	0	167246216059336518	13512703540696210061	0	2022-11-05T10:58:20.000Z	0xda1086ea736b1e77bac14b90e15e662d31109436b31103f76cd5420222ab8178
0xa604a16c50c075259f53deff19884d2de73126c8	0x031654e5d23a355d664b1b42d516aef5feb92cf6	false	0x69dc8e2d95c3281a643810fb5624b26da8610da4	8	52550794	7918761893103168577	0	0	99538030483638873	2022-11-05T12:14:28.000Z	0x5cdeb85723b10fcd3b2ab39ea00007a37a11aa0a7c63fd67671a782fd52ef156
0xa604a16c50c075259f53deff19884d2de73126c8	0x031654e5d23a355d664b1b42d516aef5feb92cf6	false	0x69dc8e2d95c3281a643810fb5624b26da8610da4	5	52544171	19400982601540899582	0	0	228571126376728167	2022-11-05T08:33:11.000Z	0x1e1914ad2eb2b63f8deea66f65c1897df2fdc255d9075f4b9937cf74668a76fe

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x450cbc1bbf60100ed415f592066cd932afb0297b	false	4	1835665017900938076525	39337252013945998823103	71205533	2024-02-01T00:01:55.000Z	0xab003572fc20fcc7f4ce86da082a5972d57b1f3f514c86df76ca5fe100a2eb4b
0x64b76b7e359af0ec6e640867f4cba687ac7f3ac8	false	28	93089588573755526684	7097845772630580352775	71205534	2024-02-01T00:02:05.000Z	0x61a9a9f6c693835c78078dde9eea2cf374a235734aa279179152a1513be72f70
0xbd992e13e39b394dbf74090b68d74f177d2e2951	false	31	525775473302206388990023	149399949435190145140700	71205534	2024-02-01T00:02:05.000Z	0x61a9a9f6c693835c78078dde9eea2cf374a235734aa279179152a1513be72f70

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

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_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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xdb040762794d45ce4c8fd0b6694a8a88e306586c	0xe5c0d0bc5866bc3638f2374d59b697e4fd48ea94	0x0000000000000000000000000000000000000000	false	1306303591347003058	4	80683308	2024-10-13T18:28:30.000Z	0x1925e2ec63a2f48fc56f57d943df1a18f33c795716b3ada4caa342538062a826
0xf6ea6266ba9a5f017a004b0f081aeaa243201faa	0xe5c0d0bc5866bc3638f2374d59b697e4fd48ea94	0x0000000000000000000000000000000000000000	false	860596072464645631	3	80683308	2024-10-13T18:28:30.000Z	0x1925e2ec63a2f48fc56f57d943df1a18f33c795716b3ada4caa342538062a826
0x359ad8918a16bf0db048eccdbdee761548312693	0xe5c0d0bc5866bc3638f2374d59b697e4fd48ea94	0x0000000000000000000000000000000000000000	false	860596072464645631	2	80683308	2024-10-13T18:28:30.000Z	0x1925e2ec63a2f48fc56f57d943df1a18f33c795716b3ada4caa342538062a826

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event