uniswap_v2_unichain

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
0x1f98400000000000000000000000000000000002	0xb41856bc2e6f800101c764c886886b0ec0bc62c4	false	6026	0x4200000000000000000000000000000000000006	0xd1ef374e1a42aa2d909e9629f81b41b91cbbdbe0	13	11752949	2025-03-20T20:08:28.000Z	0x602241be16d5b07218eb6c6366f7433e63c55c85ac3b80814a9ebbc54640a8b2
0x1f98400000000000000000000000000000000002	0xa06f02a3121dc29e3ea6704d1b6059f0b539f9fe	false	6401	0x4200000000000000000000000000000000000006	0x966fbfa46400c095bde2fcb6ceedd3487f0a2e1b	15	11766231	2025-03-20T23:49:50.000Z	0x9d0446fc440fba68307281738ab00ca3f27ca0062baf2f44c21fc8d09a9115eb
0x1f98400000000000000000000000000000000002	0x7c7a5f51e83c5412b5ab0cebe359e17e401db6a0	false	6377	0x4200000000000000000000000000000000000006	0xc58d77a852a963c8e998c425c4045834f27acf3d	0	11765275	2025-03-20T23:33:54.000Z	0x036296ac16fdce600c63c295a95b81e6013d206046237fd2e44502d1bce7118f

Example Query

Query with partition filter

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

Factory_setFeeTo_function

Uniswap V2 Factory setFeeTo function call records for updating the protocol fee recipient address. Captures administrative transactions that configure the address receiving protocol trading fees.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__feeTo`	`STRING`	Address designated to receive protocol fees from Uniswap V2 factory operations. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_unichain.Factory_setFeeTo_function`
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
0x284f11109359a7e1306c3e447ef14d38400063ff	0x76da6d6de6861741861c19a0ea31162b9fd94233	false	0x284f11109359a7e1306c3e447ef14d38400063ff	5	29790480824226	2461799104799512685090	12156506	2025-03-25T12:14:25.000Z	0xab7574243f3c9a8c861f75789a768ac9236b677d0e2828887c83d8cb22f8ab90
0x284f11109359a7e1306c3e447ef14d38400063ff	0x6b29c5e5a065ae1bde02238f623bb17818c58356	false	0x284f11109359a7e1306c3e447ef14d38400063ff	7	27868594736487	557718353800526787744	12156573	2025-03-25T12:15:32.000Z	0x4007028bb4688263e9ddc7227e0f5d7aec3771df27f9647a7c4197f7ac0ab837
0x284f11109359a7e1306c3e447ef14d38400063ff	0xeacff8a22fa035ad4b8a3fc9c431ae480c0700ec	false	0x284f11109359a7e1306c3e447ef14d38400063ff	10	90929746878135	2449509528996052913845	12181221	2025-03-25T19:06:20.000Z	0xa8c10b1bffdb1cb56ba48ff9d6305cc204cf76c4e96d16814b8ec620b4029f14

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_unichain.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
0x1583d92dc122c95cb014bd59c70816351e91858c	false	0x284f11109359a7e1306c3e447ef14d38400063ff	9	2000000000000000000	1000000000000000000000	13713762	2025-04-12T12:48:41.000Z	0x150de222a41909c74c4cfc1fdbe3bf8ed8068103c5507a340bde0cd8f9363bb1
0x52c8490a22f40afd071d207b7443cba19988f362	false	0x284f11109359a7e1306c3e447ef14d38400063ff	9	100000000000000000000000	10000000000000	13667794	2025-04-12T00:02:33.000Z	0x4b04ead0a89f28c815fc3fb128e461633cfdb1824d316004d9b95085bef7edbd
0x47730edeb1ee4e52bdb5b5818c073f843d7fe307	false	0x284f11109359a7e1306c3e447ef14d38400063ff	12	100000000000000000000000	10000000000000	13667720	2025-04-12T00:01:19.000Z	0xba51e5a4e26b2d5c96475047caf6d30b8ed3d7ced381670380e5a42206094d98

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_unichain.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
0x000000000062941def20d0d2d74dfca8f96a4ee1	0xdad190dc3fdbb64a1080d2d1c160740d3d6877b0	false	0x000000000062941def20d0d2d74dfca8f96a4ee1	10	11538445	14056117388176073739	2862584654082	2025-03-18T08:33:24.000Z	0x832387d3be65a14cf8cb1dbb7a09dc16a0ba0803e90e511537f44ea712ad897d
0x000000000062941def20d0d2d74dfca8f96a4ee1	0xe580040befd1d161aeead37c61f46937ae141a8d	false	0x000000000062941def20d0d2d74dfca8f96a4ee1	6	11559752	15363050948628084376871	60	2025-03-18T14:28:31.000Z	0xb73fbe4ca62a0fd7af44e28b5ae1b2e9d90a1267e80eb45c33f9717f8e2b096e
0x000000000062941def20d0d2d74dfca8f96a4ee1	0x4e981321e29769c0942fe76355767c3b414ac491	false	0x000000000062941def20d0d2d74dfca8f96a4ee1	24	11508381	219132757753716688105520	608156	2025-03-18T00:12:20.000Z	0xfbdb42d6f71a5defc848d81ac03b943a729dfeea75f80fa82bf9ec9c209105ab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_unichain.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
0x03144418d7d40c2abe757d6dc5b2909556ceb2f5	false	4	1	625998126	8862923	2025-02-15T09:21:22.000Z	0xcb8cb0c9bd2dc64b841a3484c3ded68e0fc98453444e489946eabc4e0d04920f
0x2322872e57df9066c86f4bb632695dd3ba6d34ce	false	7	140000000000000000000	140000000000000000000	8883780	2025-02-15T15:08:59.000Z	0xbff09f4b8af497c3e01f72e9a6535980356a476b3a3b76757d4964290f0dba87
0x355d5979448f1e9438ff84c8a265135a16b64ea1	false	3	1292934	2	8899901	2025-02-15T19:37:40.000Z	0x5d29e342766ca2814c40f4253d563a8cc19e9009278927e0ca33ecd26b4870bf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_unichain.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
0x98c69ab018c95086421db13331966e7118e1c27d	0x1a1ea4d7677835453e65d4418b9c78f139aa21a2	0xf8d890fd4a292534501e8e1d7ab336f3f796efba	false	316227766016836	0	9619661	2025-02-24T03:33:40.000Z	0x109da379d309d7c77b8c8a6c8f3a1a6d88e4f6ae5dfa62f1e77c4215c6670ee2
0x100d0c849b413ac99794354f48b5ed01efc4cbf8	0x100d0c849b413ac99794354f48b5ed01efc4cbf8	0x02cd1676f2243ebc4def8a6142c81d321b0405ae	false	1414206530903261929	1	9668833	2025-02-24T17:13:12.000Z	0x6dc9966284acd9149e8787b70629e0258976125694010cd06f7fd18bb23ed5be
0x98c69ab018c95086421db13331966e7118e1c27d	0x1a1ea4d7677835453e65d4418b9c78f139aa21a2	0xf8d890fd4a292534501e8e1d7ab336f3f796efba	false	316227766016836933	1	9615734	2025-02-24T02:28:13.000Z	0x28adc6899ac01461c9484c82bb7179cbbf51affd8a379f7e3b5749771e841429

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Factory_setFeeTo_function

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Factory_setFeeTo_function

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Factory_setFeeTo_function

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event