uniswap_v2_worldchain

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	block_number	block_timestamp	transaction_hash
0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	0xf911c1bc14d75e44ad89617c64f2c93ea6ff2f39	false	225	0x90ac15b9fadc4656dce25c8da0d2bce6a16e605c	0xed49fe44fd4249a09843c2ba4bba7e50beca7113	11090238	2025-03-09T10:28:35.000Z	0xd84bde15191ea3a954bae6e87a6348dc795cdf52f4b307c80218cd20ce3bf252
0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	0x02d149127e1221d60dbecddb2898654e2827271b	false	226	0x4200000000000000000000000000000000000006	0x90ac15b9fadc4656dce25c8da0d2bce6a16e605c	11103120	2025-03-09T17:37:59.000Z	0x6d2038a9fe60e4064a43af693a5aadb6d9b23690a6c6f71a67fc0bbd18077fcb
0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	0xdc94794bd7cb0b1b243f3b38fb9909e88362d2bf	false	227	0x79a02482a880bce3f13e09da970dc34db4cd24d1	0xa608d4089647a4b7d996612f89751dff16f1dba6	11103186	2025-03-09T17:40:11.000Z	0x7fb292909c75fed3ce1478d7a97efd0f4457b58924b213adf46276dfe719c440

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_worldchain.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`	`NUMERIC`	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_worldchain.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
0x541ab7c31a119441ef3575f6973277de0ef460bd	0x2ed721114daa3a968eb8d8276bf999dd30c15116	false	0x541ab7c31a119441ef3575f6973277de0ef460bd	5	6228768467532071	4747805222343447481039	15136767	2025-06-11T02:32:53.000Z	0x051d2736e724c80f0090e8eff5a0ff9d1590c318972180968e1cb7c8d52b63a1
0x541ab7c31a119441ef3575f6973277de0ef460bd	0x26e949d082e4b13a4152d04a94d4f8ec1339fde2	false	0x541ab7c31a119441ef3575f6973277de0ef460bd	5	343025025654573679	358915330350284727378321918	12178591	2025-04-03T15:07:01.000Z	0x1d1c49f14124b455af7337b95d89e06a5ed5c5fef43918fb20a1ebd4707080f3
0xa05796f1d61ef34c2c8f9cb42fa4a60e6bd55f48	0x5501a9fe81937b8d3fdc0b65631d228c07b75ba2	false	0x541ab7c31a119441ef3575f6973277de0ef460bd	5	603999999999999999998	596038356410773546183556035	12163055	2025-04-03T06:29:09.000Z	0x1b27768c4878012271adeea4d2153c2677b240f4ade89787a9e2451a072e72e9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_worldchain.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
0x5a5189307eae50b0ef16eff3812b798091a4dd52	false	0x541ab7c31a119441ef3575f6973277de0ef460bd	6	1000000000000000	1000000	4889574	2024-10-16T21:39:47.000Z	0x0ae95e0049d163bab580a71490a3ffb038e124a6fc6a543afefd8e1daf1ce190
0xca2a5ad8b2e8cbb9e420cd717074204e4522de39	false	0x541ab7c31a119441ef3575f6973277de0ef460bd	50	8000000000000000000000000000	177777777777777777	15194075	2025-06-12T10:23:09.000Z	0x043c576bbbfd213cd481b4eb13eb6a782d88bac22053448d5dff99cfb3a383cd
0x23c3317a8a066995eebada60b558dfd825f34064	false	0x541ab7c31a119441ef3575f6973277de0ef460bd	15	333553036309043	10000000000000000000000	15217833	2025-06-12T23:35:05.000Z	0x38edd1108a79e01701b7d7762eab8c10b9249e4e2a7bd8fbdd448c40a5f629e2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_worldchain.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
0x141a4e2a46752414f5587a98bfc0f2a53eb63bf9	0x03af1c3e031a85a3c50519eba5e8464eb42affbe	false	0x541ab7c31a119441ef3575f6973277de0ef460bd	34	8892297	17619065818638285	1192489543913862788798	2025-01-17T13:23:53.000Z	0x300892a6266ef1f0041f047bcf4e0287873f483b78b5acb058bab33cceca7958
0x18c8d7b62166c2c3e59ca9f54cae65a883f530a7	0x03af1c3e031a85a3c50519eba5e8464eb42affbe	false	0x541ab7c31a119441ef3575f6973277de0ef460bd	68	8868787	9900000000000000000	421910996166706659188668	2025-01-17T00:20:13.000Z	0xfaab4df4d3a79ac9ced11cb7f4175bf0d19b4a7a05eebc4b3f30ac9ae0956e9e
0x279595a3f85c95c77fe6028dfdf6a12b901985a5	0x03af1c3e031a85a3c50519eba5e8464eb42affbe	false	0x541ab7c31a119441ef3575f6973277de0ef460bd	31	8874177	7265418855255859	297871209374458244868	2025-01-17T03:19:53.000Z	0xeb44b488d73931f11b9504a5fe382348d5719f6e8fca3fe1b7b4556e51c98e8d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_worldchain.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
0x84bf434c13c28f6b7fa245d7209831adc57a6597	false	38	6533285064929274468	130368679037368707125270571800	8608982	2025-01-11T00:00:03.000Z	0x173d4dea953f1bb858f40ea97ce43ed99f2a1a488f5742336f4a7007d2ed7a43
0x9ad1a9a0fd8ce1a1191798d609fc12e8dd29848d	false	41	67231615514627263124	44063713910736249	8608982	2025-01-11T00:00:03.000Z	0x173d4dea953f1bb858f40ea97ce43ed99f2a1a488f5742336f4a7007d2ed7a43
0x84bf434c13c28f6b7fa245d7209831adc57a6597	false	16	6533284933221485695	130368681673444942704385327206	8608987	2025-01-11T00:00:13.000Z	0xa13a51bdc157b0717b001f6039e52df4b27291fd71f78b6635073c76ae0c20d6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_worldchain.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
0x0000000000000000000000000000000000000000	0x07d7df90add0d79dafee042861b939442c98cb2f	0x0000000000000000000000000000000000000000	false	1000	10	13456707	2025-05-03T05:10:53.000Z	0x23b39415695007f7f72a3d925526543bdf5bd4aad6578e3f3b1b6c992d84dfbc
0x45ac0dbf87c4604c36e54ba8f7afa6237f16d2fe	0x07d7df90add0d79dafee042861b939442c98cb2f	0x0000000000000000000000000000000000000000	false	36198853416853809	11	13456707	2025-05-03T05:10:53.000Z	0x23b39415695007f7f72a3d925526543bdf5bd4aad6578e3f3b1b6c992d84dfbc
0x0000000000000000000000000000000000000000	0xc2cdd4dcc888a3b1f8531c8e254628c758770e60	0x0000000000000000000000000000000000000000	false	1000	175	13464561	2025-05-03T09:32:41.000Z	0x7a2f31e60bf397710f6ad375baec51f272e8087a38cb035f073a2e487a7c2015

Example Query

Query with partition filter

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