fathom_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
0x9fab572f75008a42c6af80b36ab20c76a38abc4b	0xce2310e80636179cf5efe35b04f734c427533650	false	51	0x49d3f7543335cf38fa10889ccff10207e22110b5	0x4e3037297830c8023d1646937a3d44c018d1a5c3	1	75843395	2024-06-11T15:19:41.000Z	0x0bb3caa59238971937b84d6545e88be222e18588614c486c2d3ebc700d01cb35
0x9fab572f75008a42c6af80b36ab20c76a38abc4b	0x85cc223f3f0f6bf459ae8704754105ce23c4abfb	false	58	0x5d5f074837f5d4618b3916ba74de1bf9662a3fed	0x951857744785e80e2de051c32ee7b25f9c458c42	1	92212108	2025-08-11T06:00:08.000Z	0x9ebdd8dd4e18d6851bd976108eb1eb4585d02fee7ce5d804c2a735c10d57384b
0x9fab572f75008a42c6af80b36ab20c76a38abc4b	0x31c9ed13088feffe9ed620d9374d63cd2a7678d8	false	8	0x951857744785e80e2de051c32ee7b25f9c458c42	0x9ca227280599d31845dd21449b5a6acfb285b1fc	1	63587891	2023-07-29T16:41:47.000Z	0x85faa9d96ae7ac5bb1082f0c19096f94a3ba746297953257af8f3f7517be73c7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.fathom_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
0x7e5b4c238a904329596c4094877d48868d739963	0x183477253b3773d0ca1d798c83e7e7572c68375b	false	0x7e5b4c238a904329596c4094877d48868d739963	6	302046161671348238408	3190060270483125300582	85203057	2025-02-17T20:49:50.000Z	0x721fa1b1566df7e587f74e92b3e39c3b3c750a642e9bc9ff177e947372b5db73
0x7e5b4c238a904329596c4094877d48868d739963	0x183477253b3773d0ca1d798c83e7e7572c68375b	false	0x7e5b4c238a904329596c4094877d48868d739963	6	897303740807015733011	9266235842606823615372	85187109	2025-02-17T11:27:54.000Z	0x735b51f8b3eddd4b665c66cc7901c5b95f1fd90d6cf5c4509bd8bdfb466fec67
0x7e5b4c238a904329596c4094877d48868d739963	0xb09cabbd3b180ee331a7b6864029ebdf9e476707	false	0x7e5b4c238a904329596c4094877d48868d739963	58	3584613540211275691570	677287328550470288804	82603871	2024-12-11T22:18:15.000Z	0x7080af6d857320bbc89642b02d5dde06db996bb01970d00c73b6ebc9532ef142

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.fathom_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
0x098b5c5178c5bcdadf3488631c3b74164275e3bd	false	0x7e5b4c238a904329596c4094877d48868d739963	5	458	5000000000000000000	73922519	2024-04-22T13:33:42.000Z	0x1e53fa574307109fa8b685535fbca49ad81e1dfa78c3e129b0ce1211f0df097e
0x098b5c5178c5bcdadf3488631c3b74164275e3bd	false	0x7e5b4c238a904329596c4094877d48868d739963	5	999999	10905130019803857403489	73920938	2024-04-22T12:30:58.000Z	0x1c477375696e352a2a5821a0961f8e8d9548f0c0699b32f2b31cf7791674d848
0x098b5c5178c5bcdadf3488631c3b74164275e3bd	false	0x7e5b4c238a904329596c4094877d48868d739963	7	9170	100000042281601372390	73920673	2024-04-22T12:19:39.000Z	0x9f50d220414e98ea99b849ba6a4933c6e7e4ef4a0ac27d3db7692d838525c304

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.fathom_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_amount1In	in_amount0Out	block_timestamp	transaction_hash
0x6bec40a0129224309460e3f912a8b14e2f2770c1	0xfcabba53dac7b6b19714c7d741a46f6dad260107	false	0x6bec40a0129224309460e3f912a8b14e2f2770c1	13	68687491	123290785	2544392761230956877895	2023-12-02T02:55:31.000Z	0xc38067693eccb4e00ffc4a881c5b4fbb2c709b7c854bf795b901d7292a1e9f0b
0x6bec40a0129224309460e3f912a8b14e2f2770c1	0xfcabba53dac7b6b19714c7d741a46f6dad260107	false	0x6bec40a0129224309460e3f912a8b14e2f2770c1	15	68706001	70545479	1451604535569372145251	2023-12-02T14:05:25.000Z	0xe919054bb375300cc5efb0b8ee5d4cd6af07c591d72958d0feac87344753c09a
0x183477253b3773d0ca1d798c83e7e7572c68375b	0x4821cdc4b01bfee77c6ab8abc9348c4351600e26	false	0x5ba35b3d05f0a205d8317cea926ef5d2cb8b08bf	30	68706003	6627123	6602084175737811442	2023-12-02T14:05:29.000Z	0x940f3554a42043439eaf76c685428561d0602169f246b2f7df3867b4c44b96b9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.fathom_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
0x098b5c5178c5bcdadf3488631c3b74164275e3bd	false	2336	998416	10961499557808408768208	77966251	2024-08-02T16:20:19.000Z	0x8641197bb3ea64ebaafea835ab03e6f5baacb99d73452f97afb215ad2f858c38
0x098b5c5178c5bcdadf3488631c3b74164275e3bd	false	6	999503	10949614207461879336938	77966266	2024-08-02T16:21:23.000Z	0x2ef48d4471c7bb5648455a09ef748b3cbd473293bbce0a4253aa01e5f26dfa0b
0x098b5c5178c5bcdadf3488631c3b74164275e3bd	false	5	1000105	10943042992822169492949	77966286	2024-08-02T16:22:22.000Z	0x216c7859e4a9323781d3104ca40e73ee99f86d0e57b892d52c80d0a93bfa4c82

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.fathom_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
0xaedb3806a395eddf45c2700ab0ab67f99c06faf4	0xc923bc7eef90c9236ba356d53cd48db3de8b92c3	0x0000000000000000000000000000000000000000	false	245360919230017445	4	72229505	2024-03-01T17:29:13.000Z	0x4c2dfb85c0ccb425044e4e8bb58d112f98f0baa7c5cc0156af4c0d288a9db16d
0xa48100d789ad2a8569f46f1cc0ff895a4ddedfa7	0xc923bc7eef90c9236ba356d53cd48db3de8b92c3	0x0000000000000000000000000000000000000000	false	74411385317433520047	5	72229505	2024-03-01T17:29:13.000Z	0x4c2dfb85c0ccb425044e4e8bb58d112f98f0baa7c5cc0156af4c0d288a9db16d
0xc923bc7eef90c9236ba356d53cd48db3de8b92c3	0xc923bc7eef90c9236ba356d53cd48db3de8b92c3	0x3a038623f0ab744cb0d4594f5fa736dbb2e8ad7b	false	438882494296633678566	1	85670380	2025-03-01T14:01:36.000Z	0x72005f638640dc5cbf19c189878e199fc7937bd2bde7b3e6ddc38407d57e74b6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.fathom_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