uniswap_v2_polygon

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
0x9e5a52f57b3038f1b8eee45f28b3c1967e22799c	0x03ee3213272e1501bada6f019562f560e3c730cf	false	6209	0x09eaa1dc7baf3d570f84fa20c59e603592f8fe43	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	185	68973061	2025-03-12T21:37:59.000Z	0x7426d9c52b6502ef042fdbf54b6da2ad294859f10c071f1f3ce7331df249ad50
0x9e5a52f57b3038f1b8eee45f28b3c1967e22799c	0x44e97291b402c1caefddf7972210998578e732a8	false	6206	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xc5690ee8af63758e0df06bf0cba87961e9b78e29	362	68958911	2025-03-12T13:11:37.000Z	0x3713be73a24d73f8540b3e5ca8ffed3d9fda2065989264ac0b677b3036eb4b1d
0x9e5a52f57b3038f1b8eee45f28b3c1967e22799c	0x1cd8b833a675d122bd8caa2c5635a628d7c0fff6	false	6205	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xee7f68502c51f0c7f7d8cd4b008441565e02f2aa	37	68957231	2025-03-12T12:12:05.000Z	0x1d13afd748c7a72bbcfe3bbbc5b989f1fb5776a2f3291fb61ed5ec13353a1afc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_polygon.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`	`NUMERIC`	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_polygon.Factory_setFeeTo_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Approval_event

ERC-20 approval events emitted by Uniswap V2 liquidity pool pair contracts, granting spender addresses permission to transfer specified amounts of LP tokens on behalf of owners. Used for tracking liquidity provider token allowances and router authorizations.

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_spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. 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

address	removed	in_owner	in_value	log_index	in_spender	block_number	block_timestamp	transaction_hash
0x1f0c5400a3c7e357cc7c9a3d2f7fe6ddf629d868	false	0x24791cac57bf48328d9fe103ce402cfe4c0d8b07	3464101614137	4352	0xa5644e29708357803b5a882d272c41cc0df92b34	53479368	2024-02-13T16:48:14.000Z	0xdff2341221812837b95c1466b6c33cc61c96f3d47256931b0a95617d00b1dcd6
0x711b6f6788e4cb0f7034bf02b149118a46e500c2	false	0x50a0e82a975c55253cfe81f2bfb96994a7f9f951	5555555555555555	375	0xa5644e29708357803b5a882d272c41cc0df92b34	53761585	2024-02-20T22:28:45.000Z	0x3b66332f117f699d738e14fef95ff54f9c894416b116b79c908f87dad5d3e1a6
0x711b6f6788e4cb0f7034bf02b149118a46e500c2	false	0x8aaa8e6494b13116ad65168283ec5269479611ff	92144322546114721	20	0xedf6066a2b290c185783862c7f4776a2c8077ad1	53760338	2024-02-20T21:43:26.000Z	0xc0912f17b74c2982ca278d7be1d88758a3d183951ba10f359d1dfcd062039894

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_polygon.Pair_Approval_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
0xa5644e29708357803b5a882d272c41cc0df92b34	0x5aa7bd404e87d2399a5db1252c60f736783fba98	false	0xa5644e29708357803b5a882d272c41cc0df92b34	284	19980205655526992260	28954091316322216443443	67427555	2025-02-02T00:12:30.000Z	0x96fcc38e19d86a7633685f4cb6ba98d3a930f28f2ba5c10fae59abfd2f88b303
0xa5644e29708357803b5a882d272c41cc0df92b34	0xb7a42fe0b35cdf9a70f992bcf404d87e2f844eb0	false	0xa5644e29708357803b5a882d272c41cc0df92b34	106	587225605623024194570	44540046928412	67432769	2025-02-02T03:19:21.000Z	0xb48589b3c2cc02f4c7c48f752bb08b3da5ccfc92635f1e8471f1a33a15270778
0xa5644e29708357803b5a882d272c41cc0df92b34	0x5e72dce863df95efdfa2894b3a9b72dbd7ddbca7	false	0xa5644e29708357803b5a882d272c41cc0df92b34	266	29133	32608	67448008	2025-02-02T12:21:06.000Z	0xabeb5cba4490c54de3de8f25db0d4a0bc3c4acb9f530be41815633f62f9db34c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_polygon.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
0x4ad2e7c9e7acc020afdc3be7ad95dd1a9164753c	false	0xedf6066a2b290c185783862c7f4776a2c8077ad1	1537	1031449213132059538	100000000000000000	78841432	2025-11-10T15:15:48.000Z	0xf183e48f7e3d87e7ad1e0267267c085bca5aa411c2cfbd1017af2a0aea9ba066
0xa631d042814547cf15f6f60ae4f36591fefe70a8	false	0xedf6066a2b290c185783862c7f4776a2c8077ad1	626	8663796932949428801	1000000000000000000	78840467	2025-11-10T14:43:38.000Z	0x2214ae866c790d33f6977ab3d6fc262354e5c8b7799d16be67cdca1175016dc2
0xa631d042814547cf15f6f60ae4f36591fefe70a8	false	0xedf6066a2b290c185783862c7f4776a2c8077ad1	663	8924811284053426591	1000000000000000000	78835235	2025-11-10T11:49:14.000Z	0x7d0fe9b93f66b5d522cbb57cfacc75d2cf2d9efd2f318decb654ef35c871d9e3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_polygon.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_amount1Out	block_timestamp	transaction_hash
0x000000000093baf2da9321cbf75d8ad67e7512fb	0xfe51e911c834cc42bfffa61b4b91647695770497	false	0x000000000093baf2da9321cbf75d8ad67e7512fb	576	69935656	439865202206795856859	70768	2025-04-05T17:51:19.000Z	0x4c594102cf9e14abfbf80537876a0c2248b3ababe9b94b97150522fcc22c8ed9
0x000000000093baf2da9321cbf75d8ad67e7512fb	0x0e24c58d94e10b6763324dd6db209cf52405dfb9	false	0x000000000093baf2da9321cbf75d8ad67e7512fb	157	69917691	913498103342074634450	188	2025-04-05T07:09:33.000Z	0x5ee31429d53b5e3812a138c13225b1b707bf806f21646c5e9fdf5b8d5ec1638e
0x000000000093baf2da9321cbf75d8ad67e7512fb	0x1b295195ddcb2e13327ce56bfcee0eddc9d19181	false	0x000000000093baf2da9321cbf75d8ad67e7512fb	134	69941332	18493781663789177069389518	26364669137417	2025-04-05T21:14:56.000Z	0x0e02790333925c82a34e70ed0abd954099ba066beaf36eccca3455c18e97ead4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_polygon.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
0x005c4108fa00c6c4721fefd4338fb1e211ff9047	false	233	6418794	1850324893985489707	57204187	2024-05-21T01:16:42.000Z	0xae70e4b3a2fada086789a9976187c01ed893061e4a4b0f1cfcf34bbd0d11d879
0x005c4108fa00c6c4721fefd4338fb1e211ff9047	false	318	5852403	2029936880701565035	57205234	2024-05-21T01:54:20.000Z	0x82d68ee021fa6f5df70a95766148a7bf6d930c79bc71a11630402da8104f8bea
0x005c4108fa00c6c4721fefd4338fb1e211ff9047	false	572	5474709	2170401660887943632	57205255	2024-05-21T01:55:05.000Z	0x5a0e48164a9b3a20270693d5c97ddae18e944fe5d71cd2bf0cc58b306d49ec1a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_polygon.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
0xb0c54bd367ffb5e516b82979290b0a4ebaacd741	0x0819f470357f61e0ef3e32e035ca28f366c43917	0x0000000000000000000000000000000000000000	false	3564818863	299	67245761	2025-01-28T11:15:08.000Z	0x33de04fc611bfb3b873189773f827825153253871fcb2c816a12dd3beed0dddb
0x0000000000000000000000000000000000000000	0x150357f5e209e7171045bcfa582db9941a624270	0x0000000000000000000000000000000000000000	false	1000	284	67227917	2025-01-28T00:42:28.000Z	0x21a74805d30e1547981813dcd14cb58cedca2440220aadbc46e0d3f6ccb0a68c
0xd8d58321eb5ca1dd157910919d943bb0c1ca64bb	0x150357f5e209e7171045bcfa582db9941a624270	0x0000000000000000000000000000000000000000	false	12135597524338357551413	285	67227917	2025-01-28T00:42:28.000Z	0x21a74805d30e1547981813dcd14cb58cedca2440220aadbc46e0d3f6ccb0a68c

Example Query

Query with partition filter

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

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_Approval_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Factory_setFeeTo_function

Pair_Approval_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event