uniswap_v2_optimism

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
0x0c3c1c532f1e39edf36be9fe0be1410313e074bf	0xa7a8bfa77133a5a984c18e1ca898541d3c86a3d5	false	7	0x4200000000000000000000000000000000000042	0x9fe7ac2f13b968c607fc0f2ad7efb1fd1edd9c36	25	116653004	2024-02-25T23:46:25.000Z	0x033d1d5ca4c36738158f713868b0ab81efb1b20af04cb36cf82adacb1f8e99df
0x0c3c1c532f1e39edf36be9fe0be1410313e074bf	0x4c43646304492a925e335f2b6d840c1489f17815	false	1	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0x4200000000000000000000000000000000000006	71	116121726	2024-02-13T16:37:09.000Z	0x53da802bd6323c98d824fdedadf40a5fa6f140a1b0ad370c21cc8962abc9f291
0x0c3c1c532f1e39edf36be9fe0be1410313e074bf	0x895bb8b1cc9746b431b66b2114f46a7a57412980	false	2	0x2e3d870790dc77a83dd1d18184acc7439a53f475	0x4200000000000000000000000000000000000006	53	116121882	2024-02-13T16:42:21.000Z	0x4a624bda4df9f13426d2c541fee20c9fa168d145f3b24c569b1594ce3c5f88ce

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_optimism.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_optimism.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
0x4c43646304492a925e335f2b6d840c1489f17815	false	0xadd287e6d0213e662d400d815c481b4b2dde5d65	12811927036	14	0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	116121787	2024-02-13T16:39:11.000Z	0x4074d629cf98fe9014c3412026bc8d2f8cb6a2973af83f40674ef88423caaf2f
0xf3fe89650e170d4d54d8ddd41affde7369cbc7d3	false	0x415587b8bee6034ca6ba7a6832222e5d2b8ab93c	101345199858154793	31	0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	116581127	2024-02-24T07:50:31.000Z	0x498468e560d770708446c39945aad7a7812d7cb1f96f709fe0a1083bd8b059da
0x4c43646304492a925e335f2b6d840c1489f17815	false	0x62af4ae284b71fd83b5eebdada0743590b139531	41696915481	29	0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	116555641	2024-02-23T17:40:59.000Z	0x8b3a1a00b0a4dc61ce820003d63930174d32a4460811c5e28fdb9218efb9beaa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_optimism.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
0x8cb34f745a5e6eff6d3a15b978f8c5d42e7a7ae5	0x6728bfc6f086801c6fdaa8a3689ff498ed071704	false	0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	76	48991	48999	116670766	2024-02-26T09:38:29.000Z	0x9627094c12e9c53f311037f3400528b8149f5c6f023add533e37fa01010b7ff8
0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	0x2f629782c58918252970ab038d3fbd16e84d5076	false	0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	20	9999994277383	305358	116670544	2024-02-26T09:31:05.000Z	0x677cb20595cbb7f53da47b148d35f56dd31ba41404eaa915d034bc8b7e4b21a8
0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	0xf3fe89650e170d4d54d8ddd41affde7369cbc7d3	false	0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	37	3545147278234085	2897524788368796172	116581127	2024-02-24T07:50:31.000Z	0x498468e560d770708446c39945aad7a7812d7cb1f96f709fe0a1083bd8b059da

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_optimism.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
0xf3fe89650e170d4d54d8ddd41affde7369cbc7d3	false	0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	24	1275000000000000	1000000000000000000	116500614	2024-02-22T11:06:45.000Z	0x259876af818f84adce6cf1f565e8eb143b2fd080bf2af6d39894354aefa486ec
0xf3fe89650e170d4d54d8ddd41affde7369cbc7d3	false	0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	17	596405321913418	500000000000000000	116673976	2024-02-26T11:25:29.000Z	0x00a485cf3afdb4fc634819524e8a9323e13653e0e9d54cb2f2ba15d080116777
0x2f629782c58918252970ab038d3fbd16e84d5076	false	0x4a7b5da61326a6379179b40d00f57e5bbdc962c2	59	10000000000000	305359	116670518	2024-02-26T09:30:13.000Z	0x4fc8851e2be7c34f83e221ebde69d824e7e02592aa3cfa13c77a38b74d624dba

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_optimism.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
0xcb1355ff08ab38bbce60111f1bb2b784be25d7e8	0x4c43646304492a925e335f2b6d840c1489f17815	false	0xcb1355ff08ab38bbce60111f1bb2b784be25d7e8	4	116391940	2910000	0	0	1033701182813535	2024-02-19T22:44:17.000Z	0xac0b7102a3f92813088044b444744c251ba09abb6df86fd4c30af5095c2c0a63
0xcb1355ff08ab38bbce60111f1bb2b784be25d7e8	0x4c43646304492a925e335f2b6d840c1489f17815	false	0xcb1355ff08ab38bbce60111f1bb2b784be25d7e8	20	116293531	0	360447999138757	1001500	0	2024-02-17T16:03:59.000Z	0x78d8df86ed1c53a2a3da9fdc32fc5f00d405d765e61177ac51bd31eda5e27321
0xcb1355ff08ab38bbce60111f1bb2b784be25d7e8	0x4c43646304492a925e335f2b6d840c1489f17815	false	0xcb1355ff08ab38bbce60111f1bb2b784be25d7e8	21	116280692	0	179208996852718	500750	0	2024-02-17T08:56:01.000Z	0x8b81fd220d22d0f26272df15bc7cf72b496679913e0d4db08b4cc89bc11aae2c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_optimism.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
0x4c43646304492a925e335f2b6d840c1489f17815	false	19	265503469	95630636299640581	116293531	2024-02-17T16:03:59.000Z	0x78d8df86ed1c53a2a3da9fdc32fc5f00d405d765e61177ac51bd31eda5e27321
0x4c43646304492a925e335f2b6d840c1489f17815	false	20	266504969	95270188300501824	116280692	2024-02-17T08:56:01.000Z	0x8b81fd220d22d0f26272df15bc7cf72b496679913e0d4db08b4cc89bc11aae2c
0x4c43646304492a925e335f2b6d840c1489f17815	false	49	276500271	91840349775010701	116434884	2024-02-20T22:35:45.000Z	0xa4489cc7ad239202b4975dc7fb5dc88c047c296a775db71a972aa0b6beb83cf1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_optimism.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
0x040ee96aa7c8915f18b80d82e9f48ae4ffaf4173	0xffee909c673b41e6f532cd1ff5d531fbaee6cdce	0x0000000000000000000000000000000000000000	false	76376233271559808414	10	116565132	2024-02-23T22:57:21.000Z	0x4377cb015a305f8fae66deb8b75a5270ddd56ec5d0b48dfe68f57ab33ea615e4
0x7bb85b553c04cf2dfcbbdac998ea3621e17236c3	0x472cede4a60cb6bbc310664d6a23e58c23f877b9	0x0000000000000000000000000000000000000000	false	2366826	64	116564358	2024-02-23T22:31:33.000Z	0x44c74781308e2a3beac13b9f01f308d8786aa6de78bd05eba1d9f743c7a3b7e3
0x0000000000000000000000000000000000000000	0x472cede4a60cb6bbc310664d6a23e58c23f877b9	0x0000000000000000000000000000000000000000	false	1000	63	116564358	2024-02-23T22:31:33.000Z	0x44c74781308e2a3beac13b9f01f308d8786aa6de78bd05eba1d9f743c7a3b7e3

Example Query

Query with partition filter

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