uniswap_v2_base

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
0x8909dc15e40173ff4699343b6eb8132c65e18ec6	0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	1	0x4200000000000000000000000000000000000006	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	469	10526493	2024-02-13T16:38:53.000Z	0xe537cba808a2646f59c4993e79e798231653333cf08d43b69d95b57171bb3548
0x8909dc15e40173ff4699343b6eb8132c65e18ec6	0x6c39acc16deb25b496c24c21e1e5f5e192ed01c8	false	2	0x4200000000000000000000000000000000000006	0x4ff77748e723f0d7b161f90b4bc505187226ed0d	20	10841699	2024-02-20T23:45:45.000Z	0x8e37cb01481b79b695cd06dcb61cf6da50ee7ad09e503ffd622660d61787b0fd
0x8909dc15e40173ff4699343b6eb8132c65e18ec6	0xa7919f296503d3afbf9b781ef246da4f90ee179c	false	7	0x09417e6a6eb5cb69311cc2ca3ca10c7899f1a622	0x4200000000000000000000000000000000000006	0	10872758	2024-02-21T17:01:03.000Z	0x8c69fa3c9d94d95d1e8f80b0fbd0cff69b78340a449ca0f8fc7b59250f3bd20f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_base.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_base.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
0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	0x4423b0d6955af39b48cf215577a79ce574299d3f	5319722008	474	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	10526646	2024-02-13T16:43:59.000Z	0x473f5d4db47a081a30caf258445aed9932c6ee7024ae4099e483b9acb875cd1c
0x0fd6bb1c585548c973563d36c90f7d167b719b0d	false	0x32de0a1b868fd71e43183d7a35cad1fdaccb520d	205041459222275336376	14	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	10852411	2024-02-21T05:42:49.000Z	0xbef79a7e095e3bb4237d5c30397f1f913fe86737879d23151e53a22e26f83b0b
0x6c39acc16deb25b496c24c21e1e5f5e192ed01c8	false	0xa9369d576cd73ec101f6fc3130693516a1b01974	33876683568533208322	42	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	10874957	2024-02-21T18:14:21.000Z	0x6d0b6a1d74ccee6b17924bb42d498ec38c31c8349ff09adf325fc2748bfae785

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_base.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
0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	480	102808999796635	275789	10526646	2024-02-13T16:43:59.000Z	0x473f5d4db47a081a30caf258445aed9932c6ee7024ae4099e483b9acb875cd1c
0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	0x0fd6bb1c585548c973563d36c90f7d167b719b0d	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	20	141249336926069330	297948280569800603099551	10852411	2024-02-21T05:42:49.000Z	0xbef79a7e095e3bb4237d5c30397f1f913fe86737879d23151e53a22e26f83b0b
0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	0x6c39acc16deb25b496c24c21e1e5f5e192ed01c8	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	48	7739028842758402	148989094581279636115555	10874957	2024-02-21T18:14:21.000Z	0x6d0b6a1d74ccee6b17924bb42d498ec38c31c8349ff09adf325fc2748bfae785

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_base.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
0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	64	49092018570528	1000000	10526587	2024-02-13T16:42:01.000Z	0x9072e936b5ab840ef512668e79fb3b47202987c799f762678b2ac93b7b776e07
0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	476	100000000000000	2036991	10526493	2024-02-13T16:38:53.000Z	0xe537cba808a2646f59c4993e79e798231653333cf08d43b69d95b57171bb3548
0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	10	99926041390499414	268056311	10574146	2024-02-14T19:07:19.000Z	0x3836a98a4b7cf279276d81a72bbeaae4d6d88472ac7d39fcc6101b0b11496acd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_base.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
0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	4	10761190	50000000000000	0	0	144764	2024-02-19T03:02:07.000Z	0x74ad1fbd9da6082446e47536002a524094dbe0e0233703b5b889303bd4b37476
0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	4	10683918	0	1000000	368401852991874	0	2024-02-17T08:06:23.000Z	0xea21cb00fd47d5bc4c338c7c9c7ce305b45d3cc30d88cdefb92a6bd16f858c43
0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	4	10685515	0	277940	101910808239043	0	2024-02-17T08:59:37.000Z	0x993e6ad88a36a4d62f8921aaaea49a0c53ba20b755cac36e37b3945fa6425764

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_base.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
0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	3	96317477323450115	279851621	10748553	2024-02-18T20:00:53.000Z	0x2045bc41c83a071213bb9047c6330d915e0415011ec676084820b63574fc44a4
0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	479	308427018773893	827370	10526646	2024-02-13T16:43:59.000Z	0x473f5d4db47a081a30caf258445aed9932c6ee7024ae4099e483b9acb875cd1c
0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	false	475	100000000000000	2036991	10526493	2024-02-13T16:38:53.000Z	0xe537cba808a2646f59c4993e79e798231653333cf08d43b69d95b57171bb3548

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_base.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	0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	0x0000000000000000000000000000000000000000	false	1000	473	10526493	2024-02-13T16:38:53.000Z	0xe537cba808a2646f59c4993e79e798231653333cf08d43b69d95b57171bb3548
0x4423b0d6955af39b48cf215577a79ce574299d3f	0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	0x0000000000000000000000000000000000000000	false	14272318363	474	10526493	2024-02-13T16:38:53.000Z	0xe537cba808a2646f59c4993e79e798231653333cf08d43b69d95b57171bb3548
0x4423b0d6955af39b48cf215577a79ce574299d3f	0x88a43bbdf9d098eec7bceda4e2494615dfd9bb9c	0x0000000000000000000000000000000000000000	false	7006569672	62	10526587	2024-02-13T16:42:01.000Z	0x9072e936b5ab840ef512668e79fb3b47202987c799f762678b2ac93b7b776e07

Example Query

Query with partition filter

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