uniswap_v2_arbitrum

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
0xf1d7cc64fb4452f05c498126312ebe29f30fbcf9	0x3b1695babe3aadd0af166458dcb32c521734948c	false	1408	0x9cce9ae579142e372a8959285e3a5a2e211904f7	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2	223179995	2024-06-18T14:49:54.000Z	0x7218ea51001c76ce2ce3dbb0f0d5632734aa2493c48d550a0ea48d23687d1b45
0xf1d7cc64fb4452f05c498126312ebe29f30fbcf9	0xe425b6e4296f79c6acca7770a76082753fac0381	false	1407	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xec26036a7d06bf7e1914432811b6d9c51c4fb113	2	223128805	2024-06-18T11:14:27.000Z	0x06f5ac16ac1fbf415ac975aa42d59fea03d1269d349496b6e25c697453346570
0xf1d7cc64fb4452f05c498126312ebe29f30fbcf9	0x27d336a834775988b1305df42569e27128932bdd	false	1406	0x13654df31871b5d01e5fba8e6c21a5d0344820f5	0xaf88d065e77c8cc2239327c5edb3a432268e5831	7	223017593	2024-06-18T03:29:19.000Z	0x8600e30a899c0b1da26786839bf093a474b49f393bcd9f60b47c24232fad1dd2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_arbitrum.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`	`STRING`	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_arbitrum.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	in_spender	block_number	block_timestamp	transaction_hash
0xf64dfe17c8b87f012fcf50fbda1d62bfa148366a	false	0x687ed137c2cb1fa58db8423797b505a9de037b1e	26178364032	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	178474837	2024-02-07T22:01:24.000Z	0x17917d300304f7e50f6f3b6b2043a3fa11f48dabc872463e34dcc5e1304aeeb3
0x103b03051bf073c44decfaf8dfd12275254ab97e	false	0xf5a531c44b55e5f4379fb8741cbf1ba8d7b7e92c	78937959078845967	0xa5644e29708357803b5a882d272c41cc0df92b34	183127297	2024-02-21T21:29:59.000Z	0xa1531a15d4195d73b3640670d2e671c6ed8fbafed6d721e1a8805925bc27c54a
0x103b03051bf073c44decfaf8dfd12275254ab97e	false	0xa2d36f11e2225d1b89146f443350e825f15b8b68	414177016830794856	0xa5644e29708357803b5a882d272c41cc0df92b34	183122419	2024-02-21T21:08:37.000Z	0x875d16ccf757a87bf30cc02917e475faa8c9660ac7f930dd639263fbd983dffd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_arbitrum.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	0xf64dfe17c8b87f012fcf50fbda1d62bfa148366a	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	6	548245504374360	1249999	178474837	2024-02-07T22:01:24.000Z	0x17917d300304f7e50f6f3b6b2043a3fa11f48dabc872463e34dcc5e1304aeeb3
0xa5644e29708357803b5a882d272c41cc0df92b34	0x103b03051bf073c44decfaf8dfd12275254ab97e	false	0xa5644e29708357803b5a882d272c41cc0df92b34	6	1999999999999998	3117473590206357071	183127297	2024-02-21T21:29:59.000Z	0xa1531a15d4195d73b3640670d2e671c6ed8fbafed6d721e1a8805925bc27c54a
0xa5644e29708357803b5a882d272c41cc0df92b34	0x103b03051bf073c44decfaf8dfd12275254ab97e	false	0xa5644e29708357803b5a882d272c41cc0df92b34	6	10493735122214066	16356971053061746716	183122419	2024-02-21T21:08:37.000Z	0x875d16ccf757a87bf30cc02917e475faa8c9660ac7f930dd639263fbd983dffd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_arbitrum.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
0xf64dfe17c8b87f012fcf50fbda1d62bfa148366a	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	6	100000000000000000	228000000	176196322	2024-01-31T22:45:58.000Z	0x43d26231047ea3cfa99b9756cfcd32791322fa7e4337f9531cd628447fca050c
0xf64dfe17c8b87f012fcf50fbda1d62bfa148366a	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	17	2192982017543859	4999999	178474734	2024-02-07T22:00:57.000Z	0xae82fa4ae085a37a66b5bb1ad7e9e37f6bbe9298e9473567cce0a74b72bcc352
0x8dca5a5dba32ca529594d43f86ed4210ead2ed83	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	7	1000000000000000	2000000000000000000	178475403	2024-02-07T22:03:51.000Z	0xdb2a2b564e61c1329088b5c441a6b8dcdae30dda22e276e17895f6e4c44b385d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_arbitrum.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
0x00000000003c1eba00fb4354588cacf8cf298c40	0x42f49d119e58a670b093647ee6ee219ee0c2c91e	false	0x00000000003c1eba00fb4354588cacf8cf298c40	23	224129740	1256976554309950172886	3457266991215550	2024-06-21T08:44:57.000Z	0x86f58a2dcb90bf473a49ded88e67ca8218f0ac3f952ccf75dfe2b2dfe53fa2c7
0x00000000003c1eba00fb4354588cacf8cf298c40	0xeb4239aac41a62a695d8dbddae268d785e308dc1	false	0x00000000003c1eba00fb4354588cacf8cf298c40	20	224051078	1681015839916031	1663896014710986685	2024-06-21T03:17:23.000Z	0x95106ff8a3947cdb8ede4605088d913110d077292705565a94cc0dafc3eb73cc
0x00000000003c1eba00fb4354588cacf8cf298c40	0x6fa774876fe6badeb1a4d0c6dcf9430a72d3873b	false	0x00000000003c1eba00fb4354588cacf8cf298c40	13	224346797	9688294293264907007266380	69208841667482844	2024-06-21T23:50:15.000Z	0x998ab52fe9a43186183b97a1ce9f470ac4a015fc9d1f98f9b84f14867b7df4f1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_arbitrum.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
0x006a31cb6c78791436a67227dd8630901abef80e	false	3	46625848766119022289	57454711490994178	228226193	2024-07-03T05:30:35.000Z	0xebc301c6dcc8b92a879af88fff72a1ea179917dc4e7a55531936839f7e98160d
0x006a31cb6c78791436a67227dd8630901abef80e	false	3	47126711118910337830	56839918854493831	228171477	2024-07-03T01:41:49.000Z	0x4acf507d16caeedecc02716f6a5269d8e943e124be2b00865865ca142a7f9b83
0x006a31cb6c78791436a67227dd8630901abef80e	false	3	46963428171282225833	57045968961446668	228302206	2024-07-03T10:48:12.000Z	0xb376a9a87669ccf006a97335c6601dc1e7c2aa8e911b406a56017490ba034943

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_arbitrum.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	0xf64dfe17c8b87f012fcf50fbda1d62bfa148366a	0x0000000000000000000000000000000000000000	false	1000	3	176196322	2024-01-31T22:45:58.000Z	0x43d26231047ea3cfa99b9756cfcd32791322fa7e4337f9531cd628447fca050c
0xf5b75474d006495c82dbbf010e230d5d2f86226f	0xf64dfe17c8b87f012fcf50fbda1d62bfa148366a	0x0000000000000000000000000000000000000000	false	4774934553525	4	176196322	2024-01-31T22:45:58.000Z	0x43d26231047ea3cfa99b9756cfcd32791322fa7e4337f9531cd628447fca050c
0x0000000000000000000000000000000000000000	0xf64dfe17c8b87f012fcf50fbda1d62bfa148366a	0xf64dfe17c8b87f012fcf50fbda1d62bfa148366a	false	26178364032	2	178474837	2024-02-07T22:01:24.000Z	0x17917d300304f7e50f6f3b6b2043a3fa11f48dabc872463e34dcc5e1304aeeb3

Example Query

Query with partition filter

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